public bool SaveUpdateChequeEntry(mdlChequeEntry obj_mdlChequeWithoutSummary, string Operation)
{
bool IsSaved = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
SqlTransaction transaction = con.BeginTransaction();
try
{
SqlCommand cmd = new SqlCommand("stp_ERP_ChequeEntryWithoutSummary_CRUD", con, transaction);
cmd.Parameters.Add("@Pk_TransID", SqlDbType.VarChar, 9).Value = obj_mdlChequeWithoutSummary.TransID;
cmd.Parameters.Add("@TransDate", SqlDbType.DateTime).Value = obj_mdlChequeWithoutSummary.TransDate;
cmd.Parameters.Add("@InsNo", SqlDbType.VarChar, 20).Value = obj_mdlChequeWithoutSummary.ChequeNo;
cmd.Parameters.Add("@DSSID", SqlDbType.VarChar, 6).Value = obj_mdlChequeWithoutSummary.DssID;
cmd.Parameters.Add("@DueDate", SqlDbType.DateTime).Value = obj_mdlChequeWithoutSummary.DueDate;
cmd.Parameters.Add("@BankName", SqlDbType.VarChar, 50).Value = obj_mdlChequeWithoutSummary.BankName;
cmd.Parameters.Add("@ChequeAmount", SqlDbType.Decimal).Value = obj_mdlChequeWithoutSummary.Amount;
cmd.Parameters.Add("@ReceivedFrom", SqlDbType.VarChar, 100).Value = obj_mdlChequeWithoutSummary.ReceivedFrom;
cmd.Parameters.Add("@EmployeeID", SqlDbType.VarChar, 6).Value = obj_mdlChequeWithoutSummary.EmployeeID;
cmd.Parameters.Add("@AccountNo", SqlDbType.VarChar, 50).Value = obj_mdlChequeWithoutSummary.AccountNo;
cmd.Parameters.Add("@AccountTitle", SqlDbType.VarChar, 50).Value = obj_mdlChequeWithoutSummary.AccountTitle;
cmd.Parameters.Add("@CompanyID", SqlDbType.VarChar, 3).Value = obj_mdlChequeWithoutSummary.CompanyID;
cmd.Parameters.Add("@SpoID", SqlDbType.VarChar, 6).Value = obj_mdlChequeWithoutSummary.SpoID;
cmd.Parameters.Add("@AddUser", SqlDbType.VarChar, 16).Value = obj_mdlChequeWithoutSummary.AddUser;
// cmd.Parameters.Add("@LockUser", SqlDbType.VarChar, 16).Value = obj_mdlChequeWithoutSummary.LockUser;
if (Operation == "Save")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 12).Value = "SaveMaster";
}
else if (Operation == "Update")
{
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 12).Value = "Update";
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
SaveChequeDetail(obj_mdlChequeWithoutSummary, transaction, cmd);
transaction.Commit();
IsSaved = true;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
catch (Exception ex)
{
transaction.Rollback();
MessageBox.Show(ex.Message, "ERP - Babar Medicine Company Lahore", MessageBoxButtons.OK, MessageBoxIcon.Error);
IsSaved = false;
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
return IsSaved;
}
private SqlCommand SaveChequeDetail(mdlChequeEntry obj_mdlChequeWithoutSummary, SqlTransaction transaction, SqlCommand cmd)
{
//Delete Cheque Entry Detail
if (obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows.Count > 0)
{
cmd = new SqlCommand("Delete from D_Cheque_Invoice_Detail where TransId ='" + obj_mdlChequeWithoutSummary.TransID + "'", con, transaction);
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
//Inserting Cheque Entry Detail
for (int i = 0; i <= obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows.Count - 1; i++)
{
cmd = new SqlCommand("stp_ERP_ChequeEntryWithoutSummary_CRUD", con, transaction);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.Add("@Pk_TransID", SqlDbType.VarChar, 9).Value = obj_mdlChequeWithoutSummary.TransID;
cmd.Parameters.Add("@InvoiceID", SqlDbType.VarChar, 9).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Inv. ID"].ToString();
cmd.Parameters.Add("@ChqInvDate", SqlDbType.DateTime).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Inv. Date"].ToString();
cmd.Parameters.Add("@CustomerID", SqlDbType.VarChar, 6).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Cust. ID"].ToString();
cmd.Parameters.Add("@BalanceAmount", SqlDbType.Decimal).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Balance"].ToString();
cmd.Parameters.Add("@ChqValue", SqlDbType.Decimal).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Chq. Value"].ToString();
cmd.Parameters.Add("@AddTax", SqlDbType.Decimal).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Add Tax"].ToString();
cmd.Parameters.Add("@OldInvID", SqlDbType.VarChar, 6).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Old.Inv.ID"].ToString();
cmd.Parameters.Add("@OldInvDate", SqlDbType.DateTime).Value = obj_mdlChequeWithoutSummary.dsChequeEntry.Tables[0].Rows[i]["Old.Inv.Date"].ToString();
cmd.Parameters.Add("@Operation", SqlDbType.VarChar, 12).Value = "SaveDetail";
cmd.ExecuteNonQuery();
}
return cmd;
}
public bool SaveUpdateChequeEntry(mdlChequeEntry obj_mdlChequeWithoutSummary, string Operation)
{
return obj_dalChequeWithoutSummary.SaveUpdateChequeEntry(obj_mdlChequeWithoutSummary, Operation);
}
