public void Insert(string TemplateName,string OfficeIndicator,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) { OrderTemplateTable item = new OrderTemplateTable(); item.TemplateName = TemplateName; item.OfficeIndicator = OfficeIndicator; 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); }
protected void bind_formview(string mode) { string[] _key = { "OrderTemplateID" }; OrderTemplateTableCollection _col = new OrderTemplateTableCollection(); switch (mode){ case "Insert": { //blank template OrderTemplateTable _template = new OrderTemplateTable(); _col.Add(_template); break; } case "Edit": { int _templateid = wwi_func.vint(wwi_security.DecryptString(get_token("pid"), "publiship")); _col.Add(new OrderTemplateTable(_templateid)); break; } case "ReadOnly": { //readonly check to see if an orderid has been passed as a param 'src' //if it has populate template with data from selected order int _orderid = wwi_func.vint(wwi_security.DecryptString(get_token("src"), "publiship")); if (_orderid > 0) { //copy from order to template OrderTable _order = new OrderTable(_orderid); OrderTemplateTable _template = new OrderTemplateTable(); _template.PublishipOrder = _order.PublishipOrder; _template.OfficeIndicator = _order.OfficeIndicator; _template.CompanyID = _order.CompanyID; _template.ConsigneeID = _order.ConsigneeID; _template.NotifyPartyID = _order.NotifyPartyID; _template.AgentAtOriginID = _order.AgentAtOriginID; _template.AgentAtDestinationID = _order.AgentAtDestinationID; _template.PrinterID = _order.PrinterID; _template.ClearingAgentID = _order.ClearingAgentID; _template.OnCarriageID = _order.OnCarriageID; _template.OrderControllerID = _order.OrderControllerID; _template.OperationsControllerID = _order.OperationsControllerID; _template.OriginPortControllerID = _order.OriginPortControllerID; _template.DestinationPortControllerID = _order.DestinationPortControllerID; _template.CustomersRef = _order.CustomersRef; _template.ContactID = _order.ContactID; _template.OriginPointID = _order.OriginPointID; _template.PortID = _order.PortID; _template.DestinationPortID = _order.DestinationPortID; _template.FinalDestinationID = _order.FinalDestinationID; _template.CountryID = _order.CountryID; _template.DestinationCountryID = _order.DestinationCountryID; //add to collection _col.Add(_template); } else { int _templateid = wwi_func.vint(wwi_security.DecryptString(get_token("pid"), "publiship")); _col.Add(new OrderTemplateTable(_templateid)); } break; } default: { break; } } this.fmvTemplate.DataSource = _col; this.fmvTemplate.DataKeyNames = _key; this.fmvTemplate.DataBind(); }
/// <summary> /// insert function for a template generated from a specified order /// </summary> /// <param name="orderid">int</param> /// <returns>int key id of new record</returns> protected int insert_template(int orderid) { int _newid = 0; string _newname = ""; try { //check template name ASPxTextBox _txt = (ASPxTextBox)this.fmvTemplate.FindControl("dxtxtTemplateName"); if (_txt != null) { _newname = _txt.Text; } if (!string.IsNullOrEmpty(_newname)) { //copy from order to template OrderTable _order = new OrderTable(orderid); OrderTemplateTable _template = new OrderTemplateTable(); _template.TemplateName = _newname; //copy details from order table _template.PublishipOrder = _order.PublishipOrder; _template.OfficeIndicator = _order.OfficeIndicator; _template.CompanyID = _order.CompanyID; _template.ConsigneeID = _order.ConsigneeID; _template.NotifyPartyID = _order.NotifyPartyID; _template.AgentAtOriginID = _order.AgentAtOriginID; _template.AgentAtDestinationID = _order.AgentAtDestinationID; _template.PrinterID = _order.PrinterID; _template.ClearingAgentID = _order.ClearingAgentID; _template.OnCarriageID = _order.OnCarriageID; _template.OrderControllerID = _order.OrderControllerID; _template.OperationsControllerID = _order.OperationsControllerID; _template.OriginPortControllerID = _order.OriginPortControllerID; _template.DestinationPortControllerID = _order.DestinationPortControllerID; _template.CustomersRef = _order.CustomersRef; _template.ContactID = _order.ContactID; _template.OriginPointID = _order.OriginPointID; _template.PortID = _order.PortID; _template.DestinationPortID = _order.DestinationPortID; _template.FinalDestinationID = _order.FinalDestinationID; _template.CountryID = _order.CountryID; _template.DestinationCountryID = _order.DestinationCountryID; //save values _template.Save(); _newid = (int)_template.GetPrimaryKeyValue(); } else { string _ex = "You must enter a name for this template"; this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } } catch (Exception ex) { string _ex = ex.Message.ToString(); this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } return _newid; }
/// <summary> /// insert function for a template generated from a specified order /// </summary> /// <param name="orderid">int</param> /// <returns>int key id of new record</returns> protected int insert_order_from_template(int templateid, int neworderno, string newoffice) { int _newid = 0; //return next available orderno but just as a placeholder as it is required for appending the order //do not update actual orderno until new order is saved try { if (templateid > 0) { OrderTemplateTable _template = new OrderTemplateTable(templateid); //copy from template to order OrderTable _order = new OrderTable(); _order.OrderNumber = neworderno; _order.OfficeIndicator = newoffice; //_template.OfficeIndicator; //copy details to order table _order.PublishipOrder = (bool)_template.PublishipOrder; _order.CompanyID = _template.CompanyID; _order.ConsigneeID = _template.ConsigneeID; _order.NotifyPartyID = _template.NotifyPartyID; _order.AgentAtOriginID = _template.AgentAtOriginID; _order.AgentAtDestinationID = _template.AgentAtDestinationID; _order.PrinterID = _template.PrinterID; _order.ClearingAgentID = _template.ClearingAgentID; _order.OnCarriageID = _template.OnCarriageID; _order.OrderControllerID = _template.OrderControllerID; _order.OperationsControllerID = _template.OperationsControllerID; _order.OriginPortControllerID = _template.OriginPortControllerID; _order.DestinationPortControllerID = _template.DestinationPortControllerID; _order.CustomersRef = _template.CustomersRef; _order.ContactID = _template.ContactID; _order.OriginPointID = _template.OriginPointID; _order.PortID = _template.PortID; _order.DestinationPortID = _template.DestinationPortID; _order.FinalDestinationID = _template.FinalDestinationID; _order.CountryID = _template.CountryID; _order.DestinationCountryID = _template.DestinationCountryID; _order.DateOrderCreated = DateTime.Now; //save values _order.Save(); _newid = (int)_order.GetPrimaryKeyValue(); } else { string _ex = "Not able to create order. Template ID is 0"; this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } } catch (Exception ex) { string _ex = ex.Message.ToString(); this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } return _newid; }
/// <summary> /// insert function for a manually entered template /// </summary> /// <returns>int key id of new record</returns> protected int insert_template() { int _newid = 0; int? _intnull = null; //for nullable values string _newname = ""; try { ASPxTextBox _txt = (ASPxTextBox)this.fmvTemplate.FindControl("dxtxtTemplateName"); if (_txt != null) { _newname = _txt.Text; } if (!string.IsNullOrEmpty(_newname)) { OrderTemplateTable _template = new OrderTemplateTable(); //template name _template.TemplateName = _newname; //CustomersRef _txt = (ASPxTextBox)this.fmvTemplate.FindControl("dxtxtCustomersRef"); if (_txt != null) { _template.CustomersRef = _txt.Text.ToString(); } //office ASPxComboBox _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOfficeIndicator"); if (_cbo != null) { _template.OfficeIndicator = _cbo.SelectedItem != null ? _cbo.Text.ToString() : ""; } //CompanyId _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboCompanyID"); if (_cbo != null) { _template.CompanyID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //ConsigneeID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboConsigneeID"); if (_cbo != null) { _template.ConsigneeID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //NotifyPartyID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboNotifyPartyID"); if (_cbo != null) { _template.NotifyPartyID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //AgentAtOriginID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboAgentAtOriginID"); if (_cbo != null) { _template.AgentAtOriginID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //AgentAtDestinationID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboAgentAtDestinationID"); if (_cbo != null) { _template.AgentAtDestinationID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //PrinterID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboPrinterID"); if (_cbo != null) { _template.PrinterID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //ClearingAgentID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboClearingAgentID"); if (_cbo != null) { _template.ClearingAgentID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //OnCarriageID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOnCarriageID"); if (_cbo != null) { _template.OnCarriageID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //OrderControllerID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOrderControllerID"); if (_cbo != null) { _template.OrderControllerID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //OperationsControllerID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOperationsControllerID"); if (_cbo != null) { _template.OperationsControllerID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //OriginPortControllerID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOriginPortControllerID"); if (_cbo != null) { _template.OriginPortControllerID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //DestinationPortControllerID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboDestinationPortControllerID"); if (_cbo != null) { _template.DestinationPortControllerID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //ContactID //multicolumn combo returns selecteditem as null use value instead _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboContactID"); if (_cbo != null) { _template.ContactID = _cbo.Value != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //OriginPointID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboOriginPointID"); if (_cbo != null) { _template.OriginPointID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //PortID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboPortID"); if (_cbo != null) { _template.OriginPointID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //DestinationPortID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboDestinationPortID"); if (_cbo != null) { _template.DestinationPortID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //FinalDestinationID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboFinalDestinationID"); if (_cbo != null) { _template.FinalDestinationID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //CountryID _cbo = (ASPxComboBox)this.fmvTemplate.FindControl("dxcboCountryID"); if (_cbo != null) { _template.CountryID = _cbo.SelectedItem != null ? wwi_func.vint(_cbo.Value.ToString()) : _intnull; } //DestinationCountryID? not on form _template.DestinationCountryID = 0; //publiship order ASPxCheckBox _ckb = (ASPxCheckBox)this.fmvTemplate.FindControl("dxckbPublishipOrder"); if (_ckb != null) { _template.PublishipOrder = _ckb.Checked; } //save values _template.Save(); _newid = (int)_template.GetPrimaryKeyValue(); } else { string _ex = "You must enter a name for this template"; this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } } catch (Exception ex) { string _ex = ex.Message.ToString(); this.dxlblErr.Text = _ex; this.dxpnlErr.ClientVisible = true; } return _newid; }