public async Task <SiteFunction> GetAsync(int id)
{
var siteFunction = new SiteFunction();
try
{
var a = new AzureDBContext(_imsConfigHelper.MSGGenDB01);
var pageList = a.MsgPages.ToList();
var f = a.Msgfunctions.FirstOrDefault(fi => fi.Id == id);
var page = pageList.FirstOrDefault(p => p.Id == f.Page);
siteFunction = new SiteFunction()
{
Id = f.Id,
Name = f.Name,
Description = f.Description,
PageName = page.Name,
PageTitle = page.Title,
ApplicationId = f.ApplicationId.GetValueOrDefault()
};
}
catch (Exception e)
{
siteFunction.Error = e.Message;
}
return(siteFunction);
}
public async Task <Results <SiteFunction> > ListAsync(int applicationId, ClaimsPrincipal user)
{
var results = new Results <SiteFunction>();
_sites = new List <SiteFunction>();
try
{
var a = new AzureDBContext(_imsConfigHelper.MSGGenDB01);
var pageList = a.MsgPages.ToList();
var app = a.Msgfunctions.Where(fi => fi.ApplicationId == applicationId);
foreach (var f in app)
{
var page = pageList.FirstOrDefault(p => p.Id == f.Page);
var siteFunction = new SiteFunction()
{
Id = f.Id,
Name = f.Name,
Description = f.Description,
PageName = page.Name,
PageTitle = page.Title,
ApplicationId = applicationId
};
_sites.Add(siteFunction);
}
}
catch (Exception e)
{
results.Error = e.Message;
}
results.results = _sites;
results.Page = 0;
results.total_pages = 1;
results.total_results = results.results.Count();
return(results);
}