// PUT api/paymentvoucher/5
public int Put(int id, PaymentVoucherModel m)
{
m.paymentVoucherId = id;
int i = PaymentVoucherProvider.insertPaymentVoucher(m);
return(i);
}
public static int insertPaymentVoucher(PaymentVoucherModel s)
{
try
{
SqlHandler sql = new SqlHandler();
List <KeyValuePair <string, object> > parameter = new List <KeyValuePair <string, object> >();
parameter.Add(new KeyValuePair <string, object>("@PaymentVoucherId", s.paymentVoucherId));
parameter.Add(new KeyValuePair <string, object>("@Amount", s.Amount));
parameter.Add(new KeyValuePair <string, object>("@DrAccountId", s.AccountId));
parameter.Add(new KeyValuePair <string, object>("@PaymentType", s.PaymentType));
parameter.Add(new KeyValuePair <string, object>("@narration", s.Narration));
parameter.Add(new KeyValuePair <string, object>("@CrAccount", s.CrAccount));
parameter.Add(new KeyValuePair <string, object>("@DueGold", s.OpeningGold));
parameter.Add(new KeyValuePair <string, object>("@FinancialYearId", s.financialYearID));
parameter.Add(new KeyValuePair <string, object>("@CompanyId", s.CompanyId));
parameter.Add(new KeyValuePair <string, object>("@insertDate", s.InseertDate));
parameter.Add(new KeyValuePair <string, object>("@InsertBy", s.InsertBy));
int i = sql.ExecuteNonQueryI("Usp_PaymentVoucher", parameter);
return(i);
}
catch (Exception ex)
{
throw ex;
}
}
public List <PaymentVoucherModel> GetPaymentbyId(long id)
{
List <PaymentVoucherModel> lstPayment = new List <PaymentVoucherModel>();
PaymentVoucherModel objPayment;
StringBuilder SbQuery = new StringBuilder();
SbQuery.AppendLine("SELECT p.*,m.ACC_Name FROM Payment_Voucher_Master as p");
SbQuery.AppendLine("left join accountmaster as m on p.PaymentModeId=m.Ac_Id");
SbQuery.AppendLine("WHERE `Payment_Id`=" + id);
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(SbQuery.ToString(), _dbHelper.GetConnObject());
while (dr.Read())
{
objPayment = new PaymentVoucherModel();
objPayment.Pay_Id = DataFormat.GetInteger(dr["Payment_ID"]);
objPayment.Voucher_Series = dr["Series"].ToString();
objPayment.Pay_Date = DataFormat.GetDateTime(dr["Pay_Date"]);
objPayment.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objPayment.Type = dr["Type"].ToString();
objPayment.PaymentModeId = Convert.ToInt64(dr["PaymentModeId"].ToString());
objPayment.PaymentMode = dr["ACC_Name"].ToString();
objPayment.PDCDate = Convert.ToDateTime(dr["PDC_Date"]);
objPayment.LongNarration = dr["LongNarration"].ToString();
objPayment.TotalDebitAmt = Convert.ToDecimal(dr["TotalDebitAmt"]);
objPayment.TotalCreditAmt = Convert.ToDecimal(dr["TotalCreditAmt"]);
//SELECT Payment Voucher Details
string itemQuery = "SELECT * FROM `Payment_Voucher_Details` WHERE `Payment_Id`=" + objPayment.Pay_Id;
System.Data.IDataReader drAcc = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objPayment.PaymentAccountModel = new List <AccountModel>();
AccountModel objAcc;
while (drAcc.Read())
{
objAcc = new AccountModel();
objAcc.AC_Id = DataFormat.GetInteger(drAcc["AC_Id"]);
objAcc.ParentId = DataFormat.GetInteger(drAcc["Payment_Id"]);
objAcc.DC = drAcc["DC"].ToString();
objAcc.Account = drAcc["Account"].ToString();
objAcc.LedgerId = Convert.ToInt64(drAcc["LegderId"].ToString());
objAcc.Debit = Convert.ToDecimal(drAcc["Debit"]);
objAcc.Credit = Convert.ToDecimal(drAcc["Credit"]);
objAcc.Amount = Convert.ToDecimal(drAcc["Debit"]);
objAcc.Narration = drAcc["Narration"].ToString();
objPayment.PaymentAccountModel.Add(objAcc);
}
lstPayment.Add(objPayment);
}
return(lstPayment);
}
public List <PaymentVoucherModel> GetPaymentbyId(int id)
{
List <PaymentVoucherModel> lstPayment = new List <PaymentVoucherModel>();
PaymentVoucherModel objPayment;
string Query = "SELECT * FROM Payment_Voucher WHERE Payment_Id=" + id;
System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject());
while (dr.Read())
{
objPayment = new PaymentVoucherModel();
objPayment.Pay_Id = DataFormat.GetInteger(dr["Payment_ID"]);
objPayment.Voucher_Series = dr["Series"].ToString();
objPayment.Pay_Date = DataFormat.GetDateTime(dr["Pay_Date"]);
objPayment.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]);
objPayment.Type = dr["Type"].ToString();
if (dr["PDC_Date"].ToString() != "")
{
objPayment.PDCDate = Convert.ToDateTime(dr["PDC_Date"]);
}
//SELECT Payment Voucher Accounts
string itemQuery = "SELECT * FROM Payment_Voucher_Accounts WHERE Payment_Id=" + objPayment.Pay_Id;
System.Data.IDataReader drAcc = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject());
objPayment.PaymentAccountModel = new List <AccountModel>();
AccountModel objAcc;
while (drAcc.Read())
{
objAcc = new AccountModel();
objAcc.AC_Id = DataFormat.GetInteger(drAcc["AC_Id"]);
objAcc.ParentId = DataFormat.GetInteger(drAcc["Payment_Id"]);
objAcc.DC = drAcc["DC"].ToString();
objAcc.Account = drAcc["Account"].ToString();
objAcc.Debit = Convert.ToDecimal(drAcc["Debit"]);
objAcc.Credit = Convert.ToDecimal(drAcc["Credit"]);
objAcc.Narration = drAcc["Narration"].ToString();
objPayment.PaymentAccountModel.Add(objAcc);
}
lstPayment.Add(objPayment);
}
return(lstPayment);
}
public bool SavePaymentVoucher(PaymentVoucherModel objpaymod)
{
string Query = string.Empty;
//int payid = 0;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objpaymod.Voucher_Number));
paramCollection.Add(new DBParameter("@Series", objpaymod.Voucher_Series));
paramCollection.Add(new DBParameter("@PayDate", objpaymod.Pay_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Type", objpaymod.Type));
paramCollection.Add(new DBParameter("@PaymentModeId", objpaymod.PaymentModeId));
paramCollection.Add(new DBParameter("@PDCDate", objpaymod.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@LongNarration", objpaymod.LongNarration));
paramCollection.Add(new DBParameter("@TotalCreditAmount", objpaymod.TotalCreditAmt, DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmount", objpaymod.TotalDebitAmt, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertPaymentMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SavePaymentAccounts(objpaymod.PaymentAccountModel, id);
objLPBL.LedgerPostingAddByList(objpaymod.PaymentLPDebit);
objLPBL.LedgerPostingAddByList(objpaymod.PaymentLPCredit);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
public int SavePaymentVoucher(PaymentVoucherModel obpaybl)
{
string Query = string.Empty;
int payid = 0;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", obpaybl.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", obpaybl.Pay_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", obpaybl.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", obpaybl.Type));
paramCollection.Add(new DBParameter("@PDDate", obpaybl.PDCDate));
//paramCollection.Add(new DBParameter("@Long", obpaybl.LongNarration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Payment_Voucher([Series],[Pay_Date],[VoucherNo],[Type],[PDC_Date]," +
"[CreatedBy],[CreatedDate]) VALUES " +
"(@Series,@Date,@Voucher_Number,@Type,@PDDate, " +
" @CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
SavePaymentAccounts(obpaybl.PaymentAccountModel);
payid = GetPaymentId();
}
}
catch (Exception ex)
{
payid = 0;
throw ex;
}
return(payid);
}
private void btnUpdate_Click(object sender, EventArgs e)
{
PaymentVoucherModel objPayment = new PaymentVoucherModel();
if (tbxVchNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPayment.Voucher_Series = tbxVoucherSeries.Text.Trim();
objPayment.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim());
objPayment.Pay_Date = Convert.ToDateTime(dtDate.Text);
objPayment.Type = tbxType.Text.Trim() == null ? string.Empty : tbxType.Text.Trim();
objPayment.PDCDate = Convert.ToDateTime(dtPDCDate.Text);
objPayment.PaymentModeId = objAccBL.GetLedgerIdByAccountName(cbxPayMode.Text.Trim() == null?string.Empty:cbxPayMode.Text.Trim());
objPayment.LongNarration = tbxLongNarration.Text.Trim() == null ? string.Empty : tbxLongNarration.Text.Trim();
if (objPayment.PaymentModeId == 0)
{
objPayment.TotalDebitAmt = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue);
objPayment.TotalCreditAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue);
}
else
{
objPayment.TotalCreditAmt = Convert.ToDecimal(colAmount.SummaryItem.SummaryValue);
}
//Payment details
AccountModel objacc;
List <AccountModel> lstAccounts = new List <AccountModel>();
for (int i = 0; i < gdvPayment.DataRowCount; i++)
{
DataRow row = gdvPayment.GetDataRow(i);
objacc = new AccountModel();
objacc.DC = row["DC"].ToString();
objacc.Account = row["Account"].ToString();
objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString());
if (objPayment.PaymentModeId == 0)
{
objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty ? "0.00" : row["Debit"].ToString());
objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"].ToString());
}
else
{
objacc.Debit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
}
objacc.Narration = row["Narration"].ToString() == null ? string.Empty : row["Narration"].ToString();
objacc.ParentId = Convert.ToInt32(row["ParentId"].ToString() == string.Empty ? "0" : row["ParentId"]);
objacc.AC_Id = Convert.ToInt32(row["Ac_Id"].ToString() == string.Empty ? "0" : row["Ac_Id"]);
lstAccounts.Add(objacc);
}
objPayment.PaymentAccountModel = lstAccounts;
objPayment.Pay_Id = Payid;
bool isSuccess = objpaybl.UpdatePaymentVoucher(objPayment);
if (isSuccess)
{
MessageBox.Show("Update Successfully!");
Payid = 0;
ClearFormValues();
Transaction.List.PaymentVouchersList frmList = new Transaction.List.PaymentVouchersList();
frmList.StartPosition = FormStartPosition.CenterScreen;
frmList.ShowDialog();
FillPaymentVoucher();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PaymentVoucherModel objPayment = new PaymentVoucherModel();
if (tbxVchNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPayment.Voucher_Series = tbxVoucherSeries.Text.Trim();
objPayment.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim());
objPayment.Pay_Date = Convert.ToDateTime(dtDate.Text);
objPayment.Type = tbxType.Text.Trim() == null ? string.Empty : tbxType.Text.Trim();
objPayment.PDCDate = Convert.ToDateTime(dtPDCDate.Text);
objPayment.LongNarration = tbxLongNarration.Text.Trim() == null?string.Empty:tbxLongNarration.Text.Trim();
objPayment.PaymentModeId = objAccBL.GetLedgerIdByAccountName(cbxPayMode.Text.Trim() == null ? string.Empty : cbxPayMode.Text.Trim());
if (objPayment.PaymentModeId == 0)
{
objPayment.TotalDebitAmt = Convert.ToDecimal(colDebit.SummaryItem.SummaryValue);
objPayment.TotalCreditAmt = Convert.ToDecimal(colCredit.SummaryItem.SummaryValue);
}
else
{
objPayment.TotalCreditAmt = Convert.ToDecimal(colAmount.SummaryItem.SummaryValue);
}
//Payment details
AccountModel objacc;
List <AccountModel> lstAccounts = new List <AccountModel>();
for (int i = 0; i < gdvPayment.DataRowCount; i++)
{
DataRow row = gdvPayment.GetDataRow(i);
objacc = new AccountModel();
objacc.DC = row["DC"].ToString();
objacc.Account = row["Account"].ToString();
objacc.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString());
if (objPayment.PaymentModeId == 0)
{
objacc.Debit = Convert.ToDecimal(row["Debit"].ToString() == string.Empty ? "0.00" : row["Debit"].ToString());
objacc.Credit = Convert.ToDecimal(row["Credit"].ToString() == string.Empty ? "0.00" : row["Credit"].ToString());
}
else
{
objacc.Debit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
}
objacc.Narration = row["Narration"].ToString() == null?string.Empty: row["Narration"].ToString();
lstAccounts.Add(objacc);
}
objPayment.PaymentAccountModel = lstAccounts;
//Ledger Posting
if (objPayment.PaymentModeId != 0)
{
//Single Entery Ledger Debit Posting
LedgerPostingModel objLedger;
List <LedgerPostingModel> lstLedgerDebit = new List <LedgerPostingModel>();
for (int i = 0; i < gdvPayment.DataRowCount; i++)
{
DataRow row = gdvPayment.GetDataRow(i);
objLedger = new LedgerPostingModel();
objLedger.LedgerId = objAccBL.GetLedgerIdByAccountName(row["Account"].ToString());
objLedger.Date = Convert.ToDateTime(dtDate.Text.Trim());
objLedger.Debit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
objLedger.Credit = 0;
objLedger.VoucherNo = tbxVchNumber.Text.Trim();
objLedger.VoucherTypeId = 1;
objLedger.ChequeNo = string.Empty;
objLedger.ChequeDate = DateTime.Now;
objLedger.Extra1 = string.Empty;
objLedger.Extra2 = string.Empty;
objLedger.DetailsId = 0;
objLedger.YearId = 1;
lstLedgerDebit.Add(objLedger);
}
objPayment.PaymentLPDebit = lstLedgerDebit;
//Single Entery Ledger Credit Posting
LedgerPostingModel objLedgerCredit;
List <LedgerPostingModel> lstLedgerCredit = new List <LedgerPostingModel>();
for (int i = 0; i < gdvPayment.DataRowCount; i++)
{
DataRow row = gdvPayment.GetDataRow(i);
objLedgerCredit = new LedgerPostingModel();
objLedgerCredit.LedgerId = objPayment.PaymentModeId;
objLedgerCredit.Date = Convert.ToDateTime(dtDate.Text.Trim());
objLedgerCredit.Credit = Convert.ToDecimal(row["Amount"].ToString() == string.Empty ? "0.00" : row["Amount"].ToString());
objLedgerCredit.Debit = 0;
objLedgerCredit.VoucherNo = tbxVchNumber.Text.Trim();
objLedgerCredit.VoucherTypeId = 1;
objLedgerCredit.ChequeNo = string.Empty;
objLedgerCredit.ChequeDate = DateTime.Now;
objLedgerCredit.Extra1 = string.Empty;
objLedgerCredit.Extra2 = string.Empty;
objLedgerCredit.DetailsId = 0;
objLedgerCredit.DetailsId = 1;
lstLedgerCredit.Add(objLedgerCredit);
}
objPayment.PaymentLPCredit = lstLedgerCredit;
}
else
{
}
bool isSuccess = objpaybl.SavePaymentVoucher(objPayment);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
Payid = 0;
//ClearFormValues();
}
}
//Update Payment Voucher
public bool UpdatePaymentVoucher(PaymentVoucherModel objPay)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
//UPDATE CREDIT NOTE TABLE - PARENT TABLE
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objPay.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objPay.Pay_Date));
paramCollection.Add(new DBParameter("@Voucher_Number", objPay.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objPay.Type));
paramCollection.Add(new DBParameter("@PDDate", objPay.PDCDate));
//paramCollection.Add(new DBParameter("@TotalCreditAmt", "0"));
//paramCollection.Add(new DBParameter("@TotalDebitAmt", "0"));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@id", objPay.Pay_Id));
Query = "UPDATE Payment_Voucher SET [Series]=@Series,[Pay_Date]=@Date,[VoucherNo]=@Voucher_Number," +
"[Type]=@Type,[PDC_Date]=@PDDate,[ModifiedBy]=@ModifiedBy," +
"[ModifiedDate]=@ModifiedDate " +
"WHERE Payment_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <AccountModel> lstAcct = new List <AccountModel>();
//UPDATE CREDIT NOTE ACCOUNT -CHILD TABLE UPDATES
foreach (AccountModel act in objPay.PaymentAccountModel)
{
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@ACT_ID", act.AC_Id));
Query = "UPDATE Payment_Voucher_Accounts SET [DC]=@DC," +
"[Account]=@Account,[Debit]=@Debit,[Credit]=@Credit,[Narration]=@Narration,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE [AC_Id]=@ACT_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DN_ID", (act.ParentId)));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@Debit", act.Debit));
paramCollection.Add(new DBParameter("@Credit", act.Credit));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now));
Query = "INSERT INTO Payment_Voucher_Accounts([Payment_Id],[DC],[Account],[Debit]," +
"[Credit],[Narration],[CreatedBy],[CreatedDate]) VALUES " +
"(@Pay_ID,@DC,@Account,@Debit,@Credit,@Narration,@CreatedBy,@CreatedDate)";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
// POST api/paymentvoucher
public int Post(PaymentVoucherModel m)
{
int i = PaymentVoucherProvider.insertPaymentVoucher(m);
return(i);
}
//Update Payment Voucher
public bool UpdatePaymentVoucher(PaymentVoucherModel objPay)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Series", objPay.Voucher_Series));
paramCollection.Add(new DBParameter("@Date", objPay.Pay_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@Voucher_Number", objPay.Voucher_Number));
paramCollection.Add(new DBParameter("@Type", objPay.Type));
paramCollection.Add(new DBParameter("@PaymentModeId", objPay.PaymentModeId));
paramCollection.Add(new DBParameter("@PDDate", objPay.PDCDate, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@LongNarration", objPay.LongNarration));
paramCollection.Add(new DBParameter("@TotalCreditAmt", objPay.TotalCreditAmt, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@TotalDebitAmt", objPay.TotalDebitAmt, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@id", objPay.Pay_Id));
Query = "UPDATE Payment_Voucher_Master SET `Series`=@Series,`PaymentModeId`=PaymentModeId,`Pay_Date`=@Date,`VoucherNo`=@Voucher_Number," +
"`Type`=@Type,`PDC_Date`=@PDDate,`LongNarration`=@LongNarration,`TotalCreditAmt`=@TotalCreditAmt,`TotalDebitAmt`=@TotalDebitAmt,`ModifiedBy`=@ModifiedBy," +
"`ModifiedDate`=@ModifiedDate " +
"WHERE Payment_Id=@id";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
List <AccountModel> lstAcct = new List <AccountModel>();
foreach (AccountModel act in objPay.PaymentAccountModel)
{
act.ParentId = objPay.Pay_Id;
if (act.AC_Id > 0)
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@Debit", act.Debit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Credit", act.Credit, System.Data.DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@ACT_ID", act.AC_Id));
paramCollection.Add(new DBParameter("@ParentId", act.ParentId));
Query = "UPDATE Payment_Voucher_Details SET `DC`=@DC," +
"`Account`=@Account,`Debit`=@Debit,`LegderId`=@LegderId,`Credit`=@Credit,`Narration`=@Narration,`ModifiedBy`=@ModifiedBy,`ModifiedDate`=@ModifiedDate " +
"WHERE `AC_Id`=@ACT_ID AND Payment_Id=@ParentId";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
else
{
paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@PaymentId", (act.ParentId)));
paramCollection.Add(new DBParameter("@DC", (act.DC)));
paramCollection.Add(new DBParameter("@Account", act.Account));
paramCollection.Add(new DBParameter("@LegderId", act.LedgerId));
paramCollection.Add(new DBParameter("@DebitAmount", act.Debit, DbType.Decimal));
paramCollection.Add(new DBParameter("@CreditAmount", act.Credit, DbType.Decimal));
paramCollection.Add(new DBParameter("@Amount", act.Amount, DbType.Decimal));
paramCollection.Add(new DBParameter("@Narration", act.Narration));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime));
paramCollection.Add(new DBParameter("@ModifiedBy", ""));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertPaymentDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
isUpdated = true;
}
}
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
