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