public List<ServicesLibrary.Entities.SiteMap> GetAll()
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
List<tbl_SiteMap> dbListSiteMap = context.tbl_SiteMap.ToList();
List<ServicesLibrary.Entities.SiteMap> entList = new List<ServicesLibrary.Entities.SiteMap>();
foreach (var drItem in dbListSiteMap)
{
ServicesLibrary.Entities.SiteMap entItem = new ServicesLibrary.Entities.SiteMap();
AssignDataObjectToEntity(drItem, ref entItem);
entList.Add(entItem);
}
return entList;
}
public List<SiteMap> GetMenuByIdRole(int ID)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
List<tbl_SiteMap> dbListSiteMap = (from s in context.tbl_SiteMap
join rs in context.tbl_Roles_SiteMap on s.IdSiteMap equals rs.IdSiteMap
where rs.IdRole == ID
&& s.IsBrowsable == true
select s).ToList();
List<ServicesLibrary.Entities.SiteMap> entList = new List<ServicesLibrary.Entities.SiteMap>();
foreach (var drItem in dbListSiteMap)
{
ServicesLibrary.Entities.SiteMap entItem = new ServicesLibrary.Entities.SiteMap();
AssignDataObjectToEntity(drItem, ref entItem);
entList.Add(entItem);
}
return entList;
}
public string GetRoleCodeByURL(string slURL)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
if (!slURL.Contains("~"))
{
//slURL = slURL.Replace("/","\\");
slURL = String.Format("~{0}", slURL);
}
tbl_SiteMap dbSiteMap = context.tbl_SiteMap.Where(sm => sm.URL == slURL).FirstOrDefault();
ServicesLibrary.Entities.SiteMap entItem= new ServicesLibrary.Entities.SiteMap();
string code;
if (dbSiteMap!= null)
{
AssignDataObjectToEntity(dbSiteMap, ref entItem);
code = entItem.RoleCode;
}
else
{
code = "Not Permission or URL not exists";
}
return code;
}
public List<string> GetRolesByUserName(string UserName)
{
TCRepositoryDataContext context = DataBaseUtils.GetContext();
List<tbl_SiteMap> tblListSiteMap = (from sm in context.tbl_SiteMap
join rs in context.tbl_Roles_SiteMap on sm.IdSiteMap equals rs.IdSiteMap
join r in context.tbl_Roles on rs.IdRole equals r.IdRole
join u in context.tbl_Users on r.IdRole equals u.IdRole
where u.UserName == UserName
select sm).ToList();
//DataSet dsRole = mscConnector.GetDataFromQuery(rqQuery.SelectRoleCodesByUserName(UserName));
List<ServicesLibrary.Entities.SiteMap> entList = new List<ServicesLibrary.Entities.SiteMap>();
foreach (var drItem in tblListSiteMap)
{
ServicesLibrary.Entities.SiteMap entItem = new ServicesLibrary.Entities.SiteMap();
AssignDataObjectToEntity(drItem, ref entItem);
entList.Add(entItem);
}
return entList.Select(c => c.RoleCode).ToList();
}