public static int Insert_Stock(User_Property_Tbl_Stock u)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "insert_tbl_stock_sp";
cmd.Parameters.Add(Create_Parameter.Convert_Int("@sub_cat_id", u.sub_cat_id));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@current_stock", u.current_stock));
cmd.Parameters.Add(Create_Parameter.Convert_String("@l_date", u.l_date));
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();
}
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";
}
}
}
