public static List <Vehicle> SelectAll(SQLiteConnection conn)
{
List <Vehicle> result = new List <Vehicle>();
using (SQLiteCommand cmd = new SQLiteCommand(selectAll, conn))
{
SQLiteDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Vehicle vm = new Vehicle()
{
Id = Convert.ToInt32(reader["rowid"].ToString()),
VehicleType = VehicleTypeXmlMapper.SelectById(Convert.ToInt32(reader["VehicleTypeId"])),
VehicleBrand = VehicleBrandXmlMapper.SelectById(Convert.ToInt32(reader["VehicleBrandId"])),
Title = reader["Title"].ToString(),
Vin = reader["Vin"].ToString(),
LicensePlate = reader["LicensePlate"].ToString(),
Vintage = Convert.ToInt16(reader["Vintage"]),
PurchasedOn = Convert.ToDateTime(reader["PurchasedOn"]),
Price = Convert.ToDecimal(reader["Price"].ToString()),
Boss = UserBossDbMapper.SelectById(conn, Convert.ToInt32(reader["AdminId"])),
Driver = UserDriverDbMapper.SelectById(conn, Convert.ToInt32(reader["DriverId"]))
};
result.Add(vm);
}
}
catch (Exception e)
{
Trace.WriteLine($"EXCEPTION: VehicleDbMapper.SelectAll: {e.Message}");
}
finally
{
reader?.Close();
}
}
return(result);
}
public static Vehicle SelectById(SQLiteConnection conn, int id)
{
using (SQLiteCommand cmd = new SQLiteCommand(selectById, conn))
{
cmd.Parameters.AddWithValue("@Id", id);
SQLiteDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Vehicle vm = new Vehicle()
{
Id = Convert.ToInt32(reader["rowid"].ToString()),
VehicleType = VehicleTypeXmlMapper.SelectById(Convert.ToInt32(reader["VehicleTypeId"])),
VehicleBrand = VehicleBrandXmlMapper.SelectById(Convert.ToInt32(reader["VehicleBrandId"])),
Title = reader["Title"].ToString(),
Vin = reader["Vin"].ToString(),
LicensePlate = reader["LicensePlate"].ToString(),
Vintage = Convert.ToInt16(reader["Vintage"]),
PurchasedOn = Convert.ToDateTime(reader["PurchasedOn"]),
Price = Convert.ToDecimal(reader["Price"].ToString()),
Boss = UserBossDbMapper.SelectById(conn, Convert.ToInt32(reader["AdminId"])),
Driver = UserDriverDbMapper.SelectById(conn, Convert.ToInt32(reader["DriverId"]))
};
reader.Close();
return(vm);
}
}
catch (Exception e)
{
reader?.Close();
Trace.WriteLine($"EXCEPTION: VehicleDbMapper.SelectById: {e.Message}");
}
}
return(null);
}