public static void LoadClients(SqlDataReader reader)
        {
            while (reader.Read())
            {
                Client client = new Client();

                client.ClientID = (int)reader["ClientID"];
                client.FirstName = reader["FirstName"].ToString();
                client.LastName = reader["LastName"].ToString();
                client.Email = reader["email"].ToString();
                client.IsChanged = false;

                clients.Add(client);
            }
        }
        public static void UpdateClients()
        {
            string query1 = string.Empty;
            string query2 = string.Empty;
            Client tmpClient = new Client();
            SqlCommand command;
            SqlDataReader reader;
            List<int> changedData;

            query1 = "select * from Clients";
            command = new SqlCommand(query1, DataBase.Sql);
            reader = command.ExecuteReader();

            changedData = new List<int>();

            foreach (Client client in ClientsManager.Clients)
            {  
                if (client.IsChanged) changedData.Add(client.ClientID);
            }
            while (reader.Read())
            {
                if (changedData.Contains((int)reader["ClientID"]))
                {
                    foreach (Client client in ClientsManager.Clients)
                    {
                        if (client.ClientID == ((int)reader["ClientID"]))
                        {
                            tmpClient = client;
                            break;
                        }
                    }
                    query2 = string.Format("update Clients set FirstName = '{0}' where ClientID = {1}", tmpClient.FirstName, tmpClient.ClientID);
                    (new SqlCommand(query2, DataBase.Sql)).ExecuteNonQuery();
                    query2 = string.Format("update Clients set LastName = '{0}' where ClientID = {1}", tmpClient.LastName, tmpClient.ClientID);
                    (new SqlCommand(query2, DataBase.Sql)).ExecuteNonQuery();
                    query2 = string.Format("update Clients set email = '{0}' where ClientID = {1}", tmpClient.Email, tmpClient.ClientID);
                    (new SqlCommand(query2, DataBase.Sql)).ExecuteNonQuery();

                    tmpClient.IsChanged = false;
                }
            }

            reader.Close();
        }
 public ClientForCB(Client cl)
 {
     clientFromList = cl;
     name = string.Format("{0} {1} {2}", cl.ClientID, cl.FirstName, cl.LastName);
 }