/// <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; }