/// <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>
///
/// </summary>
/// <param name="clientId"></param>
/// <returns></returns>
public int DeleteClient(int clientId)
{
DataSet ds = new DataSet();
DataSetTableAdapters.clientsTableAdapter adapter = new DataSetTableAdapters.clientsTableAdapter();
return adapter.Delete(clientId);
}
/// <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="id"></param>
/// <param name="name"></param>
/// <param name="address"></param>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="zip"></param>
/// <param name="phone"></param>
/// <param name="contactName"></param>
/// <returns># of rows affected</returns>
public int UpdateClient(int id, String name, String address, String city, String state, String zip, String phone, String contactName)
{
DataSet ds = new DataSet();
DataSetTableAdapters.clientsTableAdapter adapter = new DataSetTableAdapters.clientsTableAdapter();
return adapter.Update(name, address, city, state, zip, phone, contactName, id);
}
/// <summary>
///
/// </summary>
/// <param name="name"></param>
/// <param name="address"></param>
/// <param name="city"></param>
/// <param name="state"></param>
/// <param name="zip"></param>
/// <param name="phone"></param>
/// <param name="contactName"></param>
/// <returns></returns>
public int InsertClient(String name, String address, String city, String state, String zip, String phone, String contactName)
{
DataSet ds = new DataSet();
DataSetTableAdapters.clientsTableAdapter adapter = new DataSetTableAdapters.clientsTableAdapter();
return adapter.Insert(name, address, city, state, zip, phone, contactName);
}