public ItemRequestPullDelinquentsResponseModel GetItemRequestFormDelinquents(ItemRequestDelinquentQueryModel query) { ItemRequestPullDelinquentsResponseModel result = new ItemRequestPullDelinquentsResponseModel(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { result.RecordCount = context.ItemRequestFormSearch_SP(query.ModuleNm, null, null, query.FirstFollowupDate.ToString(), query.SecondFollowupDate.ToString(), query.ThirdFollowupDate.ToString()).Count(); result.SearchResult = context.ItemRequestFormSearch_SP(query.ModuleNm, null, null, query.FirstFollowupDate.ToString(), query.SecondFollowupDate.ToString(), query.ThirdFollowupDate.ToString()).Skip(query.NextBatch).Take(10) .Select(x => new ItemRequestDelinquentQueryResultModel { Id = x.Id, Title = x.Title, Status = x.CodeValue, TicketStatus = x.TicketStatus, DateCreated = x.CreateDttm }) .ToList(); return(result); } }
public ItemRequestSearchModel GetItemRequestFormSearchResults(ItemRequestFormSearchQueryModel query) { ItemRequestSearchModel result = new ItemRequestSearchModel(); result.SearchResult = new List <ItemRequestFormSearchResultModel>(); using (OrmocIMSEntities context = new OrmocIMSEntities()) { result.RecordCount = context.ItemRequestFormSearch_SP(query.ModuleNm, query.Id.HasValue ? query.Id.Value.ToString() : null, String.IsNullOrEmpty(query.Title) ? null : query.Title, query.StatusCd.HasValue ? query.StatusCd.Value.ToString() : null, string.IsNullOrEmpty(query.DateCreated) ? null : query.DateCreated, string.IsNullOrEmpty(query.DateTo) ? null : query.DateTo) .Count(); result.SearchResult = context.ItemRequestFormSearch_SP(query.ModuleNm, query.Id.HasValue ? query.Id.Value.ToString() : null, String.IsNullOrEmpty(query.Title) ? null : query.Title, query.StatusCd.HasValue ? query.StatusCd.Value.ToString() : null, string.IsNullOrEmpty(query.DateCreated) ? null : query.DateCreated, string.IsNullOrEmpty(query.DateTo) ? null : query.DateTo) .Skip(query.NextBatch).Take(10) .Select(x => new ItemRequestFormSearchResultModel { Id = x.Id, Title = x.Title, Status = x.CodeValue, DateCreated = x.CreateDttm }).ToList(); return(result); } }