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