/// <summary>
/// Get a single client from the database
/// </summary>
/// <param name="id">The ID of the client to find</param>
/// <returns>a Client if found; null if client not found</returns>
public Client GetClientById(int id)
{
DataSet ds = new DataSet();
DataSetTableAdapters.clientsTableAdapter adapter = new DataSetTableAdapters.clientsTableAdapter();
adapter.Fill(ds.clients);
Client c = new Client();
// find the client
DataSet.clientsDataTable table = adapter.GetClientById(id);
// if a client was found, then fill in the details
if (table.Rows.Count > 0)
{
// use the 1st row's data
DataSet.clientsRow row = (DataSet.clientsRow)table.Rows[0];
c.ID = row.clientId;
c.Name = row.clientName;
c.Address = row.clientAddress;
c.City = row.clientCity;
c.State = row.clientState;
c.Zip = row.clientZip;
c.Phone = row.clientPhone;
c.ContactName = row.clientContactName;
return c;
}
else
{
return null;
}
}
/// <summary>
/// Gets all clients from database
/// </summary>
/// <returns>List Generic Class</returns>
public List<Client> GetClients()
{
List<Client> clients = new List<Client>();
DataSet ds = new DataSet();
DataSetTableAdapters.clientsTableAdapter adapter = new DataSetTableAdapters.clientsTableAdapter();
adapter.Fill(ds.clients);
DataSet.clientsDataTable table = adapter.GetClientData();
// load all clients into the list
foreach (DataSet.clientsRow row in table.Rows)
{
// create memory for new client & fill in properties
Client c = new Client();
c.ID = row.clientId;
c.Name = row.clientName;
c.Address = row.clientAddress;
c.City = row.clientCity;
c.State = row.clientState;
c.Zip = row.clientZip;
c.Phone = row.clientPhone;
c.ContactName = row.clientContactName;
// add this client to the list
clients.Add(c);
}
// returns the list w/ 0 or more Clients
return clients;
}
/// <summary>
/// Update a client to the database
/// </summary>
/// <param name="c">a client</param>
/// <returns># of rows affected</returns>
public int UpdateClient(Client c)
{
return UpdateClient(c.ID, c.Name, c.Address, c.City, c.State, c.Zip, c.Phone, c.ContactName);
}
/// <summary>
///
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public int DeleteClient(Client c)
{
return DeleteClient(c.ID);
}
/// <summary>
/// Insert a new client into the database
/// </summary>
/// <param name="c"></param>
/// <returns></returns>
public int InsertClient(Client c)
{
return InsertClient(c.Name, c.Address, c.City, c.State, c.Zip, c.Phone, c.ContactName);
}