1#@!#!123s

��JFIF�� 1#@!#!123s
: C: / Inetpub / vhosts / neyoclubricant.com / httpdocs / admin /
Filename : Product_Master.aspx.cs
back
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Admin_Product_Master : System.Web.UI.Page
{
    public enum MessageType { Success, Error, Info, Warning };
    protected void ShowMessage(string Message, MessageType type)
    {
        ScriptManager.RegisterStartupScript(this, this.GetType(), System.Guid.NewGuid().ToString(), "ShowMessage('" + Message + "','" + type + "');", true);
    }


    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                bind_control();
                bind_data();
            }
        }
        catch (Exception)
        {

            throw;
        }
    }
    public void bind_control()
    {
        try
        {
            DataSet ds = BAL_Oil_Type.dis_oil_type();
            if (ds.Tables.Count > 0)
            {
                ddl_type.DataSource = ds.Tables[0];
                ddl_type.DataBind();
                ddl_type.Items.Insert(0, new ListItem("- - - - - Select - - - - -","0"));
            }
        }
        catch (Exception)
        {

            throw;
        }
    }
    public void bind_data()
    {
        try
        {
            DataSet ds = BAL_product.dis_product();
            if (ds.Tables.Count > 0)
            {
                grid_product.DataSource = ds.Tables[0];
                grid_product.DataBind();
            }
        }
        catch (Exception)
        {

            throw;
        }
    }

    protected void grid_product_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            string pro_id = e.CommandArgument.ToString();
            if (e.CommandName == "btn_edit")
            {
                DataSet ds_admin = BAL_product.sel_product(pro_id);
                if (ds_admin.Tables.Count > 0)
                {
                    ddl_type.SelectedValue = ds_admin.Tables[0].Rows[0]["type_id"].ToString();
                    txt_code.Text = ds_admin.Tables[0].Rows[0]["code"].ToString();
                    txt_name.Text = ds_admin.Tables[0].Rows[0]["name"].ToString();
                    txt_desc.Text = ds_admin.Tables[0].Rows[0]["desc"].ToString();
                    ViewState["title_photo"] = ds_admin.Tables[0].Rows[0]["photo"].ToString();

                    ViewState["pro_id"] = pro_id;
                    btn_save.Text = "Update";
                    hd_action.Value = "update";
                    ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#modal_add').modal();", true);
                }
            }
            else if (e.CommandName == "btn_delete")
            {
                DataSet ds_admin = BAL_product.dlt_product(pro_id, Session["user_id"].ToString());
                if (ds_admin.Tables.Count > 0)
                {
                    clear();
                    ShowMessage("Product Delete", MessageType.Success);
                    bind_data();
                }
                else
                {
                    ShowMessage("Product Not Delete", MessageType.Error);
                }
            }
        }
        catch (Exception ex)
        {
            ScriptManager.RegisterStartupScript(this, GetType(), "Success", "alert('" + ex.Message.ToString() + "');", true);

        }
    }
    protected void btn_save_Click(object sender, EventArgs e)
    {
        try
        {
            string title_photo = "";
            if (ViewState["title_photo"] != null)
            {
                title_photo = ViewState["title_photo"].ToString();
            }

            if (flu_title_photo.HasFiles)
            {
                title_photo = General.rename_file_name(flu_title_photo.FileName);
                flu_title_photo.SaveAs(Server.MapPath("image/product/") + title_photo);
            }


            if (hd_action.Value == "save")
            {
                DataSet ds = BAL_product.ins_product(ddl_type.SelectedValue, txt_name.Text, txt_code.Text, title_photo, txt_desc.Text, Session["user_id"].ToString());
                if (ds.Tables.Count > 0)
                {
                    clear();
                    ShowMessage("Product Save", MessageType.Success);
                    bind_data();
                }
                else
                {
                    ShowMessage("Product Not Save ! Something Wrong.", MessageType.Error);
                }
            }
            else if (hd_action.Value == "update")
            {
                DataSet ds = BAL_product.upd_product(ViewState["pro_id"].ToString(), ddl_type.SelectedValue, txt_name.Text, txt_code.Text, title_photo, txt_desc.Text, Session["user_id"].ToString());
                if (ds.Tables.Count > 0)
                {
                    clear();
                    ShowMessage("Product Update", MessageType.Success);
                    bind_data();
                }
                else
                {
                    ShowMessage("Product Not Update ! Something Wrong.", MessageType.Error);
                }
            }

        }
        catch (Exception)
        {

            throw;
        }
    }

    public void clear()
    {
        ddl_type.SelectedIndex = 0;
        txt_name.Text = "";
        txt_code.Text = "";
        txt_desc.Text = "";
        hd_action.Value = "save";
        btn_save.Text = "Save";
    }
}