public static int Insert_Selling(Userr_Property_Tbl_Selling u)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "insert_tbl_selling_sp";
cmd.Parameters.Add(Create_Parameter.Convert_Int("@c_id", u.c_id));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@bill_no", u.bill_no));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@total_amount", u.total_amount));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@current_pay", u.current_pay));
cmd.Parameters.Add(Create_Parameter.Convert_Int("@remaining_amount", u.remaining_amount));
cmd.Parameters.Add(Create_Parameter.Convert_String("@purchase_date", u.purchase_date));
return(Create_Command.Execute_Non_Query(cmd));
}
//bill generation
protected void btn_generate_bill_Click(object sender, EventArgs e)
{
if (Session["remaining_amount_customer"] != "")
{
if (Convert.ToInt32(txt_total_amount.Text) >= Convert.ToInt32(txt_current_pay.Text))
{
string bill_no1 = Session["remaining_amount_customer"].ToString();
string remaining_amount = Convert.ToString(Convert.ToInt32(txt_total_amount.Text) - Convert.ToInt32(txt_current_pay.Text));
Update_Logic.update_remaining_amount(bill_no1, remaining_amount);
Response.Redirect("Bill.aspx");
}
else
{
lbl_msg.Text = "Current Pay should not be Greater than Total Amount";
mpe.Show();
}
}
else if (Session["Bill_no_customer_page"] != "")
{
if (Convert.ToInt32(txt_total_amount.Text) >= Convert.ToInt32(txt_current_pay.Text))
{
String bill_no1 = Session["Bill_no_customer_page"].ToString();
string remaining_amount = Convert.ToString(Convert.ToInt32(txt_total_amount.Text) - Convert.ToInt32(txt_current_pay.Text));
Update_Logic.update_remaining_amount(bill_no1, remaining_amount);
Response.Redirect("Bill.aspx");
}
else
{
lbl_msg.Text = "Current Pay should not be Greater than Total Amount";
mpe.Show();
}
}
else
{
Userr_Property_Tbl_Selling u = new Userr_Property_Tbl_Selling();
u.bill_no = Session["bill_no"].ToString();
u.c_id = find_customer_id();
u.total_amount = txt_total_amount.Text;
u.purchase_date = txt_purchase_date.Text;
u.current_pay = txt_current_pay.Text;
if ((Convert.ToInt32(u.total_amount)) < (Convert.ToInt32(u.current_pay)))
{
amount_error.ForeColor = System.Drawing.Color.Red;
amount_error.Text = "current pay should not be greater than total amount";
return;
}
u.remaining_amount = Convert.ToString(Convert.ToInt32(u.total_amount) - Convert.ToInt32(u.current_pay));
int i = Insert_Logic.Insert_Selling(u);
if (i == 1)
{
Response.Redirect("Bill.aspx");
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('Sry Try Again')", true);
}
Session["bill_no"] = "";
Session["id"] = "";
}
}
