public IEnumerable <ScrimsServerLess.DTO.Project> GetListOfProjects()
{
OpenConnection();
List <ScrimsServerLess.DTO.Project> projectList = new List <ScrimsServerLess.DTO.Project>();
var statuses = scrimsDbContext.Cistatus.ToList();
foreach (var project in scrimsDbContext.Project.Include(p => p.ClearanceItem))
{
ScrimsServerLess.DTO.Project projObj = new ScrimsServerLess.DTO.Project();
projObj.ProjectName = project.WorkingTitle ?? project.ReleaseTitle;
projObj.TotalCICount = project.ClearanceItem != null ? project.ClearanceItem.Count : 0;
projObj.ReviewQueueCount = project.ClearanceItem != null?project.ClearanceItem.Where(it => it.ReviewQueue.HasValue && it.ReviewQueue.Value).Count() : 0;
projObj.StatusNames = new List <string>();
projObj.StatusValues = new List <int>();
foreach (var status in statuses)
{
projObj.StatusNames.Add(status.Cistatus1);
projObj.StatusValues.Add(project.ClearanceItem != null ? project.ClearanceItem.Where(it => it.Cistatus.Value == status.CistatusId).Count() : 0);
}
projObj.ProjectUniqueID = project.ProjectUniqueId;
projObj.ProjectId = project.ProjectId;
projectList.Add(projObj);
}
return(projectList);
}
public DTO.Project Get(int projectID)
{
//this.logger.LogInformation("Started executing Get");
//string page = "http://en.wikipedia.org/";
//// ... Use HttpClient.
//using (HttpClient client = new HttpClient())
//{
// this.logger.LogInformation("Started executing client.GetAsync");
// using (HttpResponseMessage response = await client.GetAsync(page))
// using (HttpContent content = response.Content)
// {
// this.logger.LogInformation("Started executing client.ReadAsStringAsync");
// // ... Read the string.
// string result = await content.ReadAsStringAsync();
// // ... Display the result.
// if (result != null &&
// result.Length >= 50)
// {
// Console.WriteLine(result.Substring(0, 50) + "...");
// }
// }
// this.logger.LogInformation("Started executing Get1");
//}
var project = scrimsDbContext.Project.FirstOrDefault(it => it.ProjectId == projectID);
if (project != null)
{
ScrimsServerLess.DTO.Project projObj = new ScrimsServerLess.DTO.Project();
projObj.ProjectName = project.WorkingTitle ?? project.ReleaseTitle;
projObj.ProjectId = project.ProjectId;
projObj.ProjectUniqueID = project.ProjectUniqueId;
projObj.WorkingTitle = project.WorkingTitle;
projObj.ReleaseTitle = project.ReleaseTitle;
projObj.WprBillingCode = "Code";
projObj.StrartDate = project.StartDate.Value.ToString();
projObj.ReleaseDate = project.ReleaseDate;
return(projObj);
}
return(null);
}
