public static ClientInfoRecord GetClient(int clientId)
        {
            String    query   = $"SELECT * FROM clients WHERE clientId='{clientId}'";
            DataTable clients = connector.ExecuteQuery(query);

            if (clients.Rows.Count == 0)
            {
                return(null);
            }
            var record = new ClientInfoRecord();

            record.Fill(clients.Rows[0]);
            return(record);
        }
        public static ClientInfoRecord GetClient(string email, string password)
        {
            String    query   = $"SELECT * FROM clients WHERE email='{email}' and password='******'";
            DataTable clients = connector.ExecuteQuery(query);

            if (clients.Rows.Count == 0)
            {
                return(null);
            }
            var record = new ClientInfoRecord();

            record.Fill(clients.Rows[0]);
            return(record);
        }
        public static List <ClientInfoRecord> GetClients()
        {
            List <ClientInfoRecord> clientsRecords = new List <ClientInfoRecord>();

            String    query   = "SELECT * FROM clients";
            DataTable clients = connector.ExecuteQuery(query);

            foreach (DataRow dr in clients.Rows)
            {
                var record = new ClientInfoRecord();
                record.Fill(dr);
                clientsRecords.Add(record);
            }
            return(clientsRecords);
        }