public ActionResult RoleDelete(int id)
{
Session_CRM sess = (Session_CRM)Session["CRM_Session"];
string msg = "";
try
{
AT_Role role = db.AT_Role.Where(x => x.RoleID == id).FirstOrDefault();
if (role != null)
{
if (db.AT_Users.Where(x => x.RoleID == role.RoleID && x.IsDeleted != true).Count() > 0)
{
return(Json("Conflict"));
}
//role.RoleID = id;
//role.IsDeleted = true;
//role.UpdateBy = sess.User.UserID;
//role.UpdateDate = DateTime.Now;
//db.AT_Role.Attach(role);
db.AT_RolePermissionJunc.RemoveRange(db.AT_RolePermissionJunc.Where(x => x.RoleID == role.RoleID));
db.AT_Role.Remove(role);
db.SaveChanges();
msg = "Role deleted successfully!";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
ViewBag.msg = msg;
return(PartialView("_RoleIndex", db.AT_Role.Where(x => x.IsDeleted != true).ToList()));
}
public ActionResult _RoleSave(AT_Role role)
{
Session_CRM sess = (Session_CRM)Session["CRM_Session"];
string msg = "";
try
{
if (role.RoleID > 0)
{
if (role.IsActive != true)
{
if (db.AT_Users.Where(x => x.RoleID == role.RoleID && x.IsDeleted != true).Count() > 0)
{
return(Json("Conflict"));
}
}
role.UpdateBy = sess.User.UserID;
role.UpdateDate = DateTime.Now;
db.AT_Role.Attach(role);
db.UpdateExcept <AT_Role>(role, x => x.CreateBy, x => x.CreateDate);
}
else
{
role.CreateBy = sess.User.UserID;
role.CreateDate = DateTime.Now;
db.Entry(role).State = System.Data.Entity.EntityState.Added;
}
db.SaveChanges();
msg = "Role saved successfully!";
}
catch (Exception ex)
{
if (ex.InnerException != null && ex.InnerException.ToString().Contains("UNIQUE"))
{
msg = "Conflict";
}
else
{
msg = ex.Message;
}
}
ViewBag.msg = msg;
return(PartialView("_RoleIndex", db.AT_Role.Where(x => x.IsDeleted != true).ToList()));
}
