public ShipDetail GetShipDeliveryByShipDetailID(int ShipDetailID)
{
ShipDetail s = (from ship in context.ShipDetails
where ship.ShipDetailID == ShipDetailID
select ship).SingleOrDefault();
return(s);
}
public ShipDetail GetShipDetailByOrderID(int OrderID)
{
ShipDetail shipdetail = (from s in context.ShipDetails
where s.OrderID == OrderID
select s).Single();
return(shipdetail);
}
public ActionResult ConfirmDeliveried(int ShipDetailID)
{
string Status = "Close";
string statusOrder = "Paid";
ShipDetail ship = info.GetShipDeliveryByShipDetailID(ShipDetailID);
info.UpdateShipDetailStatusByShipDetailID(ShipDetailID, Status);
info.UpdateOrderStatus(ship.OrderID, statusOrder);
return(RedirectToAction("GetListShipDelivery", new { ShipDetailID = ship.ShipDetailID }));
}
public ActionResult DetailShipDelivery(int ShipDetailID)
{
ShipDetail ship = info.GetShipDeliveryByShipDetailID(ShipDetailID);
int OrderID = ship.OrderID;
IEnumerable <OrderItem> item = info.GetAllOrderItemByOrderID(OrderID);
ViewData["OrderItem"] = item;
ViewData["ShipDetailID"] = ShipDetailID;
return(View());
}
public ActionResult ConfirmDeliveriedFailed(int ShipDetailID)
{
string Status = "Failed";
string statusOrder = "Cancel";
ShipDetail ship = info.GetShipDeliveryByShipDetailID(ShipDetailID);
info.UpdateShipDetailStatusByShipDetailID(ShipDetailID, Status);
info.UpdateOrderStatus(ship.OrderID, statusOrder);
OrderItem item = info.GetOrderItemByOrderID(ship.OrderID);
info.UpdateOrderItemStatus(item.OrderItemID, statusOrder);
return(RedirectToAction("GetListShipDelivery", new { ShipDetailID = ship.ShipDetailID }));
}
public bool UpdateShipDetailStatus(int OrderID, string Status)
{
try
{
ShipDetail shipDetail = this.context.ShipDetails.Single(o => o.OrderID == OrderID);
shipDetail.Status = Status;
context.SubmitChanges();
return(true);
}
catch (Exception ex)
{
throw new Exception("Error Update Ship Detail Status : " + ex.Message);
}
}
public bool InsertShipDetail(int ShipID, int OrderID, string CustName, string Address, string Phone, string Status)
{
try
{
ShipDetail shipdetail = new ShipDetail();
shipdetail.ShipID = ShipID;
shipdetail.OrderID = OrderID;
shipdetail.CustName = CustName;
shipdetail.Address = Address;
shipdetail.Phone = Phone;
shipdetail.Status = Status;
context.ShipDetails.InsertOnSubmit(shipdetail);
context.SubmitChanges();
return(true);
}
catch (Exception e)
{
throw new Exception("Error Insert ShipDetail: " + e.Message);
}
}
