/// <summary>
/// function to find the total balance while from balancesheet and trial balance
/// </summary>
public void AccountGroupWiseReportForProfitAndLossLedgerGridfill()
{
decimal decBalanceTotal = 0;
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupWiseReportForProfitAndLossLedger(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text));
dgvAccountGroupWiseReport.DataSource = ListObj;
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++)
{
decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString());
}
}
if (decBalanceTotal < 0)
{
decBalanceTotal = -1 * decBalanceTotal;
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr";
}
else
{
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr";
}
}
catch (Exception ex)
{
MessageBox.Show("AGWREP07:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill accountgroup combobox
/// </summary>
/// <param name="cmbAccountGroup"></param>
public void AccountGroupComboFill(ComboBox cmbAccountGroup)
{
try
{
cmbAccountGroup.Enabled = true;
AccountGroupBll bllAccountGroup = new AccountGroupBll();
bllAccountGroup.BillAllocationAccountGroupFill(cmbAccountGroup, true);
}
catch (Exception ex)
{
MessageBox.Show("BA:02" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill ledgers as TreeMode
/// </summary>
/// <param name="tn"></param>
public void FillTree(TreeNode tn)
{
try
{
List<DataTable> ListObj = new List<DataTable>();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
ListObj = bllAccountGroup.AccountGroupViewAllByGroupUnder(Convert.ToDecimal(tn.Name));
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
if (ListObj[0].Rows.Count > 0)
{
foreach (DataRow dr in ListObj[0].Rows)
{
tn.Nodes.Add(dr["accountGroupId"].ToString(), dr["accountGroupName"].ToString());
tn.ExpandAll();
if (tn.LastNode != null)
{
tn.LastNode.ForeColor = Color.Red;
}
else
{
tn.LastNode.ForeColor = Color.Blue;
}
}
foreach (TreeNode tn1 in tn.Nodes)
{
FillTree(tn1);
List<DataTable> ListObjLedger= bllAccountLedger.AccountLedgerViewAllByLedgerName(Convert.ToDecimal(tn1.Name));
foreach (DataRow dr in ListObjLedger[0].Rows)
{
tn1.Nodes.Add(dr["ledgerId"].ToString(), dr["ledgerName"].ToString());
tn1.ExpandAll();
if (tn1.LastNode != null)
{
tn1.LastNode.ForeColor = Color.Blue;
}
else
{
tn.LastNode.ForeColor = Color.Red;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("COA:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the accountgroup combo box
/// </summary>
public void AccountGroupComboFill()
{
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupViewAllComboFillForAccountLedger();
DataRow dr = ListObj[0].NewRow();
dr["accountGroupName"] = "All";
dr["accountGroupId"] = -1;
ListObj[0].Rows.InsertAt(dr, 0);
cmbAccountGroup.DataSource = ListObj[0];
cmbAccountGroup.ValueMember = "accountGroupId";
cmbAccountGroup.DisplayMember = "accountGroupName";
}
catch (Exception ex)
{
MessageBox.Show("ALREP2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// on combobox account group text changing
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cmbAccountGroup_TextChanged(object sender, EventArgs e)
{
try
{
if (isLoad)
{
int index = cmbAccountGroup.SelectedIndex;
string strinr = cmbAccountGroup.Text.ToString();
int dec = cmbAccountGroup.SelectedIndex;
int inRowcount = dgvMultipleAccountLedger.RowCount;
AccountGroupBll bllAccountGroup = new AccountGroupBll();
string strNature;
strNature = bllAccountGroup.MultipleAccountLedgerCrOrDr(cmbAccountGroup.Text);
for (int i = 0; i < inRowcount; i++)
{
if (strNature == "Assets" || strNature == "Income")
{
dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value = "Cr";
}
else if (strNature == "Expenses" || strNature == "Liabilities")
{
dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value = "Dr";
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("MAL12:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// on grid opening balance textbox keypress
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvtxtOpeningBalance_KeyPress(object sender, KeyPressEventArgs e)
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
try
{
if (dgvMultipleAccountLedger.CurrentCell != null)
{
if (dgvMultipleAccountLedger.Columns[dgvMultipleAccountLedger.CurrentCell.ColumnIndex].Name == "dgvtxtOpeningBalance")
{
Common.DecimalValidation(sender, e, false);
}
if (dgvMultipleAccountLedger.Columns[dgvMultipleAccountLedger.CurrentCell.ColumnIndex].Name == "dgvtxtLedgerName")
{
if (dgvMultipleAccountLedger.Columns["dgvtxtLedgerName"].Index == 1)
{
string strNature;
strNature = bllAccountGroup.MultipleAccountLedgerCrOrDr(cmbAccountGroup.Text);
if (strNature == "Assets" || strNature == "Income")
{
dgvMultipleAccountLedger.Rows[dgvMultipleAccountLedger.CurrentRow.Index].Cells["dgvcmbDebitOrCredit"].Value = "Cr";
}
else if (strNature == "Expenses" || strNature == "Liabilities")
{
dgvMultipleAccountLedger.Rows[dgvMultipleAccountLedger.CurrentRow.Index].Cells["dgvcmbDebitOrCredit"].Value = "Dr";
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("MAL17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// datagridview cell beginend edit
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvBudget_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
inUpdatingRowIndexForPartyRemove = -1;
decUpdatingLedgerForPartyremove = 0;
List<DataTable> ListObj = new List<DataTable>();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
if (cmbType.SelectedIndex == 0)
{
if (dgvBudget.CurrentCell.ColumnIndex == dgvBudget.Columns["dgvcmbParticular"].Index)
{
ListObj = bllAccountLedger.AccountLedgerViewAll();
DataRow dr = ListObj[0].NewRow();
dr[0] = 0;
dr[2] = string.Empty;
ListObj[0].Rows.InsertAt(dr, 0);
if (ListObj[0].Rows.Count > 0)
{
if (dgvBudget.RowCount > 1)
{
int inGridRowCount = dgvBudget.RowCount;
for (int inI = 0; inI < inGridRowCount - 1; inI++)
{
if (inI != e.RowIndex)
{
int inTableRowcount = ListObj[0].Rows.Count;
for (int inJ = 0; inJ < inTableRowcount; inJ++)
{
if (dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (ListObj[0].Rows[inJ]["ledgerId"].ToString() == dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value.ToString())
{
ListObj[0].Rows.RemoveAt(inJ);
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvccVoucherType = (DataGridViewComboBoxCell)dgvBudget[dgvBudget.Columns["dgvcmbParticular"].Index, e.RowIndex];
dgvccVoucherType.DataSource = ListObj[0];
dgvccVoucherType.ValueMember = "ledgerId";
dgvccVoucherType.DisplayMember = "ledgerName";
}
}
if (dgvBudget.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbParticular")
{
if (dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (bllAccountLedger.AccountGroupIdCheck(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].FormattedValue.ToString()))
{
inUpdatingRowIndexForPartyRemove = e.RowIndex;
decUpdatingLedgerForPartyremove = Convert.ToDecimal(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString());
}
}
}
if (dgvBudget.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbDrOrCr")
{
if (dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (bllAccountLedger.AccountGroupIdCheck(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].FormattedValue.ToString()))
{
inUpdatingRowIndexForPartyRemove = e.RowIndex;
decUpdatingLedgerForPartyremove = Convert.ToDecimal(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString());
}
}
}
}
else
{
if (dgvBudget.CurrentCell.ColumnIndex == dgvBudget.Columns["dgvcmbParticular"].Index)
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
ListObj = bllAccountGroup.GroupNameViewForComboFill();
DataRow dr = ListObj[0].NewRow();
dr[0] = 0;
ListObj[0].Rows.InsertAt(dr, 0);
if (ListObj[0].Rows.Count > 0)
{
if (dgvBudget.RowCount > 1)
{
int inGridRowCount = dgvBudget.RowCount;
for (int inI = 0; inI < inGridRowCount - 1; inI++)
{
if (inI != e.RowIndex)
{
int inTableRowcount = ListObj[0].Rows.Count;
for (int inJ = 0; inJ < inTableRowcount; inJ++)
{
if (dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (ListObj[0].Rows[inJ]["accountGroupName"].ToString() == dgvBudget.Rows[inI].Cells["dgvcmbParticular"].Value.ToString())
{
ListObj[0].Rows.RemoveAt(inJ);
break;
}
}
}
}
}
}
DataGridViewComboBoxCell dgvccVoucherType = (DataGridViewComboBoxCell)dgvBudget[dgvBudget.Columns["dgvcmbParticular"].Index, e.RowIndex];
dgvccVoucherType.DataSource = ListObj[0];
dgvccVoucherType.ValueMember = "accountGroupId";
dgvccVoucherType.DisplayMember = "accountGroupName";
}
}
if (dgvBudget.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbParticular")
{
if (dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (bllAccountLedger.AccountGroupIdCheck(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].FormattedValue.ToString()))
{
inUpdatingRowIndexForPartyRemove = e.RowIndex;
decUpdatingLedgerForPartyremove = Convert.ToDecimal(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString());
}
}
}
if (dgvBudget.Rows[e.RowIndex].Cells[e.ColumnIndex].OwningColumn.Name == "dgvcmbDrOrCr")
{
if (dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value != null && dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString() != string.Empty)
{
if (bllAccountLedger.AccountGroupIdCheck(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].FormattedValue.ToString()))
{
inUpdatingRowIndexForPartyRemove = e.RowIndex;
decUpdatingLedgerForPartyremove = Convert.ToDecimal(dgvBudget.Rows[e.RowIndex].Cells["dgvcmbParticular"].Value.ToString());
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("BU37:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// function to fill particulars combo
/// </summary>
public void GroupNameViewForComboFill()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
ListObj = bllAccountGroup.GroupNameViewForComboFill();
dgvcmbParticular.DataSource = ListObj[0];
dgvcmbParticular.ValueMember = "accountGroupId";
dgvcmbParticular.DisplayMember = "accountGroupName";
}
catch (Exception ex)
{
MessageBox.Show("BU3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save and edit account group
/// </summary>
public void SaveOrEdit()
{
try
{
strAccountGroupName = btnSave.Text == "Save" ? string.Empty : strAccountGroupName;
if (CheckExistanceOfGroupName() == false)
{
if (txtAccountGroupName.Text.Trim() == string.Empty)
{
Messages.InformationMessage("Enter account group name");
txtAccountGroupName.Focus();
}
else if (cmbGroupUnder.SelectedIndex == -1)
{
Messages.InformationMessage("Select under");
cmbGroupUnder.Focus();
}
else if (cmbNature.SelectedIndex == -1)
{
Messages.InformationMessage("Select nature");
cmbNature.Focus();
}
else
{
AccountGroupInfo infoAccountGroup = new AccountGroupInfo();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
infoAccountGroup.AccountGroupName = txtAccountGroupName.Text.Trim();
infoAccountGroup.GroupUnder = Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString());
infoAccountGroup.Nature = cmbNature.SelectedItem.ToString();
if (cmbAffectGrossProfit.SelectedIndex == -1)
{
infoAccountGroup.AffectGrossProfit = "No";
}
else
{
infoAccountGroup.AffectGrossProfit = cmbAffectGrossProfit.SelectedItem.ToString();
}
infoAccountGroup.IsDefault = false;
infoAccountGroup.Narration = txtNarration.Text.Trim();
infoAccountGroup.Extra1 = string.Empty;
infoAccountGroup.Extra2 = string.Empty;
if (btnSave.Text == "Save")
{
if (Messages.SaveConfirmation())
{
decAccountGroupId = bllAccountGroup.AccountGroupAddWithIdentity(infoAccountGroup);
Messages.SavedMessage();
decIdForOtherForms = decAccountGroupId;
if (frmAccountLedgerobj != null)
{
this.Close();
}
GridFill();
Clear();
}
}
else
{
if (isDefault == true)
{
Messages.InformationMessage("Can't update build in account group");
}
else if (txtAccountGroupName.Text.Trim().ToLower() != cmbGroupUnder.Text.ToLower())
{
if (Messages.UpdateConfirmation())
{
infoAccountGroup.AccountGroupId = decAccountGroupIdForEdit;
if (bllAccountGroup.AccountGroupUpdate(infoAccountGroup))
{
Messages.UpdatedMessage();
}
GridFill();
Clear();
}
}
else
{
Messages.InformationMessage(" Can't save under same group");
}
}
}
}
else
{
Messages.InformationMessage(" Account group already exist");
txtAccountGroupName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("AG8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill acoountgroup combobox
/// </summary>
public void AccountGroupComboFillSearch()
{
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
DataTable dtblAcccountGroup = new DataTable();
ListObj = bllAccountGroup.AccountGroupViewAllComboFill();
DataRow dr = ListObj[0].NewRow();
dr[1] = "All";
ListObj[0].Rows.InsertAt(dr, 0);
cmbGroupSearch.DataSource = ListObj[0];
ListObj.Add(dtblAcccountGroup);
cmbGroupSearch.ValueMember = "accountGroupId";
cmbGroupSearch.DisplayMember = "accountGroupName";
cmbGroupSearch.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show("AL9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Form Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmChartOfAccount_Load(object sender, EventArgs e)
{
try
{
dtblItems.Columns.Add("name");
dtblItems.Columns.Add("type");
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupViewAllByGroupUnder(-1);
foreach (DataRow dr in ListObj[0].Rows)
{
tvChartOfAccount.Nodes.Add(dr["accountGroupId"].ToString(), dr["accountGroupName"].ToString());
}
foreach (TreeNode tn1 in tvChartOfAccount.Nodes)
{
FillTree(tn1);
}
}
catch (Exception ex)
{
MessageBox.Show("COA:3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Grid Fill function while coming from other form to update or delete
/// </summary>
public void FillFunction()
{
try
{
//PaymentMasterSP SpPaymentMaster = new PaymentMasterSP();
PaymentMasterInfo InfoPaymentMaster = new PaymentMasterInfo();
//PaymentDetailsSP SpPaymentDetails = new PaymentDetailsSP();
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
InfoPaymentMaster = BllPaymentVoucher.PaymentMasterViewByMasterId(decPaymentmasterId);//view master details
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(InfoPaymentMaster.VoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.ReadOnly = true;
txtVoucherNo.Text = InfoPaymentMaster.InvoiceNo;
txtDate.Focus();
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = InfoPaymentMaster.InvoiceNo;
txtVoucherNo.Focus();
}
dtpDate.Text = InfoPaymentMaster.Date.ToString();
cmbBankorCash.SelectedValue = InfoPaymentMaster.LedgerId;
txtNarration.Text = InfoPaymentMaster.Narration;
txtTotal.Text = InfoPaymentMaster.TotalAmount.ToString();
decDailySuffixPrefixId = InfoPaymentMaster.SuffixPrefixId;
decPaymentVoucherTypeId = InfoPaymentMaster.VoucherTypeId;
strVoucherNo = InfoPaymentMaster.VoucherNo;
strInvoiceNo = InfoPaymentMaster.InvoiceNo;
//DataTable dtbl = new DataTable();
List<DataTable> listObj1 = new List<DataTable>();
listObj1 = BllPaymentVoucher.PaymentDetailsViewByMasterId(decPaymentmasterId);//view details details
for (int inI = 0; inI < listObj1[0].Rows.Count; inI++)
{
dgvPaymentVoucher.Rows.Add();
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(listObj1[0].Rows[inI]["ledgerId"].ToString());
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentMasterId"].Value = listObj1[0].Rows[inI]["paymentMasterId"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtpaymentDetailsId"].Value = listObj1[0].Rows[inI]["paymentDetailsId"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = listObj1[0].Rows[inI]["amount"].ToString();
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listObj1[0].Rows[inI]["exchangeRateId"].ToString());
decimal decDetailsId1 = Convert.ToDecimal(listObj1[0].Rows[inI]["paymentDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decPaymentVoucherTypeId);
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
decimal decLedgerId = Convert.ToDecimal(listObj1[0].Rows[inI]["ledgerId"].ToString());
bool IsBankAccount = bllAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(dgvPaymentVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)//to make amount and currency read only when party is choosen as ledger
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = true;
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = false;
dgvPaymentVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = false;
}
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value = listObj1[0].Rows[inI]["ChequeNo"].ToString();
if (dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
dgvPaymentVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value = Convert.ToDateTime(listObj1[0].Rows[inI]["ChequeDate"].ToString()).ToString("dd-MMM-yyyy");
}
dgvPaymentVoucher.Rows[inI].HeaderCell.Value = string.Empty;
}
List<DataTable> listObj = new List<DataTable>();
listObj = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decPaymentVoucherTypeId, strVoucherNo, InfoPaymentMaster.Date);
dtblPartyBalance = listObj[0];
}
catch (Exception ex)
{
MessageBox.Show("PV36:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// On print button click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
if (dgvCashOrBank.Rows.Count > 0)
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
DataSet dsCashBankBook = bllAccountGroup.CashBankBookPrinting(1, this.dtpFromDate.Value, this.dtpToDate.Value, true);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.CashBankBookPrinting(dsCashBankBook);
}
else
{
Messages.InformationMessage("No data found");
}
}
catch (Exception ex)
{
MessageBox.Show("CBBOOK09 :" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Fill function for updation
/// </summary>
public void FillFunction()
{
try
{
isValueChange = false;
ReceiptMasterInfo InfoReceiptMaster = new ReceiptMasterInfo();
ReceiptDetailsInfo InfoReceiptDetails = new ReceiptDetailsInfo();
RecieptVoucherBll bllRecieptVoucherBll = new RecieptVoucherBll();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVoucherType = new VoucherTypeBll();
AccountGroupBll BllAccountGroup = new AccountGroupBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
InfoReceiptMaster = bllRecieptVoucherBll.ReceiptMasterViewByMasterId(decRecieptmasterId);
isAutomatic = BllVoucherType.CheckMethodOfVoucherNumbering(InfoReceiptMaster.VoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.ReadOnly = true;
txtVoucherNo.Text = InfoReceiptMaster.InvoiceNo;
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = InfoReceiptMaster.VoucherNo;
}
dtpDate.Value = InfoReceiptMaster.Date;
cmbCashOrBank.SelectedValue = InfoReceiptMaster.LedgerId;
txtNarration.Text = InfoReceiptMaster.Narration;
txtTotal.Text = InfoReceiptMaster.TotalAmount.ToString();
decDailySuffixPrefixId = InfoReceiptMaster.SuffixPrefixId;
decReceiptVoucherTypeId = InfoReceiptMaster.VoucherTypeId;
strVoucherNo = InfoReceiptMaster.VoucherNo;
strInvoiceNo = InfoReceiptMaster.InvoiceNo;
List<DataTable> listobj = new List<DataTable>();
listobj = bllRecieptVoucherBll.ReceiptDetailsViewByMasterId(decRecieptmasterId);
for (int inI = 0; inI < listobj[0].Rows.Count; inI++)
{
dgvReceiptVoucher.Rows.Add();
dgvReceiptVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value = Convert.ToDecimal(listobj[0].Rows[inI]["ledgerId"].ToString());
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtreceiptMasterId"].Value = listobj[0].Rows[inI]["receiptMasterId"].ToString();
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtreceiptDetailsId"].Value = listobj[0].Rows[inI]["receiptDetailsId"].ToString();
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtAmount"].Value = listobj[0].Rows[inI]["amount"].ToString();
dgvReceiptVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listobj[0].Rows[inI]["exchangeRateId"].ToString());
decimal decDetailsId1 = Convert.ToDecimal(listobj[0].Rows[inI]["receiptDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, decReceiptVoucherTypeId);
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
decimal decLedgerId = Convert.ToDecimal(listobj[0].Rows[inI]["ledgerId"].ToString());
bool IsBankAccount = BllAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(dgvReceiptVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)
{
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = true;
dgvReceiptVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtAmount"].ReadOnly = false;
dgvReceiptVoucher.Rows[inI].Cells["dgvcmbCurrency"].ReadOnly = false;
}
if (listobj[0].Rows[inI]["chequeNo"].ToString() != string.Empty)
{
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value = listobj[0].Rows[inI]["chequeNo"].ToString();
dgvReceiptVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value = Convert.ToDateTime(listobj[0].Rows[inI]["chequeDate"].ToString()).ToString("dd-MMM-yyyy");
}
dgvReceiptVoucher.Rows[inI].HeaderCell.Value = string.Empty;
}
List<DataTable> listObj = new List<DataTable>();
listObj = BllPartyBalance.PartyBalanceViewByVoucherNoAndVoucherType(decReceiptVoucherTypeId, strVoucherNo, InfoReceiptMaster.Date);
dtblPartyBalance = listObj[0];
isValueChange = true;
}
catch (Exception ex)
{
MessageBox.Show("RV34:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check existance of account group in DataBase
/// </summary>
/// <returns></returns>
public bool CheckExistanceOfGroupName()
{
bool isExist = false;
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
isExist = bllAccountGroup.AccountGroupCheckExistence(txtAccountGroupName.Text.Trim(), 0);
if (isExist)
{
if (txtAccountGroupName.Text.ToLower() == strAccountGroupName.ToLower())
{
isExist = false;
}
}
}
catch (Exception ex)
{
MessageBox.Show("AG5:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return isExist;
}
/// <summary>
/// Fills to control on cell double click in Datagridview
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvAccountGroup_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1)
{
AccountGroupInfo InfoAccountGroup = new AccountGroupInfo();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
InfoAccountGroup = bllAccountGroup.AccountGroupViewForUpdate(Convert.ToDecimal(dgvAccountGroup.CurrentRow.Cells["dgvtxtAccountGroupId"].Value.ToString()));
bool Isdefault=InfoAccountGroup.IsDefault;
txtAccountGroupName.Text = InfoAccountGroup.AccountGroupName;
cmbGroupUnder.SelectedValue = InfoAccountGroup.GroupUnder.ToString();
decimal decAccountGroupId =Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString());
string strNature = bllAccountGroup.AccountGroupNatureUnderGroup(decAccountGroupId);
if (strNature != "NA")
{
cmbNature.Text = InfoAccountGroup.Nature;
cmbNature.Enabled = false;
}
else
{
cmbNature.Text = InfoAccountGroup.Nature;
cmbNature.Enabled = true;
}
if (Isdefault)
{
decimal decAffectGrossProfit = Convert.ToDecimal(InfoAccountGroup.AffectGrossProfit);
if (decAffectGrossProfit == 0)
{
cmbAffectGrossProfit.Text = "No";
}
else
{
cmbAffectGrossProfit.Text = "Yes";
}
}
else
{
cmbAffectGrossProfit.Text = InfoAccountGroup.AffectGrossProfit;
}
txtNarration.Text = InfoAccountGroup.Narration;
btnSave.Text = "Update";
txtAccountGroupName.Focus();
btnDelete.Enabled = true;
strAccountGroupName = InfoAccountGroup.AccountGroupName;
decAccountGroupIdForEdit = Convert.ToDecimal(dgvAccountGroup.CurrentRow.Cells["dgvtxtAccountGroupId"].Value.ToString());
inId = Convert.ToInt32(InfoAccountGroup.AccountGroupId.ToString());
isDefault = Convert.ToBoolean(InfoAccountGroup.IsDefault);
if (isDefault == true && strNature!="NA")
{
txtAccountGroupName.Enabled = false;
cmbAffectGrossProfit.Enabled = false;
cmbGroupUnder.Enabled = false;
cmbNature.Enabled = false;
}
else
{
if (strNature == "NA")
{
txtAccountGroupName.Enabled = true;
cmbAffectGrossProfit.Enabled = true;
cmbGroupUnder.Enabled = true;
cmbNature.Enabled = true;
}
}
if (isDefault == false)
{
if (bllAccountGroup.AccountGroupCheckExistenceOfUnderGroup(Convert.ToDecimal(inId.ToString())) == false)
{
cmbAffectGrossProfit.Enabled = false;
cmbGroupUnder.Enabled = false;
cmbNature.Enabled = false;
}
else
{
if (strNature == "NA")
{
cmbAffectGrossProfit.Enabled = true;
cmbGroupUnder.Enabled = true;
cmbNature.Enabled = true;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("AG18:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void cmbGroupUnder_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (cmbGroupUnder.SelectedValue != null && cmbGroupUnder.SelectedValue.ToString() != "System.Data.DataRowView")
{
decimal decAccountGroupId = Convert.ToDecimal(cmbGroupUnder.SelectedValue.ToString());
AccountGroupBll bllAccountGroup = new AccountGroupBll();
AccountGroupInfo infoAccountGroup = new AccountGroupInfo();
infoAccountGroup = bllAccountGroup.AccountGroupView(decAccountGroupId);
string strNature = infoAccountGroup.Nature;
string strIsAffectGrossProfit = infoAccountGroup.AffectGrossProfit;
if (strNature != "NA")
{
cmbNature.Text = strNature;
if (infoAccountGroup.AffectGrossProfit == "1")
{
cmbAffectGrossProfit.SelectedIndex = 0;
}
else
{
cmbAffectGrossProfit.SelectedIndex = 1;
}
cmbNature.Enabled = false;
cmbAffectGrossProfit.Enabled = false;
}
else
{
cmbNature.Enabled = true;
cmbAffectGrossProfit.Enabled = true;
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// Function to print report
/// </summary>
/// <param name="fromDate"></param>
/// <param name="toDate"></param>
public void Print(DateTime fromDate, DateTime toDate)
{
try
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
DataSet dsAccountGroup = new DataSet();
List<DataTable> ListObj = bllAccountGroup.AccountGroupReportFill(fromDate, toDate);
string strSum = lblBalanceTotal.Text;
DataTable dtblSum = new DataTable();
dtblSum.Columns.Add("Sum", typeof(string));
DataRow dr = dtblSum.NewRow();
dr[0] = strSum;
dtblSum.Rows.InsertAt(dr, 0);
List<DataTable> listCompany = bllFinancialStatement.FundFlowReportPrintCompany(1);
dsAccountGroup.Tables.Add(ListObj[0]);
dsAccountGroup.Tables.Add(listCompany[0]);
dsAccountGroup.Tables.Add(dtblSum);
frmReport frmReport = new frmReport();
frmReport.MdiParent = formMDI.MDIObj;
frmReport.AccountGroup(dsAccountGroup);
}
catch (Exception ex)
{
MessageBox.Show("AGR:1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to delete account group
/// </summary>
public void Delete()
{
try
{
if (isDefault == true)
{
Messages.InformationMessage("Can't delete build in account group");
}
//else if (PublicVariables.isMessageDelete)
//{
else if (Messages.DeleteConfirmation())
{
AccountGroupInfo InfoAccountGroup = new AccountGroupInfo();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
if ((bllAccountGroup.AccountGroupReferenceDelete(decAccountGroupIdForEdit) == -1))
{
Messages.ReferenceExistsMessage();
}
else
{
Messages.DeletedMessage();
btnSave.Text = "Save";
btnDelete.Enabled = false;
Clear();
}
}
}
catch (Exception ex)
{
MessageBox.Show("AG10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the report in grid
/// </summary>
public void AccountGroupGridFill()
{
decimal decBalanceTotal = 0;
DateTime dtmFromDate = DateTime.Now;
DateTime dtmToDate = DateTime.Now;
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
try
{
if (txtFromDate.Text != string.Empty)
{
dtmFromDate = Convert.ToDateTime(txtFromDate.Text);
}
if (txtToDate.Text != string.Empty)
{
dtmToDate = Convert.ToDateTime(txtToDate.Text);
}
ListObj = bllAccountGroup.AccountGroupReportFill(dtmFromDate, dtmToDate);
for (int i = 0; i < ListObj[0].Rows.Count; i++)
{
if (Convert.ToDecimal(ListObj[0].Rows[i]["accountGroupId"].ToString()) == 6)
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
CalculationMethod();
decimal dcOpeninggStock = bllFinancialStatement.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true);
dcOpeninggStock = Math.Round(dcOpeninggStock, PublicVariables._inNoOfDecimalPlaces);
decimal decOpBalance = Convert.ToDecimal(ListObj[0].Rows[i]["OpBalance"].ToString()) + dcOpeninggStock;
decimal decClosing = Convert.ToDecimal(ListObj[0].Rows[i]["balance1"].ToString()) + dcOpeninggStock;
if (decOpBalance >= 0)
{
ListObj[0].Rows[i]["OpeningBalance"] = decOpBalance.ToString() + "Dr";
}
else
{
ListObj[0].Rows[i]["OpeningBalance"] = decOpBalance.ToString() + "Cr";
}
if (decClosing >= 0)
{
ListObj[0].Rows[i]["balance"] = decClosing.ToString() + "Dr";
}
else
{
ListObj[0].Rows[i]["balance"] = decClosing.ToString() + "Cr";
}
ListObj[0].Rows[i]["balance1"] = decClosing.ToString();
}
}
dgvAccountGroupReport.DataSource = ListObj[0];
if (dgvAccountGroupReport.RowCount > 0)
{
for (int i = 0; i < dgvAccountGroupReport.RowCount; i++)
{
decBalanceTotal = decBalanceTotal + Convert.ToDecimal(dgvAccountGroupReport.Rows[i].Cells["dgvtxtBalance1"].Value.ToString());
}
}
if (decBalanceTotal < 0)
{
decBalanceTotal = -1 * decBalanceTotal;
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr";
}
else
{
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr"; ;
}
}
catch (Exception ex)
{
MessageBox.Show("AGR:4" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the report in grid for fundflow
/// </summary>
/// <param name="decCS"></param>
public void GridFillForFundFlow(decimal decCS)
{
decimal decBalanceTotal = 0;
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text));
DataRow drow = ListObj[0].NewRow();
decimal decCsop = 0;
drow[1] = -2;
drow[2] = 0;
drow[3] = "Closing Stock";
drow[4] = decCsop .ToString ()+ ".00Dr";
drow[5] = decCS;
drow[6] = "0.00";
drow[7] = decCS.ToString ()+"Dr";
drow[8] = decCS.ToString();
ListObj[0].Rows.InsertAt(drow, ListObj[0].Rows.Count);
dgvAccountGroupWiseReport.DataSource = ListObj[0];
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++)
{
decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString());
}
}
if (decBalanceTotal < 0)
{
decBalanceTotal = -1 * decBalanceTotal;
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr";
}
else
{
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Dr";
}
}
catch (Exception ex)
{
MessageBox.Show("AGWREP03:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Gridview cell value changed , doing basic calculations and checking invalid entries
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvPaymentVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
TotalAmount();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == string.Empty)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
}
}
AccountGroupBll bllAccountGroup = new AccountGroupBll();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value != null && dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString().Trim() != string.Empty)
{
if (dgvPaymentVoucher.CurrentCell.ColumnIndex == dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].ColumnIndex)
{
/*************Remove partybalance while changing the ledger ************/
if (inUpdatingRowIndexForPartyRemove != -1)
{
int inTableRowCount = dtblPartyBalance.Rows.Count;
for (int inJ = 0; inJ < inTableRowCount; inJ++)
{
if (dtblPartyBalance.Rows.Count == inJ)
{
break;
}
if (Convert.ToDecimal(dtblPartyBalance.Rows[inJ]["ledgerId"].ToString()) == decUpdatingLedgerForPartyremove)
{
if (dtblPartyBalance.Rows[inJ]["PartyBalanceId"].ToString() != "0")
{
arrlstOfDeletedPartyBalanceRow.Add(dtblPartyBalance.Rows[inJ]["PartyBalanceId"]);
}
dtblPartyBalance.Rows.RemoveAt(inJ);
inJ--;
}
}
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtAmount"].Value = string.Empty;
decUpdatingLedgerForPartyremove = 0;
inUpdatingRowIndexForPartyRemove = -1;
}
/*************************************************************************/
decimal decLedgerId = Convert.ToDecimal(dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbAccountLedger"].Value.ToString());
bool IsBankAccount = bllAccountGroup.AccountGroupwithLedgerId(decLedgerId);
decimal decI = Convert.ToDecimal(bllAccountLedger.AccountGroupIdCheck(dgvPaymentVoucher.CurrentRow.Cells["dgvcmbAccountLedger"].FormattedValue.ToString()));
if (decI > 0)//to make amount and currency read only when party is choosen as ledger
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = true;
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].Value = string.Empty;
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);
dgvPaymentVoucher.CurrentRow.Cells["dgvcmbCurrency"].ReadOnly = true;
}
else
{
dgvPaymentVoucher.CurrentRow.Cells["dgvtxtAmount"].ReadOnly = false;
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("MultiCurrency") == "Yes")
{
dgvcmbCurrency.ReadOnly = false;
}
else
{
dgvcmbCurrency.ReadOnly = true;
}
}
}
}
CheckColumnMissing();
DateValidation objVal = new DateValidation();
TextBox txtDate1 = new TextBox();
if (dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null)
{
txtDate1.Text = dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate1);
if (isDate)
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate1.Text;
}
else
{
dgvPaymentVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("PV48:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill master grid
/// </summary>
public void GridFill()
{
try
{
List<DataTable> ListObj = new List<DataTable>();
AccountGroupBll bllAccountGroup = new AccountGroupBll();
if (cmbGroupUnderSearch.Text.Trim() == string.Empty)
{
cmbGroupUnderSearch.Text = "All";
}
ListObj = bllAccountGroup.AccountGroupSearch(txtAccountGroupNameSearch.Text.Trim(), cmbGroupUnderSearch.Text);
dgvAccountGroup.DataSource = ListObj[0];
}
catch (Exception ex)
{
MessageBox.Show("AG1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to check wheteher cash or bank is selected
/// </summary>
public void CheckWhetherBankOrCash()
{
try
{
//----- To make readonly txtChequeNo and txtChequeDate if selected ledger group is cash-----//
if (cmbCashOrBank.SelectedValue != null && cmbCashOrBank.SelectedValue.ToString() != string.Empty)
{
decimal decLedger = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString());
bool isBankAcocunt = false;
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.CheckWheatherLedgerUnderCash();
//-------- Checking whether the selected legder is under bank----------//
foreach (DataRow dr in ListObj[0].Rows)
{
string str = dr.ItemArray[0].ToString();
if (decLedger == Convert.ToDecimal(dr.ItemArray[0].ToString()))
{
isBankAcocunt = true;
}
}
if (isBankAcocunt)
{
txtCheckNo.Enabled = false;
txtChequeDate.Enabled = false;
dtpCheckDate.Enabled = false;
txtCheckNo.Clear();
}
else
{
txtCheckNo.Enabled = true;
txtChequeDate.Enabled = true;
dtpCheckDate.Enabled = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show("AP17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
///Function to fill acoountgroup combobox
/// </summary>
public void AccountGroupComboFill()
{
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupViewAllComboFillForAccountLedger();
cmbGroup.DataSource = ListObj[0];
cmbGroup.ValueMember = "accountGroupId";
cmbGroup.DisplayMember = "accountGroupName";
}
catch (Exception ex)
{
MessageBox.Show("AL8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Call the totalamount,SlNo,InvalidEntry functions to do the all are the process even if change one value of the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvContraVoucher_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
if (e.RowIndex != -1 && e.ColumnIndex != -1)
{
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value.ToString() != "")
{
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value == null || dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value.ToString() == "")
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(1);//PublicVariables._decCurrencyId;
}
}
TotalAmount();
SlNo();
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value != null)
{
decimal decLedger = Convert.ToDecimal(dgvContraVoucher.Rows[e.RowIndex].Cells["dgvcmbBankorCashAccount"].Value.ToString());
isBankAcocunt = bllAccountGroup.AccountGroupwithLedgerId(decLedger);
if (isBankAcocunt)
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly = false;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].ReadOnly = false;
}
else
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly = true;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].ReadOnly = true;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = string.Empty;
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeNo"].Value = string.Empty;
}
}
CheckColumnMissing(e);
if (!dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].ReadOnly)
{
DateValidation objVal = new DateValidation();
TextBox txtDate = new TextBox();
if (dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value != null)
{
txtDate.Text = dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value.ToString();
bool isDate = objVal.DateValidationFunction(txtDate);
if (isDate)
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = txtDate.Text;
}
else
{
dgvContraVoucher.Rows[e.RowIndex].Cells["dgvtxtChequeDate"].Value = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("CV:42" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill the report in grid
/// </summary>
public void GridFill()
{
decimal decBalanceTotal = 0;
try
{
AccountGroupBll bllAccountGroup = new AccountGroupBll();
List<DataTable> ListObj = new List<DataTable>();
ListObj = bllAccountGroup.AccountGroupWiseReportViewAll(decAccountGroupId, Convert.ToDateTime(txtFromDate.Text), Convert.ToDateTime(txtToDate.Text));
if (decAccountGroupId == 6)
{
FinancialStatementBll bllFinancialStatement = new FinancialStatementBll();
CalculationMethod();
decimal dcOpeninggStock = bllFinancialStatement.StockValueGetOnDate(PublicVariables._dtFromDate, calculationMethod, true, true);
dcOpeninggStock = Math.Round(dcOpeninggStock, PublicVariables._inNoOfDecimalPlaces);
int inRowCount = ListObj[0].Rows.Count;
DataRow dr = ListObj[0].NewRow();
dr["SlNo"] = inRowCount+1;
dr["accountGroupId"] = -2;
dr["ledgerId"] = 0;
dr["name"] = "Opening Stock";
if (dcOpeninggStock >= 0)
{
dr["OpeningBalance"] = dcOpeninggStock + "Dr";
dr["Balance"] = dcOpeninggStock + "Dr";
}
else
{
dr["OpeningBalance"] = dcOpeninggStock + "Cr";
dr["Balance"] = dcOpeninggStock + "Cr";
}
dr["debit"] = Math.Round(Convert.ToDecimal(0.00000), PublicVariables._inNoOfDecimalPlaces).ToString()+".00" ;
dr["credit"] = Math.Round(Convert.ToDecimal(0.00000), PublicVariables._inNoOfDecimalPlaces).ToString()+".00";
dr["balance1"] = dcOpeninggStock;
ListObj[0].Rows.InsertAt(dr, inRowCount);
}
dgvAccountGroupWiseReport.DataSource = ListObj[0];
if (ListObj[0].Rows.Count > 0)
{
for (int i = 0; i < dgvAccountGroupWiseReport.RowCount; i++)
{
decBalanceTotal += Convert.ToDecimal(dgvAccountGroupWiseReport.Rows[i].Cells["balance1"].Value.ToString());
}
}
if (decBalanceTotal < 0)
{
decBalanceTotal = -1 * decBalanceTotal;
lblBalanceTotal.Text = decBalanceTotal.ToString() + "Cr";
}
else
{
lblBalanceTotal.Text = decBalanceTotal.ToString()+"Dr";
}
}
catch (Exception ex)
{
MessageBox.Show("AGWREP02:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
