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; }