/// <summary>
/// Детали заказа для таблицы заказов
/// </summary>
/// <param name="OrderID"></param>
public IEnumerable<OrderDetailsDTO> ShowOrderDetails(int OrderID)
{
try {
List<OrderDetailsDTO> Orders = new List<OrderDetailsDTO>();
var OrdersDAL = Data.ShowOrderDetails(OrderID);
foreach (var o in OrdersDAL)
{
OrderDetailsDTO order = new OrderDetailsDTO();
order.OrderID = o.OrderID;
order.CustomerID = o.CustomerID;
order.EmployeeID = o.EmployeeID;
order.OrderDate = o.OrderDate;
order.RequiredDate = o.RequiredDate;
order.ShippedDate = o.ShippedDate;
order.ShipVia = o.ShipVia;
order.Freight = o.Freight;
order.ShipName = o.ShipName;
order.ShipAddress = o.ShipAddress;
order.ShipCity = o.ShipCity;
order.ShipRegion = o.ShipRegion;
order.ShipPostalCode = o.ShipPostalCode;
order.ShipCountry = o.ShipCountry;
order.OrderStatus = o.OrderStatus.ToString();
order.ProductID = o.ProductID;
order.ProductName = o.ProductName;
order.Quantity = o.Quantity;
order.UnitPrice = o.UnitPrice;
order.Discount = o.Discount;
Orders.Add(order);
}
return Orders;
}
catch (ArgumentException ex)
{
throw new ValidationException(ex.Message, ex.ParamName);
}
}
/// <summary>
/// Детали заказа для обновления данных
/// </summary>
/// <param name="OrderID"></param>
public OrderDetailsDTO OrderDetails(int OrderID)
{
try
{
var o = Data.OrderDetails(OrderID);
OrderDetailsDTO order = new OrderDetailsDTO();
order.OrderID = o.OrderID;
order.CustomerID = o.CustomerID;
order.EmployeeID = o.EmployeeID;
order.OrderDate = o.OrderDate;
order.RequiredDate = o.RequiredDate;
order.ShippedDate = o.ShippedDate;
order.ShipVia = o.ShipVia;
order.Freight = o.Freight;
order.ShipName = o.ShipName;
order.ShipAddress = o.ShipAddress;
order.ShipCity = o.ShipCity;
order.ShipRegion = o.ShipRegion;
order.ShipPostalCode = o.ShipPostalCode;
order.ShipCountry = o.ShipCountry;
order.OrderStatus = o.OrderStatus.ToString();
order.ProductID = o.ProductID;
order.ProductName = o.ProductName;
order.Quantity = o.Quantity;
order.UnitPrice = o.UnitPrice;
order.Discount = o.Discount;
return order;
}
catch (ArgumentException ex)
{
throw new ValidationException(ex.Message, ex.ParamName);
}
}
/// <summary>
/// Добавление деталей заказа
/// </summary>
/// <param name="order"></param>
public bool AddOrderDetails(OrderDetailsDTO order)
{
try {
OrderDetails orderDAL = new OrderDetails();
orderDAL.OrderID = order.OrderID;
orderDAL.CustomerID = order.CustomerID;
orderDAL.EmployeeID = order.EmployeeID;
orderDAL.OrderDate = order.OrderDate;
orderDAL.RequiredDate = order.RequiredDate;
orderDAL.ShippedDate = order.ShippedDate;
orderDAL.ShipVia = order.ShipVia;
orderDAL.Freight = order.Freight;
orderDAL.ShipName = order.ShipName;
orderDAL.ShipAddress = order.ShipAddress;
orderDAL.ShipCity = order.ShipCity;
orderDAL.ShipRegion = order.ShipRegion;
orderDAL.ShipPostalCode = order.ShipPostalCode;
orderDAL.ShipCountry = order.ShipCountry;
orderDAL.ProductID = order.ProductID;
orderDAL.ProductName = order.ProductName;
orderDAL.Quantity = order.Quantity;
orderDAL.UnitPrice = order.UnitPrice;
orderDAL.Discount = order.Discount;
if (Data.AddOrderDetail(orderDAL) != true)
return true;
else return false;
}
catch (ArgumentException ex)
{
throw new ValidationException(ex.Message, ex.ParamName);
}
}
public ActionResult UpdateOrder(OrderDetailsViewModel order)
{
try
{
if (ModelState.IsValid)
{
OrderDetailsDTO OrderBLL = new OrderDetailsDTO();
OrderBLL.OrderID = order.OrderID;
OrderBLL.CustomerID = order.CustomerID;
OrderBLL.EmployeeID = order.EmployeeID;
OrderBLL.OrderDate = order.OrderDate;
OrderBLL.RequiredDate = order.RequiredDate;
OrderBLL.ShippedDate = order.ShippedDate;
OrderBLL.ShipVia = order.ShipVia;
OrderBLL.Freight = Convert.ToDouble(order.Freight);
OrderBLL.ShipName = order.ShipName;
OrderBLL.ShipAddress = order.ShipAddress;
OrderBLL.ShipCity = order.ShipCity;
OrderBLL.ShipRegion = order.ShipRegion;
OrderBLL.ShipPostalCode = order.ShipPostalCode;
OrderBLL.ShipCountry = order.ShipCountry;
OrderBLL.OrderStatus = order.OrderStatus;
OrderBLL.ProductID = order.ProductID;
OrderBLL.ProductName = order.ProductName;
OrderBLL.Quantity = order.Quantity;
OrderBLL.UnitPrice = Convert.ToDouble(order.UnitPrice);
OrderBLL.Discount = Convert.ToDouble(order.Discount);
Data.AddOrderDetails(OrderBLL);
//После успешного обновления заказа, пользователя перенаправляют на главную страницу
return RedirectToAction("Index");
}
else return View(order);
}
catch(ValidationException ex)
{
return Content(ex.Message);
}
}