public static void PrintClientCollection(ClientCollection clients) { string divider = new string('-', 70); Console.WriteLine($"{"CompanyName",-35} {"City",-16} {"Prov",-4} {"Postal",-7} {"Hold",1}\n{divider}"); foreach (Client client in clients) { PrintClient(client); } }
public static ClientCollection GetAllClients() { ClientCollection clients; using (SqlConnection conn = new SqlConnection(connString)) { string query; query = @"SELECT ClientCode, CompanyName, Address1, Address2, City, Province, PostalCode, YTDSales, CreditHold, Notes FROM Client ORDER BY CompanyName; "; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.Text; cmd.CommandText = query; cmd.Connection = conn; conn.Open(); clients = new ClientCollection(); using (SqlDataReader reader = cmd.ExecuteReader()) { string clientCode; // not null 0 string companyName; // not null 1 string address1; // not null 2 string address2 = null; //null 3 string city = null; //null 4 string province; // not null 5 string postalCode = null; //null 6 decimal ytdSales; //not null 7 bool creditHold; //not null string notes = null; //null 9 while (reader.Read()) { clientCode = reader["ClientCode"] as string; // 0 companyName = reader["CompanyName"] as string; // 1 address1 = reader["Address1"] as string; // 2 if (!reader.IsDBNull(3)) { address2 = reader["Address2"] as string; } if (!reader.IsDBNull(4)) { city = reader["City"] as string; } province = reader["Province"] as string; //5 if (!reader.IsDBNull(6)) { postalCode = reader["PostalCode"] as string; } ytdSales = (decimal)reader["YTDSales"]; //7 creditHold = (bool)reader["CreditHold"]; //8 if (!reader.IsDBNull(9)) { notes = reader["Notes"] as string; } clients.Add(new Client(clientCode, companyName, address1, address2, city, province, postalCode, ytdSales, creditHold, notes)); clientCode = null; companyName = null; address1 = null; province = null; ytdSales = 0; creditHold = false; } } return(clients); } } }
public ClientViewModel(ClientCollection clients) { this.Clients = clients; }