Ejemplo n.º 1
0
        public ShipperDataset GetShippers(FreightType freightType, string clientNumber, string clientTerminal)
        {
            //Get a list of shippers
            ShipperDataset shippers = null;

            try {
                shippers = new ShipperDataset();
                if (freightType == FreightType.Regular)
                {
                    VendorDataset vendors = GetVendors(clientNumber, clientTerminal);
                    shippers = new ShipperDataset();
                    for (int i = 0; i < vendors.VendorTable.Rows.Count; i++)
                    {
                        shippers.ShipperTable.AddShipperTableRow(vendors.VendorTable[i].VendorNumber, vendors.VendorTable[i].VendorName, vendors.VendorTable[i].VendorParentNumber, vendors.VendorTable[i].VendorSummary);
                    }
                    shippers.AcceptChanges();
                }
                else if (freightType == FreightType.Returns)
                {
                    AgentDataset   agents    = GetAgents(false);
                    ShipperDataset _shippers = new ShipperDataset();
                    for (int i = 0; i < agents.AgentTable.Rows.Count; i++)
                    {
                        _shippers.ShipperTable.AddShipperTableRow(agents.AgentTable[i].AgentNumber, agents.AgentTable[i].AgentName, agents.AgentTable[i].AgentParentNumber, agents.AgentTable[i].AgentSummary);
                    }
                    shippers.Merge(_shippers.ShipperTable.Select("", "ShipperNumber ASC"));
                    shippers.AcceptChanges();
                }
            }
            catch (ApplicationException ex) { throw ex; }
            catch (Exception ex) { throw new ApplicationException("Unexpected exception creating shipper list.", ex); }
            return(shippers);
        }
Ejemplo n.º 2
0
        public AgentDataset GetAgents(bool mainZoneOnly)
        {
            //Get a list of agents
            AgentDataset agents = null;

            try {
                agents = new AgentDataset();
                DataSet ds = FillDataset(USP_AGENTS, TBL_AGENTS, new object[] { });
                if (ds.Tables[TBL_AGENTS].Rows.Count != 0)
                {
                    AgentDataset _ds = new AgentDataset();
                    if (mainZoneOnly)
                    {
                        AgentDataset __ds = new AgentDataset();
                        __ds.Merge(ds);
                        _ds.Merge(__ds.AgentTable.Select("MainZone <> ''"));
                    }
                    else
                    {
                        _ds.Merge(ds);
                    }
                    for (int i = 0; i < _ds.AgentTable.Rows.Count; i++)
                    {
                        _ds.AgentTable.Rows[i]["AgentSummary"] = (!_ds.AgentTable.Rows[i].IsNull("MainZone") ? _ds.AgentTable.Rows[i]["MainZone"].ToString().PadLeft(2, ' ') : "  ") + " - " +
                                                                 (!_ds.AgentTable.Rows[i].IsNull("AgentNumber") ? _ds.AgentTable.Rows[i]["AgentNumber"].ToString() : "    ") + " - " +
                                                                 (!_ds.AgentTable.Rows[i].IsNull("AgentName") ? _ds.AgentTable.Rows[i]["AgentName"].ToString().Trim() : "");
                    }
                    agents.Merge(_ds.AgentTable.Select("", "MainZone ASC"));
                    agents.AgentTable.AcceptChanges();
                }
            }
            catch (ApplicationException ex) { throw ex; }
            catch (Exception ex) { throw new ApplicationException("Unexpected exception creating agent list.", ex); }
            return(agents);
        }
Ejemplo n.º 3
0
        public AgentDataset GetAgentLocations(string agent)
        {
            //Get a list of agents
            System.Diagnostics.Debug.WriteLine("GetAgentLocations");
            AgentDataset subagents = null;

            try {
                subagents = new AgentDataset();
                AgentDataset ds = GetAgents(false);
                if (agent != null && ds.AgentTable.Rows.Count > 0)
                {
                    subagents.Merge(ds.AgentTable.Select("AgentParentNumber = '" + agent + "'"));
                }
            }
            catch (ApplicationException ex) { throw ex; }
            catch (Exception ex) { throw new ApplicationException("Unexpected exception creating subagent list.", ex); }
            return(subagents);
        }