///<summary>
///Function to add values to tblGeneralLedger
/// </summary>
public void generaledgerAddAll(GeneraLedgerInfo generalLedgerInfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
MySqlCommand sqlcmd = new MySqlCommand("generaledgerAddAll", sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
MySqlParameter sqlparam = new MySqlParameter();
sqlparam = sqlcmd.Parameters.Add("?transDate", MySqlDbType.DateTime);
sqlparam.Value = generalLedgerInfo.TransDate;
sqlparam = sqlcmd.Parameters.Add("?journalTypeId", MySqlDbType.Int32);
sqlparam.Value = generalLedgerInfo.JournalTypeId;
sqlparam = sqlcmd.Parameters.Add("?journalNo", MySqlDbType.Decimal);
sqlparam.Value = generalLedgerInfo.JournalNo;
sqlparam = sqlcmd.Parameters.Add("?ledgerId", MySqlDbType.Int32);
sqlparam.Value = generalLedgerInfo.LedgerId;
sqlparam = sqlcmd.Parameters.Add("?debit", MySqlDbType.Decimal);
sqlparam.Value = generalLedgerInfo.Debit;
sqlparam = sqlcmd.Parameters.Add("?credit", MySqlDbType.Decimal);
sqlparam.Value = generalLedgerInfo.Credit;
sqlparam = sqlcmd.Parameters.Add("?invoiceNo", MySqlDbType.VarChar);
sqlparam.Value = generalLedgerInfo.InvoiceNo;
sqlparam = sqlcmd.Parameters.Add("?chequeNo", MySqlDbType.VarChar);
sqlparam.Value = generalLedgerInfo.ChequeNo;
sqlparam = sqlcmd.Parameters.Add("?chequeDate", MySqlDbType.DateTime);
sqlparam.Value = generalLedgerInfo.ChequeDate;
sqlparam = sqlcmd.Parameters.Add("?extraDate", MySqlDbType.DateTime);
sqlparam.Value = generalLedgerInfo.ExtraDate;
sqlparam = sqlcmd.Parameters.Add("?extra1", MySqlDbType.VarChar);
sqlparam.Value = generalLedgerInfo.Extra1;
sqlparam = sqlcmd.Parameters.Add("?extra2", MySqlDbType.VarChar);
sqlparam.Value = generalLedgerInfo.Extra2;
sqlcmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Ledger Posting Add
/// </summary>
public void MasterLedgerPosting()
{
try
{
GeneraLedgerInfo InfoLedgerPosting = new GeneraLedgerInfo();
GeneralLedgerSP SpLedgerPosting = new GeneralLedgerSP();
//ExchangeRateSP SpExchangRate = new ExchangeRateSP();
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
InfoLedgerPosting.Credit = Convert.ToDecimal(txtTotal.Text);
InfoLedgerPosting.TransDate = Convert.ToDateTime(txtDate.Text);
InfoLedgerPosting.Debit = 0;
InfoLedgerPosting.DetailsId = 0;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
//InfoLedgerPosting.InvoiceNo = strInvoiceNo;
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
InfoLedgerPosting.LedgerId = Convert.ToDecimal(cmbBankorCash.SelectedValue.ToString());
/*if (!isAutomatic)
* {
* InfoLedgerPosting.JournalNo = txtVoucherNo.Text.Trim();
* }
* else
* {
* InfoLedgerPosting.JournalNo = strVoucherNo;
* }*/
// InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
SpLedgerPosting.generaledgerAddAll(InfoLedgerPosting);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// Ledger posting details add
/// </summary>
/// <param name="inA"></param>
/// <param name="decPaymentDetailsId"></param>
public void DetailsLedgerPosting(int inA, decimal decPaymentDetailsId)
{
GeneraLedgerInfo InfoLedgerPosting = new GeneraLedgerInfo();
GeneralLedgerSP SpLedgerPosting = new GeneralLedgerSP();
try
{
if (!dgvPayment.Rows[inA].Cells["dgvtxtAmount"].ReadOnly)
{
decimal d = Convert.ToDecimal(dgvPayment.Rows[inA].Cells["dgvcmbCurrency"].Value.ToString());
decAmount = Convert.ToDecimal(dgvPayment.Rows[inA].Cells["dgvtxtAmount"].Value.ToString());
txtDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
InfoLedgerPosting.Credit = 0;
InfoLedgerPosting.TransDate = Convert.ToDateTime(txtDate.Text);
InfoLedgerPosting.Debit = decAmount;
InfoLedgerPosting.DetailsId = decPaymentDetailsId;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
//InfoLedgerPosting.InvoiceNo = strInvoiceNo;
// isAutomatic = SpVoucherType.CheckMethodOfVoucherNumbering(InfoPaymentMaster.VoucherTypeId);
if (dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value != null && dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeNo = dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value != null && dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeDate = Convert.ToDateTime(dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
}
else
{
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
InfoLedgerPosting.LedgerId = Convert.ToDecimal(dgvPayment.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString());
/*if (!isAutomatic)
* {
* InfoLedgerPosting.VoucherNo = txtVoucherNo.Text.Trim();
* }
* else
* {
* InfoLedgerPosting.VoucherNo = strVoucherNo;
* }*/
// InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
SpLedgerPosting.generaledgerAddAll(InfoLedgerPosting);
}
else
{
//InfoLedgerPosting.Date = dtpDate.Value;
InfoLedgerPosting.Extra1 = string.Empty;
InfoLedgerPosting.Extra2 = string.Empty;
//InfoLedgerPosting.InvoiceNo = strInvoiceNo;
//InfoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId;
InfoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
InfoLedgerPosting.Credit = 0;
InfoLedgerPosting.LedgerId = Convert.ToDecimal(dgvPayment.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString());
// InfoLedgerPosting.VoucherNo = strVoucherNo;
InfoLedgerPosting.DetailsId = decPaymentDetailsId;
InfoLedgerPosting.InvoiceNo = txtVoucherNo.Text.Trim();
if (dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value != null && dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeNo = dgvPayment.Rows[inA].Cells["dgvtxtChequeNo"].Value.ToString();
if (dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value != null && dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString() != string.Empty)
{
InfoLedgerPosting.ChequeDate = Convert.ToDateTime(dgvPayment.Rows[inA].Cells["dgvtxtChequeDate"].Value.ToString());
}
else
{
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
}
else
{
InfoLedgerPosting.ChequeNo = string.Empty;
InfoLedgerPosting.ChequeDate = DateTime.Now;
}
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (InfoLedgerPosting.LedgerId == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
}
}
InfoLedgerPosting.Debit = decAmount;
SpLedgerPosting.generaledgerAddAll(InfoLedgerPosting);
InfoLedgerPosting.LedgerId = 12;
foreach (DataRow dr in dtblPartyBalance.Rows)
{
if (Convert.ToDecimal(dgvPayment.Rows[inA].Cells["dgvcmbAccountLedger"].Value.ToString()) == Convert.ToDecimal(dr["LedgerId"].ToString()))
{
if (dr["ReferenceType"].ToString() == "Against")
{
decAmount = Convert.ToDecimal(dr["Amount"].ToString());
InfoLedgerPosting.Credit = -1 * decAmount;
InfoLedgerPosting.Debit = 0;
SpLedgerPosting.generaledgerAddAll(InfoLedgerPosting);
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SaveFunction()
{
try
{
GeneraLedgerInfo generalLedgerInfo = new GeneraLedgerInfo();
GeneralLedgerSP spGeneraLedger = new GeneralLedgerSP();
//Debit the Student/customer Account
generalLedgerInfo.TransDate = DateTime.Now;
generalLedgerInfo.JournalTypeId = 1; //
generalLedgerInfo.JournalNo = 1; //automatic generated
generalLedgerInfo.LedgerId = ledgerID;
generalLedgerInfo.Debit = Convert.ToDecimal(txtGrandTotal.Text);
generalLedgerInfo.Credit = 0;
generalLedgerInfo.ChequeNo = txtChequeNo.Text;
generalLedgerInfo.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
spGeneraLedger.generaledgerAddAll(generalLedgerInfo);
//Credit the DebtorsControl A/c
generalLedgerInfo.TransDate = DateTime.Now;
generalLedgerInfo.JournalTypeId = 1; //
generalLedgerInfo.JournalNo = 1; //automatic generated
generalLedgerInfo.LedgerId = 61;
generalLedgerInfo.Credit = Convert.ToDecimal(txtGrandTotal.Text);
generalLedgerInfo.Debit = 0;
generalLedgerInfo.ChequeNo = txtChequeNo.Text;
generalLedgerInfo.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
spGeneraLedger.generaledgerAddAll(generalLedgerInfo);
if (Convert.ToDecimal(txtPaidAmount.Text) > 0)
{
//Debit Bank A/c with the amount paid
generalLedgerInfo.TransDate = DateTime.Now;
generalLedgerInfo.JournalTypeId = 1; //
generalLedgerInfo.JournalNo = 1; //automatic generated
generalLedgerInfo.LedgerId = 63;
generalLedgerInfo.Debit = Convert.ToDecimal(txtPaidAmount.Text.ToString());
generalLedgerInfo.Credit = 0;
generalLedgerInfo.ChequeNo = txtChequeNo.Text;
generalLedgerInfo.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
spGeneraLedger.generaledgerAddAll(generalLedgerInfo);
//Credit the Student/Customer A/c
generalLedgerInfo.TransDate = DateTime.Now;
generalLedgerInfo.JournalTypeId = 1; //
generalLedgerInfo.JournalNo = 1; //automatic generated
generalLedgerInfo.LedgerId = ledgerID;
generalLedgerInfo.Credit = Convert.ToDecimal(txtPaidAmount.Text);
generalLedgerInfo.Debit = 0;
generalLedgerInfo.ChequeNo = txtChequeNo.Text;
generalLedgerInfo.ChequeDate = Convert.ToDateTime(txtChequeDate.Text);
spGeneraLedger.generaledgerAddAll(generalLedgerInfo);
}
Messages.SavedMessage();
ClearFunction();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
