public Argix.Enterprise.Clients GetClients()
{
//Get a list of clients
Argix.Enterprise.Clients clients = null;
try {
clients = new Argix.Enterprise.Clients();
DataSet ds = fillDataset(USP_CLIENTS, TBL_CLIENTS, new object[] { });
if (ds.Tables[TBL_CLIENTS].Rows.Count > 0)
{
ClientDS __clients = new ClientDS();
__clients.Merge(ds);
ClientDS _clients = new ClientDS();
_clients.Merge(__clients.InvoiceClientTable.Select("DivisionNumber='01'", "ClientName ASC"));
for (int i = 0; i < _clients.InvoiceClientTable.Rows.Count; i++)
{
if (InvoicingConfig.Document.DocumentElement.SelectSingleNode("//client[@number='" + _clients.InvoiceClientTable[i].ClientNumber + "']") != null)
{
Argix.Enterprise.Client client = new Argix.Enterprise.Client(_clients.InvoiceClientTable[i]);
clients.Add(client);
}
}
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new ApplicationException("Unexpected exception creating client list.", ex); }
return(clients);
}
public static Client GetClient(string clientNumber)
{
//Create a client
ClientDS client = null;
try {
client = new ClientDS();
DataSet ds = App.Mediator.FillDataset(USP_CLIENT_DETAIL, TBL_CLIENT_DETAIL, new object[] { clientNumber });
if (ds.Tables[TBL_CLIENT_DETAIL].Rows.Count == 0)
{
throw new Exception("Client number " + clientNumber + " not found.");
}
else
{
client.Merge(ds);
}
}
catch (Exception ex) { throw ex; }
return(new Client(client.ClientDetailTable[0]));
}
public static Client CreateClientForStoreSAN(string division, string sanNumber)
{
//Create a client based on Store san
Client client = null;
try {
DataSet ds = Mediator.FillDataset(USP_CLIENT_DETAIL_SAN, TBL_CLIENT_DETAIL, new object[] { division, sanNumber });
if (ds.Tables[TBL_CLIENT_DETAIL].Rows.Count == 0)
{
throw new ApplicationException("Client for san number " + sanNumber + " not found.");
}
else
{
ClientDS clientDS = new ClientDS();
clientDS.Merge(ds);
client = new Client(clientDS.ClientDetailTable[0]);
}
}
catch (ApplicationException ex) { throw ex; }
catch (Exception ex) { throw new ApplicationException("Unexpected exception creating client.", ex); }
return(client);
}
