public int Get(int page, int rows, string sidx, string sord)
{
try
{
DeliveryMethodFilter filter = new DeliveryMethodFilter
{
Page = page,
Rows = rows,
Sidx = sidx,
Sord = sord
};
var options = CreateNewContextOptions();
using (var db = new OrderContext(options))
{
ProcessingTestHelper.PopulateDefaultOrderCtx(db);
}
using (var db = new OrderContext(options))
{
var repository = new DeliveryMethodRepository(db);
IEnumerable <DeliveryMethod> result = new List <DeliveryMethod>();
Assert.DoesNotThrow(() => result = repository.Get(filter));
return(result.Count());
}
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
public IEnumerable <DeliveryMethod> Get(DeliveryMethodFilter filter)
{
try
{
var query = Db.Set <DeliveryMethod>().AsQueryable();
//TODO: dependencies.
if (!string.IsNullOrEmpty(filter.Sidx))
{
query = filter.Sord.Equals("desc", StringComparison.OrdinalIgnoreCase)
? query.OrderByDescending(filter.Sidx)
: query.OrderBy(filter.Sidx);
}
if (filter.Page != 0 && filter.Rows != 0)
{
return(query.Skip(filter.Rows * (filter.Page - 1)).Take(filter.Rows));
}
return(query);
}
catch (Exception ex)
{
LogEventManager.Logger.Error(ex.Message, ex);
throw;
}
}
public IndexViewModel Create(HttpContext httpContext, DeliveryMethodFilter filter, IEnumerable <DeliveryMethod> deliveryMethods, string orderBy, int skip, int take, int total)
{
IStringLocalizer <IndexViewModelFactory> localizer = httpContext.GetStringLocalizer <IndexViewModelFactory>();
return(new IndexViewModel()
{
Grid = new GridViewModelFactory().Create(
httpContext,
new FilterViewModelFactory().Create(httpContext, "Name.Value.Contains", localizer["Name"]),
orderBy, skip, take, total,
new[] {
new GridColumnViewModelFactory().Create(localizer["Name"], httpContext.CreateLocalizedOrderBy("Name")),
new GridColumnViewModelFactory().Create(localizer["Position"], "Position"),
new GridColumnViewModelFactory().CreateEmpty()
},
deliveryMethods.Select(dm => new DeliveryMethodViewModelFactory().Create(dm)),
"_DeliveryMethod"
)
});
}
