private bool insertVoucher()
{
FinancialDSTableAdapters.InsertVoucherTableAdapter vch = new FinancialDSTableAdapters.InsertVoucherTableAdapter();
FinancialDSTableAdapters.tbl_Ledger_EntriesTableAdapter led = new FinancialDSTableAdapters.tbl_Ledger_EntriesTableAdapter();
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter temp = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vType = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter();
FinancialDS.tempTransaction_EntriesDataTable entries = temp.GetTempTransactionsByEntryKey(MySessionManager.TempTranKey);
if (entries.Count > 0)
{
DateTime vchDate = DateTime.Now;
try
{
CultureInfo ukCulture = new CultureInfo("en-GB");
vchDate = DateTime.Parse(txtDate.Text, ukCulture);
}
catch (Exception ex) { }
string VchType = MySessionManager.VchTypeName;
string vchNarration = txtNarration.Value;
string vchNumber = "";
int vchIsPostDated = 0;
int vchIsOptional = 0;
FinancialDS.tbl_VoucherTypesDataTable vtypes = vType.GetVoucherTypeByName(VchType);
if (vtypes.Count > 0)
{
try
{
vchNumber = vtypes[0].datPrefix + " " + vtypes[0].datSuffix;
int newid = Convert.ToInt32(vch.InsertVoucher(vchDate, VchType, vchNumber, vchNarration, vchIsPostDated, vchIsOptional, 0, DateTime.Now, DateTime.Now, Convert.ToInt32(MySessionManager.CurrentUser.UserID), 0)[0].vchNewID);
decimal totAmount = 0;
foreach (FinancialDS.tempTransaction_EntriesRow entry in entries)
{
led.InsertLedgerEntry(entry.datAccountType, entry.datAccountID, Convert.ToDecimal(entry.datAmount), 0, newid, "On Account", entry.datPaymentMode, "", "", "", "", "", "", "", "", "");
totAmount += entry.datAmount;
}
led.InsertLedgerEntry(vtypes[0].datCreditAccountTypes, Convert.ToInt32(ListofCreditAccounts.SelectedValue), Convert.ToDecimal(totAmount), 1, newid, "On Account", entries[0].datPaymentMode, "", "", "", "", "", "", "", "", "");
return(true);
}
catch (Exception ex) { return(false); }
}
else
{
return(false);
}
}
else
{
return(false);
}
}
private bool insertVoucher()
{
FinancialDSTableAdapters.InsertVoucherTableAdapter vch = new FinancialDSTableAdapters.InsertVoucherTableAdapter();
FinancialDSTableAdapters.tbl_Ledger_EntriesTableAdapter led = new FinancialDSTableAdapters.tbl_Ledger_EntriesTableAdapter();
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter temp = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vType = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter();
FinancialDS.tempTransaction_EntriesDataTable entries = temp.GetTempTransactionsByEntryKey(MySessionManager.TempTranKey);
if (entries.Count > 0)
{
DateTime vchDate = DateTime.Now;
try
{
CultureInfo ukCulture = new CultureInfo("en-GB");
vchDate = DateTime.Parse(txtDate.Text, ukCulture);
}
catch (Exception ex) { }
string VchType = MySessionManager.VchTypeName;
string vchNarration = txtNarration.Value;
string vchNumber = "";
int vchIsPostDated = 0;
int vchIsOptional = 0;
FinancialDS.tbl_VoucherTypesDataTable vtypes = vType.GetVoucherTypeByName(VchType);
if (vtypes.Count > 0)
{
try
{
vchNumber = vtypes[0].datPrefix + " " + vtypes[0].datSuffix;
int newid = Convert.ToInt32(vch.InsertVoucher(vchDate, VchType, vchNumber, vchNarration, vchIsPostDated, vchIsOptional, 0, DateTime.Now, DateTime.Now, Convert.ToInt32(MySessionManager.CurrentUser.UserID), 0)[0].vchNewID);
decimal totAmount = 0;
foreach (FinancialDS.tempTransaction_EntriesRow entry in entries)
{
led.InsertLedgerEntry(entry.datAccountType, entry.datAccountID, Convert.ToDecimal(entry.datAmount),1, newid, "On Account", entry.datPaymentMode, "", "", "", "", "", "", "","","");
totAmount += entry.datAmount;
}
led.InsertLedgerEntry(vtypes[0].datCreditAccountTypes, Convert.ToInt32(ListofCreditAccounts.SelectedValue), Convert.ToDecimal(totAmount), 0, newid, "On Account", entries[0].datPaymentMode, "", "", "", "", "", "", "","","");
return true;
}
catch (Exception ex) { return false; }
}
else { return false; }
}
else { return false; }
}