public async Task <ApiResponse> GetStockHistory(Pagination request = null) { try { request = request ?? new Pagination { page = request.page, rowsPerPage = request.rowsPerPage }; var stocks = dbContext.stocks .Where(r => !r.deleted) .OrderBy(r => r.lastUpdate); var count = await stocks.CountAsync(); var pagination = new PaginationResponse { page = request.page, pageCount = (int)Math.Ceiling(count * 1.0 / request.rowsPerPage), rowCount = count, rowsPerPage = request.rowsPerPage }; var response = await stocks .Skip(request.rowsPerPage *(request.page - 1)) .Take(request.rowsPerPage) .ToListAsync(); return(pagination.CreateResponse(response)); } catch (Exception e) { return((e.InnerException).Message.CreateResponse()); } }
public async Task <ApiResponse> GetCompanyList(Pagination request = null) { try { request = request ?? new Pagination { page = request.page, rowsPerPage = request.rowsPerPage }; var company = dbContext.companies .Where(r => !r.deleted); var count = await company.CountAsync(); var pagination = new PaginationResponse { page = request.page, pageCount = (int)Math.Ceiling(count * 1.0 / request.rowsPerPage), rowCount = count, rowsPerPage = request.rowsPerPage }; var response = await company .Skip(request.rowsPerPage *(request.page - 1)) .Take(request.rowsPerPage) .ToListAsync(); return(pagination.CreateResponse(response)); } catch (Exception e) { return((e.InnerException).Message.CreateResponse()); } }
public async Task <ApiResponse> GetCategoryList(Pagination request = null) { try { request = request ?? new Pagination { page = request.page, rowsPerPage = request.rowsPerPage }; var subCategories = dbContext.categories .Join(dbContext.categories, c => c.id, sc => sc.parentId, (c, sc) => new { c, sc }) .Join(dbContext.users, y => y.sc.editedBy, x => x.objectSid, (y, x) => new { y, x }) .Where(r => !r.x.deleted && !r.y.sc.deleted && !r.y.c.deleted) .OrderBy(r => r.y.c.name) .Select(r => new { parentName = r.y.c.name, parentId = r.y.c.id, childName = r.y.sc.name, childId = r.y.sc.id, editedBy = r.x.displayName, lastUpdate = r.y.sc.lastUpdate }); var count = await subCategories.CountAsync(); var pagination = new PaginationResponse { page = request.page, pageCount = (int)Math.Ceiling(count * 1.0 / request.rowsPerPage), rowCount = count, rowsPerPage = request.rowsPerPage }; var response = await subCategories .Skip(request.rowsPerPage *(request.page - 1)) .Take(request.rowsPerPage) .ToListAsync(); return(pagination.CreateResponse(response)); } catch (Exception e) { return((e.InnerException ?? e).Message.CreateResponse()); } }