protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
try
{
GridDataItem item = (GridDataItem) e.Item;
string id = item["colId"].Text;
switch (e.CommandName)
{
case "btnSelect":
Response.Redirect("BankAccountsInfo.aspx?id=" + id, true);
break;
case "btnDelete":
//int delete = new Bank().DeleteBankByBankId(int.Parse(id));
int delete = new BankAccounts().DeleteBankAccountsByBankAccountId(int.Parse(id));
if (delete == 0)
{
Alert.Show("Data was not delete..");
}
else
LoadAccountsTable();
break;
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
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();
}
protected void Page_Load(object sender, EventArgs e)
{
_company = (Company)Session["Company"];
_user = (Users)Session["User"];
if (!isValidSession())
{
string str = Request.QueryString.ToString();
if (str == string.Empty)
Response.Redirect("LogIn.aspx?refPage=index.aspx");
else
Response.Redirect("LogIn.aspx?refPage=index.aspx?" + str);
}
if (!IsPostBack)
{
if (Request.QueryString["id"] != null)
{
string bankAccountId = Request.QueryString["id"].ToString();
BankAccounts objBankAccounts = new BankAccounts().GetBankAccountsByBankAccountId(int.Parse(bankAccountId), _company.CompanyId);
if (objBankAccounts != null || objBankAccounts.BankAccountId != 0)
{
List<Bank> bankList = new List<Bank>();
Bank bank = new Bank();
lblId.Text = objBankAccounts.BankAccountId.ToString();
bankIdRadDropDownList1.Items.Clear();
bankList = bank.GetAllBank(_company.CompanyId);
List<string> bankName = new List<string>();
foreach (Bank bankNew in bankList)
{
if (bankNew.BankId == objBankAccounts.BankId)
bankName.Add(bankNew.BankName);
}
bankIdRadDropDownList1.DataSource = bankName;
bankIdRadDropDownList1.DataBind();
txtBranchName.Value = objBankAccounts.BranchName;
txtAccountNo.Value = objBankAccounts.AccountNo;
txtTitle.Value = objBankAccounts.AccountTitle;
accountTypeRadDropDownList1.Items.Clear();
List<string> list = new List<string>();
list.Add(objBankAccounts.AccountType);
accountTypeRadDropDownList1.DataSource = list;
accountTypeRadDropDownList1.DataBind();
RadDatePicker2.SelectedDate = DateTime.Parse(objBankAccounts.OpeningDate);
chkIsActive.Checked = objBankAccounts.IsActive;
}
}
}
this.LoadBankNames();
this.LoadAccountTypeDropDown();
}
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);
}
}
