public void JournalDetailsEdit(JournalDetailsInfo infoJournalDetails)
{
try
{
spJournalDetails.JournalDetailsEdit(infoJournalDetails);
}
catch (Exception ex)
{
MessageBox.Show("JVBLL2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public decimal JournalDetailsAdd(JournalDetailsInfo infoJournalDetails)
{
decimal decDecid = 0;
try
{
decDecid = spJournalDetails.JournalDetailsAdd(infoJournalDetails);
}
catch (Exception ex)
{
MessageBox.Show("JVBLL3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decDecid);
}
/// <summary>
/// Function to insert values to JournalDetails Table
/// </summary>
/// <param name="journaldetailsinfo"></param>
/// <returns></returns>
public decimal JournalDetailsAdd(JournalDetailsInfo journaldetailsinfo)
{
decimal decId = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("JournalDetailsAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@journalMasterId", SqlDbType.Decimal);
sprmparam.Value = journaldetailsinfo.JournalMasterId;
sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam.Value = journaldetailsinfo.LedgerId;
sprmparam = sccmd.Parameters.Add("@credit", SqlDbType.Decimal);
sprmparam.Value = journaldetailsinfo.Credit;
sprmparam = sccmd.Parameters.Add("@debit", SqlDbType.Decimal);
sprmparam.Value = journaldetailsinfo.Debit;
sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam.Value = journaldetailsinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@chequeNo", SqlDbType.VarChar);
sprmparam.Value = journaldetailsinfo.ChequeNo;
sprmparam = sccmd.Parameters.Add("@chequeDate", SqlDbType.DateTime);
sprmparam.Value = journaldetailsinfo.ChequeDate;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = journaldetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = journaldetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = journaldetailsinfo.Extra2;
decId = Convert.ToDecimal(sccmd.ExecuteScalar());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(decId);
}
public void JournalDetailsEdit(JournalDetailsInfo journaldetailsinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("JournalDetailsEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam12 = new SqlParameter();
sprmparam12 = sccmd.Parameters.Add("@journalDetailsId", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.JournalDetailsId;
sprmparam12 = sccmd.Parameters.Add("@journalMasterId", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.JournalMasterId;
sprmparam12 = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.LedgerId;
sprmparam12 = sccmd.Parameters.Add("@credit", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.Credit;
sprmparam12 = sccmd.Parameters.Add("@debit", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.Debit;
sprmparam12 = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
sprmparam12.Value = journaldetailsinfo.ExchangeRateId;
sprmparam12 = sccmd.Parameters.Add("@chequeNo", SqlDbType.VarChar);
sprmparam12.Value = journaldetailsinfo.ChequeNo;
sprmparam12 = sccmd.Parameters.Add("@chequeDate", SqlDbType.DateTime);
sprmparam12.Value = journaldetailsinfo.ChequeDate;
sprmparam12 = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam12.Value = journaldetailsinfo.ExtraDate;
sprmparam12 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam12.Value = journaldetailsinfo.Extra1;
sprmparam12 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam12.Value = journaldetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
public JournalDetailsInfo JournalDetailsView(decimal journalDetailsId)
{
JournalDetailsInfo journaldetailsinfo = new JournalDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("JournalDetailsView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@journalDetailsId", SqlDbType.Decimal);
sprmparam2.Value = journalDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
journaldetailsinfo.JournalDetailsId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString());
journaldetailsinfo.JournalMasterId = decimal.Parse(((DbDataReader)sdrreader)[1].ToString());
journaldetailsinfo.LedgerId = decimal.Parse(((DbDataReader)sdrreader)[2].ToString());
journaldetailsinfo.Credit = decimal.Parse(((DbDataReader)sdrreader)[3].ToString());
journaldetailsinfo.Debit = decimal.Parse(((DbDataReader)sdrreader)[4].ToString());
journaldetailsinfo.ExchangeRateId = decimal.Parse(((DbDataReader)sdrreader)[5].ToString());
journaldetailsinfo.ChequeNo = ((DbDataReader)sdrreader)[6].ToString();
journaldetailsinfo.ChequeDate = DateTime.Parse(((DbDataReader)sdrreader)[7].ToString());
journaldetailsinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[8].ToString());
journaldetailsinfo.Extra1 = ((DbDataReader)sdrreader)[9].ToString();
journaldetailsinfo.Extra2 = ((DbDataReader)sdrreader)[10].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(journaldetailsinfo);
}
/// <summary>
/// Function to edit the debitnote voucher
/// </summary>
/// <param name="decJournalMasterId"></param>
public void Edit(decimal decJournalMasterId)
{
try
{
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalVoucherBll bllJournalDetails = new JournalVoucherBll();
JournalDetailsInfo infoJournalDetails = new JournalDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
/*****************Update in JournalMaster table *************/
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
infoJournalMaster.JournalMasterId = decJournalMasterId;
infoJournalMaster.VoucherNo = strVoucherNo;
infoJournalMaster.InvoiceNo = txtVoucherNo.Text.Trim();
infoJournalMaster.SuffixPrefixId = decJournalSuffixPrefixId;
infoJournalMaster.Date = Convert.ToDateTime(txtDate.Text);
infoJournalMaster.Narration = txtNarration.Text.Trim();
infoJournalMaster.UserId = PublicVariables._decCurrentUserId;
infoJournalMaster.VoucherTypeId = decJournalVoucherTypeId;
infoJournalMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoJournalMaster.ExtraDate = DateTime.Now;
infoJournalMaster.Extra1 = string.Empty;
infoJournalMaster.Extra2 = string.Empty;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
infoJournalMaster.TotalAmount = decTotalDebit;
decimal decEffectRow = bllJournalMaster.JournalMasterEdit(infoJournalMaster);
/**********************JournalDetails Edit********************/
if (decEffectRow > 0)
{
infoJournalDetails.JournalMasterId = decJournalMasterId;
infoJournalDetails.ExtraDate = DateTime.Now;
infoJournalDetails.Extra1 = string.Empty;
infoJournalDetails.Extra2 = string.Empty;
//-----------to delete details, LedgerPosting and bankReconciliation of removed rows--------------//
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
foreach (object obj in arrlstOfRemove)
{
string str = Convert.ToString(obj);
bllJournalDetails.JournalDetailsDelete(Convert.ToDecimal(str));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(str), strVoucherNo, decJournalVoucherTypeId);
}
BllLedgerPosting.LedgerPostingDeleteByVoucherNoVoucherTypeIdAndLedgerId(strVoucherNo, decJournalVoucherTypeId, 12);
//=============================================================================================//
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
decimal decJournalDetailsId = 0;
int inRowCount = dgvJournalVoucher.RowCount;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoJournalDetails.LedgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoJournalDetails.LedgerId;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
//------------------Currency conversion------------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value));
decAmount = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//======================================================//
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoJournalDetails.Debit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoJournalDetails.Credit;
}
else
{
infoJournalDetails.Credit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Debit = 0;
decDebit = infoJournalDetails.Debit;
decCredit = decConvertRate;
}
infoJournalDetails.ExchangeRateId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeNo = dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoJournalDetails.ChequeNo = string.Empty;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeDate = Convert.ToDateTime(dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoJournalDetails.ChequeDate = DateTime.Now;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString() != string.Empty)
{
infoJournalDetails.JournalDetailsId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtDetailsId"].Value.ToString());
bllJournalDetails.JournalDetailsEdit(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
decJournalDetailsId = infoJournalDetails.JournalDetailsId;
decimal decLedgerPostId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtLedgerPostingId"].Value.ToString());
LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
else
{
decJournalDetailsId = bllJournalDetails.JournalDetailsAdd(infoJournalDetails);
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
}
}
DeletePartyBalanceOfRemovedRow();
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(infoJournalMaster.JournalMasterId);
}
else
{
Print(infoJournalMaster.JournalMasterId);
}
}
if (journalRegisterObj != null)
{
this.Close();
journalRegisterObj.Enabled = true;
}
else if (frmJournalReportObj != null)
{
this.Close();
frmJournalReportObj.Enabled = true;
}
else if (frmDayBookObj != null)
{
this.Close();
}
else if (frmBillallocationObj != null)
{
this.Close();
}
}
//----------------If print after save is enable-----------------------//
//===================================================================//
}
catch (Exception ex)
{
MessageBox.Show("JV16:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to Save the voucher
/// </summary>
public void Save()
{
try
{
decimal decTotalDebit = 0;
decimal decTotalCredit = 0;
decTotalDebit = Convert.ToDecimal(txtDebitTotal.Text.Trim());
decTotalCredit = Convert.ToDecimal(txtCreditTotal.Text.Trim());
JournalVoucherBll bllJournalMaster = new JournalVoucherBll();
JournalVoucherBll bllJournalVoucher = new JournalVoucherBll();
JournalMasterInfo infoJournalMaster = new JournalMasterInfo();
JournalDetailsInfo infoJournalDetails = new JournalDetailsInfo();
PartyBalanceBll BllPartyBalance = new PartyBalanceBll();
PartyBalanceInfo InfopartyBalance = new PartyBalanceInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoJournalMaster.VoucherNo = strVoucherNo;
infoJournalMaster.InvoiceNo = txtVoucherNo.Text;
infoJournalMaster.SuffixPrefixId = decJournalSuffixPrefixId;
infoJournalMaster.Date = Convert.ToDateTime(txtDate.Text);
infoJournalMaster.Narration = txtNarration.Text.Trim();
infoJournalMaster.UserId = PublicVariables._decCurrentUserId;
infoJournalMaster.VoucherTypeId = decJournalVoucherTypeId;
infoJournalMaster.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString());
infoJournalMaster.Extra1 = string.Empty;
infoJournalMaster.Extra2 = string.Empty;
infoJournalMaster.ExtraDate = DateTime.Now;
infoJournalMaster.TotalAmount = decTotalDebit;
decimal decJournalMasterId = bllJournalMaster.JournalMasterAdd(infoJournalMaster);
/*******************JournalDetailsAdd and LedgerPosting*************************/
infoJournalDetails.JournalMasterId = decJournalMasterId;
infoJournalDetails.ExtraDate = DateTime.Now;
infoJournalDetails.Extra1 = string.Empty;
infoJournalDetails.Extra2 = string.Empty;
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
int inRowCount = dgvJournalVoucher.RowCount;
for (int inI = 0; inI < inRowCount - 1; inI++)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString() != string.Empty)
{
infoJournalDetails.LedgerId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbAccountLedger"].Value.ToString());
decLedgerId = infoJournalDetails.LedgerId;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() != string.Empty)
{
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
//--------Currency conversion--------------//
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString()));
decAmount = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
//===========================================//
if (dgvJournalVoucher.Rows[inI].Cells["dgvcmbDrOrCr"].Value.ToString() == "Dr")
{
infoJournalDetails.Debit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Credit = 0;
decDebit = decConvertRate;
decCredit = infoJournalDetails.Credit;
}
else
{
infoJournalDetails.Credit = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvtxtAmount"].Value.ToString());
infoJournalDetails.Debit = 0;
decDebit = infoJournalDetails.Debit;
decCredit = decConvertRate;
}
}
infoJournalDetails.ExchangeRateId = Convert.ToDecimal(dgvJournalVoucher.Rows[inI].Cells["dgvcmbCurrency"].Value.ToString());
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeNo = dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoJournalDetails.ChequeNo = string.Empty;
}
if (dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value != null && dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoJournalDetails.ChequeDate = Convert.ToDateTime(dgvJournalVoucher.Rows[inI].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoJournalDetails.ChequeDate = DateTime.Now;
}
decimal decJournalDetailsId = bllJournalVoucher.JournalDetailsAdd(infoJournalDetails);
if (decJournalDetailsId != 0)
{
PartyBalanceAddOrEdit(inI);
LedgerPosting(decLedgerId, decCredit, decDebit, decJournalDetailsId, inI);
}
}
}
Messages.SavedMessage();
//----------------If print after save is enable-----------------------//
if (cbxPrintAfterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decJournalMasterId);
}
else
{
Print(decJournalMasterId);
}
}
//===================================================================//
}
catch (Exception ex)
{
MessageBox.Show("JV14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
