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