protected void btnRegister_Click(object sender, EventArgs e) { int accNum = int.Parse(txtAccountNumber.Text); var _db = new CustomerContext(); var query = (from c in _db.Customers join a in _db.Accounts on c.CustomerID equals a.CustomerID where a.AccountNumber == accNum && c.Email == txtEmail.Text select c); foreach (Customer cust in query) { if (cust.OnlineCustomer == false) { cust.OnlineCustomer = true; cust.UserName = txtUserName.Text; cust.CustomerPassword = txtPassword.Text; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Unsuccessfully')", true); } } _db.SaveChanges(); }
protected void btnLogin_Click(object sender, EventArgs e) { using (var _db = new CustomerContext()) { try { Customer currentCustomer = (from c in _db.Customers where c.UserName == txtUsername.Text && c.CustomerPassword == txtPassword.Text select c).First(); if (currentCustomer.UserName == txtUsername.Text && currentCustomer.CustomerPassword == txtPassword.Text) { CustomSessionObject.Current.SessionUsername = txtUsername.Text.Trim(); CustomSessionObject.Current.LoginStatus = true; Response.Redirect("LoggedIn.aspx", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Login Unsuccessful')", true); CustomSessionObject.Current.LoginStatus = false; } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
protected void btnRecover_Click(object sender, EventArgs e) { using (var _db = new CustomerContext()) { try { var password = (from p in _db.Customers where p.UserName == txtUsername.Text && p.Email == txtEmail.Text select new { p.CustomerPassword }).First(); using (MailMessage message = new MailMessage()) { message.From = new MailAddress("*****@*****.**"); message.To.Add(new MailAddress(txtEmail.Text)); message.Subject = "Password Recovery"; message.Body = "You have recieved this email because you have forgot your password." + Environment.NewLine + "Your password is " + password.CustomerPassword + Environment.NewLine + "Please login using this password"; } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
public List<Transaction> GetTransactions() { using (var cxt = new CustomerContext()) { List<Transaction> allTransactions = cxt.Transactions.ToList(); return allTransactions; } }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetExpires(DateTime.Now.AddSeconds(-1)); Response.Cache.SetNoStore(); if (CustomSessionObject.Current.SessionUsername == null) { Response.Redirect("ErrorPage.aspx", true); } if (!IsPostBack) { DisplaySessionValue(); LoadAccountNumber(); string username = CustomSessionObject.Current.SessionUsername; using (var _db = new CustomerContext()) { try { var match = (from c in _db.Customers join a in _db.Accounts on c.CustomerID equals a.CustomerID where c.UserName == username select new { c.FirstName, c.Surname, a.AccountNumber, c.AddressLine1, c.AddressLine2, c.City, c.County, c.CustomerID, a.AccountType, a.Balance }).FirstOrDefault(); lblName.Text = match.FirstName + " " + match.Surname; lblAccountNumber.Text = match.AccountNumber.ToString(); lblAddressLine1.Text = match.AddressLine1; lblAddressLine2.Text = match.AddressLine2; lblCity.Text = match.City; lblCounty.Text = match.County; lblAccountNum.Text = match.AccountNumber.ToString(); lblAccountType.Text = match.AccountType; lblAccountBalance.Text = CurrencyFormat(match.Balance); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } } }
public IQueryable<Branch> GetBranches() { IQueryable<Branch> query = null; var cxt = new CustomerContext(); try { query = cxt.Branches; } catch (Exception ex) { FireBugWriter.Write(ex.Message); } return query; }
private void PrimeCustomerDropdowns() { using (var cxt = new CustomerContext()) { try { List<Customer> customerList = cxt.Customers.ToList(); foreach (Customer customer in customerList) { ListItem item = new ListItem(customer.FirstName + " " + customer.Surname, customer.CustomerID.ToString()); cboCustomerDetails.Items.Add(item); cboCustomers.Items.Add(item); cboViewCustomers.Items.Add(item); } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void PrimeAccountDropDown() { int customerID = int.Parse(cboCustomerDetails.SelectedValue); using (var cxt = new CustomerContext()) { try { var accounts = cxt.Accounts.Where(a => a.CustomerID == customerID); foreach (var account in accounts) { ListItem item = new ListItem(account.AccountNumber.ToString()); cboAccounts.Items.Add(item); } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void SerializeCustomerInfo(StreamWriter writer) { XmlSerializer xmlSerializer = new XmlSerializer(typeof(Customer)); int customerId = int.Parse(cboViewCustomers.SelectedValue); using (var cxt = new CustomerContext()) { try { Customer customer = cxt.Customers.Where(c => c.CustomerID == customerId).First(); xmlSerializer.Serialize(writer, customer); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void DeleteAccount() { int accountNumber = int.Parse(cboAccounts.SelectedItem.ToString()); using (var cxt = new CustomerContext()) { try { cxt.Accounts.Remove(cxt.Accounts.Where(a => a.AccountNumber == accountNumber).First()); cxt.SaveChanges(); cboAccounts.Visible = false; } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void RemoveCustomer() { bool hasAccounts = false; using (var cxt = new CustomerContext()) { int customerID = int.Parse(cboCustomers.SelectedValue); try { var customerWithAccounts = (from c in cxt.Customers join a in cxt.Accounts on c.CustomerID equals a.CustomerID where c.CustomerID == customerID select a.AccountNumber); foreach (var account in customerWithAccounts) { if (account == 0) hasAccounts = false; else hasAccounts = true; } if (hasAccounts) ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Customer has open Accounts!')", true); else { cxt.Customers.Remove(cxt.Customers.Where(c => c.CustomerID == customerID).First()); cxt.SaveChanges(); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", "alert('Customer Record Deleted.')", true); } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void AddCustomer() { Customer newCustomer = new Customer(); newCustomer.FirstName = txtFname.Text; newCustomer.Surname = txtLname.Text; newCustomer.Email = txtEmail.Text; newCustomer.Phone = txtPhone.Text; newCustomer.AddressLine1 = txtAddress1.Text; newCustomer.AddressLine2 = txtAddress2.Text; newCustomer.City = txtCity.Text; newCustomer.County = cboCounties.SelectedItem.ToString(); using (var cxt = new CustomerContext()) { try { cxt.Customers.Add(newCustomer); cxt.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
protected void btnTransfer_Click(object sender, EventArgs e) { bool success = false; int fromAccount, toAccount, amount; string description = txtDescription.Text; string transType = "Transfer"; DateTime stamp = DateTime.Now; string transRef = "Online Transfer"; fromAccount = int.Parse(txtAccountNumber.Text); toAccount = int.Parse(txtToAccountNumber.Text); amount = int.Parse(txtAmount.Text); Transaction newTransaction = new Transaction(); newTransaction.TransactionAccountNumber = fromAccount; newTransaction.DestinationAccountNumber = toAccount; newTransaction.TransactionType = transType; newTransaction.TransactionReference = transRef; newTransaction.TransactionAmount = amount; newTransaction.TransactionDateTime = stamp; newTransaction.TransactionDescription = description; using (var _db = new CustomerContext()) { try { _db.Transactions.Add(newTransaction); success = true; _db.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } using (var db = new CustomerContext()) { int deductAmount = int.Parse(txtAmount.Text); int accountNumber = int.Parse(txtAccountNumber.Text); try { var query = (from a in db.Accounts where a.AccountNumber == accountNumber select a).First(); int newBalance = query.Balance - deductAmount; query.Balance = newBalance; db.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } using (var db = new CustomerContext()) { int addAmount = int.Parse(txtAmount.Text); int destinationAccount = int.Parse(txtToAccountNumber.Text); try { var query = (from a in db.Accounts where a.AccountNumber == destinationAccount select a).First(); int newBalance = query.Balance + addAmount; query.Balance = newBalance; db.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } if (success) { txtAmount.Text = string.Empty; txtDescription.Text = string.Empty; txtReference.Text = string.Empty; txtToAccountNumber.Text = string.Empty; } }
public void LoadAccountNumber() { string username = CustomSessionObject.Current.SessionUsername; using (var _db = new CustomerContext()) { try { var query = (from c in _db.Customers join a in _db.Accounts on c.CustomerID equals a.CustomerID where c.UserName == username select new { a.AccountNumber }).FirstOrDefault(); txtAccountNumber.Text = query.AccountNumber.ToString(); txtExtAccountNumber.Text = query.AccountNumber.ToString(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
protected void btnTransfer_Click(object sender, EventArgs e) { bool success = false; int fromAccount, toAccount, amount; string description = txtDescription.Text; string transType = "Transfer"; DateTime stamp = DateTime.Now; string transRef = "Online Transfer"; fromAccount = int.Parse(txtFromAccount.Text); toAccount = int.Parse(txtToAccount.Text); amount = int.Parse(txtAmount.Text); Transaction newTransaction = new Transaction(); newTransaction.TransactionAccountNumber = fromAccount; newTransaction.DestinationAccountNumber = toAccount; newTransaction.TransactionType = transType; newTransaction.TransactionReference = transRef; newTransaction.TransactionAmount = amount; newTransaction.TransactionDateTime = stamp; newTransaction.TransactionDescription = description; using (var _db = new CustomerContext()) { try { _db.Transactions.Add(newTransaction); success = true; _db.SaveChanges(); UpdateBalance(); if (success) { txtFromAccount.Text = string.Empty; txtToAccount.Text = string.Empty; txtAmount.Text = string.Empty; } } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
public static List<Transaction> GetTransactions() { using (var _db = new CustomerContext()) { try { var query = (from t in _db.Transactions join a in _db.Accounts on t.TransactionAccountNumber equals a.AccountNumber join c in _db.Customers on a.CustomerID equals c.CustomerID where c.CustomerID == a.CustomerID select t).ToList(); return query.ToList(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
private void ViewCustomerDetails() { int id = int.Parse(cboViewCustomers.SelectedValue); using (var cxt = new CustomerContext()) { try { Customer currentCustomer = cxt.Customers.Where(c => c.CustomerID == id).First(); lblDisplayFname.Text = currentCustomer.FirstName; lblDisplayLname.Text = currentCustomer.Surname; lblDisplayEmail.Text = currentCustomer.Email; lblDisplayPhone.Text = currentCustomer.Phone; lblDisplayAddress1.Text = currentCustomer.AddressLine1; lblDisplayAddress2.Text = currentCustomer.AddressLine2; lblDisplayCity.Text = currentCustomer.City; lblDisplayCounty.Text = currentCustomer.County; } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } }
public void UpdateBalance() { using (var db = new CustomerContext()) { try { int deductAmount = int.Parse(txtAmount.Text); int accountNumber = int.Parse(txtFromAccount.Text); var query = (from a in db.Accounts where a.AccountNumber == accountNumber select a).First(); int newBalance = query.Balance - deductAmount; query.Balance = newBalance; db.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } using (var db = new CustomerContext()) { int addAmount = int.Parse(txtAmount.Text); int destinationAccount = int.Parse(txtToAccount.Text); try { var query = (from a in db.Accounts where a.AccountNumber == destinationAccount select a).First(); int newBalance = query.Balance + addAmount; query.Balance = newBalance; db.SaveChanges(); } catch (Exception ex) { FireBugWriter.Write(ex.Message); } } Response.Redirect(Request.RawUrl); }