Exemple #1
0
    protected void bind_eta_grid(int voyageid)
    {
        string[]          _cols = { "VoyageETASubTable.VoyageETASubID", "VoyageETASubTable.VoyageID", "VoyageETASubTable.DestinationPortID", "VoyageETASubTable.ETA", "PortTable.PortName" };
        SubSonic.SqlQuery _qry  = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.VoyageETASubTable).
                                  LeftOuterJoin(DAL.Logistics.PortTable.PortIDColumn, DAL.Logistics.VoyageETASubTable.DestinationPortIDColumn)
                                  .WhereExpression("VoyageID").IsEqualTo(voyageid);

        DataTable _dt = _qry.ExecuteDataSet().Tables[0];

        this.dxgrdETA.DataSource   = _dt;
        this.dxgrdETA.KeyFieldName = "VoyageETASubID";
        this.dxgrdETA.DataBind();
    }
        public string get_company_group(int requestCompanyId)
        {
            string _cg = "0";

            string[]          _tcols = { "NameAndAddressBook.CompanyId", "NameAndAddressBook.Pricer_Group" };
            SubSonic.SqlQuery _qry   = DAL.Logistics.DB.Select(_tcols).From(DAL.Logistics.Tables.NameAndAddressBook).Where("CompanyID").IsEqualTo(requestCompanyId);
            DataSet           _dt    = _qry.ExecuteDataSet();

            if (_dt.Tables.Count > 0 && _dt.Tables[0].Rows.Count > 0)
            {
                _cg = !string.IsNullOrEmpty(_dt.Tables[0].Rows[0]["Pricer_Group"].ToString()) ? _dt.Tables[0].Rows[0]["Pricer_Group"].ToString() : "0";
            }

            return(_cg);
        }
    protected void dxcboCountry_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
    {
        DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;

        string _filter = !string.IsNullOrEmpty(e.Filter) ? e.Filter : "";

        //use datareaders - much faster than loading into collections
        string[] _cols  = { "CountryID", "CountryName" };
        string[] _order = { "CountryName" };

        //SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.NameAndAddressBook).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CompanyID").WhereExpression("CompanyName").Like(string.Format("%{0}%", e.Filter.ToString()));
        SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).Paged(e.BeginIndex + 1, e.EndIndex + 1, "CountryID").WhereExpression("CountryName").Like(string.Format("{0}%", _filter));

        DataTable   _dt = _query.ExecuteDataSet().Tables[0];
        IDataReader _rd = _query.ExecuteReader();

        _combo.ValueField = "CountryID";
        _combo.ValueType  = typeof(int);
        _combo.TextField  = "CountryName";
        _combo.DataBindItems();
    }
    //end bind country
    #endregion

    #region incremental filtering for large combobox datasets
    //14/07/14 dxcboVesselID_ItemRequestedByValue and dxcboVesselID_ItemsRequestedByFilterCondition DEPRECATED
    //can't use OnItemsRequestedByFilterCondition and OnItemRequestedByValue on this combo as server-side filtring makes the search case sensitive
    //incremental filtering for large datasets on combos
    /// <summary>
    /// incremental filtering and partial loading of name and address book for speed
    /// both ItemsRequestedByFilterCondition and ItemRequestedByValue must be set up for this to work
    /// company name is only available to publiship users
    /// </summary>
    /// <param name="source"></param>
    /// <param name="e"></param>
    protected void dxcboCountry_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
    {
        DevExpress.Web.ASPxEditors.ASPxComboBox _combo = (DevExpress.Web.ASPxEditors.ASPxComboBox)source;

        Int32 _id = 0;

        if (e.Value != null)
        {
            _id = wwi_func.vint(e.Value.ToString());
        }

        string[]          _cols  = { "CountryID", "CountryName" };
        string[]          _order = { "CountryName" };
        SubSonic.SqlQuery _query = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.CountryTable).WhereExpression("CountryID").IsEqualTo(_id);
        IDataReader       _rd    = _query.ExecuteReader();

        DataTable _dt = _query.ExecuteDataSet().Tables[0];

        _combo.ValueField = "CountryID";
        _combo.ValueType  = typeof(int);
        _combo.TextField  = "CountryName";
        _combo.DataBindItems();
    }
    protected void formOrder_DataBound(object sender, EventArgs e)
    {
        try
        {
            OrderTable _row = (OrderTable)this.formOrder.DataItem;
            //icons
            //publiship order
            this.dximgJobPubliship.ClientVisible = _row != null? _row.PublishipOrder: false;
            this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false;
            //job closed
            this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            //hot job
            this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false;
            this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false;

            string _office = "";
            int _officeid = 0;
            if (this.formOrder.CurrentMode == FormViewMode.Insert)
            {
                //order number and office in header
                this.dxlblOrderNo.Text = "[New Order]";
                _officeid = Page.Session["user"] != null ? (int)((UserClass)Page.Session["user"]).OfficeId : 0;
                _office = wwi_func.lookup_xml_string("xml\\office_names.xml", "value", _officeid.ToString(), "name");
            }
            else
            {
                this.dxlblOrderNo.Text = _row.OrderNumber.ToString();
                _office = _row != null ? _row.OfficeIndicator : "";
                _officeid = wwi_func.vint(wwi_func.lookup_xml_string("xml\\office_names.xml", "name", _office, "value"));

            }
            this.dxlbOrderDetails1.Text = "|" + _office;
            //just pass it as a param
            //this.dxhfOfficeID.Clear();
            //this.dxhfOfficeID.Add("officeid", _officeid.ToString());  

            //16/10/13 view returned to this page and single summary query used to populate look-up values
            //view moved to seperate page (Order_View.aspx) so we can avoid all these calls to the database!
            if (this.formOrder.CurrentMode == FormViewMode.Edit || this.formOrder.CurrentMode == FormViewMode.Insert)
            {
                //have to bind the standard ddls here or they don't populate for new orders
                bind_company_combos(_officeid);
                bind_origin_combos(-1);
                bind_dest_combos();

                sub_decks();
            }
            else //readonly
            {
                string _test ="";

                SubSonic.SqlQuery _q = new SubSonic.SqlQuery();
                _q = DB.Select().From("view_order_summary").Where("OrderNumber").IsEqualTo(_row.OrderNumber);
                DataTable _dt = _q.ExecuteDataSet().Tables[0];

                //labels
                ASPxLabel _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewController");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OrderController"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewContact");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["ContactName"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOps");
                if (_lbl != null) { _lbl.Text = _lbl.Text = _dt.Rows[0]["OpsController"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblContactEmail");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["EMail"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCompany");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["CompanyName"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewPrinter");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["PrinterName"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCountry");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginCountry"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOrigin");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["PlaceName"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginPort");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginPort"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewAgentAtOrigin");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginAgent"].ToString(); 
                    _test = _dt.Rows[0]["OriginAgent"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDestPort");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["DestinationPort"].ToString(); }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewFinal");
                if (_lbl != null) { _lbl.Text = _dt.Rows[0]["FinalDestination"].ToString(); }

                //260211 some older jobs have an origin controller but no origin agent in those cases don't display the origin controller
                if (!string.IsNullOrEmpty(_test))
                {
                    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginController");
                    if (_lbl != null) { _lbl.Text = _dt.Rows[0]["OriginPortController"].ToString(); }
                }

                //date formatting
                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblDateCreated");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewExWorks");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewBookingReceived");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCargoReady");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDueWarehouse");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDocsApprovedDate");
                if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }
                                
                //addresses
                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblCompanyAddress");
                if (_lbl != null)
                {
                    _lbl.Text = _dt.Rows[0]["Address1"].ToString() + Environment.NewLine + _dt.Rows[0]["Address2"].ToString() +
                        Environment.NewLine + _dt.Rows[0]["Address3"].ToString() + Environment.NewLine + _dt.Rows[0]["CountryName"].ToString() +
                        Environment.NewLine + _dt.Rows[0]["TelNo"].ToString();
                }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblPrinterAddress");
                if (_lbl != null)
                {
                    _lbl.Text = _dt.Rows[0]["PrinterAdd1"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterAdd2"].ToString() +
                        Environment.NewLine + _dt.Rows[0]["PrinterAdd3"].ToString() + Environment.NewLine + _dt.Rows[0]["PrinterCountry"].ToString() +
                        Environment.NewLine + _dt.Rows[0]["PrinterTel"].ToString();
                }

                _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblOriginAgentAddress");
                if (_lbl != null)
                {
                    _lbl.Text = _dt.Rows[0]["OriginAgentAddress1"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentAddress2"].ToString() +
                       Environment.NewLine + _dt.Rows[0]["OriginAgentAddress3"].ToString() + Environment.NewLine + _dt.Rows[0]["OriginAgentCountry"].ToString() +
                       Environment.NewLine + _dt.Rows[0]["OriginAgentTel"].ToString();
                }

                //deprecated look-up code
                //if (this.formOrder.CurrentMode == FormViewMode.ReadOnly)
                //{
                //    //text values for view template
                //    ASPxLabel _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewController");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OrderControllerID); }
                //   _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewContact");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("ContactName", "ContactTable", "ContactID", _row.ContactID); }

                //   _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOps");
                //   if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OperationsControllerID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCompany");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("CompanyName", "view_delivery_address", "CompanyID", _row.CompanyID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewPrinter");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PrinterName", "PrinterView", "CompanyID", _row.PrinterID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewCountry");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("CountryName", "CountryTable", "CountryID", _row.CountryID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOrigin");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PlaceName", "PlacesTable", "PlaceID", _row.OriginPointID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginPort");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PortName", "PortTable", "PortID", _row.PortID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewAgentAtOrigin");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("OriginAgent", "OriginAgentView", "OriginAgentID", _row.AgentAtOriginID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewDestPort");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PortName", "PortTable", "PortID", _row.DestinationPortID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewFinal");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("PlaceName", "PlacesTable", "PlaceID", _row.FinalDestinationID); }

                //   _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblViewOriginController");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("Name", "EmployeesTable", "EmployeeID", _row.OriginPortControllerID); }

                //    //address labels
                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblCompanyAddress");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("Address1,Address2,Address3,CountryName,TelNo", "view_delivery_address", "CompanyID", _row.CompanyID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblContactEmail");
                //   if (_lbl != null) { _lbl.Text = wwi_func.lookup_value("EMail", "ContactTable", "ContactID", _row.ContactID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblPrinterAddress");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("PrinterAdd1,PrinterAdd2,PrinterAdd3,PrinterCountry,PrinterTel", "PrinterView", "CompanyID", _row.PrinterID); }

                //    _lbl = (ASPxLabel)this.formOrder.FindControl("dxlblOriginAgentAddress");
                //    if (_lbl != null) { _lbl.Text = wwi_func.lookup_multi_values("OriginAgentAddress1,OriginAgentAddress2,OriginAgentAddress3,OriginAgentCountry", "OriginAgentView", "OriginAgentID", _row.AgentAtOriginID); }
                //}
            }
        }
        catch (Exception ex)
        {
            string _ex = ex.Message.ToString();
            this.dxlblErr.Text = _ex;
            this.dxpnlErr.Visible = true;
        }
    }
    //end selecting

    protected void fmvShipment_DataBound(object sender, EventArgs e)
    {
        try
        {
            OrderTable _row = (OrderTable)this.fmvShipment.DataItem;
            //publiship order
            this.dximgJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false;
            this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false;
            //job closed
            this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            //hot job
            this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false;
            this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false;
            //order number and office in header
            this.dxlblOrderNo.Text = _row.OrderNumber.ToString();

            string[] _cols = { "OrderNumber", "PublishipOrder", "OfficeIndicator", "DateOrderCreated", "JobClosed", "HotJob", "PortID", "DestinationPortID", "VesselID", "PackageTypeID", "FCLLCL" };
            SubSonic.SqlQuery _q = new SubSonic.SqlQuery();
            _q = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.OrderTable).WhereExpression("OrderNumber").IsEqualTo(_row.OrderNumber);

            DataTable _dt = _q.ExecuteDataSet().Tables[0];
            if (_dt.Rows.Count > 0)
            {
                string _vessel = wwi_func.lookup_value("Joined", "VoyageTable", "VoyageID", wwi_func.vint(_dt.Rows[0]["VesselID"].ToString()));
                string _package = wwi_func.lookup_value("PackageType", "PackageTypeTable", "PackageTypeID", wwi_func.vint(_dt.Rows[0]["PackageTypeID"].ToString()));
                string _fcllcl = wwi_func.lookup_xml_string("//xml//ddl_items.xml", "ddls", "FCLLCL", "value", _dt.Rows[0]["FCLLCL"].ToString(), "name");

                this.dxhfOrder.Remove("ptstart"); //origin port
                this.dxhfOrder.Remove("ptend");  //destination port
                this.dxhfOrder.Remove("vssl");  //vessel name

                this.dxhfOrder.Add("ptstart", _dt.Rows[0]["PortID"].ToString());
                this.dxhfOrder.Add("ptend", _dt.Rows[0]["DestinationPortID"].ToString());
                this.dxhfOrder.Add("vssl", _vessel);

                //containers list in all views
                bind_containers();

                if (this.fmvShipment.CurrentMode != FormViewMode.ReadOnly)
                {
                    //bind dlls here or won't populate on new record
                    bind_fcl_lcl();
                    bind_package_type();
                }
                else
                {
                    //set values for dlls in ReadOnly mode
                    ASPxLabel _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldVessel");
                    if (_lbl != null) { _lbl.Text = _vessel; }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldPackageTypeID");
                    if (_lbl != null) { _lbl.Text = _package; }
                    
                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldFCLLCL");
                    if (_lbl != null) { _lbl.Text = _fcllcl; }

                    //date formatting
                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETS");
                    if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETA");
                    if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldJobClosureDate");
                    if (_lbl != null) { _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : ""; }
                }//endif
            }//endif
        }
        catch (Exception ex)
        {
            string _err = ex.Message.ToString();
            this.dxlblErr.Text = _err;
            this.dxpnlErr.ClientVisible = true;
        }
    }
    //end selecting

    protected void fmvShipment_DataBound(object sender, EventArgs e)
    {
        try
        {
            OrderTable _row = (OrderTable)this.fmvShipment.DataItem;
            //publiship order
            this.dximgJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false;
            this.dxlblJobPubliship.ClientVisible = _row != null ? _row.PublishipOrder : false;
            //job closed
            this.dximgJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            this.dxlblJobClosed.ClientVisible = _row != null ? _row.JobClosed : false;
            //hot job
            this.dximgJobHot.ClientVisible = _row != null ? _row.HotJob : false;
            this.dxlblJobHot.ClientVisible = _row != null ? _row.HotJob : false;
            //order number and office in header
            this.dxlblOrderNo.Text = _row.OrderNumber.ToString();

            string[]          _cols = { "OrderNumber", "PublishipOrder", "OfficeIndicator", "DateOrderCreated", "JobClosed", "HotJob", "PortID", "DestinationPortID", "VesselID", "PackageTypeID", "FCLLCL" };
            SubSonic.SqlQuery _q    = new SubSonic.SqlQuery();
            _q = DAL.Logistics.DB.Select(_cols).From(DAL.Logistics.Tables.OrderTable).WhereExpression("OrderNumber").IsEqualTo(_row.OrderNumber);

            DataTable _dt = _q.ExecuteDataSet().Tables[0];
            if (_dt.Rows.Count > 0)
            {
                string _vessel  = wwi_func.lookup_value("Joined", "VoyageTable", "VoyageID", wwi_func.vint(_dt.Rows[0]["VesselID"].ToString()));
                string _package = wwi_func.lookup_value("PackageType", "PackageTypeTable", "PackageTypeID", wwi_func.vint(_dt.Rows[0]["PackageTypeID"].ToString()));
                string _fcllcl  = wwi_func.lookup_xml_string("//xml//ddl_items.xml", "ddls", "FCLLCL", "value", _dt.Rows[0]["FCLLCL"].ToString(), "name");

                this.dxhfOrder.Remove("ptstart"); //origin port
                this.dxhfOrder.Remove("ptend");   //destination port
                this.dxhfOrder.Remove("vssl");    //vessel name

                this.dxhfOrder.Add("ptstart", _dt.Rows[0]["PortID"].ToString());
                this.dxhfOrder.Add("ptend", _dt.Rows[0]["DestinationPortID"].ToString());
                this.dxhfOrder.Add("vssl", _vessel);

                //containers list in all views
                bind_containers();

                if (this.fmvShipment.CurrentMode != FormViewMode.ReadOnly)
                {
                    //bind dlls here or won't populate on new record
                    bind_fcl_lcl();
                    bind_package_type();
                }
                else
                {
                    //set values for dlls in ReadOnly mode
                    ASPxLabel _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldVessel");
                    if (_lbl != null)
                    {
                        _lbl.Text = _vessel;
                    }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldPackageTypeID");
                    if (_lbl != null)
                    {
                        _lbl.Text = _package;
                    }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldFCLLCL");
                    if (_lbl != null)
                    {
                        _lbl.Text = _fcllcl;
                    }

                    //date formatting
                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETS");
                    if (_lbl != null)
                    {
                        _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : "";
                    }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldETA");
                    if (_lbl != null)
                    {
                        _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : "";
                    }

                    _lbl = (ASPxLabel)this.fmvShipment.FindControl("dxlblFieldJobClosureDate");
                    if (_lbl != null)
                    {
                        _lbl.Text = _lbl.Text != "" ? wwi_func.vdatetime(_lbl.Text).ToShortDateString() : "";
                    }
                } //endif
            }     //endif
        }
        catch (Exception ex)
        {
            string _err = ex.Message.ToString();
            this.dxlblErr.Text          = _err;
            this.dxpnlErr.ClientVisible = true;
        }
    }