public ActionResult AddAccessGroupChild(List <tblAccessGroupChild> lst)
{
try
{
var msg = "";
tblAccessGroupChild groupId = new tblAccessGroupChild();
tblAccessGroupChild grpchild = new tblAccessGroupChild();
foreach (var item in lst)
{
if (item.group_Id != null)
{
groupId.group_Id = item.group_Id;
break;
}
}
scheModel.tblAccessGroupChilds.RemoveRange(scheModel.tblAccessGroupChilds.Where(c => c.group_Id == groupId.group_Id));
scheModel.SaveChanges();
foreach (var itemlist in lst)
{
if (itemlist.group_Id == null)
{
grpchild.group_Id = groupId.group_Id;
grpchild.menu_Id = itemlist.menu_Id;
grpchild.access_Create = itemlist.access_Create;
grpchild.access_Modify = itemlist.access_Modify;
grpchild.access_Delete = itemlist.access_Delete;
grpchild.access_View = itemlist.access_View;
grpchild.access_Review = itemlist.access_Review;
grpchild.access_Approve = itemlist.access_Approve;
scheModel.tblAccessGroupChilds.Add(grpchild);
scheModel.SaveChanges();
}
}
msg = "Add";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
catch (Exception e) { throw; }
}
public List <tblAccessGroupChild> grpchildList()
{
var EmployeeId = ((tblEmployee)(Session["EmployeeData"])).Employee_Id;
var AccessGroupChildDetail = scheModel.tblEmployees
.Join(
scheModel.tblAccessGroupChilds,
E => E.group_Id,
GC => GC.group_Id,
(E, GC) => new { E, GC })
.Join(
scheModel.tblAccessMenuMasters,
GCC => GCC.GC.menu_Id,
MM => MM.menu_Id,
(GCC, MM) => new
{
EmployeeID = GCC.E.Employee_Id,
MenuId = MM.menu_Id,
MenuName = MM.menu_Name,
AccessCreate = GCC.GC.access_Create,
AccessModify = GCC.GC.access_Modify,
AccessDelete = GCC.GC.access_Delete,
AccessView = GCC.GC.access_View,
}).Where(x => (x.AccessCreate == "True" || x.AccessModify == "True" || x.AccessDelete == "True" || x.AccessView == "True") && x.EmployeeID == EmployeeId).ToList();
List <tblAccessGroupChild> grpChildAccessList = new List <tblAccessGroupChild>();
foreach (var item in AccessGroupChildDetail)
{
tblAccessGroupChild grpchild = new tblAccessGroupChild();
grpchild.menu_Id = item.MenuId;
grpchild.access_Create = item.AccessCreate;
grpchild.access_Modify = item.AccessModify;
grpchild.access_Delete = item.AccessDelete;
grpchild.access_View = item.AccessView;
grpChildAccessList.Add(grpchild);
}
return(grpChildAccessList);
}
