public PartialViewResult Edit(string id)
{
view_DetailUser obj = (new SysUserService()).GetViewUserByID(id);
if (obj == null)
{
obj = new view_DetailUser()
{
IsActive = 1
}
}
;
return(PartialView("EditUser", obj));
}
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 ActionResult Update(view_DetailUser obj)
{
int result = (new SysUserService()).UpdateOrInsertSysUser(obj);
return(Json(new { result = result }, JsonRequestBehavior.AllowGet));
}
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);
}
}
}
