public void PartialUpdate(int OrderID, string OrderNumber, string Payee, string DeliveryAddress, string Country, int?CompanyID, int?ContactID, DateTime?CargoReady, string Fao)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
item.OrderNumber = OrderNumber;
item.Payee = Payee;
item.DeliveryAddress = DeliveryAddress;
item.DestinationCountry = Country;
item.CompanyID = CompanyID;
item.ContactID = ContactID;
//if (!string.IsNullOrEmpty(CargoReady))
//{
// item.CargoReadyDate = Convert.ToDateTime(CargoReady).ToString("yyyy-MM-dd");
//}
item.CargoReadyDate = CargoReady;
item.Fao = Fao;
item.Save(UserName);
}
public void UpdateCartonCount(int OrderID, int newValue)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
int _v = item.Cartons ?? 0;
item.Cartons = _v + newValue >= 0 ? _v + newValue : 0;
item.Save(UserName);
}
public void UpdateCartonCount(int OrderID, int newValue)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
int _v = item.Cartons ?? 0;
item.Cartons = _v + newValue >= 0 ? _v + newValue : 0;
item.Save(UserName);
}
public void PartialUpdate(int OrderID, string OrderNumber, string Payee, string DeliveryAddress, string Country, int? CompanyID, int? ContactID, DateTime? CargoReady, string Fao)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
item.OrderNumber = OrderNumber;
item.Payee = Payee;
item.DeliveryAddress = DeliveryAddress;
item.DestinationCountry = Country;
item.CompanyID = CompanyID;
item.ContactID = ContactID;
//if (!string.IsNullOrEmpty(CargoReady))
//{
// item.CargoReadyDate = Convert.ToDateTime(CargoReady).ToString("yyyy-MM-dd");
//}
item.CargoReadyDate = CargoReady;
item.Fao = Fao;
item.Save(UserName);
}
public void Update(int OrderID,string OrderNumber,DateTime? DateOrderReceived,string Payee,string DeliveryAddress,string DestinationCountry,int? CompanyID,int? ConsigneeID,int? PrinterID,string CustomerRef,string PrintersRef,int? ContactID,DateTime? CargoReadyDate,DateTime? CargoReceivedDate,int? OriginID,int? DestID,int? FinalDestID,int? DeliveryAddressID,int? AttentionOfID,int? FlightID,DateTime? Etd,DateTime? Eta,string HAWBno,bool? HAWBAdded,bool? ShippedonBoard,int? Titles,int? Cartons,decimal? ActualWeight,decimal? ActualVolume,string RemarkstoAgent,string RemarkstoCust,bool? JobClosed,string JobClosureDate,string CompositeInvRef,decimal? InsuranceValue,DateTime? CancelRequestRcd,int? CancelRequestByID,bool? OrderCancelled,DateTime? CancelDate,int? CancelledByID,string Fao,byte[] Ts)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
item.OrderNumber = OrderNumber;
item.DateOrderReceived = DateOrderReceived;
item.Payee = Payee;
item.DeliveryAddress = DeliveryAddress;
item.DestinationCountry = DestinationCountry;
item.CompanyID = CompanyID;
item.ConsigneeID = ConsigneeID;
item.PrinterID = PrinterID;
item.CustomerRef = CustomerRef;
item.PrintersRef = PrintersRef;
item.ContactID = ContactID;
item.CargoReadyDate = CargoReadyDate;
item.CargoReceivedDate = CargoReceivedDate;
item.OriginID = OriginID;
item.DestID = DestID;
item.FinalDestID = FinalDestID;
item.DeliveryAddressID = DeliveryAddressID;
item.AttentionOfID = AttentionOfID;
item.FlightID = FlightID;
item.Etd = Etd;
item.Eta = Eta;
item.HAWBno = HAWBno;
item.HAWBAdded = HAWBAdded;
item.ShippedonBoard = ShippedonBoard;
item.Titles = Titles;
item.Cartons = Cartons;
item.ActualWeight = ActualWeight;
item.ActualVolume = ActualVolume;
item.RemarkstoAgent = RemarkstoAgent;
item.RemarkstoCust = RemarkstoCust;
item.JobClosed = JobClosed;
item.JobClosureDate = JobClosureDate;
item.CompositeInvRef = CompositeInvRef;
item.InsuranceValue = InsuranceValue;
item.CancelRequestRcd = CancelRequestRcd;
item.CancelRequestByID = CancelRequestByID;
item.OrderCancelled = OrderCancelled;
item.CancelDate = CancelDate;
item.CancelledByID = CancelledByID;
item.Fao = Fao;
item.Ts = Ts;
item.Save(UserName);
}
public void Update(int OrderID, string OrderNumber, DateTime?DateOrderReceived, string Payee, string DeliveryAddress, string DestinationCountry, int?CompanyID, int?ConsigneeID, int?PrinterID, string CustomerRef, string PrintersRef, int?ContactID, DateTime?CargoReadyDate, DateTime?CargoReceivedDate, int?OriginID, int?DestID, int?FinalDestID, int?DeliveryAddressID, int?AttentionOfID, int?FlightID, DateTime?Etd, DateTime?Eta, string HAWBno, bool?HAWBAdded, bool?ShippedonBoard, int?Titles, int?Cartons, decimal?ActualWeight, decimal?ActualVolume, string RemarkstoAgent, string RemarkstoCust, bool?JobClosed, string JobClosureDate, string CompositeInvRef, decimal?InsuranceValue, DateTime?CancelRequestRcd, int?CancelRequestByID, bool?OrderCancelled, DateTime?CancelDate, int?CancelledByID, string Fao, byte[] Ts)
{
PublishipAdvanceOrderTable item = new PublishipAdvanceOrderTable();
item.MarkOld();
item.IsLoaded = true;
item.OrderID = OrderID;
item.OrderNumber = OrderNumber;
item.DateOrderReceived = DateOrderReceived;
item.Payee = Payee;
item.DeliveryAddress = DeliveryAddress;
item.DestinationCountry = DestinationCountry;
item.CompanyID = CompanyID;
item.ConsigneeID = ConsigneeID;
item.PrinterID = PrinterID;
item.CustomerRef = CustomerRef;
item.PrintersRef = PrintersRef;
item.ContactID = ContactID;
item.CargoReadyDate = CargoReadyDate;
item.CargoReceivedDate = CargoReceivedDate;
item.OriginID = OriginID;
item.DestID = DestID;
item.FinalDestID = FinalDestID;
item.DeliveryAddressID = DeliveryAddressID;
item.AttentionOfID = AttentionOfID;
item.FlightID = FlightID;
item.Etd = Etd;
item.Eta = Eta;
item.HAWBno = HAWBno;
item.HAWBAdded = HAWBAdded;
item.ShippedonBoard = ShippedonBoard;
item.Titles = Titles;
item.Cartons = Cartons;
item.ActualWeight = ActualWeight;
item.ActualVolume = ActualVolume;
item.RemarkstoAgent = RemarkstoAgent;
item.RemarkstoCust = RemarkstoCust;
item.JobClosed = JobClosed;
item.JobClosureDate = JobClosureDate;
item.CompositeInvRef = CompositeInvRef;
item.InsuranceValue = InsuranceValue;
item.CancelRequestRcd = CancelRequestRcd;
item.CancelRequestByID = CancelRequestByID;
item.OrderCancelled = OrderCancelled;
item.CancelDate = CancelDate;
item.CancelledByID = CancelledByID;
item.Fao = Fao;
item.Ts = Ts;
item.Save(UserName);
}
