/// <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; } }