public IREQUEST_RESULT GET_USERS(PAGINATION_MODEL Paging) { try { var users = context.VwUsers.Skip((Paging.Page_Number - 1) * Paging.Page_Size).Take(Paging.Page_Size).ToList(); int TotalRows = context.VwUsers.Count(); if (users.Count == 0) { request_result.Status = false; request_result.Error_AR = "لا يوجد بيانات"; request_result.Error_EN = "There are no data"; request_result.Data = null; return(request_result); } request_result.Status = true; request_result.Pages_Total_Rows = TotalRows; float all_pages = (float)TotalRows / Paging.Page_Size; request_result.Pages_Number = (int)Math.Ceiling(all_pages); request_result.Page_Size = Paging.Page_Size; request_result.Page_Number = Paging.Page_Number; request_result.Data = users; return(request_result); } catch (Exception ex) { request_result.Status = false; request_result.Error_AR = ex.Message + " : " + ex.Source; request_result.Error_EN = ex.Message + " : " + ex.Source; request_result.Data = null; return(request_result); } }
public IREQUEST_RESULT GET_TICKETS(PAGINATION_MODEL Paging, int Branch_Dept) { try { var tickets = context.Tickets.Where(t => t.Branch_Departement_Id == Branch_Dept && t.Created_Date.Date == DateTime.Now.Date) .OrderBy(t => t.Ticket_Number).Skip((Paging.Page_Number - 1) * Paging.Page_Size).Take(Paging.Page_Size).ToList(); int TotalRows = context.Tickets.Where(t => t.Created_Date.Date == DateTime.Now.Date).Count(); if (tickets.Count == 0) { request_result.Status = false; request_result.Error_AR = "لا يوجد بيانات"; request_result.Error_EN = "There are no data"; request_result.Data = null; return(request_result); } request_result.Status = true; request_result.Pages_Total_Rows = TotalRows; float all_pages = (float)TotalRows / Paging.Page_Size; request_result.Pages_Number = (int)Math.Ceiling(all_pages); request_result.Page_Size = Paging.Page_Size; request_result.Page_Number = Paging.Page_Number; request_result.Data = tickets; return(request_result); } catch (Exception ex) { request_result.Status = false; request_result.Error_AR = ex.Message + " : " + ex.Source; request_result.Error_EN = ex.Message + " : " + ex.Source; request_result.Data = null; return(request_result); } }
public IActionResult GET_USERS([FromBody] PAGINATION_MODEL Page) { var result = service.GET_USERS(Page); if (result.Status == false) { return(BadRequest(result)); } return(Ok(result)); }
public ActionResult GET_TICKETS([FromBody] PAGINATION_MODEL Paging) { var Branch_Dept = int.Parse(User.GetClaimType("Branch_Departement")); var result = service.GET_TICKETS(Paging, Branch_Dept); if (result.Status == false) { return(BadRequest(result)); } return(Ok(result)); }