public ActionResult LoginDB(UserView uv)
{
using (var ctx = new ArtGalleryEntities()) {
string pwcv = Encrypt(uv.PasswordU);
if (Session["IDU"] == null)
{
var checkus = ctx.Users.Where(a => a.UsernameU.Equals(uv.UsernameU)).FirstOrDefault();
if (checkus != null)
{
var obj = ctx.Users.Where(a => a.UsernameU.Equals(uv.UsernameU) && a.PasswordU.Equals(pwcv)).FirstOrDefault();
if (obj != null)
{
var ut = ctx.Usertypes.Where(t => t.IDUT == obj.IDUT).Select(t => t.NameUT).FirstOrDefault().ToString();
var sta = obj.StatusU == true ? "Unlock" : "Lock";
if (sta == "Unlock")
{
if (ut == "Admin")
{
Session["IDU"] = obj.IDU;
Session["UsernameU"] = obj.UsernameU;
Session["Usertype"] = ctx.Usertypes.Where(utt => utt.IDUT == obj.IDUT).Select(utt => utt.NameUT).FirstOrDefault();
//TempData["Alert"] = "Welcome admin!";
return(RedirectToAction("AdminHomePage", "Admin"));
}
else
{
Session["IDU"] = obj.IDU;
Session["UsernameU"] = obj.UsernameU;
Session["Usertype"] = ctx.Usertypes.Where(utt => utt.IDUT == obj.IDUT).Select(utt => utt.NameUT).FirstOrDefault();
//TempData["Alert"] = "Have a nice day!";
return(RedirectToAction("Index", "Home"));
}
}
else
{
TempData["Alert"] = "Your account has been locked!";
return(RedirectToAction("Login", "Login"));
}
}
else
{
TempData["Alert"] = "Your password is wrong!";
return(RedirectToAction("Login", "Login"));
}
}
else
{
TempData["Alert"] = "Your account not exist!";
return(RedirectToAction("Login", "Login"));
}
}
else
{
TempData["Alert"] = "Please log out to be able to log in with another account!";
return(RedirectToAction("Index", "Home"));
}
}
}
public ActionResult Authorize(P_Art.Models.Credential user)
{
using (ArtGalleryEntities db = new ArtGalleryEntities())
{
var userdetails = db.Credentials.Where(x => x.UserID == user.UserID && x.Password == user.Password).Count();
if (userdetails > 0)
{
FormsAuthentication.RedirectFromLoginPage(user.UserID.ToString(), true);
return(RedirectToAction("Index"));
}
else
{
user.Loginerrormessage = "Wrong UserName or Password";
return(View("Login", user));
}
}
}
protected void Application_EndRequest()
{
ArtGalleryEntities context = (ArtGalleryEntities)HttpContext.Current.Items[ExhibitionController.REQUEST_STORAGE_DBCONTEXT];
context.Dispose();
}
protected void Application_BeginRequest()
{
ArtGalleryEntities context = new ArtGalleryEntities();
HttpContext.Current.Items.Add(ExhibitionController.REQUEST_STORAGE_DBCONTEXT, context);
}
