using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;


public partial class Category : System.Web.UI.Page
{
    Page p = new Page();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        {
             
            if (Session["Bulkmail"] == null)
            {
                Response.Redirect("BulkmailLogin.aspx");
            }
            TextBox1.AutoPostBack = false;
            p = this.Page;
           // Response.Write(p.Title);

            ModCommon.CancelClick(ref p , ref btnAdd ,ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
            ModCommon.Fill_Grid("Select * From BEM_Category", GridView1);
            btnDelete.Attributes.Add("onclick", "return FunctDelete();");
            enable(false);
            ScriptManager1.SetFocus(btnAdd);

        }
        lblMsg.Visible = false;
    }

    protected void enable(bool action)
    {
        TextBox1.Enabled = action;
        
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        
        TextBox1.AutoPostBack = false;
        TextBox1.Focus();
        enable(true);
        ModCommon.AddClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        TextBox1.AutoPostBack = false;
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText="BEM_Category_Proc";
        cmd.CommandType=CommandType.StoredProcedure ;
        cmd.Connection=con;

        cmd.Parameters.Add("Category_Kid", SqlDbType.NVarChar, 10).Value = ModCommon.NewPrimaryKey(p);
        cmd.Parameters.Add("Category_Code", SqlDbType.NVarChar, 25).Value = CommonData.Generate_Code("Select Count(*) From BEM_Category Where Category_Code='", "BCC");
        cmd.Parameters.Add("Category_Name",SqlDbType.NVarChar,200).Value=TextBox1.Text;

        //cmd.Parameters.Add(New SqlParameter("FactoryDetails_TINNo", SqlDbType.NVarChar, 50)).Value = txttinno.Text;

        cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Insert";

        //cmd.Parameters.Add(new SqlParameter("Mode", SqlDbType.NVarChar, 50).Value = "Insert");
        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        TextBox1.Text = "";
        enable(false);
        ModCommon.showmessage("Record is Saved Sucessfully.", lblMsg);
        ModCommon.Fill_Grid("Select * From BEM_Category",GridView1);
        ModCommon.SaveClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        //string str;
        //str = GridView1.SelectedDataKey.Value.ToString();
        TextBox1.AutoPostBack = false;
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText="BEM_Category_Proc";
        cmd.CommandType=CommandType.StoredProcedure;
        cmd.Connection = con;

        cmd.Parameters.Add("Category_KID", SqlDbType.NVarChar , 10).Value = ModCommon.RemoveLiterals(GridView1.SelectedDataKey.Value.ToString());
        cmd.Parameters.Add("Category_Code",SqlDbType.NVarChar,25).Value=ModCommon.ReturnValue("Select Category_Code from BME_Category where Category_Kid ='" + ModCommon.RemoveLiterals(GridView1.SelectedDataKey.Value.ToString()) +"'");
        cmd.Parameters.Add("Category_Name", SqlDbType.NVarChar, 200).Value = TextBox1.Text;
        cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Update";

        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();
        ModCommon.Fill_Grid("Select * From BEM_Category",GridView1);
        TextBox1.Text = "";
        enable(false);
        ModCommon.showmessage("Record is Updated Sucessfully.", lblMsg);
        ModCommon.EditClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        TextBox1.AutoPostBack = false;
        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = "BEM_Category_Proc";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = con;

        cmd.Parameters.Add("Category_KID", SqlDbType.NVarChar , 10).Value = GridView1.SelectedDataKey.Value;
        cmd.Parameters.Add("Category_Code",SqlDbType.NVarChar,25).Value=ModCommon.ReturnValue("Select Category_Code from BME_Category where Category_Kid ='" + ModCommon.RemoveLiterals(GridView1.SelectedDataKey.Value.ToString()) + "'");
        cmd.Parameters.Add("Category_Name", SqlDbType.NVarChar, 200).Value = TextBox1.Text;
        cmd.Parameters.Add("Mode", SqlDbType.NVarChar, 50).Value = "Delete";

        con.Open();
        cmd.ExecuteNonQuery();
        con.Close();

        enable(false);
        TextBox1.Text = "";
        ModCommon.Fill_Grid("Select * From BEM_Category", GridView1);
        ModCommon.showmessage("Record is Deleted Sucessfully.", lblMsg);
        ModCommon.DeleteClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void btnCancel_Click(object sender, EventArgs e)
    {
        TextBox1.AutoPostBack = false;
        TextBox1.Text = "";
        enable(false);
        ModCommon.Fill_Grid("Select * From BEM_Category", GridView1);
                ModCommon.CancelClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        TextBox1.AutoPostBack = true;
        enable(true);
        TextBox1.Text = "";
        TextBox1.Focus();
        ModCommon.SearchClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);
    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        //string str;
        //str = GridView1.SelectedDataKey.Value.ToString ();
        TextBox1.AutoPostBack = false;
        TextBox1.Text = GridView1.SelectedRow.Cells[1].Text;
        enable(true);
        ModCommon.GridClick(ref p, ref btnAdd, ref btnSave, ref btnUpdate, ref btnDelete, ref btnCancel, ref btnSearch);


    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
        ModCommon.Fill_Grid("Select * From BEM_Category where Category_Name like '" + TextBox1.Text + "%'" , GridView1);
        if (GridView1.Rows.Count == 0)
        {
            ModCommon.showmessage("Record is Not Found.", lblMsg);
        }

    }
}