public int CommonBillNo_Save(BAL_InvoiceDetails balid)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Bill_No", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Customer_ID", balid.Customer_ID);
cmd.Parameters.AddWithValue("@Bill_No", balid.Bill_No);
cmd.Parameters.AddWithValue("@Payment_Mode", balid.Payment_Mode);
cmd.Parameters.AddWithValue("@Total_Price", balid.Total_Price);
cmd.Parameters.AddWithValue("@Paid_Amount", balid.Paid_Amount);
cmd.Parameters.AddWithValue("@Balance_Amount", balid.Balance_Amount);
cmd.Parameters.AddWithValue("@S_Status", balid.S_Status);
cmd.Parameters.AddWithValue("@C_Date", balid.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int InvoiceDetails_Save(BAL_InvoiceDetails balid)
{
try
{
con.Open();
cmd = new SqlCommand("SP_InvoiceDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Customer_ID", balid.Customer_ID);
cmd.Parameters.AddWithValue("@EmployeeID", balid.EmployeeID);
cmd.Parameters.AddWithValue("@Bill_No", balid.Bill_No);
cmd.Parameters.AddWithValue("@Domain_ID", balid.Domain_ID);
cmd.Parameters.AddWithValue("@Product_ID", balid.Product_ID);
cmd.Parameters.AddWithValue("@Brand_ID", balid.Brand_ID);
cmd.Parameters.AddWithValue("@P_Category", balid.P_Category);
cmd.Parameters.AddWithValue("@Model_No_ID", balid.Model_No_ID);
cmd.Parameters.AddWithValue("@Color_ID", balid.Color_ID);
cmd.Parameters.AddWithValue("@Products123", balid.Products123);
// cmd.Parameters.AddWithValue("@Followup_Walkin_Option", balfp.Followup_Walkin_Option);
cmd.Parameters.AddWithValue("@Per_Product_Price", balid.Per_Product_Price);
cmd.Parameters.AddWithValue("@Qty", balid.Qty);
cmd.Parameters.AddWithValue("@C_Price", balid.C_Price);
// cmd.Parameters.AddWithValue("@Walkins", balfp.Walkins);
cmd.Parameters.AddWithValue("@Tax_Name", balid.Tax_Name);
cmd.Parameters.AddWithValue("@Tax", balid.Tax);
cmd.Parameters.AddWithValue("@Total_Price", balid.Total_Price);
cmd.Parameters.AddWithValue("@Payment_Mode", balid.Payment_Mode);
cmd.Parameters.AddWithValue("@Warranty", balid.Warranty);
cmd.Parameters.AddWithValue("@S_Status", balid.S_Status);
cmd.Parameters.AddWithValue("@C_Date", balid.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int Update_QTY(BAL_InvoiceDetails balid)
{
try
{
con.Open();
cmd = new SqlCommand("SP_update_Qty", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Products123", balid.Products123);
cmd.Parameters.AddWithValue("@ID",balid .ID );
cmd.Parameters.AddWithValue("@AvilableQty", balid.AvilableQty);
cmd.Parameters.AddWithValue("@SaleQty", balid.SaleQty);
cmd.Parameters.AddWithValue("@S_Status", balid.S_Status);
cmd.Parameters.AddWithValue("@C_Date", balid.C_Date);
int i = cmd.ExecuteNonQuery();
return i;
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}