/// <summary> /// Method which checks the db and validates a customerID /// </summary> /// <param name="custID"></param> /// <returns>A bool value</returns> public bool ValidateCustomer(int custID, string password) { BankDataContext bankDataContext = new BankDataContext(); CustomerTable custTable = new CustomerTable(); var valIDQuery = bankDataContext.CustomerTables.Any(cust => (cust.Customer_ID == custID && cust.Customer_Password == password)); if (!valIDQuery) { return(false); } else { return(Convert.ToBoolean(valIDQuery)); } }
/// <summary> /// Method to get the customer name from the db based on the customerID /// </summary> /// <param name="custID"></param> /// <returns>CustomerName</returns> public string GetCustomerName(int custID) { BankDataContext bankDataContext = new BankDataContext(); CustomerTable custTable = new CustomerTable(); var custNameQuery = bankDataContext.CustomerTables.SingleOrDefault(cust => cust.Customer_ID == custID).Customer_Name; if (custNameQuery == null) { return("Customer Name not found"); } else { return(custNameQuery.ToString()); } }
/// <summary> /// Method to add a new customer into the db /// </summary> /// <param name="customer"></param> /// <returns>New generated customerID</returns> public int AddNewCustomer1(Customers customer) { BankDataContext bankDataContext = new BankDataContext(); CustomerTable custTable = new CustomerTable(); bankDataContext.Connection.Open(); custTable.Customer_Address = customer.GetCustomerAddress(); custTable.Customer_Name = customer.GetCustomerName(); custTable.Customer_Telephone = customer.GetCustomerTelephone(); bankDataContext.CustomerTables.InsertOnSubmit(custTable); bankDataContext.SubmitChanges(); // how linq to sql works in fetching the identity column return(custTable.Customer_ID); }
partial void DeleteCustomerTable(CustomerTable instance);
partial void UpdateCustomerTable(CustomerTable instance);
partial void InsertCustomerTable(CustomerTable instance);