public ActionResult DeleteConfirmed(int id)
{
SUserRole sUserRole = db.SUserRoles.Find(id);
db.SUserRoles.Remove(sUserRole);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Account,RoleId")] SUserRole sUserRole)
{
if (ModelState.IsValid)
{
db.Entry(sUserRole).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sUserRole));
}
/// <summary>
/// 添加用户角色关系
/// </summary>
/// <param name="roleId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public int AddUserRole(int roleId, int userId)
{
SUserRole ur = new SUserRole()
{
RoleID = roleId,
UserID = userId
};
dbContext.Connection.Insert(ur);
return(ur.ID);
}
public ActionResult Create([Bind(Include = "Id,Account,RoleId")] SUserRole sUserRole)
{
if (ModelState.IsValid)
{
db.SUserRoles.Add(sUserRole);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sUserRole));
}
// GET: SUserRoles/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SUserRole sUserRole = db.SUserRoles.Find(id);
if (sUserRole == null)
{
return(HttpNotFound());
}
return(View(sUserRole));
}
public ResponseBase InsertOrUpdate(UserModel model)
{
ResponseBase result = null;
try
{
using (var db = new IEDEntities())
{
result = new ResponseBase();
SUser obj = null;
SUserRole userRoleObj = null;
if (CheckName(model.UserName, model.Id, db))
{
result.IsSuccess = false;
result.Errors.Add(new Error()
{
Message = "Tên đăng nhập đã tồn tại. Vui lòng chọn lại tên khác!", MemberName = "Thêm Mới"
});
}
else
{
if (model.Id == 0)
{
#region add user
obj = new SUser();
Parse.CopyObject(model, ref obj);
if (!string.IsNullOrEmpty(model.ImagePath))
{
obj.ImagePath = model.ImagePath != "0" ? model.ImagePath.Split(',').ToList().First() : null;
}
obj.IsLock = false;
obj.IsRequireChangePW = true;
obj.NoteForgotPassword = null;
obj.PassWord = GlobalFunction.EncryptMD5(model.PassWord);
obj.CreatedUser = model.ActionUser;
obj.CreatedDate = DateTime.Now;
obj.CompanyId = model.CompanyId;
obj.SUserRoles = new Collection <SUserRole>();
obj.WorkshopIds = model.WorkshopIds;
if (model.NoteForgotPassword != null)
{
foreach (var item in model.NoteForgotPassword.Split(',').ToList())
{
userRoleObj = new SUserRole();
userRoleObj.RoleId = int.Parse(item);
userRoleObj.CreatedDate = obj.CreatedDate;
userRoleObj.CreatedUser = obj.CreatedUser;
userRoleObj.SUser = obj;
obj.SUserRoles.Add(userRoleObj);
}
}
db.SUsers.Add(obj);
#endregion
}
else
{
obj = db.SUsers.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
#region update user detail
if (!string.IsNullOrEmpty(model.PassWord))
{
obj.PassWord = obj.IsRequireChangePW ? GlobalFunction.EncryptMD5(model.PassWord) : obj.PassWord;
}
obj.FisrtName = model.FisrtName;
obj.LastName = model.LastName;
obj.NoteForgotPassword = null;
if (model.ImagePath != null && model.ImagePath != "0")
{
obj.ImagePath = model.ImagePath.Split(',').ToList().First();
}
obj.Email = model.Email;
obj.UpdatedUser = model.ActionUser;
obj.WorkshopIds = model.WorkshopIds;
obj.UpdatedDate = DateTime.Now;
#endregion
var oldRoles = db.SUserRoles.Where(x => !x.IsDeleted && x.UserId == model.Id);
SUserRole userRole;
if (model.NoteForgotPassword != null)
{
model.UserRoleIds = model.NoteForgotPassword.Split(',').Select(x => Convert.ToInt32(x)).ToList();
#region sử lý nếu list user role new != null
if (oldRoles != null && oldRoles.Count() > 0)
{
string query = "";
foreach (var oldItem in oldRoles)
{
//var userRoleFind = model.UserRoleIds.Find(x => x == oldItem.Id);
//if (userRoleFind == 0)
//{
// oldItem.IsDeleted = true;
// oldItem.DeletedUser = obj.UpdatedUser;
// oldItem.DeletedDate = obj.UpdatedDate;
//}
//else
// model.UserRoleIds.Remove(userRoleFind);
query += " update SUserRole set IsDeleted=1 where Id=" + oldItem.Id;
}
if (!string.IsNullOrEmpty(query))
{
db.Database.ExecuteSqlCommand(query);
}
if (model.UserRoleIds != null && model.UserRoleIds.Count > 0)
{
foreach (var item in model.UserRoleIds)
{
userRoleObj = new SUserRole();
userRoleObj.RoleId = item;
userRoleObj.CreatedDate = DateTime.Now;
userRoleObj.CreatedUser = model.ActionUser;
userRoleObj.UserId = model.Id;
obj.SUserRoles.Add(userRoleObj);
}
}
}
else
{
foreach (var item in model.NoteForgotPassword.Split(',').Select(x => Convert.ToInt32(x)).ToList())
{
userRoleObj = new SUserRole();
userRoleObj.RoleId = item;
userRoleObj.CreatedDate = DateTime.Now;
userRoleObj.CreatedUser = model.ActionUser;
userRoleObj.UserId = model.Id;
obj.SUserRoles.Add(userRoleObj);
}
}
#endregion
}
else
{
#region sử lý nếu list user role new is null
foreach (var oldItem in oldRoles)
{
oldItem.IsDeleted = true;
oldItem.DeletedUser = obj.UpdatedUser;
oldItem.DeletedDate = obj.UpdatedDate;
}
#endregion
}
}
else
{
result.IsSuccess = false;
result.Errors.Add(new Error()
{
MemberName = "Update Account", Message = "Tài Khoản đang thao tác không tồn tại. Vui lòng kiểm tra lại!"
});
}
}
db.SaveChanges();
result.IsSuccess = true;
}
}
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
