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);
}
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);
}