public IActionResult CreateShipmentDetail(ShipmentDetailInsert shipmentdetail) { try { return(new JsonResult(ShipmentBAL.CreateShipmentDetail(shipmentdetail))); } catch (Exception ex) { return(StatusCode(StatusCodes.Status500InternalServerError, "Failed to create Shipment Detail")); } }
public ShipmentDetail CreateShipmentDetail(ShipmentDetailInsert shipmentdetail) { using (SqlConnection connection = new SqlConnection(DefaultConnection)) { connection.Open(); SqlTransaction transaction = connection.BeginTransaction(); ShipmentDetail shipmentDetail = new ShipmentDetail(); DynamicParameters p = new DynamicParameters(); p.Add("businessid", shipmentdetail.Shipment.BusinessID); p.Add("shipperid", shipmentdetail.Shipment.ShipperID); p.Add("customerid", shipmentdetail.Shipment.CustomerID); p.Add("originffw", shipmentdetail.Shipment.OriginFFW); p.Add("origin3pl", shipmentdetail.Shipment.Origin3PL); p.Add("destinationffw", shipmentdetail.Shipment.DestinationFFW); p.Add("destination3pl", shipmentdetail.Shipment.Destination3PL); p.Add("hblnumber", shipmentdetail.Shipment.HBLNumber); p.Add("mblnumber", shipmentdetail.Shipment.MBLNumber); p.Add("containernumber", shipmentdetail.Shipment.ContainerNumber); p.Add("etd", shipmentdetail.Shipment.ETD); p.Add("eta", shipmentdetail.Shipment.ETA); p.Add("txl", shipmentdetail.Shipment.TXL); p.Add("isffiled", shipmentdetail.Shipment.ISFFiled); p.Add("deliverylocationid", shipmentdetail.Shipment.DeliveryLocationID); p.Add("status", shipmentdetail.Shipment.Status); p.Add("memo", shipmentdetail.Shipment.Memo); p.Add("shipperreference", shipmentdetail.Shipment.ShipperReference); p.Add("createdby", shipmentdetail.Shipment.CreatedBy); Shipment shipment = connection.Query <Shipment>("spCreateShipment", p, transaction, commandType: CommandType.StoredProcedure).Single(); shipmentDetail.Shipment = shipment; foreach (ShipmentLineInsert _ShipmentLine in shipmentdetail.ShipmentLines) { DynamicParameters p2 = new DynamicParameters(); p2.Add("shipmentid", shipment.ShipmentID); ShipmentLine shipmentLine = connection.Query <ShipmentLine>("spCreateShipmentLine", p2, transaction, commandType: CommandType.StoredProcedure).Single(); shipmentDetail.ShipmentLines.Add(shipmentLine); } foreach (ShipmentPackageInsert _ShipmentPackage in shipmentdetail.ShipmentPackages) { DynamicParameters p2 = new DynamicParameters(); p2.Add("shipmentid", shipment.ShipmentID); ShipmentPackage shipmentPackge = connection.Query <ShipmentPackage>("spCreateShipmentPackage", p2, transaction, commandType: CommandType.StoredProcedure).Single(); shipmentDetail.ShipmentPackages.Add(shipmentPackge); } foreach (ShipmentFeeInsert _ShipmentFee in shipmentdetail.ShipmentFees) { DynamicParameters p2 = new DynamicParameters(); p2.Add("shipmentid", shipment.ShipmentID); ShipmentFee shipmentFee = connection.Query <ShipmentFee>("spCreateShipmentFee", p2, transaction, commandType: CommandType.StoredProcedure).Single(); shipmentDetail.ShipmentFees.Add(shipmentFee); } foreach (ShipmentContactInsert _ShipmentContact in shipmentdetail.ShipmentContacts) { DynamicParameters p2 = new DynamicParameters(); p2.Add("shipmentid", shipment.ShipmentID); ShipmentContact shipmentContact = connection.Query <ShipmentContact>("spCreateShipmentContact", p2, transaction, commandType: CommandType.StoredProcedure).Single(); shipmentDetail.ShipmentContacts.Add(shipmentContact); } transaction.Commit(); return(shipmentDetail); } }
public ShipmentDetail CreateShipmentDetail(ShipmentDetailInsert shipmentdetail) { return(ShipmentDAL.CreateShipmentDetail(shipmentdetail)); }