/// <summary> /// /// </summary> /// <param name="page"></param> /// <param name="from"></param> /// <param name="to"></param> /// <param name="type"></param> /// <returns></returns> public PaginatedList <ExpenseGetModel> GetAll(int page, DateTime?from = null, DateTime?to = null, Models.Type?type = null) { IQueryable <Expense> result = context .Expenses .OrderBy(e => e.Id) .Include(x => x.Comments); PaginatedList <ExpenseGetModel> paginatedResult = new PaginatedList <ExpenseGetModel>(); paginatedResult.CurrentPage = page; if ((from == null && to == null) && type == null) { if (from != null) { result = result.Where(e => e.Date >= from); } } if (to != null) { result = result.Where(e => e.Date <= to); } if (type != null) { result = result.Where(e => e.Type == type); } paginatedResult.NumberOfPages = (result.Count() - 1) / PaginatedList <ExpenseGetModel> .EntriesPerPage + 1; result = result .Skip((page - 1) * PaginatedList <ExpenseGetModel> .EntriesPerPage) .Take(PaginatedList <ExpenseGetModel> .EntriesPerPage); paginatedResult.Entries = result.Select(e => ExpenseGetModel.FromExpense(e)).ToList(); return(paginatedResult); }
public IEnumerable <ExpenseGetModel> GetAll(int page, DateTime?from = null, DateTime?to = null, ExpenseType?type = null) { DateTime dateTimeFrom = new DateTime(); DateTime dateTimeTo = new DateTime(); IQueryable <Expense> result = context.Expenses.OrderBy(f => f.Id).Include(f => f.Comments); // PaginatedList<ExpenseGetModel> paginatedResult = new PaginatedList<ExpenseGetModel>(); // paginatedResult.CurrentPage = page; if (from != null && from != dateTimeFrom) { result = result.Where(f => f.Date >= from); } if (to != null && to != dateTimeTo) { result = result.Where(f => f.Date <= to); } if (type != ExpenseType.none) { result = result.Where(f => f.ExpenseType == type); } // paginatedResult.NumberOfPages = (result.Count() - 1) / PaginatedList<ExpenseGetModel>.EntriesPerPage + 1; // result = result // .Skip((page - 1) * PaginatedList<ExpenseGetModel>.EntriesPerPage) // .Take(PaginatedList<ExpenseGetModel>.EntriesPerPage); // paginatedResult.Entries = result.Select(f => ExpenseGetModel.FromExpense(f)).ToList(); IEnumerable <ExpenseGetModel> resultGetModel = result.Select(f => ExpenseGetModel.FromExpense(f)).ToList(); return(resultGetModel); }
public IEnumerable <ExpenseGetModel> GetAll(DateTime?from = null, DateTime?to = null, ExpenseType?type = null) { IQueryable <Expense> result = context.Expenses.Include(f => f.Comments); if (from == null && to == null && type == null) { return(result.Select(f => ExpenseGetModel.FromExpense(f))); } if (from != null) { result = result.Where(f => f.Date >= from); } if (to != null) { result = result.Where(f => f.Date <= to); } if (type != null) { result = result.Where(f => f.ExpenseType == type); } return(result.Select(f => ExpenseGetModel.FromExpense(f)));; }
public IEnumerable <ExpenseGetModel> GetAll(DateTime?from = null, DateTime?to = null, TypeExpenses?type = null) { IQueryable <Expense> result = context. Expenses. Include(c => c.Comments); if (from == null && to == null && type == null) { return(result.Select(e => ExpenseGetModel.FromExpense(e))); } if (from != null) { result = result.Where(e => e.Date >= from); } if (to != null) { result = result.Where(e => e.Date <= to); } if (type != null) { result = result.Where(e => e.Type.Equals(type)); } return(result.Select(e => ExpenseGetModel.FromExpense(e))); }