public List <SPGetMeetingRoom_Result> Filter(MeetingRoomQuery query, out int count)
{
count = 0;
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var listDepartmentID = string.IsNullOrEmpty(query.ListDepartmentId) != true ? query.ListDepartmentId : "";
var start = 0;
var limit = query.PageSize;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetMeetingRoom_Result> result = new List <SPGetMeetingRoom_Result>();
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
result = _entities.SPGetMeetingRoom(Util.DetecVowel(keyword), listDepartmentID, start, limit, prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public BaseListResponse <SPGetMeetingRoom_Result> FilterMeetingRoom(MeetingRoomQuery query)
{
var response = new BaseListResponse <SPGetMeetingRoom_Result>();
int count = 0;
try
{
response.Data = _meetingRoomRepository.Filter(query, out count);
response.TotalItems = count;
response.PageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
response.PageSize = query.PageSize;
}
catch (Exception ex)
{
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
}
return(response);
}
public BaseListResponse <SPGetMeetingRoom_Result> Search([FromUri] MeetingRoomQuery query)
{
return(categoryService.FilterMeetingRoom(query));
}
