public Custom_UserDTO GetByUserID(int usrID) { empRep.AddInputParameters("@usrID", usrID); DataTable dt = empRep.GetList("sp_Employee_GetByUserID", CommandType.StoredProcedure); Custom_UserDTO employee = new Custom_UserDTO(); employee.usrID = Convert.ToInt32(dt.Rows[0]["usrID"]); employee.empID = Convert.ToInt32(dt.Rows[0]["empID"]); employee.empName = dt.Rows[0]["empName"].ToString(); employee.empSurname = dt.Rows[0]["empSurname"].ToString(); employee.empMiddleName = dt.Rows[0]["empMiddleName"].ToString(); employee.empMail = dt.Rows[0]["empMail"].ToString(); employee.usrName = dt.Rows[0]["usrName"].ToString(); employee.usrPassword = dt.Rows[0]["usrPassword"].ToString(); employee.positionTitle = dt.Rows[0]["positionTitle"].ToString(); return(employee); }
public Custom_UserDTO CheckUser(UserDTO entity) { userRep.AddInputParameters("@usrName", entity.usrName); userRep.AddInputParameters("@usrPassword", entity.usrPassword); DataTable dt = userRep.GetList("sp_User_Check", CommandType.StoredProcedure); Custom_UserDTO userInfo = new Custom_UserDTO(); if (dt.Rows.Count > 0) { userInfo.usrID = Convert.ToInt32(dt.Rows[0]["usrID"]); userInfo.usrName = dt.Rows[0]["usrName"].ToString(); userInfo.empName = dt.Rows[0]["empName"].ToString(); userInfo.empSurname = dt.Rows[0]["empSurname"].ToString(); return(userInfo); } else { return(null); } }
public ActionResult Index(UserDTO entity) { if (ModelState.IsValid) { LoginService logServ = new LoginService(); Custom_UserDTO user = logServ.CheckUser(entity); if (user != null) { FormsAuthentication.SetAuthCookie(user.usrName, false); Session["userName"] = user.usrName; Session["userID"] = user.usrID; Session["userFullName"] = user.empName + " " + user.empSurname; return(RedirectToAction("Index", "Document")); } else { ModelState.AddModelError(string.Empty, "İstifadəçi mövcud deyil."); } } return(View("Index")); }