protected void btnSaveBankInfo_Click(object sender, EventArgs e)
{
Bank objBank = new Bank();
List<Bank> myList = objBank.GetAllBank(_company.CompanyId);
int bankId = myList.Count;
objBank.BankId = bankId;
objBank.BankCode = txtBankCode.Value;
objBank.BankName = txtBankName.Value;
objBank.ContactPerson = txtContactPerson.Value;
objBank.ContactDesignation = txtDesignation.Value;
objBank.ContactNo = txtContactNo.Value;
objBank.ContactEmail = txtEmail.Value;
objBank.CompanyId = _company.CompanyId;
objBank.UpdatedBy = _user.UserId;
objBank.UpdatedDate = DateTime.Today;
objBank.IsActive = chkIsActive.Checked;
int sucess = 0;
sucess = objBank.InsertBank();
if (sucess > 0)
{
Alert.Show("Bank info Saved successfully");
this.Clear();
this.LoadBankTable();
this.LoadBankNames();
AccountInfoPageDiv.Disabled = false;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Bank objBank = new Bank();
objBank.BankCode = txtBankCode.Value;
objBank.BankName = txtBankName.Value;
objBank.ContactPerson = txtContactPerson.Value;
objBank.ContactDesignation = txtDesignation.Value;
objBank.ContactNo = txtContactNo.Value;
objBank.ContactEmail = txtEmail.Value;
objBank.CompanyId = _company.CompanyId;
objBank.UpdatedBy = _user.UserId;
objBank.UpdatedDate = DateTime.Today;
objBank.IsActive = chkIsActive.Checked;
int sucess = 0;
if (lblId.Text == "" || lblId.Text == "0")
{
objBank.BankId = new Bank().GetMaxBankId() + 1;
sucess = objBank.InsertBank();
if (sucess > 0)
{
Alert.Show("Bank info saved successfully");
this.Clear();
}
}
else
{
objBank.BankId = int.Parse(lblId.Text);
sucess = objBank.UpdateBank();
if (sucess > 0)
{
Response.Redirect("BankLists.aspx", true);
}
}
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
GridDataItem item = (GridDataItem)e.Item;
string id = item["colId"].Text;
switch (e.CommandName)
{
case "btnSelect":
Response.Redirect("BankInfo.aspx?id=" + id, true);
break;
case "btnDelete":
int delete = new Bank().DeleteBankByBankId(int.Parse(id));
if (delete == 0)
{
Alert.Show("Data was not delete..");
}
else
LoadBankTable();
break;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Bank objBank = new Bank();
objBank.BankCode = txtBankCode.Value;
objBank.BankName = txtBankName.Value;
objBank.ContactPerson = txtContactPerson.Value;
objBank.ContactDesignation = txtDesignation.Value;
objBank.ContactNo = txtContactNo.Value;
objBank.ContactEmail = txtEmail.Value;
objBank.CompanyId = _company.CompanyId;
objBank.UpdatedBy = _user.UserId;
objBank.UpdatedDate = DateTime.Today;
objBank.IsActive = chkIsActive.Checked;
int sucess = 0;
if (lblId.Text == "" || lblId.Text == "0")
{
objBank.BankId = new Bank().GetMaxBankId(objBank.CompanyId);
objBank.BankId++;
sucess = objBank.InsertBank();
}
else
{
objBank.BankId = int.Parse(lblId.Text==""?"0":lblId.Text);
sucess = objBank.UpdateBank();
}
if (sucess > 0)
{
Alert.Show("Bank info saved successfully");
this.Clear();
this.LoadBankTable();
}
}
private void LoadBankTable()
{
Bank objBank = new Bank();
tableBankBody.InnerHtml = "";
string htmlContent = "";
objBankList = objBank.GetAllBank(_company.CompanyId);
foreach (Bank bank in objBankList)
{
htmlContent += "<tr>";
htmlContent += String.Format(@"<th>{0}</th><th>{1}</th><th>{2}</th><th>{3}</th><th>{4}</th><th>{5}</th><th>{6}</th><th>{7}</th><th>{8}</th>", bank.BankCode, bank.BankName, bank.ContactPerson, bank.ContactDesignation, bank.ContactNo, bank.ContactEmail, bank.IsActive, bank.UpdatedBy, bank.UpdatedDate);
htmlContent += "</tr>";
}
tableBankBody.InnerHtml += htmlContent;
}
void LoadBankNames()
{
List<Bank> allBanks = new Bank().GetAllBank(1);
List<string> nameList = new List<string>();
foreach (Bank bank in allBanks)
{
nameList.Add(bank.BankName);
}
bankIdRadDropDownList1.DataSource = nameList;
bankIdRadDropDownList1.DataBind();
}
void LoadBankNames()
{
List<Bank>allBanks=new Bank().GetAllBank(_company.CompanyId);
bankIdRadDropDownList1.DataSource = allBanks;
bankIdRadDropDownList1.DataTextField = "BankName";
bankIdRadDropDownList1.DataValueField = "BankId";
bankIdRadDropDownList1.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();
}
private void LoadBankTable()
{
try
{
Bank objBank = new Bank();
objBankList = objBank.GetAllBank(_company.CompanyId);
if (objBankList.Count == 0)
objBankList.Add(new Bank());
RadGrid1.DataSource = objBankList;
RadGrid1.Rebind();
}
catch (Exception ex)
{
Alert.Show(ex.Message);
}
}
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 bankId = Request.QueryString["id"].ToString();
Bank bank = new Bank().GetBankByBankId(int.Parse(bankId), _company.CompanyId);
if (bank != null || bank.BankId != 0)
{
lblId.Text = bank.BankId.ToString();
txtBankCode.Value = bank.BankCode;
txtBankName.Value = bank.BankName;
txtContactPerson.Value = bank.ContactPerson;
txtDesignation.Value = bank.ContactDesignation;
txtContactNo.Value = bank.ContactNo;
txtEmail.Value = bank.ContactEmail;
chkIsActive.Checked = bank.IsActive;
}
}
}
}
protected void RadGrid1_OnItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "btnSelect")
{
GridDataItem item = (GridDataItem)e.Item;
lblId.Text = item["colId"].Text;
txtBankName.Value = item["colName"].Text.Trim();
}
else if (e.CommandName == "btnDelete")
{
GridDataItem item = (GridDataItem)e.Item;
lblId.Text = item["colId"].Text;
int delete = new Bank().DeleteBankByBankId(int.Parse(lblId.Text));
if (delete == 0)
{
Alert.Show("Data was not delete..");
}
//else
//LoadListTable();
}
}
