public IActionResult Login(LogRegModels model)
{
if (ModelState.IsValid)
{
string FormPassword = model.Log.Password;
string query = $"SELECT * FROM user WHERE email = '{model.Log.Email}'";
List <Dictionary <string, object> > user = new List <Dictionary <string, object> >();
try
{
user = DbConnector.Query(query);
if (user.Count == 0)
{
TempData["ValError"] = "This email does not exist.";
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
Debug.Print("Exception when querying for user:"******"password"].ToString(), model.Log.Password) != 0)
{
try
{
object id = DbConnector.Query($"SELECT iduser FROM user WHERE email = '{model.Log.Email}'")[0]["iduser"];
string idString = id.ToString();
CookieOptions option = new CookieOptions();
option.Expires = DateTime.Now.AddMinutes(60);
Response.Cookies.Append("userCookie", idString, option);
}
catch (Exception e)
{
Debug.Print("Exception when baking cookie: " + e.Message);
}
HttpContext.Session.SetString("userEmail", model.Log.Email);
return(RedirectToAction("Home"));
}
else
{
TempData["ValError"] = "Incorrect password.";
return(RedirectToAction("Index"));
}
}
return(View("Index"));
}
public IActionResult Register(LogRegModels model)
{
if (ModelState.IsValid)
{
try
{
List <Dictionary <string, object> > user = DbConnector.Query($"SELECT * FROM user WHERE email = '{model.Reg.Email}'");
if (user.Count > 0)
{
TempData["ValError"] = "This email already exists.";
return(RedirectToAction("Index"));
}
}
catch (Exception e)
{
Debug.Print("Exception when querying for user: "******"INSERT INTO user(Firstname, Lastname, Email, Password, createdAt, updatedAt) VALUES('{model.Reg.Firstname}', '{model.Reg.Lastname}', '{model.Reg.Email}', '{hashedPassword}', '{DateTime.Now.ToString()}', '{DateTime.Now.ToString()}')");
try
{
string id = DbConnector.Query($"SELECT iduser FROM user WHERE email = '{model.Reg.Email}'")[0]["iduser"].ToString();
CookieOptions option = new CookieOptions();
option.Expires = DateTime.Now.AddMinutes(60);
Response.Cookies.Append("userCookie", id, option);
}
catch (Exception e)
{
Debug.Print("Exception when baking cookie: " + e.Message);
}
HttpContext.Session.SetString("userEmail", model.Reg.Email);
return(Redirect("Home"));
}
catch (Exception e)
{
Debug.Print("Exception when inserting new user: "******"Index"));
}
