public static List <Notification> GenerateNotifications(SQLiteConnection conn, int days)
{
List <Notification> result = new List <Notification>();
using (SQLiteCommand cmd = new SQLiteCommand(generateNotifications, conn))
{
cmd.Parameters.AddWithValue("@days", days);
SQLiteDataReader reader = null;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
Notification nm = new Notification()
{
Id = -1,
Inspection = InspectionDbMapper.SelectById(conn, Convert.ToInt32(reader["InspectionId"])),
Destination = "",
SentOn = DateTime.Now,
Delivered = DateTime.Now
};
var vehicle = VehicleDbMapper.SelectById(conn, Convert.ToInt32(reader["VehicleId"]));
var boss = UserBossDbMapper.SelectById(conn, vehicle.Boss.Id);
var email = boss.Email;
nm.Destination = email;
result.Add(nm);
}
}
catch (Exception e)
{
Trace.WriteLine($"EXCEPTION: NotificationDbMapper.SelectAll: {e.Message}");
}
finally
{
reader?.Close();
}
}
return(result);
}
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);
}