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