public static ObservableCollection <BaseEntity> getPaginated(int start = 0, int number = 25)
{
ObservableCollection <BaseEntity> companies = new ObservableCollection <BaseEntity>();
using (var connection = DatabaseConnection.Instance.Connection)
{
MySqlCommand command = new MySqlCommand(
$"SELECT * FROM company LIMIT {start},{number};",
connection
);
var reader = command.ExecuteReader();
while (reader.Read())
{
Company company = new Company(reader);
companies.Add(company);
}
reader.Close();
}
foreach (Company company in companies)
{
Address address = AddressDataAccessObject.getAddressById(company.AddrId);
company.address = address;
}
return(companies);
}
public static ObservableCollection <BaseEntity> getPaginated(int start = 0, int number = 25)
{
ObservableCollection <BaseEntity> people = new ObservableCollection <BaseEntity>();
using (var connection = DatabaseConnection.Instance.Connection)
{
MySqlCommand command = new MySqlCommand(
$"SELECT * FROM person LIMIT {start},{number};",
connection
);
var reader = command.ExecuteReader();
while (reader.Read())
{
Person person = new Person(reader);
people.Add(person);
}
reader.Close();
foreach (Person person in people)
{
Address address = AddressDataAccessObject.getAddressById(person.AddrId);
person.address = address;
}
}
return(people);
}
public static Company getById(long id)
{
Company company = null;
using (var connection = DatabaseConnection.Instance.Connection)
{
MySqlCommand command = new MySqlCommand(
$"SELECT * FROM company WHERE id={id}",
connection
);
var reader = command.ExecuteReader();
while (reader.Read())
{
company = new Company(reader);
}
reader.Close();
}
Address address = AddressDataAccessObject.getAddressById(company.AddrId);
company.address = address;
return(company);
}
public static Person getById(long id)
{
Person person = null;
using (var connection = DatabaseConnection.Instance.Connection)
{
MySqlCommand command = new MySqlCommand(
$"SELECT * FROM person WHERE id={id}",
connection
);
var reader = command.ExecuteReader();
while (reader.Read())
{
person = new Person(reader);
}
reader.Close();
}
Address address = AddressDataAccessObject.getAddressById(person.AddrId);
person.address = address;
return(person);
}