public void ContraMasterEdit(ContraMasterInfo InfoContraMaster)
{
try
{
SpContraMaster.ContraMasterEdit(InfoContraMaster);
}
catch (Exception)
{
}
}
/// <summary>
/// Function to insert values to ContraMaster Table
/// </summary>
/// <param name="contramasterinfo"></param>
/// <returns></returns>
public decimal ContraMasterAdd(ContraMasterInfo contramasterinfo)
{
decimal decIdentity = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ContraMasterAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.VoucherNo;
sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.InvoiceNo;
sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.SuffixPrefixId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = contramasterinfo.Date;
sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.LedgerId;
sprmparam = sccmd.Parameters.Add("@type", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.Type;
sprmparam = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.TotalAmount;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.Narration;
sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.UserId;
sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.VoucherTypeId;
//sprmparam = sccmd.Parameters.Add("@exchangeRateId", SqlDbType.Decimal);
//sprmparam.Value = contramasterinfo.ExchangeRateId;
sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam.Value = contramasterinfo.FinancialYearId;
//sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
//sprmparam.Value = contramasterinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = contramasterinfo.Extra2;
decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString());
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(decIdentity);
}
public void ContraMasterEdit(ContraMasterInfo contramasterinfo)
{
try
{
ContraMasterSP spContraMaster = new ContraMasterSP();
spContraMaster.ContraMasterEdit(contramasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("CVBLL:11" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public decimal ContraMasterAdd(ContraMasterInfo InfoContraMaster)
{
decimal decId = 0;
try
{
decId = SpContraMaster.ContraMasterAdd(InfoContraMaster);
}
catch (Exception ex)
{
MessageBox.Show("CV:1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decId);
}
public ContraMasterInfo ContraMasterView(decimal contraMasterId)
{
ContraMasterInfo InfoContraMaster = new ContraMasterInfo();
try
{
InfoContraMaster = SpContraMaster.ContraMasterView(contraMasterId);
}
catch (Exception ex)
{
MessageBox.Show("CV:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(InfoContraMaster);
}
public ContraMasterInfo ContraMasterView(decimal contraMasterId)
{
ContraMasterInfo contramasterinfo = new ContraMasterInfo();
try
{
ContraMasterSP spContraMaster = new ContraMasterSP();
contramasterinfo = spContraMaster.ContraMasterView(contraMasterId);
}
catch (Exception ex)
{
MessageBox.Show("CVBLL:12" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(contramasterinfo);
}
public decimal ContraMasterAdd(ContraMasterInfo contramasterinfo)
{
decimal decIdentity = 0;
try
{
ContraMasterSP spContraMaster = new ContraMasterSP();
decIdentity = spContraMaster.ContraMasterAdd(contramasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("CVBLL:10" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(decIdentity);
}
public void ContraMasterEdit(ContraMasterInfo contramasterinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ContraMasterEdit", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam14 = new SqlParameter();
sprmparam14 = sccmd.Parameters.Add("@contraMasterId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.ContraMasterId;
sprmparam14 = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar);
sprmparam14.Value = contramasterinfo.InvoiceNo;
sprmparam14 = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.SuffixPrefixId;
sprmparam14 = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam14.Value = contramasterinfo.Date;
sprmparam14 = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.LedgerId;
sprmparam14 = sccmd.Parameters.Add("@type", SqlDbType.VarChar);
sprmparam14.Value = contramasterinfo.Type;
sprmparam14 = sccmd.Parameters.Add("@totalAmount", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.TotalAmount;
sprmparam14 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam14.Value = contramasterinfo.Narration;
sprmparam14 = sccmd.Parameters.Add("@userId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.UserId;
sprmparam14 = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.VoucherTypeId;
sprmparam14 = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal);
sprmparam14.Value = contramasterinfo.FinancialYearId;
sprmparam14 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam14.Value = contramasterinfo.Extra1;
sprmparam14 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam14.Value = contramasterinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
public ContraMasterInfo ContraMasterView(decimal contraMasterId)
{
ContraMasterInfo contramasterinfo = new ContraMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("ContraMasterView", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam2 = new SqlParameter();
sprmparam2 = sccmd.Parameters.Add("@contraMasterId", SqlDbType.Decimal);
sprmparam2.Value = contraMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
contramasterinfo.ContraMasterId = decimal.Parse(((DbDataReader)sdrreader)[0].ToString());
contramasterinfo.VoucherNo = ((DbDataReader)sdrreader)[1].ToString();
contramasterinfo.InvoiceNo = ((DbDataReader)sdrreader)[2].ToString();
contramasterinfo.SuffixPrefixId = decimal.Parse(((DbDataReader)sdrreader)[3].ToString());
contramasterinfo.Date = DateTime.Parse(((DbDataReader)sdrreader)[4].ToString());
contramasterinfo.LedgerId = decimal.Parse(((DbDataReader)sdrreader)[5].ToString());
contramasterinfo.Type = ((DbDataReader)sdrreader)[6].ToString();
contramasterinfo.TotalAmount = decimal.Parse(((DbDataReader)sdrreader)[7].ToString());
contramasterinfo.Narration = ((DbDataReader)sdrreader)[8].ToString();
contramasterinfo.UserId = decimal.Parse(((DbDataReader)sdrreader)[9].ToString());
contramasterinfo.VoucherTypeId = decimal.Parse(((DbDataReader)sdrreader)[10].ToString());
contramasterinfo.FinancialYearId = decimal.Parse(((DbDataReader)sdrreader)[11].ToString());
contramasterinfo.ExtraDate = DateTime.Parse(((DbDataReader)sdrreader)[12].ToString());
contramasterinfo.Extra1 = ((DbDataReader)sdrreader)[13].ToString();
contramasterinfo.Extra2 = ((DbDataReader)sdrreader)[14].ToString();
contramasterinfo.date = ((DbDataReader)sdrreader)["date"].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
base.sqlcon.Close();
}
return(contramasterinfo);
}
/// <summary>
/// Fill all the controlls while coming from other forms for update or delete
/// </summary>
public void FillFunction()
{
try
{
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
ContraMasterInfo infoContraMaster = new ContraMasterInfo();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
VoucherTypeBll BllVOucherType = new VoucherTypeBll();
infoContraMaster = bllContraVoucherDetails.ContraMasterView(decMasterId);
txtVoucherNo.ReadOnly = false;
strVoucherNo = infoContraMaster.VoucherNo;
txtVoucherNo.Text = infoContraMaster.InvoiceNo;
strInvoiceNo = infoContraMaster.InvoiceNo;
strInvoiceNo = infoContraMaster.InvoiceNo;
decContraSuffixPrefixId = Convert.ToDecimal(infoContraMaster.SuffixPrefixId.ToString());
DecContraVoucherTypeId = Convert.ToDecimal(infoContraMaster.VoucherTypeId.ToString());
int inDecimalPlace = PublicVariables._inNoOfDecimalPlaces;
txtNarration.Text = infoContraMaster.Narration;
txtContraVoucherDate.Text = Convert.ToString(infoContraMaster.date);
cmbBankAccount.SelectedValue = infoContraMaster.LedgerId;
strVoucherNo = infoContraMaster.VoucherNo;
if (infoContraMaster.Type == "Deposit")
{
rbtnDeposit.Checked = true;
}
else
{
rbtnWithdrawal.Checked = true;
}
isAutomatic = BllVOucherType.CheckMethodOfVoucherNumbering(DecContraVoucherTypeId);
if (isAutomatic)
{
txtVoucherNo.Enabled = false;
}
else
{
txtVoucherNo.Enabled = true;
}
List<DataTable> listObj = new List<DataTable>();
listObj = bllContraVoucherDetails.ContraDetailsViewWithMasterId(decMasterId);
for (int i = 0; i < listObj[0].Rows.Count; i++)
{
dgvContraVoucher.Rows.Add();
dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value = Convert.ToDecimal(listObj[0].Rows[i]["ledgerId"].ToString());
dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value = Convert.ToDecimal(listObj[0].Rows[i]["exchangeRateId"].ToString());
dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value = Convert.ToDecimal(listObj[0].Rows[i]["amount"].ToString());
if (listObj[0].Rows[i]["chequeNo"].ToString() != string.Empty)
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value = listObj[0].Rows[i]["chequeNo"].ToString();
if (listObj[0].Rows[i]["chequeDate"].ToString() == "01 Jan 1753")
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = null;
}
else
{
dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value = listObj[0].Rows[i]["chequeDate"].ToString();
}
}
dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value = listObj[0].Rows[i]["contraDetailsId"].ToString();
decimal decDetailsId1 = Convert.ToDecimal(listObj[0].Rows[i]["contraDetailsId"].ToString());
decimal decLedgerPostingId = BllLedgerPosting.LedgerPostingIdFromDetailsId(decDetailsId1, strVoucherNo, DecContraVoucherTypeId);
dgvContraVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value = decLedgerPostingId.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show("CV:31" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Edit function Call the ledger posting Edit function also
/// </summary>
/// <param name="decMasterId"></param>
public void EditFunction(decimal decMasterId)
{
try
{
//ContraMasterSP spContraMaster = new ContraMasterSP();
ContraMasterInfo infoContraMaster = new ContraMasterInfo();
//ContraDetailsSP spContraDetails = new ContraDetailsSP();
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
ContraDetailsInfo infoCOntraDetails = new ContraDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
LedgerPostingBll BllLedgerPosting = new LedgerPostingBll();
decimal decContraDetailsId = 0;
decimal decLedgerPostId = 0;
infoContraMaster.ContraMasterId = decMasterId;
infoContraMaster.LedgerId = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString());
if (isAutomatic)
{
infoContraMaster.VoucherNo = strVoucherNo;
}
if (isAutomatic)
{
infoContraMaster.InvoiceNo = strInvoiceNo;
}
else
{
infoContraMaster.InvoiceNo = txtVoucherNo.Text;
}
infoContraMaster.Date = Convert.ToDateTime(dtpContraVoucherDate.Text.ToString());
infoContraMaster.Narration = txtNarration.Text.Trim();
infoContraMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
if (rbtnDeposit.Checked)
infoContraMaster.Type = "Deposit";
else
infoContraMaster.Type = "Withdraw";
infoContraMaster.SuffixPrefixId = decContraSuffixPrefixId;
infoContraMaster.VoucherTypeId = DecContraVoucherTypeId;
infoContraMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoContraMaster.UserId = PublicVariables._decCurrentUserId;
infoContraMaster.Extra1 = string.Empty;
infoContraMaster.Extra2 = string.Empty;
infoContraMaster.Date = Convert.ToDateTime(txtContraVoucherDate.Text);
int inCount = dgvContraVoucher.RowCount;
int inValue = 0;
for (int i = 0; i < inCount - 1; i++)
{
if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null &&
dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != null)
{
inValue++;
}
}
if (inValue > 0)
{
if (Convert.ToDecimal(txtTotal.Text) != 0)
{
infoCOntraDetails.ContraMasterId = decMasterId;
infoCOntraDetails.Extra1 = string.Empty;
infoCOntraDetails.Extra2 = string.Empty;
//------------------deleting removed rows----------------------------------------//
foreach (var item in arrlstOfRemove)
{
decimal decId = Convert.ToDecimal(item);
bllContraVoucherDetails.ContraDetailsDelete(Convert.ToDecimal(decId));
BllLedgerPosting.LedgerPostDeleteByDetailsId(Convert.ToDecimal(decId), strVoucherNo, DecContraVoucherTypeId);
}
//--------------------------End---------------------------------------------------//
int inRowCount = dgvContraVoucher.RowCount;
decimal decLedgerId = 0;
decimal decLedger1Id = 0;
decimal decDebit = 0;
decimal decCredit = 0;
decLedger1Id = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString());
for (int i = 0; i < inRowCount; i++)
{
if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != "")
{
decLedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString());
infoCOntraDetails.LedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString());
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString() != "")
{
infoCOntraDetails.ChequeNo = dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoCOntraDetails.ChequeNo = string.Empty;
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString() != "")
{
infoCOntraDetails.ChequeDate = Convert.ToDateTime(dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoCOntraDetails.ChequeDate = Convert.ToDateTime("1/1/1753");
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != "")
{
infoCOntraDetails.Amount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
if (dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString() != "")
{
infoCOntraDetails.ContraDetailsId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtDetailsId"].Value.ToString());
decContraDetailsId = infoCOntraDetails.ContraDetailsId;
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString()));
decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
if (rbtnDeposit.Checked)
{
decCredit = decConvertRate;
decDebit = 0;
}
else
{
decDebit = decConvertRate;
decCredit = 0;
}
infoCOntraDetails.ContraMasterId = decMasterId;
infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString());
bllContraVoucherDetails.ContraDetailsEdit(infoCOntraDetails);
decLedgerPostId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtLedgerPostingId"].Value.ToString());
LedgerPostingEdit(decLedgerPostId, decLedgerId, decCredit, decDebit, decContraDetailsId, i);
}
else
{
infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString());
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString()));
decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
if (rbtnDeposit.Checked)
{
decCredit = decConvertRate;
decDebit = 0;
}
else
{
decDebit = decConvertRate;
decCredit = 0;
}
decContraDetailsId = bllContraVoucherDetails.ContraDetailsAddReturnWithhIdentity(infoCOntraDetails);
LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i);
}
}
}
bllContraVoucherDetails.ContraMasterEdit(infoContraMaster);
decLedgerPostId = BllLedgerPosting.LedgerPostingIdForTotalAmount(strVoucherNo, DecContraVoucherTypeId);
decAmount = Convert.ToDecimal(txtTotal.Text);
decContraDetailsId = 0;
if (rbtnDeposit.Checked)
{
decDebit = decAmount;
decCredit = 0;
LedgerPostingEdit(decLedgerPostId, decLedger1Id, decCredit, decDebit, decContraDetailsId, -1);
}
else
{
decCredit = decAmount;
decDebit = 0;
LedgerPostingEdit(decLedgerPostId, decLedger1Id, decCredit, decDebit, decContraDetailsId, -1);
}
Messages.UpdatedMessage();
if (cbxPrintafterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decMasterId);
}
else
{
Print(decMasterId);
}
}
this.Close();
}
else
{
Messages.InformationMessage("Cannot save total amount as 0");
dgvContraVoucher.Focus();
}
}
else
{
Messages.InformationMessage("Cant update contra voucher without atleast one ledger with complete details");
}
}
catch (Exception ex)
{
MessageBox.Show("CV:17" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Save function Call the ledger posting function also
/// </summary>
public void SaveFuction()
{
try
{
decimal decContraDetailsId = 0;
//ContraMasterSP spContraMaster = new ContraMasterSP();
ContraMasterInfo infoContraMaster = new ContraMasterInfo();
//ContraDetailsSP spContraDetails = new ContraDetailsSP();
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
ContraDetailsInfo infoCOntraDetails = new ContraDetailsInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
decimal decIdentity = 0;
decimal decLedgerId = 0;
decimal decDebit = 0;
decimal decCredit = 0;
int inCount = dgvContraVoucher.RowCount;
int inValue = 0;
for (int i = 0; i < inCount - 1; i++)
{
if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null &&
dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != null)
{
inValue++;
}
}
if (inValue > 0)
{
if (Convert.ToDecimal(txtTotal.Text) != 0)
{
infoContraMaster.LedgerId = Convert.ToDecimal(cmbBankAccount.SelectedValue.ToString());
if (isAutomatic)
{
infoContraMaster.VoucherNo = strVoucherNo;
}
else
{
decimal decVoucherNo = bllContraVoucherDetails.ContraVoucherMasterGetMaxPlusOne(DecContraVoucherTypeId) + 1;
infoContraMaster.VoucherNo = Convert.ToString(decVoucherNo);
}
infoContraMaster.Date = Convert.ToDateTime(dtpContraVoucherDate.Text.ToString());
infoContraMaster.Narration = txtNarration.Text.Trim();
infoContraMaster.TotalAmount = Convert.ToDecimal(txtTotal.Text);
infoContraMaster.Extra1 = string.Empty;
infoContraMaster.Extra2 = string.Empty;
if (rbtnDeposit.Checked)
{
infoContraMaster.Type = "Deposit";
}
else
{
infoContraMaster.Type = "Withdraw";
}
infoContraMaster.SuffixPrefixId = decContraSuffixPrefixId;
infoContraMaster.VoucherTypeId = DecContraVoucherTypeId;
infoContraMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoContraMaster.UserId = PublicVariables._decCurrentUserId;
if (isAutomatic)
{
infoContraMaster.InvoiceNo = strInvoiceNo;
}
else
{
infoContraMaster.InvoiceNo = txtVoucherNo.Text;
}
decIdentity = bllContraVoucherDetails.ContraMasterAdd(infoContraMaster);
infoCOntraDetails.ContraMasterId = decIdentity;
infoCOntraDetails.Extra1 = string.Empty;
infoCOntraDetails.Extra2 = string.Empty;
int inRowCount = dgvContraVoucher.RowCount;
//-------------------------------Saving grid details--------------------------------------------------------------------
for (int i = 0; i < inRowCount - 1; i++)
{
if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != string.Empty)
{
infoCOntraDetails.LedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString());
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
infoCOntraDetails.Amount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
infoCOntraDetails.ChequeNo = dgvContraVoucher.Rows[i].Cells["dgvtxtChequeNo"].Value.ToString();
}
else
{
infoCOntraDetails.ChequeNo = string.Empty;
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
infoCOntraDetails.ChequeDate = Convert.ToDateTime(dgvContraVoucher.Rows[i].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
infoCOntraDetails.ChequeDate = Convert.ToDateTime("1/1/1753");
}
infoCOntraDetails.ExchangeRateId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value.ToString());
decContraDetailsId = bllContraVoucherDetails.ContraDetailsAddReturnWithhIdentity(infoCOntraDetails);
//---------------------------------------------------------Ledger Posting-----------------------------------------/---------------------------------------------------/
if (dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString() != string.Empty)
{
decLedgerId = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbBankorCashAccount"].Value.ToString());
}
if (dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value != null && dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString() != string.Empty)
{
decSelectedCurrencyRate = BllExchangeRate.GetExchangeRateByExchangeRateId(Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvcmbCurrency"].Value));
decAmount = Convert.ToDecimal(dgvContraVoucher.Rows[i].Cells["dgvtxtAmount"].Value.ToString());
decConvertRate = decAmount * decSelectedCurrencyRate;
if (rbtnDeposit.Checked)
{
decCredit = decConvertRate;
decDebit = 0;
LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i);
}
else
{
decDebit = decConvertRate;
decCredit = 0;
LedgerPosting(decLedgerId, decCredit, decDebit, decContraDetailsId, i);
}
}
}
decAmount = Convert.ToDecimal(txtTotal.Text);
decContraDetailsId = 0;
if (rbtnDeposit.Checked)
{
decDebit = decAmount;
decCredit = 0;
LedgerPosting(infoContraMaster.LedgerId, decCredit, decDebit, decContraDetailsId, -1);
}
else
{
decCredit = decAmount;
decDebit = 0;
LedgerPosting(infoContraMaster.LedgerId, decCredit, decDebit, decContraDetailsId, -1);
}
//------------------------------------------------------------------Ledger Posting---end---------------------------------------------------------------------//
Messages.SavedMessage();
if (cbxPrintafterSave.Checked)
{
if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decIdentity);
}
else
{
Print(decIdentity);
}
}
Clear();
}
else
{
Messages.InformationMessage("Cannot save total debit and credit as 0");
dgvContraVoucher.Focus();
}
}
else
{
Messages.InformationMessage("Cant save contra voucher without atleast one ledger with complete details");
}
}
catch (Exception ex)
{
MessageBox.Show("CV:16" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
