public ActionResult Login(string submit, LoginModel model) { USERS iUser = new USERS(); DataTable dt = iUser.GetUserInfo(model); if (dt.Rows.Count > 0) { if ((model.UserName == dt.Rows[0]["UserName"].ToString()) && (model.Password == dt.Rows[0]["Password"].ToString())) { //model.Id = dt.Rows[0]["UserName"].ToString(); model.UserName = dt.Rows[0]["UserName"].ToString(); model.Password = dt.Rows[0]["Password"].ToString(); SetLoginSessionData(model, false); return RedirectToAction("Index", "Home"); } else { ModelState.AddModelError("UserName", "invalid username or password."); } } else { ModelState.AddModelError("UserName", "invalid username or password."); } return View("Login", model); }
public DataTable GetUserInfo(LoginModel param) { Database db = DatabaseFactory.CreateDatabase(); DbConnection connection = db.CreateConnection(); string sql = "SELECT USERID, UserName, Password, UserType FROM Usersatten.dbo.USERLOGIN WHERE UserName='******' and Password='******' "; DbCommand dbCommand = db.GetSqlStringCommand(sql); dbCommand.Connection = connection; connection.Open(); DataSet ds = db.ExecuteDataSet(dbCommand); //IDataReader ds = db.ExecuteReader(dbCommand); connection.Close(); return ds.Tables[0]; }
protected void SetUserSessionData(LoginModel LoginM) { //CurrentUserName = LoginM.Id + " " + LoginM.Password; CurrentUserPassword = LoginM.Password; CurrentUserName = LoginM.UserName; LoginDatetime = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt"); CurrentUserId = LoginM.USERID; }
protected void SetLoginSessionData(LoginModel LoginM, bool createPersistentCookie) { SetUserSessionData(LoginM); FormsAuthentication.SetAuthCookie("1", createPersistentCookie); Session.Timeout = 1; }
public ActionResult Login(LoginModel model, string returnUrl) { if (ModelState.IsValid && WebSecurity.Login(model.UserName, model.Password, persistCookie: model.RememberMe)) { return RedirectToLocal(returnUrl); } // If we got this far, something failed, redisplay form ModelState.AddModelError("", "The user name or password provided is incorrect."); return View(model); }
public ActionResult Login(LoginModel model) { ModelState.Clear(); return View("Login", model); }