protected void btnAddCreditEntry_Click(object sender, EventArgs e)
{
try
{
int accid = Convert.ToInt32(ddlCreditAccountList.SelectedValue);
string accname = Convert.ToString(ddlCreditAccountList.SelectedItem.Text);
Decimal amount = Convert.ToDecimal(txtCreditAmount.Text);
String tempKey = MySessionManager.TempTranKey;
FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vchTypes = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter();
FinancialDS.tbl_VoucherTypesDataTable vtypes = vchTypes.GetVoucherTypeByName(MySessionManager.VchTypeName);
if (vtypes.Count > 0)
{
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter tempTran = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
tempTran.InsertTempTransaction(tempKey, accid, accname, MySessionManager.DebitAccountListID, 0, amount, amount, 1, 0, "", DateTime.Now, "", "", "", "", "", "", "", "");
gvTranEntries.DataBind();
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(tempKey);
lblDebitTotal.Text = Convert.ToString(totEntries[0].TotalDebit);
lblCreditTotal.Text = Convert.ToString(totEntries[0].TotalCredit);
}
}
catch (Exception ex) { }
VchPanel.Visible = true;
VchTypeSelPanel.Visible = false;
txtCreditAmount.Text = "";
}
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);
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(MySessionManager.TempTranKey);
if (entries.Count > 0 & totEntries[0].TotalDebit == totEntries[0].TotalCredit)
{
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);
foreach (FinancialDS.tempTransaction_EntriesRow entry in entries)
{
led.InsertLedgerEntry(entry.datAccountType, entry.datAccountID, Convert.ToDecimal(entry.datAmount), entry.datIsCredit, newid, "On Account", 0, "", "", "", "", "", "", "", "", "");
}
return(true);
}
catch (Exception ex) { return(false); }
}
else
{
return(false);
}
}
else
{
return(false);
}
}
protected void deleteItem_Click(object sender, EventArgs e)
{
try
{
LinkButton link = (LinkButton)sender;
int id = Convert.ToInt32(link.CommandArgument);
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter tempTran = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
tempTran.DeleteTempTransactionEntry(id);
gvTranEntries.DataBind();
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(MySessionManager.TempTranKey);
lblDebitTotal.Text = Convert.ToString(totEntries[0].TotalDebit);
lblCreditTotal.Text = Convert.ToString(totEntries[0].TotalCredit);
}
catch (Exception ex) { }
loadAccItems();
VchPanel.Visible = true;
VchTypeSelPanel.Visible = false;
}
protected void btnAddEntry_Click(object sender, EventArgs e)
{
try
{
int accid = Convert.ToInt32(ddlDebitAccountList.SelectedValue);
string accname = Convert.ToString(ddlDebitAccountList.SelectedItem.Text);
int paymenttype = Convert.ToInt32(ddlPaymentType.SelectedValue);
string paymentmodename = Convert.ToString(ddlPaymentType.SelectedItem.Text);
Decimal amount = Convert.ToDecimal(txtAmount.Text);
String tempKey = MySessionManager.TempTranKey;
FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter vchTypes = new FinancialDSTableAdapters.tbl_VoucherTypesTableAdapter();
FinancialDS.tbl_VoucherTypesDataTable vtypes = vchTypes.GetVoucherTypeByName(MySessionManager.VchTypeName);
if (vtypes.Count > 0)
{
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter tempTran = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
tempTran.InsertTempTransaction(tempKey, accid, accname, MySessionManager.DebitAccountListID, 0, 0, amount, 0, paymenttype, paymentmodename, DateTime.Now,"","","","","","","","");
gvTranEntries.DataBind();
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(tempKey);
lblTotal.Text = Convert.ToString(totEntries[0].TotalAmount);
}
}
catch (Exception ex) { }
transactionsPanel.Visible = true;
VchPanel.Visible = true;
VchTypeSelPanel.Visible = false;
txtAmount.Text = "";
}
protected void deleteItem_Click(object sender, EventArgs e)
{
try
{
LinkButton link = (LinkButton)sender;
int id = Convert.ToInt32(link.CommandArgument);
FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter tempTran = new FinancialDSTableAdapters.tempTransaction_EntriesTableAdapter();
tempTran.DeleteTempTransactionEntry(id);
gvTranEntries.DataBind();
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(MySessionManager.TempTranKey);
lblTotal.Text = Convert.ToString(totEntries[0].TotalAmount);
}
catch (Exception ex) { }
loadAccItems();
transactionsPanel.Visible = true;
VchPanel.Visible = true;
VchTypeSelPanel.Visible = 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);
FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter getTotal = new FinancialDSTableAdapters.GetTempEntriesTotalsTableAdapter();
FinancialDS.GetTempEntriesTotalsDataTable totEntries = getTotal.GetData(MySessionManager.TempTranKey);
if (entries.Count > 0 & totEntries[0].TotalDebit == totEntries[0].TotalCredit)
{
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);
foreach (FinancialDS.tempTransaction_EntriesRow entry in entries)
{
led.InsertLedgerEntry(entry.datAccountType, entry.datAccountID, Convert.ToDecimal(entry.datAmount),entry.datIsCredit, newid, "On Account",0, "", "", "", "", "", "", "", "", "");
}
return true;
}
catch (Exception ex) { return false; }
}
else { return false; }
}
else { return false; }
}
