/// <summary> /// Checking invalid entries for Save or Update and Save and Update function /// </summary> public void saveOrEdit() { try { BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo(); BankReconciliationBll BllBankReconciliation = new BankReconciliationBll(); 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 = BllBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString())); if (decReconcileId != 0) { infoBankReconciliation.ReconcileId = decReconcileId; BllBankReconciliation.BankReconciliationEdit(infoBankReconciliation); } else { BllBankReconciliation.BankReconciliationAdd(infoBankReconciliation); } } else { if (Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString()) != 0) { decimal decReconcileId = BllBankReconciliation.BankReconciliationLedgerPostingId(Convert.ToDecimal(dgv.Cells["dgvtxtLedgerPostingId"].Value.ToString())); if (decReconcileId != 0) { BllBankReconciliation.BankReconciliationDelete(decReconcileId); } } } } } catch (Exception ex) { MessageBox.Show("BR:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// BankReconciliation Grid Fill function /// </summary> public void BankReconciliationFill() { try { BankReconciliationInfo infoBankReconciliation = new BankReconciliationInfo(); BankReconciliationBll BllBankReconciliation = new BankReconciliationBll(); dgvBankReconciliation.Rows.Clear(); List <DataTable> listObj = new List <DataTable>(); if (cmbBankAccount.SelectedIndex > -1) { if (cmbStatus.Text == "Reconciled") { listObj = BllBankReconciliation.BankReconciliationFillReconcile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text)); if (listObj[0].Rows.Count > 0) { for (int i = 0; i < listObj[0].Rows.Count; i++) { dgvBankReconciliation.Rows.Add(); dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = listObj[0].Rows[i]["Sl No"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = listObj[0].Rows[i]["date"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = listObj[0].Rows[i]["ledgerName"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = listObj[0].Rows[i]["voucherTypeName"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = listObj[0].Rows[i]["voucherNo"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString(); dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = listObj[0].Rows[i]["debit"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = listObj[0].Rows[i]["credit"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = listObj[0].Rows[i]["statementDate"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = listObj[0].Rows[i]["ledgerPostingId"]; } } } else { listObj = BllBankReconciliation.BankReconciliationUnrecocile(Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString()), Convert.ToDateTime(txtStatementFrom.Text), Convert.ToDateTime(txtStatementTo.Text)); if (listObj[0].Rows.Count > 0) { for (int i = 0; i < listObj[0].Rows.Count; i++) { dgvBankReconciliation.Rows.Add(); dgvBankReconciliation.Rows[i].Cells["dgvtxtSlNo"].Value = listObj[0].Rows[i]["Sl No"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtDate"].Value = listObj[0].Rows[i]["date"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtParticular"].Value = listObj[0].Rows[i]["ledgerName"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherType"].Value = listObj[0].Rows[i]["voucherTypeName"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtVoucherNo"].Value = listObj[0].Rows[i]["voucherNo"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString(); dgvBankReconciliation.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtDeposit"].Value = listObj[0].Rows[i]["debit"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtWithdraw"].Value = listObj[0].Rows[i]["credit"]; dgvBankReconciliation.Rows[i].Cells["dgvtxtStatementDate"].Value = string.Empty; dgvBankReconciliation.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = listObj[0].Rows[i]["ledgerPostingId"]; } } } } } catch (Exception ex) { MessageBox.Show("BR:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }