public int AddJob(JobGeneration JG)
{
ObjectParameter objMaxJobId = new ObjectParameter("MaxJObID", 0);
int query = Convert.ToInt32(Context1.SP_InsertJob(JG.JobCode, JG.JobTypeID, JG.JobDate, JG.ConsignerID, JG.ConsigneeID, JG.InvoiceToID, JG.EmployeeID, JG.ShipperID, JG.IPTNo, JG.RefNo, JG.BillOfEnquiry, JG.BLDate, JG.DeliveryOrderNo, JG.BLStatus, JG.CLFValue, JG.DepositAmount, JG.DepositDate, JG.ReceiptNo, JG.RefundDate, JG.RefundAmount, JG.VesselID, JG.VoyageNo, JG.Freight, JG.SailingDate, JG.ArrivalDate, JG.MBL, JG.HBL, JG.LoadPortID, JG.DestinationPortID, JG.DeliveryPlaceID, JG.ReceiptPlaceID, JG.CountryofOriginID, JG.TransporterID, JG.CollectionDate, JG.DeliveryInstructions, JG.TruckRegNo, JG.DriverDetails, JG.Remarks, JG.RotationNo, JG.CarrierID, JG.CollectionPoint, JG.DeliveryNote, JG.DeliveryPoint, JG.CollectionInstructions, Convert.ToInt32(JG.InvoiceNo.Value), Convert.ToDateTime(JG.InvoiceDate), JG.MainJobID.HasValue ? JG.MainJobID.Value : 0, JG.DeliveryDate, JG.DepartingDate, JG.Flight, JG.MAWB, JG.HAWB, JG.MRN, JG.DeliveryOrderDate, JG.shippingInstruction, objMaxJobId));
return(Convert.ToInt32(objMaxJobId.Value));
}
public JobGeneration JobGenerationByJobID(int ID)
{
JobGeneration JG1 = new JobGeneration();
var query = Context1.SP_GetJobGenerationByJobID(ID);
foreach (var item in query)
{
JG1.JobCode = item.JobCode;
JG1.JobDate = item.JobDate.Value;
JG1.JobTypeID = item.JobTypeID;
JG1.MainJobID = item.MainJobID;
JG1.JobID = item.JobID;
JG1.ArrivalDate = item.ArrivalDate;
JG1.InvoiceToID = item.InvoiceToID;
JG1.EmployeeID = item.EmployeeID;
JG1.DeliveryPlaceID = item.DeliveryPlaceID;
JG1.DestinationPortID = item.DestinationPortID;
JG1.ShipperID = item.ShipperID;
JG1.DeliveryPlaceID = item.DeliveryPlaceID;
JG1.ReceiptPlaceID = item.ReceiptPlaceID;
JG1.LoadPortID = item.LoadPortID;
JG1.Freight = item.Freight;
JG1.BLStatus = item.BLStatus1;
JG1.CarrierID = item.CarrierID;
JG1.CLFValue = item.CLFValue;
JG1.CollectionDate = item.CollectionDate;
JG1.CollectionInstructions = item.CollectionInstructions;
JG1.CollectionPoint = item.CollectionPoint;
JG1.ConsigneeID = item.ConsigneeID;
JG1.ConsignerID = item.ConsignerID;
JG1.CountryofOriginID = item.CountryofOriginID;
JG1.DeliveryDate = item.DeliveryDate;
JG1.DeliveryInstructions = item.DeliveryInstructions;
JG1.DeliveryNote = item.DeliveryNote;
JG1.DeliveryOrderDate = item.DeliveryOrderDate;
JG1.DeliveryOrderNo = item.DeliveryOrderNo;
JG1.DeliveryPoint = item.DeliveryPoint;
JG1.DepositAmount = item.DepositAmount;
JG1.DepositDate = item.DepositDate;
JG1.DriverDetails = item.DriverDetails;
JG1.HBL = item.HBL;
JG1.BLStatus = item.BLStatus;
JG1.IPTNo = item.IPTNo;
JG1.RefNo = item.RefNo;
JG1.MBL = item.MBL;
JG1.RefundAmount = item.RefundAmount;
JG1.RefundDate = item.RefundDate;
JG1.Remarks = item.Remarks;
JG1.RotationNo = item.RotationNo;
JG1.SailingDate = item.SailingDate;
JG1.VoyageNo = item.VoyageNo;
JG1.shippingInstruction = item.shippingInstruction;
JG1.CustRef = item.CustRef;
JG1.MRN = item.MRN;
JG1.ReceiptNo = item.ReceiptNo;
JG1.BLDate = item.BLDate;
JG1.TruckRegNo = item.TruckRegNo;
JG1.InvoiceNo = item.InvoiceNo;
JG1.VesselID = item.VesselID;
JG1.TransporterID = item.TransporterID;
JG1.HAWB = item.HAWB;
JG1.MAWB = item.MAWB;
JG1.Flight = item.Flight;
JG1.DepartingDate = item.DepartingDate;
//JG1.BLStatus1 = JG1.BLStatus1;
}
return(JG1);
}
