public virtual bool Edit(SysUserModel model) { try { tbl_SysUser entity = m_Rep.GetById(model.UserId); if (entity == null) { return(false); } entity.UserId = model.UserId; entity.UserName = model.UserName; entity.PassWord = model.PassWord; entity.PhoneNumber = model.PhoneNumber; entity.SchoolCard = model.SchoolCard; entity.Sex = model.Sex; entity.DepId = model.DepId; entity.PosId = model.PosId; if (m_Rep.Edit(entity)) { return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public ActionResult Login(string type) { if (type != "logout" && type != "fgpw") { int retcode = -1; string retmesg = ""; LoginModel mdlogin = new LoginModel(); if (Request.Cookies["CUserName"] != null && Request.Cookies["CPassword"] != null) { try { mdlogin.UserName = Request.Cookies["CUserName"].Value; mdlogin.Password = Request.Cookies["CPassword"].Value; mdlogin.Email = ""; tbl_SysUser userinfo = (new SysUserService()).CheckLogin(mdlogin.UserName, mdlogin.Password); if (userinfo != null) { TempData["userinfo"] = userinfo; TempData.Keep("userinfo"); Session[CConfig.SESSION_USERID] = retcode; Session[CConfig.SESSION_USERNAME] = userinfo.UserName; Session[CConfig.SESSION_FULLNAME] = userinfo.FullName; Session[CConfig.SESSION_HOTELCODE] = ""; Session[CConfig.SESSION_HOTELNAME] = ""; Session[CConfig.SESSION_HOTELGROUPCODE] = ""; Session[CConfig.SESSION_PW] = userinfo.Password; return(RedirectToAction("index", "Home")); } else { ViewBag.Mesg = retmesg; return(View()); } } catch (Exception ex) { return(RedirectToAction("Index500", "Error")); } } } return(View()); }
public tbl_SysUser CloneFromView(view_DetailUser obj) { tbl_SysUser objUpdate = new tbl_SysUser(); objUpdate = InitEmpty(); objUpdate.UserName = obj.UserName; //objUpdate.Password = obj.Password; objUpdate.IdentityNumber = obj.IdentityNumber; objUpdate.FullName = obj.FullName; objUpdate.Address = obj.Address; objUpdate.Email = obj.Email; objUpdate.Mobile = obj.Mobile; objUpdate.SysHotelID = obj.SysHotelID; objUpdate.Status = obj.Status; objUpdate.IsActive = obj.IsActive; return(objUpdate); }
public tbl_SysUser InitEmpty() { var objUpdate = new tbl_SysUser(); objUpdate.UserName = ""; objUpdate.Password = ""; objUpdate.IdentityNumber = ""; objUpdate.FullName = ""; objUpdate.Address = ""; objUpdate.Email = ""; objUpdate.Mobile = ""; objUpdate.SysHotelID = 0; objUpdate.Status = 1; objUpdate.IsActive = 1; return(objUpdate); }
public virtual SysUserModel GetById(string id) { if (IsExists(id)) { tbl_SysUser entity = m_Rep.GetById(id); SysUserModel model = new SysUserModel(); model.UserId = entity.UserId; model.UserName = entity.UserName; model.PassWord = entity.PassWord; model.PhoneNumber = entity.PhoneNumber; model.SchoolCard = entity.SchoolCard; model.Sex = entity.Sex; model.DepId = entity.DepId; model.PosId = entity.PosId; return(model); } else { return(null); } }
public ActionResult Login(String command, string chkRememberMe) { int retcode = -1; string retmesg = ""; if (command == "SignInSub") { try { LoginModel mdlogin = new LoginModel(); Response.Cookies["CUserName"].Value = Request.Form["UserName"].ToString().ToUpper().Trim(); Response.Cookies["CPassword"].Value = MD5.md5(Request.Form["Password"].ToString().Trim()).ToString(); mdlogin.UserName = Response.Cookies["CUserName"].Value.ToString().Trim(); mdlogin.Password = Response.Cookies["CPassword"].Value.ToString().Trim(); mdlogin.Email = ""; if (chkRememberMe == "on") //có check remember { Response.Cookies["CUserName"].Expires = DateTime.Now.AddDays(30); Response.Cookies["CPassword"].Expires = DateTime.Now.AddDays(30); } else { Response.Cookies["CUserName"].Expires = DateTime.Now.AddDays(-1); Response.Cookies["CPassword"].Expires = DateTime.Now.AddDays(-1); } tbl_SysUser userinfo = (new SysUserService()).CheckLogin(Request.Form["UserName"].ToString(), Request.Form["Password"].ToString()); if (userinfo != null) { /*Get thông tin user đăng nhập*/ //userinfo = data.AccountGetInfomation(mdlogin, retcode); TempData["userinfo"] = userinfo; TempData.Keep("userinfo"); Session[CConfig.SESSION_USERID] = retcode; Session[CConfig.SESSION_USERNAME] = userinfo.UserName; Session[CConfig.SESSION_FULLNAME] = userinfo.FullName; Session[CConfig.SESSION_HOTELCODE] = userinfo.SysHotelID; Session[CConfig.SESSION_HOTELNAME] = userinfo.SysHotelID.ToString(); Session[CConfig.SESSION_HOTELGROUPCODE] = ""; Session[CConfig.SESSION_PW] = userinfo.Password; Session[CConfig.SESSION_HOTELID] = userinfo.SysHotelID; tbl_GroupType oGroupType = (new SysUserService()).GetGroupTypeByUserID(userinfo.Id, userinfo.SysHotelID.Value); if (oGroupType != null) { Session[CConfig.SESSION_GROUPCODE] = oGroupType.code; } return(RedirectToAction("Index", "Home")); } else { ViewBag.Mesg = retmesg; return(View()); } } catch (Exception ex) { return(RedirectToAction("Index500", "Error")); } } return(View()); }
public int UpdateOrInsertSysUser(view_DetailUser obj) { using (var db = _connectionData.OpenDbConnection()) { //update if (obj.ID > 0) { var query = db.From <tbl_SysUser>().Where(e => e.Id == obj.ID); var objUpdate = db.Select(query).SingleOrDefault(); if (objUpdate != null) { int nx = 0; using (var tran = db.OpenTransaction())//if need { //objUpdate.UserName = obj.UserName; //objUpdate.Password = obj.Password; objUpdate.IdentityNumber = obj.IdentityNumber; objUpdate.FullName = obj.FullName; objUpdate.Address = obj.Address; objUpdate.Email = obj.Email; objUpdate.Mobile = obj.Mobile; objUpdate.SysHotelID = obj.SysHotelID; objUpdate.Status = obj.Status; objUpdate.IsActive = obj.IsActive; //objUpdate.FirstLogin = obj.FirstLogin; //objUpdate.Createby =comm.GetUserId(); //objUpdate.CreateDate =DateTime.Now; objUpdate.Modifyby = comm.GetUserId(); nx = db.Update(objUpdate); //delete for update var query1 = db.From <tbl_SysUsers_GroupType_Hotel>().Where(e => e.hotelid == obj.SysHotelID && e.userid == obj.ID); var objUpdate1 = db.Delete(query1); //insert again var rightForHotel = new tbl_SysUsers_GroupType_Hotel(); rightForHotel.hotelid = objUpdate.SysHotelID; rightForHotel.grouptypeid = obj.grouptypeid; rightForHotel.userid = objUpdate.Id; db.Insert(rightForHotel); tran.Commit(); } return(nx); } return(-1); } //insert else { var queryCount = db.From <tbl_SysUser>().Where(e => e.UserName == obj.UserName && e.SysHotelID == comm.GetHotelId()).Select(e => e.Id); var objCount = db.Count(queryCount); if (objCount > 0) { return(comm.ERROR_EXIST); } int nx = 0; using (var tran = db.OpenTransaction())//if need { tbl_SysUser obj1 = CloneFromView(obj); obj1.Password = MD5.md5(obj.Password); obj1.FirstLogin = obj.FirstLogin; obj1.Createby = comm.GetUserId(); obj1.CreateDate = DateTime.Now; obj1.Department = 0; nx = (int)db.Insert(obj1, selectIdentity: true); var query1 = db.From <tbl_SysUsers_GroupType_Hotel>().Where(e => e.grouptypeid == obj.grouptypeid && e.hotelid == obj.SysHotelID && e.userid == nx); var objUpdate1 = db.Select(query1).SingleOrDefault(); if (objUpdate1 == null) { var rightForHotel = new tbl_SysUsers_GroupType_Hotel(); rightForHotel.hotelid = obj.SysHotelID; rightForHotel.grouptypeid = obj.grouptypeid; rightForHotel.userid = nx; db.Insert(rightForHotel); } tran.Commit(); } return(nx); } } }