public ActionResult Details(int?id) //Delivery Request ID
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }


            var deliveryInfo = db.GetDeliveryInfoByRequestID(id).FirstOrDefault();

            if (deliveryInfo == null)
            {
                return(HttpNotFound());
            }

            var items = db.GetDeliveryInfoItemsByRequestID(id).ToList();

            ViewBag.DeliveryInfo = deliveryInfo;
            ViewBag.Items        = items;
            ViewBag.ProjectID    = db.ProjectDeliveryRequests.Where(p => p.RequestID == id).Select(p => p.ProjectID).FirstOrDefault();

            ViewBag.CustodyLocations = new SelectList(db.GetCustodyLocationsBySiteCoID(siteusercompanyid).ToList(), nameof(GetCustodyLocationsBySiteCoID_Result.ViewID), nameof(GetCustodyLocationsBySiteCoID_Result.Name));
            ViewBag.DeliveryStatus   = new SelectList(db.GetDeliveryStatusBySiteCoID(siteusercompanyid).ToList(), nameof(GetDeliveryStatusBySiteCoID_Result.ViewID), nameof(GetDeliveryStatusBySiteCoID_Result.Name));

            return(View());
        }