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)); }