public ActionResult Register() { Customer_info customer_Info = new Customer_info(); // return(View(customer_Info)); }
public ActionResult Register(Customer_info model) { using (register db = new register()) { db.Customer_info.Add(model); db.SaveChanges(); } ModelState.Clear(); TempData["SM"] = "Record Saved!"; return(View("Register", new Customer_info())); }
public ActionResult Login(Customer_info model) { using (register db = new register()) { if (db.Customer_info.Count(x => x.Name == model.Name && x.Password == model.Password) == 1) { name_login = model.Name; TempData["SM"] = "Successfully Logged in!"; return(RedirectToAction("Index")); } else { TempData["SM"] = "Name and" + " passwords does not match!"; return(View(model)); } } }
//VERIFIES LOGIN INFORMATION AND POPULATES PROFILES public ActionResult LoggedIn(string Login, string Password) { customer = new Customer_info(); CustomerLoginQuerys.customerLogin(Login, Password, customer); CustomerLoginQuerys.populateRequests(customer); CustomerLoginQuerys.populateServices(customer); //if login fails if (customer.FName == null) { return(RedirectToAction("Index", "Home")); } ViewBag.CustomerID = customer.ID; ViewBag.Login = customer.Login; ViewBag.Password = customer.Password; return(View("LoggedIn", customer)); }
public ActionResult SignUp(Customer_info account) { db.Customer_info.Add(account); db.SaveChanges(); return(View()); }
public ActionResult Login() { Customer_info customer_Info = new Customer_info(); return(View(customer_Info)); }
public ActionResult Register(string FName, string LName, string Address, string Number, string Login, string Password) { Customer_info customer = new Customer_info(); TempData["message"] = ""; //CHECK FOR USER TAKEN var db = DBConnection.Instance(); db.DatabaseName = "sql9235287"; if (db.IsConnect()) { string query = string.Format("SELECT * FROM Customer_info WHERE Login='******'", Login); var cmd = new MySqlCommand(query, db.Connection); cmd.CommandType = System.Data.CommandType.Text; var reader = cmd.ExecuteReader(); while (reader.Read()) { if (reader.GetString(5) == Login) { reader.Close(); TempData["message"] = "USERNAME TAKEN"; return(RedirectToAction("RegisterForm")); } } db.Close(); } //RETURN CURRENT ID COUNT FOR NEW ID ASSIGNMENT int ID = 1; db = DBConnection.Instance(); db.DatabaseName = "sql9235287"; if (db.IsConnect()) { string query = "SELECT * FROM ID_Count"; var cmd = new MySqlCommand(query, db.Connection); ID += (int)cmd.ExecuteScalar(); db.Close(); } //REGISTER NEW USER db = DBConnection.Instance(); db.DatabaseName = "sql9235287"; if (db.IsConnect()) { string insert = string.Format("INSERT INTO Customer_info(FName, LName, Address, Number, ID, Login, Password) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", FName, LName, Address, Number, ID, Login, Password); var cmd = new MySqlCommand(insert, db.Connection); cmd.CommandType = System.Data.CommandType.Text; cmd.ExecuteNonQuery(); db.Close(); } //UPDATE CURRENT ID COUNT IN TABLE db = DBConnection.Instance(); db.DatabaseName = "sql9235287"; if (db.IsConnect()) { string update = string.Format("UPDATE ID_Count SET count='{0}'", ID); var cmd = new MySqlCommand(update, db.Connection); cmd.CommandType = System.Data.CommandType.Text; cmd.ExecuteNonQuery(); db.Close(); } return(RedirectToAction("Redirect")); }