/// <summary>
/// Checking invalid entries for Save or Update and Save and Update function
/// </summary>
public void saveOrEdit()
{
try
{
BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo();
BankReconciliationSP spBankReconciliation = new BankReconciliationSP();
foreach (DataGridViewRow dgv in dgvBankReconciliation.Rows)
{
if (dgv.Cells["dgvtxtStatementDate"].Value != null && Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()) != 0 && dgv.Cells["dgvtxtStatementDate"].Value.ToString() != string.Empty)
{
infoBankReconciliation.LedgerPostingId = decimal.Parse(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString());
infoBankReconciliation.StatementDate = Convert.ToDateTime((dgv.Cells["dgvtxtStatementDate"].Value.ToString()));
infoBankReconciliation.Extra1 = string.Empty;
infoBankReconciliation.Extra2 = string.Empty;
infoBankReconciliation.ExtraDate = PublicVariables._dtCurrentDate;
decimal decReconcileId = spBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()));
if (decReconcileId != 0)
{
infoBankReconciliation.ReconcileId = decReconcileId;
spBankReconciliation.BankReconciliationEdit(infoBankReconciliation);
}
else
{
spBankReconciliation.BankReconciliationAdd(infoBankReconciliation);
}
}
else
{
if (Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()) != 0)
{
decimal decReconcileId = spBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()));
if (decReconcileId != 0)
{
spBankReconciliation.BankReconciliationDelete(decReconcileId);
}
}
}
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "BR4:" + ex.Message;
}
}
/// <summary>
/// BankReconciliation Grid Fill function
/// </summary>
public void BankReconciliationFill()
{
try
{
BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo();
BankReconciliationSP spBankReconciliation = new BankReconciliationSP();
dgvBankReconciliation.Rows.Clear();
DataTable dtblBank = new DataTable();
if (cmbBankAccount.SelectedIndex > -1)
{
if (cmbStatus.Text == "Reconciled")
{
dtblBank = spBankReconciliation.BankReconciliationFillReconcile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text));
if (dtblBank.Rows.Count > 0)
{
for (int i = 0; i < dtblBank.Rows.Count; i++)
{
dgvBankReconciliation.Rows.Add();
dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = dtblBank.Rows[i]["Sl No"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = dtblBank.Rows[i]["date"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = dtblBank.Rows[i]["ledgerName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = dtblBank.Rows[i]["voucherTypeName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = dtblBank.Rows[i]["voucherNo"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = dtblBank.Rows[i]["chequeNo"].ToString();
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = dtblBank.Rows[i]["chequeDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = dtblBank.Rows[i]["debit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = dtblBank.Rows[i]["credit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = dtblBank.Rows[i]["statementDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = dtblBank.Rows[i]["ledgerPostingId"];
}
}
}
else
{
dtblBank = spBankReconciliation.BankReconciliationUnrecocile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text));
if (dtblBank.Rows.Count > 0)
{
for (int i = 0; i < dtblBank.Rows.Count; i++)
{
dgvBankReconciliation.Rows.Add();
dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = dtblBank.Rows[i]["Sl No"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = dtblBank.Rows[i]["date"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = dtblBank.Rows[i]["ledgerName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = dtblBank.Rows[i]["voucherTypeName"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = dtblBank.Rows[i]["voucherNo"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = dtblBank.Rows[i]["chequeNo"].ToString();
dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = dtblBank.Rows[i]["chequeDate"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = dtblBank.Rows[i]["debit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = dtblBank.Rows[i]["credit"];
dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = string.Empty;
dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = dtblBank.Rows[i]["ledgerPostingId"];
}
}
}
}
}
catch (Exception ex)
{
formMDI.infoError.ErrorString = "BR3:" + ex.Message;
}
}
