public ActionResult UserLogin(LoginDetails loginDetails)
{
ReleaseManagementContext context = new ReleaseManagementContext();
LoginDetails user = context.loginDetails
.FirstOrDefault(ud => ud.UserName == loginDetails.UserName && ud.Password == loginDetails.Password);
if (user != null)
{
TempData["username"] = loginDetails.UserName;
TempData["role"] = user.Role;
return(RedirectToAction("Index", "Student"));
}
return(View());
}
public IHttpActionResult Get()
{
using (var db = new ReleaseManagementContext()) {
var releaseCutoffDay = DateTime.Now.AddDays(-5);
var releases = db.Releases.Include(p => p.Client).Include(p => p.ReleasePlatforms)
.Include(p => p.Features)
.Include(p => p.WorkItems)
.Where(p => p.StatusCode != "completed")
//.Where(p => p.ReleaseDate > releaseCutoffDay)
.OrderBy(p => p.ReleaseDate).ToList();
return(Ok(releases));
}
}
// GET: api/Reports
public IHttpActionResult Get()
{
using (var context = new ReleaseManagementContext())
{
var releases = context.Releases
.Include(p => p.Client)
.Where(p => p.StatusCode == "completed")
.GroupBy(p => p.ClientId)
.Select(grp => new
{
grp.Key,
release = grp.OrderByDescending(p => p.ReleaseDate)
.Select(p => new { p.ApplicationVersion, p.Client.ClientName, p.StatusCode, p.ReleaseDate, p.ReleaseId })
.FirstOrDefault()
}).ToList();
return(Ok(releases));
}
}