public Car_Engine Get(int id)
{
Car_Engine car_Engine = null;
using (var connection = Database.GetConnection())
{
var command = new SqlCommand("SELECT * FROM Car_Engine WHERE IDengine=@id", connection);
command.Parameters.AddWithValue("id", id);
connection.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
car_Engine = new Car_Engine(
reader.GetInt32(0),
reader.GetDecimal(1),
reader.GetInt32(2),
reader.GetString(3)
);
}
}
connection.Close();
}
return(car_Engine);
}
private void SetComponents()
{
rb = transform.root.GetComponent <Rigidbody>();
body = transform.root.GetComponent <Car_Body>();
engine = transform.root.GetComponent <Car_Engine>();
wheelObject = transform.GetChild(0);
}
public List <Car_Engine> GetAll()
{
var Car_EngineList = new List <Car_Engine>();
using (var connection = Database.GetConnection())
{
var command = new SqlCommand("SELECT * FROM Car_Engine", connection);
connection.Open();
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var car_Engine = new Car_Engine(
reader.GetInt32(0),
reader.GetDecimal(1),
reader.GetInt32(2),
reader.GetString(3)
);
Car_EngineList.Add(car_Engine);
}
}
connection.Close();
}
return(Car_EngineList);
}
private void Start()
{
body = transform.root.GetComponent <Car_Body>();
engine = transform.root.GetComponent <Car_Engine>();
rb = transform.root.GetComponent <Rigidbody>();
front = frontWheel ? 1 : -1;
passanger = PassangerWheel ? -1 : 1;
}
private void Add()
{
Car_Engine car_Engine = new Car_Engine();
Console.WriteLine("Enter Cubes: ");
car_Engine.Cubes = decimal.Parse(Console.ReadLine());
Console.WriteLine("Enter HP: ");
car_Engine.HP = int.Parse(Console.ReadLine());
Console.WriteLine("Enter Fuel: ");
car_Engine.Fuel = Console.ReadLine();
car_EngineWork.Add(car_Engine);
}
public void Update(Car_Engine car_Engine)
{
using (var connection = Database.GetConnection())
{
var command = new SqlCommand("UPDATE Car_Engine SET Cubes=@cubes, HP=@hp, Fuel=@fuel WHERE IDengine=@id", connection);
command.Parameters.AddWithValue("id", car_Engine.IDengine);
command.Parameters.AddWithValue("cubes", car_Engine.Cubes);
command.Parameters.AddWithValue("hp", car_Engine.HP);
command.Parameters.AddWithValue("fuel", car_Engine.Fuel);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
public void Add(Car_Engine car_Engine)
{
using (var connection = Database.GetConnection())
{
var command = new SqlCommand("INSERT INTO Car_Engine (Cubes, HP, Fuel) VALUES( @cubes, @hp, @fuel)", connection);
command.Parameters.AddWithValue("cubes", car_Engine.Cubes);
command.Parameters.AddWithValue("hp", car_Engine.HP);
command.Parameters.AddWithValue("fuel", car_Engine.Fuel);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
private void Fetch()
{
Console.WriteLine("Enter ID to fetch: ");
int id = int.Parse(Console.ReadLine());
Car_Engine car_Engine = car_EngineWork.Get(id);
if (car_Engine != null)
{
Console.WriteLine(new string('-', 40));
Console.WriteLine("ID: " + car_Engine.IDengine);
Console.WriteLine("Cubes: " + car_Engine.Cubes);
Console.WriteLine("HP: " + car_Engine.HP);
Console.WriteLine("Fuel: " + car_Engine.Fuel);
Console.WriteLine(new string('-', 40));
}
}
private void Update()
{
Console.WriteLine("Enter ID to update: ");
int id = int.Parse(Console.ReadLine());
Car_Engine car_Engine = car_EngineWork.Get(id);
if (car_Engine != null)
{
Console.WriteLine("Enter Cubes: ");
car_Engine.Cubes = decimal.Parse(Console.ReadLine());
Console.WriteLine("Enter HP: ");
car_Engine.HP = int.Parse(Console.ReadLine());
Console.WriteLine("Enter Fuel: ");
car_Engine.Fuel = Console.ReadLine();
car_EngineWork.Update(car_Engine);
}
else
{
Console.WriteLine("Engine not found!");
}
}
public void Update(Car_Engine car_Engine)
{
manager.Update(car_Engine);
}
public void Add(Car_Engine car_Engine)
{
manager.Add(car_Engine);
}
private void Start()
{
engine = transform.root.GetComponent <Car_Engine>();
startRotation = steeringWheel.localRotation;
}
