public static List <InsuranceAgency> GetInsuranceAgencies()
{
var agencies = new List <InsuranceAgency>();
var sql = $"SELECT * FROM {Fieldnames.InsuranceAgencys.TableName}";
using (var c = new SQLiteConnection(@"Data Source = ..\..\..\..\DB\MYDb.db; Version = 3;"))
{
c.Open();
using (var command = new SQLiteCommand(sql, c))
{
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var id = reader.GetInt32((int)Fieldnames.InsuranceAgencys.Index.Id);
var addressId = reader.GetInt32((int)Fieldnames.InsuranceAgencys.Index.Address);
var note = reader.GetString((int)Fieldnames.InsuranceAgencys.Index.Note);
Address address = GetAddress(addressId);
var agency = new InsuranceAgency();
agency.SetValues(id, address, note);
agencies.Add(agency);
}
}
}
}
return(agencies);
}
private static InsuranceAgency GetInsuranceAgency(int insuranceAgencyId)
{
var insuranceAgency = new InsuranceAgency();
var sql = $"SELECT * FROM {Fieldnames.InsuranceAgencys.TableName} WHERE ID = " +
Convert.ToString(insuranceAgencyId);
using (var c = new SQLiteConnection(@"Data Source = ..\..\..\..\DB\MYDb.db; Version = 3;"))
{
c.Open();
using (var command = new SQLiteCommand(sql, c))
{
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
var id = reader.GetInt32((int)Fieldnames.InsuranceAgencys.Index.Id);
var addressId = reader.GetInt32((int)Fieldnames.InsuranceAgencys.Index.Address);
var note = reader.GetString((int)Fieldnames.InsuranceAgencys.Index.Note);
var address = GetAddress(addressId);
insuranceAgency.SetValues(id, address, note);
}
else
{
throw DataError;
}
}
}
}
return(insuranceAgency);
}