public static int Insert_Sub_Category(User_Property_Tbl_Sub_Category u)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "insert_tbl_sub_category";
cmd.Parameters.Add(Create_Parameter.Convert_Int("@cat_id", u.cat_id));
cmd.Parameters.Add(Create_Parameter.Convert_String("@sub_cat_name", u.sub_cat_name));
return(Create_Command.Execute_Non_Query(cmd));
}
protected void btn_ok_Click(object sender, EventArgs e)
{
User_Property_Tbl_Sub_Category u = new User_Property_Tbl_Sub_Category();
u.cat_id = ddl_sub_category.SelectedValue.ToString();
u.sub_cat_name = txt_sub_category_name.Text;
//insert data in sub category table
if (btn_ok.Text == "Add")
{
int i = Insert_Logic.Insert_Sub_Category(u);
//For Stock
User_Property_Tbl_Stock s = new User_Property_Tbl_Stock();
s.current_stock = "0";
s.sub_cat_id = find_sub_cat_id();
s.l_date = DateTime.Now.ToShortDateString();
Insert_Logic.Insert_Stock(s);
if (i == 1)
{
lbl_msg.Text = "Successfully Inserted";
lbl_msg.ForeColor = System.Drawing.Color.Green;
}
else
{
lbl_msg.Text = "Duplicate Data";
lbl_msg.ForeColor = System.Drawing.Color.Red;
}
}
else
{
//update details about sub category
u.sub_cat_id = id;
int ii = Update_Logic.Update_Sub_Category(u);
if (ii == 1)
{
Response.Redirect("manage_sub_category.aspx");
}
else
{
lbl_msg.Text = "Error";
}
}
ModalPopupExtender1.Show();
}
