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")); } }