//Check User Cridentils is vallid or not public DataTable CheckLoginCridentials(AccountModel account) { AddParameter("@username", account.UserName); AddParameter("@password", account.Password); AddParameter("@ipaddress", Utilities.GetIP()); return this.GetDataTable("[usp_CheckLoginCridentials]"); }
public ActionResult LogOff() { AccountModel account = new AccountModel(); HttpCookie useCookie = HttpContext.Request.Cookies["myCookie"]; account.UserName = useCookie.Values["UserName"]; accountDAL = new AccountDAL(); if (String.Compare(accountDAL.LogOff(account).ToString(), "SUCCESS") == 0) { Session.RemoveAll(); Response.Cookies.Clear(); useCookie.Expires = DateTime.Now.AddDays(-1d); Response.Cookies.Add(useCookie); FormsAuthentication.SignOut(); } Session["LogOut"] = true; return RedirectToAction("LogOn", "Account"); }
public ActionResult LogOn() { var logOn = new AccountModel(); var valid = TryUpdateModel(logOn); if (valid) { accountModel = new AccountModel(); accountModel.UserName = logOn.UserName; accountModel.Password = logOn.Password; //accountModel.RememberMe = logon.RememberMe; accountDAL = new AccountDAL(); DataTable userdetails = accountDAL.CheckLoginCridentials(accountModel); if (userdetails.Rows.Count > 0) { String LoginStatus; if (!String.IsNullOrEmpty(userdetails.Rows[0]["LoginStatus"].ToString()) == true) { LoginStatus = userdetails.Rows[0]["LoginStatus"].ToString(); if (LoginStatus == "A") { if (!String.IsNullOrEmpty(userdetails.Rows[0]["RoleID"].ToString())) { String roleid = userdetails.Rows[0]["RoleID"].ToString(); FormsAuthentication.SetAuthCookie(logOn.UserName, false); //FormsAuthenticationTicket FrmAutTicket = new FormsAuthenticationTicket(1, model.UserName, DateTime.Now, DateTime.Now.AddMinutes(3600), false, roleid); //HttpCookie Cookie = new HttpCookie(FormsAuthentication.FormsCookieName, FormsAuthentication.Encrypt(FrmAutTicket)); //Response.Cookies.Add(Cookie); HttpCookie myCookie = new HttpCookie("myCookie"); myCookie.Values.Add("UserName", logOn.UserName); myCookie.Values.Add("FirstName", userdetails.Rows[0]["FirstName"].ToString()); myCookie.Values.Add("RoleID", roleid); myCookie.Values.Add("CommunityID", userdetails.Rows[0]["CommunityID"].ToString()); myCookie.Values.Add("CommunityName", userdetails.Rows[0]["CommunityName"].ToString()); myCookie.Values.Add("UserID", userdetails.Rows[0]["UserID"].ToString()); myCookie.Values.Add("CommunityMenuOptions", userdetails.Rows[0]["CommunityMenuOptions"].ToString()); myCookie.HttpOnly = true; Response.Cookies.Add(myCookie); String RedirectURL = null; switch (roleid) { case "1": RedirectURL = "SuperAdministrator"; break; case "2": RedirectURL = "Administrator"; break; case "3": RedirectURL = "SecurityManager"; break; case "4": RedirectURL = "SecurityPersonnel"; break; case "5": RedirectURL = "HomeOwner"; break; case "6": RedirectURL = "ServiceProvider"; break; } return Json(new { result = true, redirecturl = RedirectURL }); } } else if (LoginStatus == "P") { ModelState.AddModelError("P1", "You already login from some other ipaddress." + '\n' + "Wait for " + userdetails.Rows[0]["MinutesToWait"].ToString() + " minutes"); String[] lostLoginDetails = userdetails.Rows[0]["LastLogin"].ToString().Split(' '); ModelState.AddModelError("P2", "Your last login on " + lostLoginDetails[0] + " @ " + lostLoginDetails[1]); } else if (LoginStatus == "FP") { ModelState.AddModelError("FP", "Requested for Password Change, Link has been sent to your email."); } else if (LoginStatus == "MM") { ModelState.AddModelError("MM", "Username, Password mismatch"); } else if (LoginStatus == "NF") { ModelState.AddModelError("NF", "The username is not registered."); } } else { ModelState.AddModelError("problem", "Problem with website, Please Try after some time."); } } else { ModelState.AddModelError("NR", "User not registered yet."); } } else { ModelState.AddModelError("error", "Model Errors."); } // return Json(new { result = ModelState.IsValid, errors = GetErrorsFromModelState() }); return Json(new { result = false, errors = GetErrorsFromModelState(), errorPartial = RenderPartialViewToString("_LogOn", logOn) }); }
internal DataTable UserNameCheck(AccountModel model) { AddParameter("@username", model.UserName); return this.GetDataTable("[usp_UserNameCheck]"); }
public object LogOff(AccountModel account) { AddParameter("@username", account.UserName); return this.ExecuteScalar("[usp_LogOff]"); }
public object ForgotPassword(AccountModel account) { AddParameter("@username", account.UserName); return this.ExecuteScalar("[usp_ForgotPasswordRequest]"); }