protected void btnSaveAccount_Click(object sender, EventArgs e)
{
BankAccounts objAccounts = new BankAccounts();
List<BankAccounts> myList = objAccounts.GetAllBankAccounts(_user.CompanyId);
objAccounts.BankAccountId = myList.Count+1;
objAccounts.BranchName = txtBranchName.Value;
objAccounts.AccountNo = txtAccountNo.Value;
objAccounts.AccountTitle = txtTitle.Value;
objAccounts.AccountType = accountTypeRadDropDownList1.SelectedItem.Text;
objAccounts.OpeningDate = (RadDatePicker2.SelectedDate.ToString());
objAccounts.CompanyId = _company.CompanyId;
objAccounts.IsActive = chkIsActive.Checked;
int success = objAccounts.InsertBankAccounts();
if (success > 0)
{
this.LoadAccountsTable();
Session["saveBankAccountInfo"] = ("Accounts info Saved successfully");
Response.Redirect(Request.RawUrl);
//
this.Clear();
}
else
{
Alert.Show("Error occured");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
BankAccounts objAccounts = new BankAccounts();
List<BankAccounts> myList = objAccounts.GetAllBankAccounts(_user.CompanyId);
objAccounts.BankAccountId = myList.Count;
if (bankIdRadDropDownList1.SelectedIndex > -1)
{
objAccounts.BankId = int.Parse(bankIdRadDropDownList1.SelectedItem.Value);
}
else
{
Alert.Show("Please select a bank");
}
objAccounts.BranchName = txtBranchName.Value;
objAccounts.AccountNo = txtAccountNo.Value;
objAccounts.AccountTitle = txtTitle.Value;
objAccounts.AccountType = accountTypeRadDropDownList1.SelectedItem.Text;
objAccounts.OpeningDate = (RadDatePicker2.SelectedDate.ToString());
objAccounts.CompanyId = _company.CompanyId;
objAccounts.IsActive = chkIsActive.Checked;
int sucess = 0;
if (lblId.Text == "" || lblId.Text == "0")
{
objAccounts.BankAccountId=new BankAccounts().GetMaxAccountId()+1;
sucess = objAccounts.InsertBankAccounts();
if (sucess > 0)
{
Alert.Show("Bank Accounts info saved successfully");
this.Clear();
}
}
else
{
objAccounts.BankAccountId = int.Parse(lblId.Text);
sucess = objAccounts.UpdateBankAccounts();
if (sucess > 0)
{
Response.Redirect("BankAccoutsList.aspx", true);
}
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
private void LoadAccountsTable()
{
try
{
tableBody.InnerHtml = "";
string htmlContent = "";
BankAccounts accounts = new BankAccounts();
List<BankAccounts> allaAccountses = accounts.GetAllBankAccounts(_company.CompanyId);
foreach (BankAccounts acc in allaAccountses)
{
htmlContent += "<tr>";
htmlContent += String.Format(@"<th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th>", acc.BranchName, acc.AccountNo, acc.AccountTitle, acc.AccountType, acc.OpeningDate, acc.IsActive);
htmlContent += "</tr>";
}
tableBody.InnerHtml += htmlContent;
}
catch (Exception exc)
{
Alert.Show(exc.Message);
}
}
private void LoadJournalDetailsDataTable()
{
try
{
string htmlContent = "";
totalCredit.InnerHtml = "";
totalDebit.InnerHtml = "";
BankAccounts aBankAccount = new BankAccounts();
List<BankAccounts> aBankAccountList = aBankAccount.GetAllBankAccounts(_company.CompanyId);
List<JournalDetails> aJournalList =(List<JournalDetails>)Session["JournalDetailsInformation"];
journalDetailsTableBody.InnerHtml = "";
foreach (JournalDetails Journal in aJournalList)
{
BankAccounts newBankAccounts = new BankAccounts();
foreach (var bank in aBankAccountList)
{
if (bank.BankAccountId == Journal.AccountNo)
{
newBankAccounts = bank;
break;
}
}
htmlContent += String.Format(@"<tr><th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th></tr>", newBankAccounts.AccountNo, newBankAccounts.AccountTitle, Journal.Debit, Journal.Credit, Journal.Description, Journal.VoucherNo);
}
var totalCredi = from n in aJournalList select n.Credit;
var totalDebi = from n in aJournalList select n.Debit;
Decimal totalCreditbalance = totalCredi.Sum();
Decimal totalDebitbalance = totalDebi.Sum();
journalDetailsTableBody.InnerHtml += htmlContent;
totalDebit.InnerHtml += totalDebitbalance.ToString();
totalCredit.InnerHtml += totalCreditbalance.ToString();
}
catch (Exception exp)
{
Alert.Show(exp.Message);
}
}
private void LoadJournalAccountNo()
{
BankAccounts anAccount=new BankAccounts();
List<BankAccounts> accountList = anAccount.GetAllBankAccounts(_company.CompanyId);
accountNoDropDownList.DataSource = accountList;
accountNoDropDownList.DataTextField = "AccountTitle";
accountNoDropDownList.DataValueField = "BankAccountId";
accountNoDropDownList.DataBind();
}
void LoadType()
{
List<BankAccounts>accList=new List<BankAccounts>();
BankAccounts acc=new BankAccounts();
accList = acc.GetAllBankAccounts(_company.CompanyId);
List<string>accTypeList=new List<string>();
foreach (BankAccounts bankAccounts in accList)
{
accTypeList.Add(bankAccounts.AccountType);
}
chartOfAccountTypeDropDownList.DataSource = accTypeList;
chartOfAccountTypeDropDownList.DataBind();
}
private void LoadAccountsTable()
{
try
{
BankAccounts objAccounts=new BankAccounts();
objAccountList = objAccounts.GetAllBankAccounts(_company.CompanyId);
if(objAccountList.Count==0)
objAccountList.Add(new BankAccounts());
RadGrid1.DataSource = objAccountList;
RadGrid1.Rebind();
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
