/// <summary>
/// Save data to the database
/// </summary>
public void SaveFunction()
{
try
{
int inRowcount = dgvMultipleAccountLedger.RowCount;//edited by Runali
int inRowcountDec = (dgvMultipleAccountLedger.RowCount) - 1;
decimal decOpeningBalance = 0;
decimal decLedgerId = 0;
bool isSave = false;
AccountLedgerInfo infoAccountledger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
FinancialYearBll BllFinancialYear = new FinancialYearBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
for (int i = 0; i < inRowcount - 1; i++)
{
infoAccountledger.AccountGroupId = Convert.ToDecimal(cmbAccountGroup.SelectedValue.ToString());
infoAccountledger.LedgerName = dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtLedgerName"].Value.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value != null)
{
infoAccountledger.OpeningBalance = Convert.ToDecimal(dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString());
}
else
{
infoAccountledger.OpeningBalance = 0;
}
infoAccountledger.CrOrDr = dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtNarration"].Value != null)
{
infoAccountledger.Narration = dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtNarration"].Value.ToString();
}
else
{
infoAccountledger.Narration = string.Empty;
}
infoAccountledger.MailingName = string.Empty;
infoAccountledger.Address = string.Empty;
infoAccountledger.State = string.Empty;
infoAccountledger.Phone = string.Empty;
infoAccountledger.Mobile = string.Empty;
infoAccountledger.Email = string.Empty;
infoAccountledger.CreditPeriod = 0;
infoAccountledger.CreditLimit = 0;
infoAccountledger.PricinglevelId = 0;
infoAccountledger.BillByBill = false;
infoAccountledger.Tin = string.Empty;
infoAccountledger.Cst = string.Empty;
infoAccountledger.Pan = string.Empty;
infoAccountledger.RouteId = 0;
infoAccountledger.BankAccountNumber = string.Empty;
infoAccountledger.BranchName = string.Empty;
infoAccountledger.BranchCode = string.Empty;
infoAccountledger.Extra1 = string.Empty;
infoAccountledger.Extra2 = string.Empty;
infoAccountledger.AreaId = 0;
infoAccountledger.IsDefault = false;
infoAccountledger.ExtraDate = PublicVariables._dtCurrentDate;
decLedgerId = bllAccountLedger.AccountLedgerAddWithIdentity(infoAccountledger);
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value != null && dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString() != "0")
{
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString() != string.Empty)
{
string strfinancialId;
decOpeningBalance = Convert.ToDecimal(dgvMultipleAccountLedger.Rows[i].Cells["dgvtxtOpeningBalance"].Value.ToString());
infoFinancialYear = BllFinancialYear.FinancialYearViewForAccountLedger(1);
strfinancialId = infoFinancialYear.FromDate.ToString("dd-MMM-yyyy");
infoLedgerPosting.VoucherTypeId = 1;
infoLedgerPosting.Date = Convert.ToDateTime(strfinancialId.ToString());
infoLedgerPosting.LedgerId = decLedgerId;
infoLedgerPosting.VoucherNo = decLedgerId.ToString();
if (dgvMultipleAccountLedger.Rows[i].Cells["dgvcmbDebitOrCredit"].Value.ToString() == "Dr")
{
infoLedgerPosting.Debit = decOpeningBalance;
}
else
{
infoLedgerPosting.Credit = decOpeningBalance;
}
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.InvoiceNo = decLedgerId.ToString();
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
BllLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
isSave = true;
}
if (isSave)
{
Messages.SavedMessage();
cmbAccountGroup.Focus();
cmbAccountGroup.SelectedIndex = -1;
dgvMultipleAccountLedger.Rows.Clear();
}
else
{
}
}
catch (Exception ex)
{
MessageBox.Show("MAL6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Creating one ledger for the purticular tax
/// </summary>
public void CreateLedger()
{
try
{
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
infoAccountLedger.AccountGroupId = 20;
infoAccountLedger.LedgerName = txtTaxName.Text;
infoAccountLedger.OpeningBalance = 0;
infoAccountLedger.IsDefault = false;
infoAccountLedger.CrOrDr = "Cr";
infoAccountLedger.Narration = string.Empty;
infoAccountLedger.MailingName = txtTaxName.Text;
infoAccountLedger.Address = string.Empty;
infoAccountLedger.Phone = string.Empty;
infoAccountLedger.Mobile = string.Empty;
infoAccountLedger.Email = string.Empty;
infoAccountLedger.CreditPeriod = 0;
infoAccountLedger.CreditLimit = 0;
infoAccountLedger.PricinglevelId = 0;
infoAccountLedger.BillByBill = false;
infoAccountLedger.Tin = string.Empty;
infoAccountLedger.Cst = string.Empty;
infoAccountLedger.Pan = string.Empty;
infoAccountLedger.RouteId = 1;
infoAccountLedger.BankAccountNumber = string.Empty;
infoAccountLedger.BranchName = string.Empty;
infoAccountLedger.BranchCode = string.Empty;
infoAccountLedger.ExtraDate = DateTime.Now;
infoAccountLedger.Extra1 = string.Empty;
infoAccountLedger.Extra2 = string.Empty;
infoAccountLedger.AreaId = 1;
bllAccountLedger.AccountLedgerAddWithIdentity(infoAccountLedger);
}
catch (Exception ex)
{
MessageBox.Show("TAX:12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save account ledger
/// </summary>
public void SaveFunction()
{
try
{
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerBll bllAccountLedger = new AccountLedgerBll();
infoAccountLedger.LedgerName = txtLedgerName.Text.Trim();
infoAccountLedger.AccountGroupId = Convert.ToDecimal(cmbGroup.SelectedValue.ToString());
decOpeningBalance = Convert.ToDecimal(((txtOpeningBalance.Text == "") ? "0" : txtOpeningBalance.Text.Trim()));
infoAccountLedger.OpeningBalance = decOpeningBalance;
infoAccountLedger.CrOrDr = cmbOpeningBalanceCrOrDr.Text.Trim();
infoAccountLedger.Narration = txtNarration.Text.Trim();
infoAccountLedger.IsDefault = false;
if (isBankAccount)
{
infoAccountLedger.BankAccountNumber = txtAcNo.Text.Trim();
infoAccountLedger.BranchName = txtBranchName.Text.Trim();
infoAccountLedger.BranchCode = txtBranchCode.Text.Trim();
}
else
{
if (isSundryDebtorOrCreditor)
{
infoAccountLedger.BankAccountNumber = txtAccountNo.Text;
infoAccountLedger.BranchName = string.Empty;
infoAccountLedger.BranchCode = string.Empty;
}
else
{
infoAccountLedger.BankAccountNumber = string.Empty;
infoAccountLedger.BranchName = string.Empty;
infoAccountLedger.BranchCode = string.Empty;
}
}
if (isSundryDebtorOrCreditor)
{
infoAccountLedger.MailingName = txtMailingName.Text.Trim();
infoAccountLedger.BankAccountNumber = txtAccountNo.Text.Trim();
infoAccountLedger.Address = txtAddress.Text.Trim();
infoAccountLedger.Phone = txtPhone.Text.Trim();
infoAccountLedger.Mobile = txtMobile.Text.Trim();
infoAccountLedger.Email = txtEmail.Text.Trim();
infoAccountLedger.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text.Trim());
infoAccountLedger.CreditLimit = Convert.ToDecimal(txtCreditLimit.Text.Trim());
if (cmbPricingLevel.SelectedIndex <= 0)
{
infoAccountLedger.PricinglevelId = 1;
}
else
{
infoAccountLedger.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
if (cmbBillByBill.Text == "Yes")
{
infoAccountLedger.BillByBill = true;
}
else
{
infoAccountLedger.BillByBill = false;
}
infoAccountLedger.Tin = txtTin.Text.Trim();
infoAccountLedger.Cst = txtCst.Text.Trim();
infoAccountLedger.Pan = txtPan.Text.Trim();
if (cmbArea.SelectedIndex <= 0)
{
infoAccountLedger.AreaId = 1;
}
else
{
infoAccountLedger.AreaId = Convert.ToDecimal(cmbArea.SelectedValue.ToString());
}
if (cmbRoute.SelectedIndex < 0)
{
infoAccountLedger.RouteId = 1;
}
else
{
infoAccountLedger.RouteId = Convert.ToDecimal(cmbRoute.SelectedValue.ToString());
}
infoAccountLedger.Extra1 = string.Empty;
infoAccountLedger.Extra2 = string.Empty;
infoAccountLedger.ExtraDate = PublicVariables._dtCurrentDate;
}
else
{
infoAccountLedger.MailingName = string.Empty;
infoAccountLedger.BankAccountNumber = string.Empty;
infoAccountLedger.Address = string.Empty;
infoAccountLedger.State = string.Empty;
infoAccountLedger.Phone = string.Empty;
infoAccountLedger.Mobile = string.Empty;
infoAccountLedger.Email = string.Empty;
infoAccountLedger.CreditPeriod = 0;
infoAccountLedger.CreditLimit = 0;
infoAccountLedger.PricinglevelId = 0;
infoAccountLedger.BillByBill = false;
infoAccountLedger.Tin = string.Empty;
infoAccountLedger.Cst = string.Empty;
infoAccountLedger.Pan = string.Empty;
infoAccountLedger.RouteId = 1;
infoAccountLedger.AreaId = 1;
infoAccountLedger.Extra1 = string.Empty;
infoAccountLedger.Extra2 = string.Empty;
infoAccountLedger.ExtraDate = PublicVariables._dtCurrentDate;
}
if (bllAccountLedger.AccountLedgerCheckExistence(txtLedgerName.Text.Trim().ToString(), 0) == false)
{
decLedgerId = bllAccountLedger.AccountLedgerAddWithIdentity(infoAccountLedger);
if (decOpeningBalance > 0)
{
LedgerPostingAdd();
if (cmbBillByBill.Text == "Yes" && isSundryDebtorOrCreditor)
{
PartyBalanceAdd();
}
}
Messages.SavedMessage();
Clear();
decIdForOtherForms = decLedgerId;
if (frmRejectionInObj != null)
{
this.Close();
}
if (frmMaterialReceptObj != null)
{
this.Close();
}
if (frmPurchaseInvoiceObj != null)
{
this.Close();
}
if (frmContraVoucherObj != null)
{
this.Close();
}
if (frmPaymentVoucherObj != null)
{
this.Close();
}
if (frmReceiptVoucherObj != null)
{
this.Close();
}
if (frmDailysalaryvoucherobj != null)
{
this.Close();
}
/*------------------For ReceiptVoucher--------------------*/
if (frmReceiptVoucherObj != null)
{
this.Close();
}
if (frmPurchaseOrderObj != null)
{
this.Close();
}
/*----------For journal voucher------------*/
if (frmJournalVoucherObj != null)
{
this.Close();
}
/*----------For Debitnote voucher-----------*/
if (frmDebitNoteObj != null)
{
this.Close();
}
/*----------For Creditnote voucher-----------*/
if (frmCreditNoteObj != null)
{
this.Close();
}
if (frmSalesReturnObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
if (frmSalesInvoiceObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
if (frmSalesQuotationObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
if (frmSalesOrderObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
/*---------- For Pdcpayable voucher-----------*/
if (frmPdcpayableObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
if (frmPdcpayableObj2 != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
/*---------- Coded For PdcReceivable voucher-----------*/
if (frmpdcreceivableObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
if (frmpdcreceivableObj2 != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
/*.................end.......................*/
if (frmPOSObj != null)
{
if (decIdForOtherForms != 0)
{
this.Close();
}
}
}
else
{
Messages.InformationMessage("Ledger name already exist");
txtLedgerName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("AL1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}