public Shipment CreateShipment(ShipmentInsert shipment) { using (SqlConnection connection = new SqlConnection(DefaultConnection)) { DynamicParameters p = new DynamicParameters(); p.Add("businessid", shipment.BusinessID); p.Add("shipperid", shipment.ShipperID); p.Add("customerid", shipment.CustomerID); p.Add("originffw", shipment.OriginFFW); p.Add("origin3pl", shipment.Origin3PL); p.Add("destinationffw", shipment.DestinationFFW); p.Add("destination3pl", shipment.Destination3PL); p.Add("hblnumber", shipment.HBLNumber); p.Add("mblnumber", shipment.MBLNumber); p.Add("containernumber", shipment.ContainerNumber); p.Add("etd", shipment.ETD); p.Add("eta", shipment.ETA); p.Add("txl", shipment.TXL); p.Add("isffiled", shipment.ISFFiled); p.Add("deliverylocationid", shipment.DeliveryLocationID); p.Add("status", shipment.Status); p.Add("memo", shipment.Memo); p.Add("shipperreference", shipment.ShipperReference); p.Add("createdby", shipment.CreatedBy); Shipment result = connection.Query <Shipment>("spCreateShipment", p, commandType: CommandType.StoredProcedure).Single(); return(result); } }
public Shipment CreateShipment(ShipmentInsert shipment) { //Default if (string.IsNullOrEmpty(shipment.Status)) { shipment.Status = "Pending"; } return(ShipmentDAL.CreateShipment(shipment)); }
public IActionResult CreateShipment(ShipmentInsert shipment) { try { return(new JsonResult(ShipmentBAL.CreateShipment(shipment))); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to create Shipment")); } }