public static List <string> GetModels(int brandId)
{
List <string> models = new List <string>();
var carBrandsSqlResult = MySqlExecuter.SelectData($"SELECT Name FROM car_models WHERE Brand_Id='{brandId}' AND Name<>''", MySqlRouter.GetConnectionString());
if (carBrandsSqlResult.HasError)
{
throw new Exception(carBrandsSqlResult.ErrorText);
}
else
{
foreach (DataRow row in carBrandsSqlResult.ResultData.Rows)
{
models.Add(row["Name"].ToString());
}
return(models);
}
}
public static List <Brand> GetAllBrands()
{
List <Brand> cars = new List <Brand>();
var carBrandsSqlResult = MySqlExecuter.SelectData("SELECT Id, Name FROM car_brands WHERE Name<>''", MySqlRouter.GetConnectionString());
if (carBrandsSqlResult.HasError)
{
throw new Exception(carBrandsSqlResult.ErrorText);
}
else
{
foreach (DataRow row in carBrandsSqlResult.ResultData.Rows)
{
int id = Int32.Parse(row["Id"].ToString());
string brand = row["Name"].ToString();
cars.Add(new Brand(id, brand));
}
return(cars);
}
}