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