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