Exemplo n.º 1
0
        public ShipmentPackage UpdateShipmentPackage(ShipmentPackageUpdate shipmentpackage)
        {
            using (SqlConnection connection = new SqlConnection(DefaultConnection))
            {
                DynamicParameters p = new DynamicParameters();
                p.Add("shipmentpackageid", shipmentpackage.ShipmentPackageID);
                p.Add("shipmentid", shipmentpackage.ShipmentID);
                p.Add("businessid", shipmentpackage.BusinessID);
                p.Add("status", shipmentpackage.Status);
                p.Add("packagenumber", shipmentpackage.PackageNumber);
                p.Add("dimension", shipmentpackage.Dimension);
                p.Add("weight", shipmentpackage.Weight);
                p.Add("weightunit", shipmentpackage.WeightUnit);
                p.Add("shipmentpackagerateid", shipmentpackage.ShipmentPackageRateID);
                p.Add("shippingcarrierid", shipmentpackage.ShippingCarrierID);
                p.Add("shippingserviceid", shipmentpackage.ShippingServiceID);
                p.Add("shippingpackageid", shipmentpackage.ShippingPackageID);
                p.Add("shippingrate", shipmentpackage.ShippingRate);
                p.Add("trackingnumber", shipmentpackage.TrackingNumber);
                p.Add("uspspicnumber", shipmentpackage.USPSPICNumber);
                p.Add("shippinglablepath", shipmentpackage.ShippingLabelPath);
                p.Add("shipdate", shipmentpackage.ShipDate);
                p.Add("israted", shipmentpackage.IsRated);
                p.Add("islabeled", shipmentpackage.IsLabeled);
                p.Add("ismanual", shipmentpackage.IsManual);

                ShipmentPackage result = connection.Query <ShipmentPackage>("spUpdateShipmentPackage", p, commandType: CommandType.StoredProcedure).Single();

                return(result);
            }
        }
Exemplo n.º 2
0
 public IActionResult UpdateShipmentPackage(ShipmentPackageUpdate shipmentpackage)
 {
     try
     {
         return(new JsonResult(ShipmentBAL.UpdateShipmentPackage(shipmentpackage)));
     }
     catch (Exception ex)
     {
         return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to update Shipment Package"));
     }
 }
Exemplo n.º 3
0
 public ShipmentPackage UpdateShipmentPackage(ShipmentPackageUpdate shipmentpackage)
 {
     return(ShipmentDAL.UpdateShipmentPackage(shipmentpackage));
 }