public static AddressRecord GetAddress(int addressId)
{
String query = $"SELECT * FROM addresses WHERE addressId={addressId}";
DataTable addresses = connector.ExecuteQuery(query);
var record = new AddressRecord();
if (addresses.Rows.Count == 0)
{
return(null);
}
record.Fill(addresses.Rows[0]);
return(record);
}
public static AddressRecord GetAddress(int clientId, String country, String city, String street, int ZIPCode, int buildingNumber, String apartmentNumber)
{
var query = $"SELECT * FROM addresses WHERE clientId={clientId} and country='{country}' and city='{city}' and street='{street}' and ZIPCode={ZIPCode} and buildingNumber={buildingNumber} and apartmentNumber='{apartmentNumber}'";
var addresses = connector.ExecuteQuery(query);
if (addresses.Rows.Count == 0)
{
return(null);
}
var record = new AddressRecord();
record.Fill(addresses.Rows[0]);
return(record);
}
public static List <AddressRecord> GetAddresses(int clientId)
{
List <AddressRecord> addressRecords = new List <AddressRecord>();
String query = $"SELECT * FROM addresses WHERE clientId={clientId}";
DataTable addresses = connector.ExecuteQuery(query);
foreach (DataRow dr in addresses.Rows)
{
var record = new AddressRecord();
record.Fill(dr);
addressRecords.Add(record);
}
return(addressRecords);
}