コード例 #1
0
ファイル: ShipmentDAL.cs プロジェクト: alonzoalden/freight
        public ShipmentPackage CreateShipmentPackage(ShipmentPackageInsert shipmentpackage)
        {
            using (SqlConnection connection = new SqlConnection(DefaultConnection))
            {
                DynamicParameters p = new DynamicParameters();
                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>("spCreateShipmentPackage", p, commandType: CommandType.StoredProcedure).Single();

                return(result);
            }
        }
コード例 #2
0
 public IActionResult CreateShipmentPackage(ShipmentPackageInsert shipmentpackage)
 {
     try
     {
         return(new JsonResult(ShipmentBAL.CreateShipmentPackage(shipmentpackage)));
     }
     catch (Exception ex)
     {
         return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to create Shipment Package"));
     }
 }
コード例 #3
0
ファイル: ShipmentBAL.cs プロジェクト: alonzoalden/freight
 public ShipmentPackage CreateShipmentPackage(ShipmentPackageInsert shipmentpackage)
 {
     return(ShipmentDAL.CreateShipmentPackage(shipmentpackage));
 }