public static async Task <VehicleData> CreateVehicle(VehicleData vehicleData)
{
string query = $@"INSERT INTO Vehicles (`vehicle_name`, `owner_id`, `position_x`, `position_y`, `position_z`) VALUES ('{vehicleData.VehicleName}', {vehicleData.OwnerId}, {vehicleData.PositionX}, {vehicleData.PositionY}, {vehicleData.PositionZ});";
using (MySqlCommand command = new MySqlCommand(query, Main.Connection))
{
try
{
await command.ExecuteNonQueryAsync();
vehicleData.Id = (uint)command.LastInsertedId;
return(vehicleData);
}
catch (Exception e)
{
Main.Logger.LogError(e.Message);
}
}
return(null);
}
public static async void SaveVehicle(VehicleData vehicleData)
{
string query = $@"UPDATE Vehicles SET
`owner_id` = '{vehicleData.OwnerId}',
`position_x` = '{vehicleData.PositionX}',
`position_y` = '{vehicleData.PositionY}',
`position_z` = '{vehicleData.PositionZ}',
`heading` = '{vehicleData.Heading}',
`color_1` = {vehicleData.Color1},
`color_2` = {vehicleData.Color2} WHERE id = {vehicleData.Id}";
using (MySqlCommand command = new MySqlCommand(query, Main.Connection))
{
try
{
await command.ExecuteNonQueryAsync();
}
catch (Exception e)
{
Main.Logger.LogError(e.Message);
}
}
}
public static async Task <VehicleData> GetVehicleData(uint vehicleId)
{
string query = $"SELECT * FROM `vehicles` WHERE `id` = {vehicleId}";
using (MySqlCommand command = new MySqlCommand(query, Main.Connection))
{
try
{
using (DbDataReader reader = await command.ExecuteReaderAsync())
{
if (reader.HasRows)
{
reader.Read();
VehicleData vehicleData = new VehicleData()
{
Id = (uint)reader[0],
VehicleName = reader[1].ToString(),
Color1 = (int)reader[2],
Color2 = (int)reader[3],
PositionX = reader.FloatOrNull(4),
PositionY = reader.FloatOrNull(5),
PositionZ = reader.FloatOrNull(6),
Heading = reader.FloatOrNull(7),
OwnerId = uint.Parse(reader[8].ToString())
};
return(vehicleData);
}
}
}
catch (Exception e)
{
Main.Logger.LogError(e.Message);
}
}
return(null);
}