private void fBindData()
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
var grdData = (from u in dbContext.CustomerMasters
orderby u.CustomerUserName ascending
select new { u.CustomerName, u.CustomerType, u.CustomerBankAccountNo, u.CustomerIFSCNo, u.CustomerUserName, u.Password, u.IsEnabled }).ToList();
// Search
if (!string.IsNullOrEmpty(txtSerach.Text))
{
grdData = grdData.Where(x => x.CustomerName.ToLower().StartsWith(txtSerach.Text.Trim().ToLower())).ToList();
}
// Allow paging
if (ddlPageSize.SelectedValue == "0")
{
gvDetails.AllowPaging = false;
}
else
{
int pageSize = Convert.ToInt16(ddlPageSize.SelectedValue); gvDetails.AllowPaging = true; gvDetails.PageSize = pageSize;
}
gvDetails.DataSource = grdData;
gvDetails.DataBind();
int pageCount = gvDetails.PageCount;
int currentPage = gvDetails.PageIndex;
int recordCount = grdData.Count;
data_table_info.InnerText = "Page " + (currentPage + 1) + " of " + pageCount + " Total Records: " + recordCount + " entries";
}
}
private void fLoadAccount()
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
// Bind account information
var data = dbContext.CustomerMasters.Where(x => x.CustomerUserName.ToLower() != empCode.ToLower()).Select(x => new { Value = x.CustomerBankAccountNo, Text = x.CustomerBankAccountNo + "[ " + x.CustomerName + "]" }).ToList();
ddlAccountNumber.DataSource = data;
ddlAccountNumber.DataTextField = "Text";
ddlAccountNumber.DataValueField = "Value";
ddlAccountNumber.DataBind();
ddlAccountNumber.Items.Insert(0, "--Choose--");
}
}
private void fLoadAccountInfo(string accountNo)
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
var data = dbContext.CustomerMasters.Where(x => x.CustomerBankAccountNo.ToLower().Equals(accountNo.ToLower())).Select(x => new { x.CustomerName, x.CustomerIFSCNo, x.CustomerBankName }).SingleOrDefault();
if (data != null)
{
txtBankName.Text = data.CustomerBankName;
txtIFSCCode.Text = data.CustomerIFSCNo;
txtCustomerName.Text = data.CustomerName;
}
}
}
private void fBindData()
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
empCode = Session["USERNAME"].ToString();
var grdData = (from a in dbContext.BalanceMasters
group a by a.CustomerBankAccountNo into g
join b in dbContext.CustomerMasters on g.FirstOrDefault().CustomerBankAccountNo equals b.CustomerBankAccountNo
where b.CustomerUserName.ToLower().Equals(empCode.ToLower())
//let balamt = g.FirstOrDefault().MasterAmount - g.Sum(g => g.BalanceAmount)
select new { b.CustomerName, b.CustomerType, b.CustomerUserName, b.CustomerBankAccountNo, g.FirstOrDefault().MasterAmount, g.FirstOrDefault().BalanceAmount }).ToList();
// Allow paging
if (ddlPageSize.SelectedValue == "0")
{
gvDetails.AllowPaging = false;
}
else
{
int pageSize = Convert.ToInt16(ddlPageSize.SelectedValue); gvDetails.AllowPaging = true; gvDetails.PageSize = pageSize;
}
gvDetails.DataSource = grdData;
gvDetails.DataBind();
if (grdData.Count > 0)
{
int pageCount = gvDetails.PageCount;
int currentPage = gvDetails.PageIndex;
var dd = grdData[0].CustomerBankAccountNo;
var history = (from a in dbContext.TransferHistories
where a.CustomerBankAccountNo.ToLower().Equals(dd.ToLower())
select new { a.CustomerBankAccountNo, a.DestinationBankAccountNo, a.DestinationAccountHolderName, a.MasterAmount, a.BalanceAmount, a.TranferAmount }).ToList();
GridView1.DataSource = history;
GridView1.DataBind();
var credit = (from a in dbContext.CreditHistories
where a.CreditrBankAccountNo.ToLower().Equals(dd.ToLower())
select new { a.SourceAccountHolderName, a.SourceBankAccountNo, a.CreditAmount }).ToList();
GridView2.DataSource = credit;
GridView2.DataBind();
}
}
}
protected void lnkRemove_Click(object sender, EventArgs e)
{
LinkButton lnkRemove = (LinkButton)sender;
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
var grdDelete = dbContext.CustomerMasters.Where(x => x.CustomerUserName.Equals(lnkRemove.CommandArgument)).SingleOrDefault();
if (grdDelete != null)
{
dbContext.CustomerMasters.Attach(grdDelete);
dbContext.CustomerMasters.Remove(grdDelete);
dbContext.SaveChanges();
}
fBindData();
lblMsg.Text = "Customer details deleted successfully";
}
}
private void fGetEmpDetails()
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
var grdEmp = dbContext.CustomerMasters.Where(x => x.CustomerUserName.Equals(empCode)).SingleOrDefault();
if (grdEmp != null)
{
txtCustomerName.Text = grdEmp.CustomerName;
rblGender.SelectedValue = Convert.ToString(grdEmp.Gender);
chkIsEnabled.Checked = grdEmp.IsEnabled;
txtUserName.Text = grdEmp.CustomerUserName;
txtPassword.Text = (grdEmp.Password);
rblCustomerType.SelectedValue = Convert.ToString(grdEmp.CustomerType);
txtBankName.Text = grdEmp.CustomerBankName;
txtAccountNumber.Text = (grdEmp.CustomerBankAccountNo);
txtIFSCCode.Text = (grdEmp.CustomerIFSCNo);
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Create
if (action == "Create")
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
//Check Name Found
var chkUser = dbContext.CustomerMasters.Where(x => x.CustomerUserName.ToLower().Equals(txtUserName.Text.ToLower())).ToList();
if (chkUser.Count > 0)
{
this.lblMsg.Text = "Username is Found.";
txtUserName.Focus();
return;
}
chkUser = dbContext.CustomerMasters.Where(x => x.CustomerBankAccountNo.ToLower().Equals(txtAccountNumber.Text.ToLower())).ToList();
if (chkUser.Count > 0)
{
this.lblMsg.Text = "Account Number is Found.";
txtAccountNumber.Focus();
return;
}
var grdEmp = dbContext.CustomerMasters.Create();
grdEmp.CustomerBankName = this.txtBankName.Text.Trim();
grdEmp.CustomerBankAccountNo = this.txtAccountNumber.Text.Trim();
grdEmp.CustomerIFSCNo = this.txtIFSCCode.Text.Trim();
grdEmp.CustomerUserName = this.txtUserName.Text.Trim();
grdEmp.Password = this.txtPassword.Text.Trim();
grdEmp.CustomerName = this.txtCustomerName.Text.Trim();
grdEmp.Gender = rblGender.SelectedValue;
grdEmp.CustomerType = rblCustomerType.SelectedValue;
grdEmp.IsEnabled = this.chkIsEnabled.Checked;
dbContext.CustomerMasters.Add(grdEmp);
dbContext.SaveChanges();
var role = dbContext.LinkUserToRoles.Create();
role.UserCode = this.txtUserName.Text.Trim();
role.RoleCode = 2;
dbContext.LinkUserToRoles.Add(role);
dbContext.SaveChanges();
var grdBank = dbContext.BalanceMasters.Create();
grdBank.CustomerBankAccountNo = this.txtAccountNumber.Text.Trim();
grdBank.CustomerIFSCNo = this.txtIFSCCode.Text.Trim();
if (rblCustomerType.SelectedValue == "Premier")
{
grdBank.MasterAmount = 10000; grdBank.BalanceAmount = 10000;
}
else
{
grdBank.MasterAmount = 1000; grdBank.BalanceAmount = 1000;
}
dbContext.BalanceMasters.Add(grdBank);
dbContext.SaveChanges();
lblMsg.Text = " Customer Created successfully";
}
}
#endregion
#region Edit
if (action == "Edit")
{
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
var grdEmp = dbContext.CustomerMasters.Where(x => x.CustomerUserName.ToLower().Equals(empCode.ToLower())).SingleOrDefault();
grdEmp.CustomerBankName = this.txtBankName.Text.Trim();
grdEmp.CustomerIFSCNo = this.txtIFSCCode.Text.Trim();
grdEmp.Password = this.txtPassword.Text.Trim();
grdEmp.CustomerName = this.txtCustomerName.Text.Trim();
grdEmp.Gender = rblGender.SelectedValue;
grdEmp.CustomerType = rblCustomerType.SelectedValue;
grdEmp.IsEnabled = this.chkIsEnabled.Checked;
dbContext.SaveChanges();
var grdBank = dbContext.BalanceMasters.Where(x => x.CustomerBankAccountNo.ToLower().Equals(this.txtAccountNumber.Text.Trim())).SingleOrDefault();
if (grdBank != null)
{
grdBank.CustomerBankAccountNo = this.txtAccountNumber.Text.Trim();
grdBank.CustomerIFSCNo = this.txtIFSCCode.Text.Trim();
if (rblCustomerType.SelectedValue == "Premier")
{
grdBank.MasterAmount = 10000; grdBank.BalanceAmount = 10000;
}
else
{
grdBank.MasterAmount = 1000; grdBank.BalanceAmount = 1000;
}
dbContext.SaveChanges();
}
else
{
grdBank = dbContext.BalanceMasters.Create();
grdBank.CustomerBankAccountNo = this.txtAccountNumber.Text.Trim();
grdBank.CustomerIFSCNo = this.txtIFSCCode.Text.Trim();
if (rblCustomerType.SelectedValue == "Premier")
{
grdBank.MasterAmount = 10000; grdBank.BalanceAmount = 10000;
}
else
{
grdBank.MasterAmount = 1000; grdBank.BalanceAmount = 1000;
}
dbContext.BalanceMasters.Add(grdBank);
dbContext.SaveChanges();
}
lblMsg.Text = "Customer details modified successfully";
}
}
#endregion
fBindData();
fGetEmpDetails();
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Transaction
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
empCode = Session["USERNAME"].ToString();
//Check Name Found
var chkUser = (from a in dbContext.BalanceMasters
join b in dbContext.CustomerMasters on a.CustomerBankAccountNo equals b.CustomerBankAccountNo
where b.CustomerUserName.ToLower().Equals(empCode.ToLower())
select new { a.CustomerBankAccountNo, a.CustomerIFSCNo, b.CustomerBankName, b.CustomerName, a.MasterAmount, a.BalanceAmount }).SingleOrDefault();
if (chkUser != null)
{
// Store to TransferHistories
var grdEmp = dbContext.TransferHistories.Create();
grdEmp.CustomerBankAccountNo = chkUser.CustomerBankAccountNo;
grdEmp.DestinationBankAccountNo = this.ddlAccountNumber.SelectedValue.Trim();
grdEmp.DestinationIFSCNo = this.txtIFSCCode.Text.Trim();
grdEmp.DestinationBankName = this.txtBankName.Text.Trim();
grdEmp.DestinationAccountHolderName = this.txtCustomerName.Text.Trim();
grdEmp.MasterAmount = chkUser.BalanceAmount;
grdEmp.TranferAmount = Convert.ToDecimal(txtAmount.Text);
grdEmp.BalanceAmount = (chkUser.BalanceAmount - grdEmp.TranferAmount);
// check the balance
if (chkUser.BalanceAmount < grdEmp.TranferAmount)
{
this.lblMsg.Text = "In sufficient Amout.";
fLoadAccountInfo(ddlAccountNumber.SelectedValue);
return;
}
dbContext.TransferHistories.Add(grdEmp);
dbContext.SaveChanges();
// Store to CreditHistories
var grdCredit = dbContext.CreditHistories.Create();
grdCredit.CreditrBankAccountNo = ddlAccountNumber.SelectedValue;
grdCredit.SourceBankAccountNo = chkUser.CustomerBankAccountNo;
grdCredit.SourceBankName = chkUser.CustomerBankName;
grdCredit.SourceIFSCNo = chkUser.CustomerIFSCNo;
grdCredit.SourceAccountHolderName = chkUser.CustomerName;
grdCredit.CreditAmount = Convert.ToDecimal(txtAmount.Text);
dbContext.CreditHistories.Add(grdCredit);
dbContext.SaveChanges();
// deduct balance
var grdBank = dbContext.BalanceMasters.Where(x => x.CustomerBankAccountNo.ToLower().Equals(chkUser.CustomerBankAccountNo.ToLower())).FirstOrDefault();
grdBank.BalanceAmount = (grdBank.BalanceAmount - Convert.ToDecimal(txtAmount.Text));
dbContext.SaveChanges();
// Add balance
var grdAdsdBank = dbContext.BalanceMasters.Where(x => x.CustomerBankAccountNo.ToLower().Equals(ddlAccountNumber.SelectedValue.ToLower())).FirstOrDefault();
grdAdsdBank.BalanceAmount = (grdAdsdBank.BalanceAmount + Convert.ToDecimal(txtAmount.Text));
dbContext.SaveChanges();
fBindData();
}
else
{
this.lblMsg.Text = "Amount is not found.";
fLoadAccountInfo(ddlAccountNumber.SelectedValue);
return;
}
lblMsg.Text = " Transaction Created successfully";
}
#endregion
fBindData();
}
protected void btnSignIn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtUsername.Text))
{
lblMsg.Text = "Username is required.";
txtUsername.Focus(); lblMsg.ForeColor = Color.Red;
return;
}
if (string.IsNullOrEmpty(txtPassword.Text))
{
lblMsg.Text = "Password Code is required.";
txtPassword.Focus(); lblMsg.ForeColor = Color.Red;
return;
}
using (Bank_DBEntities dbContext = new Bank_DBEntities())
{
#region Username Check
var chkTeller = (from t in dbContext.TellerMasters
where t.TellerUserName.ToLower().Equals(txtUsername.Text.ToLower())
select new { t.TellerUserName, t.TellerName, t.TellerCode, t.IsEnabled }).SingleOrDefault();
var chkCustomer = (from c in dbContext.CustomerMasters
where c.CustomerUserName.ToLower().Equals(txtUsername.Text.ToLower())
select new { c.CustomerUserName, c.CustomerName, c.IsEnabled }).SingleOrDefault();
if (chkTeller == null && chkCustomer == null)
{
lblMsg.Text = "User not exist, Please try different.";
return;
}
else
{
if (chkTeller != null)
{
if (chkTeller.IsEnabled.Equals(false))
{
lblMsg.Text = "User has been De Activated, Please contact admin.";
return;
}
Session["USERCODE"] = chkTeller.TellerCode;
Session["USERNAME"] = chkTeller.TellerName;
}
else
{
if (chkCustomer.IsEnabled.Equals(false))
{
lblMsg.Text = "User has been De Activated, Please contact admin.";
return;
}
Session["USERCODE"] = chkCustomer.CustomerUserName;
Session["USERNAME"] = chkCustomer.CustomerName;
}
}
#endregion
#region Role Check
var chkRole = (from l in dbContext.LinkUserToRoles
where l.UserCode.ToLower().Equals(txtUsername.Text.ToLower())
select new { l.Role.RoleName, l.Role.RoleCode }).SingleOrDefault();
if (chkRole == null)
{
lblMsg.Text = "User not mapped the role, Please try different.";
return;
}
Session["ROLENAME"] = chkRole.RoleName;
Session["ROLECODE"] = chkRole.RoleCode;
#endregion
#region Username,Password Check
chkTeller = (from t in dbContext.TellerMasters
where t.TellerUserName.ToLower().Equals(txtUsername.Text.ToLower()) && t.Password.ToLower().Equals(txtPassword.Text.ToLower())
select new { t.TellerUserName, t.TellerName, t.TellerCode, t.IsEnabled }).SingleOrDefault();
chkCustomer = (from c in dbContext.CustomerMasters
where c.CustomerUserName.ToLower().Equals(txtUsername.Text.ToLower()) && c.Password.ToLower().Equals(txtPassword.Text.ToLower())
select new { c.CustomerUserName, c.CustomerName, c.IsEnabled }).SingleOrDefault();
if (chkTeller == null && chkCustomer == null)
{
lblMsg.Text = "Password not matched, Please try different.";
return;
}
#endregion
Response.Redirect(ResolveUrl("~/Default.aspx"));
}
}
