public AgentDataSet GetAgents() { //Get agents AgentDataSet agents = new AgentDataSet(); CRMServiceClient client = new CRMServiceClient(); try { DataSet ds = client.GetAgents(); client.Close(); if (ds.Tables["AgentTable"] != null && ds.Tables["AgentTable"].Rows.Count > 0) { agents.Merge(ds.Tables["AgentTable"].Select("", "AgentName ASC")); } } catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); } catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); } catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); } return(agents); }
public AgentDataSet GetAgentsByClient(string clientNumber, string agentNumber) { //Get agents AgentDataSet agents = new AgentDataSet(); CRMServiceClient client = new CRMServiceClient(); try { AgentDataSet _agents = new AgentDataSet(); if (clientNumber != null && clientNumber.Length > 3) { clientNumber = clientNumber.Substring(clientNumber.Length - 3, 3); } if (clientNumber != null && clientNumber == "000") { clientNumber = null; } DataSet ds = client.GetAgentsByClient(clientNumber); client.Close(); if (ds.Tables["AgentTable"] != null && ds.Tables["AgentTable"].Rows.Count > 0) { _agents.Merge(ds.Tables["AgentTable"].Select("", "AgentName ASC")); } if (agentNumber == null) { agents.AgentTable.AddAgentTableRow("", "", "All", "", "", "", "", "", 0, "", "", "", "", "", "", "", "", "", ""); agents.Merge(_agents); } else { agents.Merge(_agents.AgentTable.Select("AgentNumber='" + agentNumber + "'")); } } catch (TimeoutException te) { client.Abort(); throw new ApplicationException(te.Message); } catch (FaultException fe) { client.Abort(); throw new ApplicationException(fe.Message); } catch (CommunicationException ce) { client.Abort(); throw new ApplicationException(ce.Message); } return(agents); }