public static void UpdateVehicleStatus()
{
using (IDbConnection con = new SQLiteConnection(SQLiteDataAccess.GetConnectionString()))
{
SQLiteDataAccess.InstanceDB();
VehicleStatisticModel vehicleStat = new VehicleStatisticModel();
con.Query <VehicleModel>("UPDATE vehicletable SET VehicleStatus = 0");
}
}
public static VehicleStatisticModel GetVehicleStatistic(int id)
{
using (IDbConnection con = new SQLiteConnection(SQLiteDataAccess.GetConnectionString()))
{
SQLiteDataAccess.InstanceDB();
VehicleStatisticModel vehicleStat = new VehicleStatisticModel();
var vehicle = con.Query <VehicleModel>("SELECT * FROM vehicletable").FirstOrDefault(v => v.VehicleId == id);
vehicleStat.Distance = vehicle.Distance;
if (vehicle.VehicleStatus < (int)Enums.VehicleStatus.finishRace)
{
vehicleStat.Malfunction = vehicle.VehicleStatus;
}
else
{
vehicleStat.Status = vehicle.VehicleStatus;
}
vehicleStat.Time = vehicle.Time;
return(vehicleStat);
}
}
