public void OrdersCount() { int count = 0; using (var connection = factory.CreateConnection()) { connection.ConnectionString = connectionString; var command = connection.CreateCommand(); command.CommandText = "SELECT COUNT(*) FROM Northwind.Orders"; connection.Open(); count = (int)command.ExecuteScalar(); } var items = repo.GetAllOrders(); Assert.AreEqual(count, items.Count, "Получены не все элементы!"); }
public HttpResponseMessage GetAllOrders() { try { return(Request.CreateResponse(HttpStatusCode.OK, repository.GetAllOrders(), "application/json")); } catch (Exception e) { return(Request.CreateResponse(HttpStatusCode.InternalServerError, (object)null, "application/json")); } }
public IActionResult GetAllOrders() { var result = _ordersRepository.GetAllOrders(); if (!result.Any()) { return(NotFound("No orders available")); } return(Ok(result)); }
public JsonResult CheckEmployeeID(int employeeId) { var result = false; var rep = new OrdersRepository(); var employee = rep.GetAllOrders(false) .Where(x => x.EmployeeID == employeeId) .FirstOrDefault(); if (employee != null) { result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult CheckCustomerID(string customerId) { var result = false; var rep = new OrdersRepository(); var customer = rep.GetAllOrders(false) .Where(x => x.CustomerID == customerId) .FirstOrDefault(); if (customer != null) { result = true; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult EditOrder(int?orderId) { var rep = new OrdersRepository(); var viewOrder = new Models.CreatingOrderViewModel { IsNew = true, OrderDate = DateTime.Now, ShippedDate = DateTime.Now, RequiredDate = DateTime.Now }; var customers = rep.GetAllCustomers(); var employees = rep.GetAllEmployees(); if (!orderId.HasValue) { ViewBag.Customers = customers; ViewBag.Employees = employees; return(PartialView("_EditOrder", viewOrder)); } var order = rep.GetAllOrders(false) .Where(x => x.OrderID == orderId.Value) .FirstOrDefault(); if (order == null) { return(RedirectToAction("ErrorMessage", "Home", new { message = Resources.EmptyOrderId })); } ViewBag.Customers = customers .Where(x => x.CustomerID == order.CustomerID) .Concat(customers.Where(x => x.CustomerID != order.CustomerID)); ViewBag.Employees = employees .Where(x => x.EmployeeID == order.EmployeeID) .Concat(employees.Where(x => x.EmployeeID != order.EmployeeID)); Mapper.Initialize(cfg => cfg.CreateMap <DataAccessLayer.Models.Order, Models.CreatingOrderViewModel>()); viewOrder = Mapper.Map <DataAccessLayer.Models.Order, Models.CreatingOrderViewModel>(order); viewOrder.IsNew = false; return(PartialView("_EditOrder", viewOrder)); }
public ActionResult Index(int?page) { var rep = new OrdersRepository(); var orders = rep.GetAllOrders(true); var viewOrders = new List <Models.OrderViewModel>(); Mapper.Initialize(cfg => cfg.CreateMap <DataAccessLayer.Models.Order, Models.OrderViewModel>() .ForMember("Sum", opt => opt.MapFrom(src => src.Sum.ToString("F")))); foreach (var order in orders) { var viewOrder = Mapper.Map <DataAccessLayer.Models.Order, Models.OrderViewModel>(order); viewOrders.Add(viewOrder); } int pageSize = 5; int pageNumber = page ?? 1; return(View(viewOrders.ToPagedList(pageNumber, pageSize))); }
public ActionResult Details(int?orderID) { if (!orderID.HasValue) { return(RedirectToAction("Index")); } var rep = new OrdersRepository(); var order = rep.GetAllOrders(false) .Where(x => x.OrderID == orderID) .FirstOrDefault(); if (order == null) { return(RedirectToAction("ErrorMessage", "Home", new { message = Resources.EmptyOrderId })); } Mapper.Initialize(cfg => cfg.CreateMap <DataAccessLayer.Models.Order, Models.FullOrderViewModel>()); var viewOrder = Mapper.Map <DataAccessLayer.Models.Order, Models.FullOrderViewModel>(order); return(View(viewOrder)); }
public ActionResult Index() { var orders = ordersRepository.GetAllOrders(); return(View(orders)); }
public ActionResult AllOrdersForPrint() { OrdersRepository repo = new OrdersRepository(); return(View(repo.GetAllOrders())); }