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);
}
}
}
