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