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