public CompanyDataSet GetCompanies()
{
//Returns a list of companies
CompanyDataSet companies = new CompanyDataSet();
CRMServiceClient client = null;
try {
client = new CRMServiceClient();
DataSet ds = client.GetCompanies();
client.Close();
if (ds.Tables["CompanyTable"] != null && ds.Tables["CompanyTable"].Rows.Count > 0)
{
companies.Merge(ds.Tables["CompanyTable"].Select("", "CompanyName 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(companies);
}
public CompanyDataSet GetCompanies2()
{
//Returns a list of companies without the clientnumber hyphen (i.e. companyname - 001)
CompanyDataSet companies = new CompanyDataSet();
CRMServiceClient client = null;
try {
client = new CRMServiceClient();
DataSet ds = client.GetCompanies();
client.Close();
if (ds.Tables["CompanyTable"] != null && ds.Tables["CompanyTable"].Rows.Count > 0)
{
companies.Merge(ds.Tables["CompanyTable"].Select("", "CompanyName ASC"));
for (int i = 0; i < companies.CompanyTable.Count; i++)
{
companies.CompanyTable[i].CompanyName = companies.CompanyTable[i].CompanyName.Split(new string[] { "-" }, StringSplitOptions.RemoveEmptyEntries)[0].Trim();
}
}
}
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(companies);
}
