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); }