public static SQLEngines GetInstance()
{
if (Instance == null)
{
Instance = new SQLEngines();
}
return(Instance);
}
public IEnumerable <CarClass> GetList()
{
string query = "SELECT * FROM cars";
MySqlDataReader reader = GetReader(query);
while (reader.Read())
{
int carId = int.Parse(reader[0].ToString());
BodyworkClass bodywork = SQLBodyworks.GetInstance().Search(reader[1].ToString());
EngineClass engine = SQLEngines.GetInstance().Search(reader[2].ToString());
ClientClass client = ClientService.SearchClientById(int.Parse(reader[3].ToString()));
int kilometrage = int.Parse(reader[4].ToString());
int cost = int.Parse(reader[5].ToString());
int carStatus = int.Parse(reader[6].ToString());
yield return(new CarClass(carId, bodywork, engine, client, kilometrage, cost, carStatus));
}
reader.Close();
}
public CarClass Search(string carId)
{
string query = "SELECT * FROM cars WHERE carId='" + carId + "'";
CarClass car = null;
MySqlDataReader reader = GetReader(query);
try
{
reader.Read();
BodyworkClass bodywork = SQLBodyworks.GetInstance().Search(reader[1].ToString());
EngineClass engine = SQLEngines.GetInstance().Search(reader[2].ToString());
ClientClass client = ClientService.SearchClientById(int.Parse(reader[3].ToString()));
int kilometrage = int.Parse(reader[4].ToString());
int cost = int.Parse(reader[5].ToString());
int carStatus = int.Parse(reader[6].ToString());
car = new CarClass(int.Parse(carId), bodywork, engine, client, kilometrage, cost, carStatus);
}
catch (Exception e) { Console.WriteLine(e.Message); }
finally { reader.Close(); }
return(car);
}
