public HomeController(NorthwindDbContext context, ICompositeViewEngine compositeViewEngine) : base(compositeViewEngine)
{
_orderRepository = new OrdersRepository(context);
_orderDetailsRepository = new OrderDetailsRepository(context);
_customersRepository = new CustomersRepository(context);
_shippersRepository = new ShippersRepository(context);
}
private async Task <Shipper> CreateShipper()
{
var shipperRepository = new ShippersRepository(GetContext());
var shipperModel = new Shipper(Guid.NewGuid(), "SedatK Ltd", "(503) 555-9831");
await shipperRepository.Add(shipperModel);
await shipperRepository.UnitOfWork.Commit();
return(shipperModel);
}
public IEnumerable <SelectItem> GetAllShippers()
{
using (var context = new NorthwindDbContext(_options))
{
ShippersRepository repository = new ShippersRepository(context);
return(repository.GetAll()
.Select(r => new SelectItem(r.ShipperID.ToString(), r.ShipperID.ToString() + " - "
+ r.CompanyName))
.ToList());
}
}
public async Task <IViewComponentResult> InvokeAsync(string ordersGridState = "")
{
IQueryCollection query = Request.Query;
if (!string.IsNullOrWhiteSpace(ordersGridState))
{
try
{
query = new QueryCollection(StringExtensions.GetQuery(ordersGridState));
}
catch (Exception)
{
// do nothing, gridState was not a valid state
}
}
var requestCulture = HttpContext.Features.Get <IRequestCultureFeature>();
var locale = requestCulture.RequestCulture.UICulture.TwoLetterISOLanguageName;
SharedResource.Culture = requestCulture.RequestCulture.UICulture;
var shippersRepository = new ShippersRepository(_context);
var shipperList = shippersRepository.GetAll()
.Select(s => new SelectItem(s.ShipperID.ToString(), s.CompanyName))
.ToList();
Action <IGridColumnCollection <Order> > columns = c =>
{
/* Adding not mapped column, that renders body, using inline Razor html helper */
c.Add()
.Encoded(false)
.Sanitized(false)
.SetWidth(30)
.Css("hidden-xs") //hide on phones
.RenderValueAs(o => $"<b><a class='modal_link' href='javascript:void(0);' onclick='editOrder({o.OrderID})'>Edit</a></b>");
/* Adding "OrderID" column: */
c.Add(o => o.OrderID)
.Titled(SharedResource.Number)
.SetWidth(100);
/* Adding "OrderDate" column: */
c.Add(o => o.OrderDate, "OrderCustomDate")
.Titled(SharedResource.OrderCustomDate)
.SortInitialDirection(GridSortDirection.Descending)
.ThenSortByDescending(o => o.OrderID)
.SetCellCssClassesContraint(o => o.OrderDate.HasValue && o.OrderDate.Value >= DateTime.Parse("1997-01-01") ? "red" : "")
.Format("{0:yyyy-MM-dd}")
.SetWidth(110)
.Max(true).Min(true);
c.Add(o => o.ShipVia)
.Titled("Via")
.SetWidth(250)
.RenderValueAs(o => o.Shipper.CompanyName)
.SetListFilter(shipperList);
/* Adding "CompanyName" column: */
c.Add(o => o.Customer.CompanyName)
.Titled(SharedResource.CompanyName)
.SetWidth(250)
.SetInitialFilter(GridFilterType.StartsWith, "a")
.SetFilterWidgetType("CustomCompanyNameFilterWidget")
.Max(true).Min(true);
/* Adding "ContactName" column: */
c.Add(o => o.Customer.ContactName).Titled(SharedResource.ContactName).SetWidth(250)
.Max(true).Min(true);
/* Adding "Freight" column: */
c.Add(o => o.Freight)
.Titled(SharedResource.Freight)
.SetWidth(100)
.Format("{0:F}")
.Sum(true).Average(true).Max(true).Min(true);
/* Adding "Vip customer" column: */
c.Add(o => o.Customer.IsVip)
.Titled(SharedResource.IsVip)
.SetWidth(70)
.Css("hidden-xs") //hide on phones
.RenderValueAs(o => o.Customer.IsVip ? Strings.BoolTrueLabel : Strings.BoolFalseLabel);
};
var repository = new OrdersRepository(_context);
var server = new GridServer <Order>(repository.GetAll(), query, false, "ordersGrid",
columns, 10, locale, GridPager.DefaultAjaxPagerViewName)
.SetRowCssClasses(item => item.Customer.IsVip ? "success" : string.Empty)
.Sortable()
.Filterable()
.WithMultipleFilters()
.Searchable(true, false)
.Groupable(true)
.Selectable(true)
.SetStriped(true)
.ChangePageSize(true)
.WithGridItemsCount();
var factory = Task <IViewComponentResult> .Factory;
return(await factory.StartNew(() => View(server.Grid)));
}
public GridPageModel(NorthwindDbContext context)
{
_orderRepository = new OrdersRepository(context);
_shippersRepository = new ShippersRepository(context);
}
public static ShippersRepository GetShippersRepository(IUnitOfWork unitOfWork)
{
var repository = new ShippersRepository();
repository.UnitOfWork = unitOfWork;
return repository;
}
public static ShippersRepository GetShippersRepository()
{
var repository = new ShippersRepository();
repository.UnitOfWork = GetUnitOfWork();
return repository;
}
