public IList GetPage(IPageParameter input) { return(_db.ItemLocation .AddJsonFilters(input.Filters) .AddOrderByRange(input.Sorts) .ToPagedList(input.Page)); }
public IList GetPage(IPageParameter input) { return(Query() .AddJsonFilters(input.Filters) .AddOrderByRange(input.Sorts) .ToPagedList(input.Page)); }
public object GetDefaultData(IPageParameter input) { return(new { CountryId = Country.REPUBLICA_DOMINICANA, StateId = State.SANTO_DOMINGO }); }
public object GetDefaultData(IPageParameter input) { return(new { TransactionTypeId = ETransactionType.NewStock, TransactionDate = DateTime.Now }); }
public IList GetPage(IPageParameter input) { return(_db.TransactionType .Where(w => !w.Hide) .AddJsonFilters(input.Filters) .AddOrderByRange(input.Sorts) .ToPagedList(input.Page)); }
public object GetDefaultData(IPageParameter input) { return(new { transactions = _db.TransactionType .Where(w => new[] { ETransactionType.CustomerSale, ETransactionType.DamagedStock }.Contains(w.TransactionTypeId)) .ToList(), TransactionDate = DateTime.Now }); }
private object QueryPageList(ISqlMapper mapper, object parameter) { object value = null; var list = mapper.QueryForList(this._statementName, parameter); IPageParameter pageParameter = (IPageParameter)parameter; if (pageParameter.RequireTotalCount) { int count = (int)mapper.QueryForObject(this._statementName + "_Count", parameter); value = Activator.CreateInstance(this._pagedListType, list, pageParameter.PageIndex, pageParameter.PageSize, count); } else { value = Activator.CreateInstance(this._pagedListType, list, pageParameter.PageIndex, pageParameter.PageSize, pageParameter.TotalCount); } return(value); }
public object GetDefaultData(IPageParameter input) { var Date = DateTime.Now; var StartDate = new DateTime(Date.Year, Date.Month, 1); var EndDate = StartDate.AddMonths(1).AddDays(-1); return(new { Reports = new object[] { new { Id = ReportType.InventoryTransactions, Name = "Transacciones de inventario" }, new { Id = ReportType.CurrentStockList, Name = "Lista de stock actual" }, }, Date = DateTime.Now, StartDate, EndDate }); }
public IList GetPage(IPageParameter input) { return(new object[] { }); }
public IList GetStatesRD(IPageParameter input) { return(_db.State.Where(w => w.CountryId == Country.REPUBLICA_DOMINICANA).ToList()); }