/// <summary>
/// Загружает контрагентов из базы данных, возвращая объект List<Contractor>
/// </summary>
/// <returns></returns>
public static List <Contractor> Load()
{
using (SqliteConnection database = new SqliteConnection($"Filename={DatabasePath}"))
{
database.Open();
List <Contractor> result = new List <Contractor>(10);
SqliteCommand selectCommand = new SqliteCommand("SELECT * FROM ContractorTable", database);
SqliteDataReader reader = selectCommand.ExecuteReader();
while (reader.Read())
{
result.Add(new Contractor
{
ID = reader.GetInt32(0),
Name = reader.GetString(1),
PhoneNumber = reader.GetString(2),
Email = reader.GetString(3),
});
object photo = reader.GetValue(4);
result.ElementAt(result.Count - 1).Photo = DBNull.Value.Equals(photo) ?
null : XamlImageConverter.ConvertToImage((byte[])photo).Result;
}
database.Close();
return(result);
}
}
