public RetroInfoGetAllModel GetRetroInfo(RetroSearch retroSearch)
{
retroSearch.PageNumber--;
var getRetroInfo = this.context.tbl_trn_retroinfo
.Where(s => (retroSearch.ProjectId == 0 || s.retroinfo_projectinfo_id == retroSearch.ProjectId))
.Join(this.context.tbl_mst_projectinfo, a => a.retroinfo_projectinfo_id, b => b.projectinfo_id, (a, b) => new { a, b })
.Select(x => new RetroInfoModel
{
retroinfo_id = x.a.retroinfo_id,
retroinfo_name = x.a.retroinfo_name,
retroinfo_projectinfo_name = x.b.projectinfo_name,
retroinfo_sprint = x.a.retroinfo_sprint,
retroinfo_date = x.a.retroinfo_date,
retroinfo_imagepath = x.a.retroinfo_imagepath,
retroinfo_isdeleted = x.a.retroinfo_isdeleted,
retroinfo_status = x.a.retroinfo_status,
retroinfo_projectinfo_id = x.a.retroinfo_projectinfo_id
}).OrderBy(f => f.retroinfo_projectinfo_id);
var allRecords = getRetroInfo.Skip(retroSearch.PageNumber * retroSearch.PageIndex)
.Take(retroSearch.PageIndex).ToList();
var getRetroDetails = new RetroInfoGetAllModel
{
TotalRecords = getRetroInfo.Count(),
RetroInfoModel = allRecords
};
return(getRetroDetails);
}
public HttpResponseMessage GetAll([FromUri] RetroSearch retroSearch)
{
var response = this.retrospectiveInformationService.GetRetroInfo(retroSearch);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
