public JsonResult SaveAccess(string IdRole, string Ids_selected)
{
List <AccessModels> list_am = db.Access.Where(x => x.RoleId == IdRole).ToList();
if (list_am.Count > 0)
{
foreach (var am in list_am)
{
db.Access.Remove(am);
}
}
db.SaveChanges();
if (!string.IsNullOrEmpty(Ids_selected))
{
string[] ids = Ids_selected.Split(',');
if (ids.Length > 0)
{
foreach (string id in ids)
{
AccessModels am = new AccessModels
{
Id = Guid.NewGuid(),
RoleId = IdRole,
WebMenuAccess = id.ToLower()
};
db.Access.Add(am);
}
}
db.SaveChanges();
}
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
public List <AccessModels> GetAccessAll()
{
HomeController hc = new HomeController();
List <AccessModels> ul = new List <AccessModels>();
using (SqlConnection con = hc.ConnectDatabaseAuth())
{
string _SQL = "select * from [access]";
using (SqlCommand cmd = new SqlCommand(_SQL, con))
{
DataTable _Dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(_Dt);
da.Dispose();
foreach (DataRow _Item in _Dt.Rows)
{
AccessModels m = new AccessModels();
m.access_id = _Item["access_id"].ToString();
m.access_name = _Item["access_name"].ToString();
ul.Add(m);
}
}
con.Close();
}
return(ul);
}
public JsonResult DisableMenu(string WebMenuAccess, Guid IdRole)
{
var data = (from a in db.Access
where a.WebMenuAccess == WebMenuAccess && a.UserAccountRoles_Id == IdRole
select a).Single();
AccessModels am = data;
db.Access.Remove(am);
db.SaveChanges();
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
public JsonResult EnableMenu(string WebMenuAccess, Guid IdRole)
{
AccessModels am = new AccessModels();
am.Id = Guid.NewGuid();
am.UserAccountRoles_Id = IdRole;
am.UserAccountAccess_EnumId = 0;
am.WebMenuAccess = WebMenuAccess;
db.Access.Add(am);
db.SaveChanges();
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
public JsonResult SingleAccess(string WebMenuAccess, string IdRole, string Action)
{
if (Action.ToLower() == "enable")
{
AccessModels am = new AccessModels
{
Id = Guid.NewGuid(),
RoleId = IdRole,
WebMenuAccess = WebMenuAccess.ToLower()
};
db.Access.Add(am);
}
else
{
AccessModels am = db.Access.Where(x => x.RoleId == IdRole && x.WebMenuAccess == WebMenuAccess).FirstOrDefault();
db.Access.Remove(am);
}
db.SaveChanges();
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
public JsonResult BulkAccess(string IdRole, string ParentMenu, string Action)
{
var menus = (ParentMenu.ToLower() == "all") ? db.MasterMenu.ToList()
: db.MasterMenu.Where(x => x.ParentMenu == ParentMenu).ToList();
if (Action.ToLower() == "enable")
{
foreach (var menu in menus)
{
var access_role = db.Access.AsNoTracking().Where(x => x.RoleId == IdRole && x.WebMenuAccess == menu.WebMenuAccess).FirstOrDefault();
if (access_role == null)
{
AccessModels am = new AccessModels
{
Id = Guid.NewGuid(),
RoleId = IdRole,
WebMenuAccess = menu.WebMenuAccess
};
db.Access.Add(am);
}
}
}
else
{
foreach (var menu in menus)
{
AccessModels am = db.Access.Where(x => x.RoleId == IdRole && x.WebMenuAccess == menu.WebMenuAccess).FirstOrDefault();
if (am != null)
{
db.Access.Remove(am);
}
}
}
db.SaveChanges();
return(Json(new { status = "200" }, JsonRequestBehavior.AllowGet));
}
