public void Insert(int OrderNumber,string OfficeIndicator,DateTime? DateOrderCreated,bool? PublishipOrder,int? CompanyID,int? ConsigneeID,int? NotifyPartyID,int? AgentAtOriginID,int? AgentAtDestinationID,int? PrinterID,int? ClearingAgentID,int? OnCarriageID,int? OrderControllerID,int? OperationsControllerID,int? OriginPortControllerID,int? DestinationPortControllerID,string CustomersRef,int? ContactID,int? OriginPointID,int? PortID,int? DestinationPortID,int? FinalDestinationID,int? CountryID,int? DestinationCountryID,byte[] Ts)
{
CloneOrderTable item = new CloneOrderTable();
item.OrderNumber = OrderNumber;
item.OfficeIndicator = OfficeIndicator;
item.DateOrderCreated = DateOrderCreated;
item.PublishipOrder = PublishipOrder;
item.CompanyID = CompanyID;
item.ConsigneeID = ConsigneeID;
item.NotifyPartyID = NotifyPartyID;
item.AgentAtOriginID = AgentAtOriginID;
item.AgentAtDestinationID = AgentAtDestinationID;
item.PrinterID = PrinterID;
item.ClearingAgentID = ClearingAgentID;
item.OnCarriageID = OnCarriageID;
item.OrderControllerID = OrderControllerID;
item.OperationsControllerID = OperationsControllerID;
item.OriginPortControllerID = OriginPortControllerID;
item.DestinationPortControllerID = DestinationPortControllerID;
item.CustomersRef = CustomersRef;
item.ContactID = ContactID;
item.OriginPointID = OriginPointID;
item.PortID = PortID;
item.DestinationPortID = DestinationPortID;
item.FinalDestinationID = FinalDestinationID;
item.CountryID = CountryID;
item.DestinationCountryID = DestinationCountryID;
item.Ts = Ts;
item.Save(UserName);
}
/// <summary>
/// clone form is just ReadOnly we do not need any other functionality as it is for identical copies of an existing order
/// if orderid is passed as param (pid) get data from order table
/// </summary>
/// <param name="ordertemplateid"></param>
protected void bind_formview(int orderid)
{
string[] _key = { "OrderNumber" };
CloneOrderTableCollection _col = new CloneOrderTableCollection();
if (this.fmvTemplate.CurrentMode == FormViewMode.ReadOnly)
{
//blank template
CloneOrderTable _clone = new CloneOrderTable();
//create clone from selected order number (the clone table does not contain order id)
int _orderid = wwi_func.vint(wwi_security.DecryptString(get_token("pid"), "publiship"));
if (_orderid > 0)
{
//copy from order to template
OrderTable _order = new OrderTable(_orderid);
_clone.DateOrderCreated = DateTime.Now;
_clone.PublishipOrder = _order.PublishipOrder;
_clone.OfficeIndicator = _order.OfficeIndicator;
_clone.CompanyID = _order.CompanyID;
_clone.ConsigneeID = _order.ConsigneeID;
_clone.NotifyPartyID = _order.NotifyPartyID;
_clone.AgentAtOriginID = _order.AgentAtOriginID;
_clone.AgentAtDestinationID = _order.AgentAtDestinationID;
_clone.PrinterID = _order.PrinterID;
_clone.ClearingAgentID = _order.ClearingAgentID;
_clone.OnCarriageID = _order.OnCarriageID;
_clone.OrderControllerID = _order.OrderControllerID;
_clone.OperationsControllerID = _order.OperationsControllerID;
_clone.OriginPortControllerID = _order.OriginPortControllerID;
_clone.DestinationPortControllerID = _order.DestinationPortControllerID;
_clone.CustomersRef = _order.CustomersRef;
_clone.ContactID = _order.ContactID;
_clone.OriginPointID = _order.OriginPointID;
_clone.PortID = _order.PortID;
_clone.DestinationPortID = _order.DestinationPortID;
_clone.FinalDestinationID = _order.FinalDestinationID;
_clone.CountryID = _order.CountryID;
_clone.DestinationCountryID = _order.DestinationCountryID;
}
_col.Add(_clone);
this.fmvTemplate.DataSource = _col;
this.fmvTemplate.DataKeyNames = _key;
this.fmvTemplate.DataBind();
}
else
{
//_col.Add(new CloneOrderTable());
//error we must have an order number to clone from
this.dxlblErr.Text = "No order number has been selected for cloning";
this.dxpnlErr.ClientVisible = true;
}
}
