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); } }
public IActionResult UpdateShipmentPackage(ShipmentPackageUpdate shipmentpackage) { try { return(new JsonResult(ShipmentBAL.UpdateShipmentPackage(shipmentpackage))); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to update Shipment Package")); } }
public ShipmentPackage UpdateShipmentPackage(ShipmentPackageUpdate shipmentpackage) { return(ShipmentDAL.UpdateShipmentPackage(shipmentpackage)); }