///<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); } }