public static int Insert_Product(User_Property_Tbl_Product u)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "insert_tbl_product_sp";
cmd.Parameters.Add(Create_Parameter.Convert_Int("@d_id", u.d_id));
cmd.Parameters.Add(Create_Parameter.Convert_String("@prod_name", u.prod_name));
cmd.Parameters.Add(Create_Parameter.Convert_String("@prod_unique_no", u.prod_unique_no));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@prod_price", u.prod_price));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@sub_cat_id", u.sub_Cat_id));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@prod_weight", u.prod_weight));
cmd.Parameters.Add(Create_Parameter.Convert_String("@prod_description", u.prod_description));
cmd.Parameters.Add(Create_Parameter.Convert_String("@prod_quality", u.prod_quality));
cmd.Parameters.Add(Create_Parameter.Convert_String("@prod_type", u.prod_type));
cmd.Parameters.Add(Create_Parameter.Convert_String("@product_purchase_date", u.purchase_date));
return(Create_Command.Execute_Non_Query(cmd));
}
protected void Button1_Click(object sender, EventArgs e)
{
User_Property_Tbl_Product u = new User_Property_Tbl_Product();
u.d_id = ddl_dealer_name.SelectedValue.ToString();
u.sub_Cat_id = ddl_sub_category_name.SelectedValue.ToString();
u.prod_name = txt_product_name.Text;
u.prod_description = txt_product_description.Text;
try
{
u.prod_price = (Convert.ToInt32(txt_current_gold_price.Text) * Convert.ToInt32(txt_weight.Text)).ToString();
}
catch (FormatException e1)
{
error_current_gold_price.Text = "enter proper price";
return;
}
try
{
//for checking type of product weight whether is a number or not
u.prod_weight = txt_weight.Text;
int d = Convert.ToInt32(txt_current_gold_price.Text);
}
catch (FormatException ef)
{
error_product_weight.Text = "enter proper weight";
error_product_weight.ForeColor = System.Drawing.Color.Red;
return;
}
u.prod_unique_no = txt_generate_unique_no.Text;
u.prod_quality = ddl_product_quality.SelectedValue.ToString();
u.prod_type = ddl_product_type.SelectedValue.ToString();
u.purchase_date = txt_purchase_date.Text;
//find current stock
// add current stock + 1
User_Property_Tbl_Stock s = new User_Property_Tbl_Stock();
s.sub_cat_id = ddl_sub_category_name.SelectedValue.ToString();
s.current_stock = (Convert.ToInt32(find_current_stock()) + 1).ToString();
s.l_date = DateTime.Now.ToShortDateString().ToString();
//find stock id for update stock
s.s_id = find_stock_id();
if (Button1.Text == "Add")
{
int i = Insert_Logic.Insert_Product(u);
if (s.s_id != "")
{
Update_Logic.Update_Stock(s);
}
if (i == 1)
{
Label3.Text = "inserted";
Label3.ForeColor = System.Drawing.Color.Green;
ModalPopupExtender1.Show();
}
else
{
Label3.Text = "Duplicate data";
ModalPopupExtender1.Show();
lbl_msg.ForeColor = System.Drawing.Color.Red;
}
////
}
else
{
u.p_id = id;
int ii = Update_Logic.Update_Product(u);
if (ii == 1)
{
Response.Redirect("manage_product.aspx");
}
else
{
lbl_msg.Text = "Error";
}
}
}
