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