public void SelectClients()
{
Lootbox.ClearClients();
string sqlquery = @"select * from clients order by id";
SqlCommand sqlcmd = new SqlCommand(sqlquery, KEDR);
KEDR.Open();
using (SqlDataReader reader = sqlcmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
int id = (int)reader["id"];
string fname = (string)reader["f_name"];
string lname = (string)reader["l_name"];
string mname = (string)reader["m_name"];
float distance = (float)(double)reader["distance"];
int boxsize = (int)reader["box_size"];
System.DateTime stamp = (System.DateTime)reader["Stamp"];
Client client = new Client(id, fname, lname, mname, distance, (BoxSize)boxsize, stamp);
Lootbox.AddClient(client);
}
}
}
KEDR.Close();
}
