public ItemRequestSearchResponseModel ItemRequestFormSearch(ItemRequestSearchQueryModel itemRequestForm)
{
ItemRequestFormSearchQueryModel query = new ItemRequestFormSearchQueryModel();
ItemRequestSearchResultModel singleResult = new ItemRequestSearchResultModel();
ItemRequestSearchResponseModel result = new ItemRequestSearchResponseModel();
result.SearchResult = new List <ItemRequestSearchResultModel>();
query.ModuleNm = "itemrequestformsearch";
query.Id = itemRequestForm.Id;
query.Title = itemRequestForm.Title;
query.DateCreated = itemRequestForm.DateFrom;
query.DateTo = itemRequestForm.DateTo;
query.StatusCd = itemRequestForm.StatusCd;
query.NextBatch = (itemRequestForm.NextBatch - 1) * 10;
var items = _itemRequestFormDataAccess.GetItemRequestFormSearchResults(query);
result.RecordCount = items.RecordCount;
for (int i = 0; i < items.SearchResult.Count; i++)
{
singleResult.Id = items.SearchResult[i].Id;
singleResult.Title = items.SearchResult[i].Title;
singleResult.Status = items.SearchResult[i].Status;
singleResult.DateCreated = items.SearchResult[i].DateCreated;
result.SearchResult.Add(singleResult);
singleResult = new ItemRequestSearchResultModel();
}
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);
}
}
