public ShipmentFee CreateShipmentFee(ShipmentFeeInsert shipmentfee)
{
using (SqlConnection connection = new SqlConnection(DefaultConnection))
{
DynamicParameters p = new DynamicParameters();
p.Add("shipmentid", shipmentfee.ShipmentID);
p.Add("feeid", shipmentfee.FeeID);
p.Add("feeamount", shipmentfee.FeeAmount);
ShipmentFee result = connection.Query <ShipmentFee>("spCreateShipmentFee", p, commandType: CommandType.StoredProcedure).Single();
return(result);
}
}
public ShipmentFee ToEntity()
{
var fee = new ShipmentFee();
ModelObjectHelper.CopyObject(this, fee);
return fee;
}
public ShipmentFeeModel(ShipmentFee fee)
: this()
{
ModelObjectHelper.CopyObject(fee, this);
FreeThreshold = (fee.FreeThreshold.HasValue) ? fee.FreeThreshold.Value : 0;
}
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);
}
}
