public void Test_GetAll_ReturnOrderDetail_WhenCalled() { var expected = new List <Orders> { new Orders { OrdersID = 1 } }.AsQueryable(); var mockSet = new Mock <IDbSet <Orders> >(); mockSet.As <IQueryable <Orders> >().Setup(m => m.Provider).Returns(expected.Provider); mockSet.As <IQueryable <Orders> >().Setup(m => m.Expression).Returns(expected.Expression); mockSet.As <IQueryable <Orders> >().Setup(m => m.ElementType).Returns(expected.ElementType); mockSet.As <IQueryable <Orders> >().Setup(m => m.GetEnumerator()).Returns(expected.GetEnumerator()); var mockContext = new Mock <BookSaleEntities>(); mockContext.Setup(m => m.Order).Returns(mockSet.Object); var testClass = new OrdersRepository(mockContext.Object); //Act var actual = testClass.GetAll(); //Assert CollectionAssert.AreEqual(expected, actual); }
public ActionResult Grid() { var repository = new OrdersRepository(); var grid = new OrdersGrid(repository.GetAll()); return(PartialView("_OrdersGrid", grid)); }
public ActionResult AjaxPaging() { var repository = new OrdersRepository(); ViewBag.ActiveMenuTitle = "AjaxPaging"; return View("Index", new OrdersAjaxPagingGrid(repository.GetAll(), 1, false)); }
public void Test_GetAll_Order() { var repository = new OrdersRepository(); var orders = repository.GetAll(); Assert.IsTrue(orders.Count() == 0); }
public IActionResult Get() { var repository = new OrdersRepository(_context); var orders = repository.GetAll(); return(Ok(orders)); }
public void OrdersRepositoryTests_GetAll() { OrdersRepository repository = new OrdersRepository(); var result = repository.GetAll(); Assert.IsTrue(result.Count() == 2); }
public ItemsDTO <Order> GetOrdersGridRows(Action <IGridColumnCollection <Order> > columns, QueryDictionary <StringValues> query) { using (var context = new NorthwindDbContext(_options)) { var repository = new OrdersRepository(context); var server = new GridServer <Order>(repository.GetAll(), new QueryCollection(query), true, "ordersGrid", columns) .Sortable() .WithPaging(10) .Filterable() .WithMultipleFilters() .Groupable(true) .Searchable(true, false); // return items to displays var items = server.ItemsToDisplay; // uncomment the following lines are to test null responses //items = null; //items.Items = null; //items.Pager = null; return(items); } }
public ActionResult GetOrdersGridRows() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); return(PartialView("_OrdersGrid", model)); }
public void CreateNewOrder() { //Arrange OrdersRepository ordersRepository = new OrdersRepository(); var ordersCount = ordersRepository.GetAll().Count(); DateTime deliveryTime = DateTime.Now.AddDays(5); decimal freight = 26.75m; Order order = new Order("BONAP", 6, deliveryTime, 3, freight, "Ernst Handel", "Kirchgasse 6", "Graz", null, "8010", "Austria"); //Act ordersRepository.Create(order); //Assert Assert.AreEqual(ordersCount + 1, ordersRepository.GetAll().Count()); }
public ActionResult Index() { ViewBag.ActiveMenuTitle = "Demo"; var repository = new OrdersRepository(_context); var orders = repository.GetAll(); return(View(orders)); }
public ActionResult AjaxPaging() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), Request.Query, false, GridPager.DefaultAjaxPagerViewName); ViewBag.ActiveMenuTitle = "AjaxPaging"; return(View(model)); }
public IActionResult GetAll() { OrdersRepository repository = new OrdersRepository(connectionString); var orders = repository.GetAll(); return(new JsonResult(new SuccessWithResult <IEnumerable <Order> >(orders))); }
public ActionResult AjaxPaging() { var repository = new OrdersRepository(); ViewBag.ActiveMenuTitle = "AjaxPaging"; return(View("Index", new OrdersAjaxPagingGrid(repository.GetAll(), 1, false))); }
public ItemsDTO <Order> GetOrdersGridRows(QueryDictionary <StringValues> query) { var repository = new OrdersRepository(_context); var server = new GridServer <Order>(repository.GetAll(), new QueryCollection(query), true, "ordersGrid", null).AutoGenerateColumns(); // return items to displays return(server.ItemsToDisplay); }
public ActionResult Logistics() { OrdersRepository repository = new OrdersRepository(); var orders = repository.GetAll(); ViewBag.Orders = orders; return(View()); }
public async Task <IViewComponentResult> InvokeAsync() { var repository = new OrdersRepository(_context); var model = new SGrid <Order>(repository.GetAll(), HttpContext.Request.Query, false, GridPager.DefaultAjaxPagerViewName); var factory = Task <IViewComponentResult> .Factory; return(await factory.StartNew(() => View(model))); }
public ActionResult GetOrdersAutoGenerateColumns() { var repository = new OrdersRepository(_context); IGridServer <Order> server = new GridServer <Order>(repository.GetAll(), Request.Query, true, "ordersGrid", null) .AutoGenerateColumns(); return(Ok(server.ItemsToDisplay)); }
public ActionResult Index() { var repository = new OrdersRepository(); ViewBag.ActiveMenuTitle = "Demo"; var grid = new OrdersGrid(repository.GetAll()); return(View(grid)); }
public ActionResult AdminPanel() { PanelVM model = new PanelVM(); UsersRepository usersRepo = new UsersRepository(); OrdersRepository ordersRepo = new OrdersRepository(); model.Users = usersRepo.GetAll(); model.Orders = ordersRepo.GetAll(); return(View(model)); }
public ActionResult GetAllOrders() { var repository = new OrdersRepository(_context); var orders = repository.GetAll().ToList(); if (orders == null) { return(NotFound()); } return(Ok(orders)); }
public JsonResult GetOrdersGridRows(int page) { var repository = new OrdersRepository(); var grid = new OrdersAjaxPagingGrid(repository.GetAll(), page, true); return(Json(new { Html = RenderPartialViewToString("_OrdersGrid", grid), HasItems = grid.DisplayingItemsCount >= grid.Pager.PageSize }, JsonRequestBehavior.AllowGet)); }
public void GetAllOrdersTest() { //Arrange OrdersRepository ordersRepository = new OrdersRepository(); //Act IEnumerable <Order> ordersList = ordersRepository.GetAll(); //Assert Assert.AreNotEqual(0, ordersList.Count()); }
public ActionResult GetOrdersGridForSample() { var repository = new OrdersRepository(_context); IGridServer <Order> server = new GridServer <Order>(repository.GetAll(), Request.Query, true, "ordersGrid", GridSample.Columns, 10) .Sortable() .Filterable() .WithMultipleFilters(); return(Ok(server.ItemsToDisplay)); }
public JsonResult GetOrdersGridRows(int page) { var repository = new OrdersRepository(); var grid = new OrdersAjaxPagingGrid(repository.GetAll(), page, true); return Json(new { Html = RenderPartialViewToString("_OrdersGrid", grid), HasItems = grid.DisplayingItemsCount >= grid.Pager.PageSize }, JsonRequestBehavior.AllowGet); }
public void OrdersRepositoryTests_Create() { //測試rollback SqlConnection connection = new SqlConnection(SqlConnect.str); OrdersRepository repository = new OrdersRepository(); connection.Open(); var transaction = connection.BeginTransaction(); int temp1 = repository.GetAll().Count(); try { var model = new Orders { Order_Date = DateTime.Parse("2018-05-12 00:00:00.000"), Account = "Osborn", Pay = "超商取貨", Transport = "物流", Order_Check = 1, Total = 680, TranMoney = 0 }; repository.Create(connection, model, transaction); transaction.Commit(); } catch (Exception) { try { transaction.Rollback(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } var temp2 = repository.GetAll().Count(); Assert.IsTrue(temp1 < temp2); }
public void TestSave() { // подготовка var order = NewTestOrder(); try { // выполнение repository.Save(order); // проверка Order o_db = repository.GetAll().FirstOrDefault(o => o.Id == order.Id); Assert.IsTrue(o_db != null); EqualOrder(order, o_db); } finally { if (order.Id != 0) { repository.Delete(order); } } }
public ItemsDTO <Order> GetOrdersGridRows(Action <IGridColumnCollection <Order> > columns, QueryDictionary <StringValues> query) { var repository = new OrdersRepository(_context); var server = new GridServer <Order>(repository.GetAll(), new QueryCollection(query), true, "ordersGrid", columns, 10) .Sortable() .Filterable() .WithMultipleFilters(); // return items to displays return(server.ItemsToDisplay); }
public async Task <ActionResult> Orders(string id, int?page) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var totalOrders = await _ordersRepository.GetAll() .Where(o => o.CustomerId == id) .OrderByDescending(o => o.Date) .CountAsync(); var pager = new Pager(totalOrders, page, 10); var orders = await _ordersRepository.GetAll() .Select(o => new OrderDto() { Id = o.Id, Date = o.Date, CustomerId = o.CustomerId, TotalCost = o.OrderProducts.Sum(op => op.Quantity * op.Product.Price), NumberOfProducts = o.OrderProducts.Count() }) .Where(o => o.CustomerId == id) .OrderBy(o => o.Date) .Skip((pager.CurrentPage - 1) * pager.PageSize) .Take(pager.PageSize) .ToListAsync(); var viewModel = new OrderHistoryViewModel() { Orders = orders, CustomerId = id, Pager = pager }; return(View(viewModel)); }
public IActionResult Get() { var random = new Random(); if (random.Next(2) == 0) { return(BadRequest()); } var repository = new OrdersRepository(_context); var orders = repository.GetAll(); return(Ok(orders)); }
public ActionResult GetOrdersGridWithSubgrids() { var repository = new OrdersRepository(_context); IGridServer <Order> server = new GridServer <Order>(repository.GetAll(), Request.Query, true, "ordersGrid", ColumnCollections.OrderColumnsWithSubgrids) .WithPaging(10) .Sortable() .Filterable() .WithMultipleFilters(); var items = server.ItemsToDisplay; return(Ok(items)); }
public ActionResult GetOrdersGridAllFeatures() { var repository = new OrdersRepository(_context); IGridServer <Order> server = new GridServer <Order>(repository.GetAll(), Request.Query, true, "ordersGrid", c => ColumnCollections.OrderColumnsAllFeatures(c, null, null)) .WithPaging(10) .Sortable() .Filterable() .WithMultipleFilters() .Searchable(true, false); var items = server.ItemsToDisplay; return(Ok(items)); }
public ActionResult GetOrdersGridWithCount() { var repository = new OrdersRepository(_context); IGridServer <Order> server = new GridCoreServer <Order>(repository.GetAll().Include(r => r.OrderDetails), Request.Query, true, "ordersGrid", ColumnCollections.OrderColumnsCount) .WithPaging(10) .Sortable() .Filterable() .WithMultipleFilters() .WithGridItemsCount() .SetRemoveDiacritics <NorthwindDbContext>("RemoveDiacritics"); var items = server.ItemsToDisplay; return(Ok(items)); }
public ActionResult Grid() { var repository = new OrdersRepository(); var grid = new OrdersGrid(repository.GetAll()); return PartialView("_OrdersGrid", grid); }