public List <CarPictureModel> GetAllCarImagesAndNumberOfCars()
{
DataTable dt = new DataTable();
List <CarPictureModel> arrCarPictures = new List <CarPictureModel>();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(CarStringsMySql.GetAllCarImagesAndNumberOfCars());
}
foreach (DataRow ms in dt.Rows)
{
CarPictureModel carPictureModel = CarPictureModel.ToObject(ms);
arrCarPictures.Add(carPictureModel);
}
return(arrCarPictures);
}
public CarPictureModel GetNumberOfCarWithImage(string pictureName)
{
if (pictureName.Equals(""))
{
throw new ArgumentOutOfRangeException();
}
DataTable dt = new DataTable();
CarPictureModel carPictureModelSql = new CarPictureModel();
using (MySqlCommand command = new MySqlCommand())
{
dt = GetMultipleQuery(CarStringsMySql.GetNumberOfCarWithImage(pictureName));
}
foreach (DataRow ms in dt.Rows)
{
carPictureModelSql = CarPictureModel.ToObject(ms);
}
return(carPictureModelSql);
}
