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(); }