public static List <secRoleModuleGet> getRolePermission(int roleID)
{
List <secRoleModuleGet> resRoleModule = new List <secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from sm in DbContextHelper.DbContext.SecModule
join srm in DbContextHelper.DbContext.SecRoleModule
on new { sm.ModuleId, RoleID = roleID, SecroleModStatus = 1 }
equals new { ModuleId = (Int32)srm.ModuleID, srm.RoleID, SecroleModStatus = (Int32)srm.Status }
//where sm.Status == true
//
select new {
ModuleId = (Int32?)sm.ModuleId,
sm.ModuleName,
sm.ModuleDesc,
sm.ParentId,
sm.Url,
sm.ModuleType,
SecModuleStatus = sm.Status,
RoleModuleId = (Int32?)srm.RoleModuleId,
RoleID = (Int32?)srm.RoleID,
ViewPermission = (Boolean?)srm.ViewPermission,
AddPermssion = (Boolean?)srm.AddPermssion,
EditPermission = (Boolean?)srm.EditPermission,
DeletePermission = (Boolean?)srm.DeletePermission,
SecRoleModStatus = (Int32?)srm.Status
};
foreach (var get in resList)
{
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = (Boolean?)get.ViewPermission;
objsecRoleModuleGet.AddPermssion = (Boolean?)get.AddPermssion;
objsecRoleModuleGet.EditPermission = (Boolean?)get.EditPermission;
objsecRoleModuleGet.DeletePermission = (Boolean?)get.DeletePermission;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
resRoleModule.Add(objsecRoleModuleGet);
}
return(resRoleModule);
}
/// <summary>
/// This is used to prime database
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public static List<secRoleModuleGet> primeRoleModule(int roleID)
{
List<secRoleModuleGet> resRoleModule = new List<secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from secmodule in DbContextHelper.DbContext.SecModule
//join secrolemodule in DbContextHelper.DbContext.SecRoleModules
// on new { secmodule.ModuleId, RoleID = roleID, SecroleModStatus = 1 }
// equals new { ModuleId = (Int32)secrolemodule.ModuleID, secrolemodule.RoleID, SecroleModStatus = (Int32)secrolemodule.Status } into secrolemodule_join
//from secrolemodule in secrolemodule_join.DefaultIfEmpty()
where secmodule.Status == true
select new {
ModuleId = (Int32?)secmodule.ModuleId,
secmodule.ModuleName,
secmodule.ModuleDesc,
secmodule.ParentId,
secmodule.Url,
secmodule.ModuleType,
SecModuleStatus = secmodule.Status,
//RoleModuleId = (Int32?)secrolemodule.RoleModuleId,
RoleID = roleID,
ViewPermission = false,
AddPermssion = false,
EditPermission = false,
DeletePermission = false,
SecRoleModStatus = 1, //(Int32?)secrolemodule.Status,
/*added by asutosh*/
HasNew = false,
HasEdit = false,
HasDelete = false,
SortOrder = secmodule.SortOrder,
};
foreach (var get in resList) {
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
//objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = get.ViewPermission;
objsecRoleModuleGet.AddPermssion = get.AddPermssion;
objsecRoleModuleGet.EditPermission = get.EditPermission;
objsecRoleModuleGet.DeletePermission = get.DeletePermission;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
objsecRoleModuleGet.HasNew = get.HasNew;
objsecRoleModuleGet.HasEdit = get.HasEdit;
objsecRoleModuleGet.HasDelete = get.HasDelete;
objsecRoleModuleGet.SortOrder = get.SortOrder ?? 0;
//objsecRoleModuleGet.ClientID = get.ClientID ?? 0;
resRoleModule.Add(objsecRoleModuleGet);
}
return resRoleModule;
//return resList.ToList();
}
public static List<secRoleModuleGet> getRolePermission(int roleID)
{
List<secRoleModuleGet> resRoleModule = new List<secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from sm in DbContextHelper.DbContext.SecModule
join srm in DbContextHelper.DbContext.SecRoleModule
on new { sm.ModuleId, RoleID = roleID, SecroleModStatus = 1 }
equals new { ModuleId = (Int32)srm.ModuleID, srm.RoleID, SecroleModStatus = (Int32)srm.Status }
//where sm.Status == true
//
select new {
ModuleId = (Int32?)sm.ModuleId,
sm.ModuleName,
sm.ModuleDesc,
sm.ParentId,
sm.Url,
sm.ModuleType,
SecModuleStatus = sm.Status,
RoleModuleId = (Int32?)srm.RoleModuleId,
RoleID = (Int32?)srm.RoleID,
ViewPermission = (Boolean?)srm.ViewPermission,
AddPermssion = (Boolean?)srm.AddPermssion,
EditPermission = (Boolean?)srm.EditPermission,
DeletePermission = (Boolean?)srm.DeletePermission,
SecRoleModStatus = (Int32?)srm.Status
};
foreach (var get in resList) {
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = (Boolean?)get.ViewPermission;
objsecRoleModuleGet.AddPermssion = (Boolean?)get.AddPermssion;
objsecRoleModuleGet.EditPermission = (Boolean?)get.EditPermission;
objsecRoleModuleGet.DeletePermission = (Boolean?)get.DeletePermission;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
resRoleModule.Add(objsecRoleModuleGet);
}
return resRoleModule;
}
public static List<secRoleModuleGet> getRoleModule(int clientID, int roleID)
{
List<secRoleModuleGet> resRoleModule = new List<secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from secmodule in DbContextHelper.DbContext.SecModule
join secrolemodule in DbContextHelper.DbContext.SecRoleModule
on new {
secmodule.ModuleId,
RoleID = roleID,
SecroleModStatus = 1,
ClientID = (int)clientID
}
equals new {
ModuleId = (Int32)secrolemodule.ModuleID,
secrolemodule.RoleID,
SecroleModStatus = (Int32)secrolemodule.Status,
ClientID = (int)secrolemodule.ClientID
} into secrolemodule_join
from secrolemodule in secrolemodule_join.DefaultIfEmpty()
where secmodule.Status == true && secmodule.IsSystem == false
select new {
ModuleId = (Int32?)secmodule.ModuleId,
secmodule.ModuleName,
secmodule.ModuleDesc,
secmodule.ParentId,
secmodule.Url,
secmodule.ModuleType,
SecModuleStatus = secmodule.Status,
RoleModuleId = (Int32?)secrolemodule.RoleModuleId,
RoleID = (Int32?)secrolemodule.RoleID,
ViewPermission = (Boolean?)secrolemodule.ViewPermission,
AddPermssion = (Boolean?)secrolemodule.AddPermssion,
EditPermission = (Boolean?)secrolemodule.EditPermission,
DeletePermission = (Boolean?)secrolemodule.DeletePermission,
SecRoleModStatus = (Int32?)secrolemodule.Status,
/*added by asutosh*/
HasNew = (Boolean?)secmodule.HasNew,
HasEdit = (Boolean?)secmodule.HasEdit,
HasDelete = (Boolean?)secmodule.HasDelete,
SortOrder = secmodule.SortOrder,
ClientID = secrolemodule.ClientID
};
foreach (var get in resList) {
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = get.ViewPermission ?? false;
objsecRoleModuleGet.AddPermssion = get.AddPermssion ?? false;
objsecRoleModuleGet.EditPermission = get.EditPermission ?? false;
objsecRoleModuleGet.DeletePermission = get.DeletePermission ?? false;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
objsecRoleModuleGet.HasNew = get.HasNew ?? false;
objsecRoleModuleGet.HasEdit = get.HasEdit ?? false;
objsecRoleModuleGet.HasDelete = get.HasDelete ?? false;
objsecRoleModuleGet.SortOrder = get.SortOrder ?? 0;
objsecRoleModuleGet.ClientID = get.ClientID ?? 0;
resRoleModule.Add(objsecRoleModuleGet);
}
return resRoleModule;
//return resList.ToList();
}
/// <summary>
/// This is used to prime database
/// </summary>
/// <param name="roleID"></param>
/// <returns></returns>
public static List <secRoleModuleGet> primeRoleModule(int roleID)
{
List <secRoleModuleGet> resRoleModule = new List <secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from secmodule in DbContextHelper.DbContext.SecModule
//join secrolemodule in DbContextHelper.DbContext.SecRoleModules
// on new { secmodule.ModuleId, RoleID = roleID, SecroleModStatus = 1 }
// equals new { ModuleId = (Int32)secrolemodule.ModuleID, secrolemodule.RoleID, SecroleModStatus = (Int32)secrolemodule.Status } into secrolemodule_join
//from secrolemodule in secrolemodule_join.DefaultIfEmpty()
where secmodule.Status == true
select new {
ModuleId = (Int32?)secmodule.ModuleId,
secmodule.ModuleName,
secmodule.ModuleDesc,
secmodule.ParentId,
secmodule.Url,
secmodule.ModuleType,
SecModuleStatus = secmodule.Status,
//RoleModuleId = (Int32?)secrolemodule.RoleModuleId,
RoleID = roleID,
ViewPermission = false,
AddPermssion = false,
EditPermission = false,
DeletePermission = false,
SecRoleModStatus = 1, //(Int32?)secrolemodule.Status,
/*added by asutosh*/
HasNew = false,
HasEdit = false,
HasDelete = false,
SortOrder = secmodule.SortOrder,
};
foreach (var get in resList)
{
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
//objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = get.ViewPermission;
objsecRoleModuleGet.AddPermssion = get.AddPermssion;
objsecRoleModuleGet.EditPermission = get.EditPermission;
objsecRoleModuleGet.DeletePermission = get.DeletePermission;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
objsecRoleModuleGet.HasNew = get.HasNew;
objsecRoleModuleGet.HasEdit = get.HasEdit;
objsecRoleModuleGet.HasDelete = get.HasDelete;
objsecRoleModuleGet.SortOrder = get.SortOrder ?? 0;
//objsecRoleModuleGet.ClientID = get.ClientID ?? 0;
resRoleModule.Add(objsecRoleModuleGet);
}
return(resRoleModule);
//return resList.ToList();
}
public static List <secRoleModuleGet> getRoleModule(int clientID, int roleID)
{
List <secRoleModuleGet> resRoleModule = new List <secRoleModuleGet>();
secRoleModuleGet objsecRoleModuleGet = null;
var resList = from secmodule in DbContextHelper.DbContext.SecModule
join secrolemodule in DbContextHelper.DbContext.SecRoleModule
on new {
secmodule.ModuleId,
RoleID = roleID,
SecroleModStatus = 1,
ClientID = (int)clientID
}
equals new {
ModuleId = (Int32)secrolemodule.ModuleID,
secrolemodule.RoleID,
SecroleModStatus = (Int32)secrolemodule.Status,
ClientID = (int)secrolemodule.ClientID
} into secrolemodule_join
from secrolemodule in secrolemodule_join.DefaultIfEmpty()
where secmodule.Status == true && secmodule.IsSystem == false
select new {
ModuleId = (Int32?)secmodule.ModuleId,
secmodule.ModuleName,
secmodule.ModuleDesc,
secmodule.ParentId,
secmodule.Url,
secmodule.ModuleType,
SecModuleStatus = secmodule.Status,
RoleModuleId = (Int32?)secrolemodule.RoleModuleId,
RoleID = (Int32?)secrolemodule.RoleID,
ViewPermission = (Boolean?)secrolemodule.ViewPermission,
AddPermssion = (Boolean?)secrolemodule.AddPermssion,
EditPermission = (Boolean?)secrolemodule.EditPermission,
DeletePermission = (Boolean?)secrolemodule.DeletePermission,
SecRoleModStatus = (Int32?)secrolemodule.Status,
/*added by asutosh*/
HasNew = (Boolean?)secmodule.HasNew,
HasEdit = (Boolean?)secmodule.HasEdit,
HasDelete = (Boolean?)secmodule.HasDelete,
SortOrder = secmodule.SortOrder,
ClientID = secrolemodule.ClientID
};
foreach (var get in resList)
{
objsecRoleModuleGet = new secRoleModuleGet();
objsecRoleModuleGet.ModuleId = (int?)get.ModuleId;
objsecRoleModuleGet.ModuleName = get.ModuleName;
objsecRoleModuleGet.ParentId = (int?)get.ParentId;
objsecRoleModuleGet.Url = get.Url;
objsecRoleModuleGet.ModuleType = get.ModuleType;
objsecRoleModuleGet.RoleModuleId = (int?)get.RoleModuleId;
objsecRoleModuleGet.RoleID = (int?)get.RoleID;
objsecRoleModuleGet.ViewPermssion = get.ViewPermission ?? false;
objsecRoleModuleGet.AddPermssion = get.AddPermssion ?? false;
objsecRoleModuleGet.EditPermission = get.EditPermission ?? false;
objsecRoleModuleGet.DeletePermission = get.DeletePermission ?? false;
objsecRoleModuleGet.RoleModuleStatus = (Int32?)get.SecRoleModStatus;
objsecRoleModuleGet.HasNew = get.HasNew ?? false;
objsecRoleModuleGet.HasEdit = get.HasEdit ?? false;
objsecRoleModuleGet.HasDelete = get.HasDelete ?? false;
objsecRoleModuleGet.SortOrder = get.SortOrder ?? 0;
objsecRoleModuleGet.ClientID = get.ClientID ?? 0;
resRoleModule.Add(objsecRoleModuleGet);
}
return(resRoleModule);
//return resList.ToList();
}