public CarAutopark GetAutoParkCarByID(int id)
{
CarAutopark car = null;
Open();
if (status)
{
string sql1 = "SELECT * from cars where id=" + id.ToString() + ";";
MySqlCommand myCommand = new MySqlCommand(sql1, conn);
MySqlDataReader reader;
reader = myCommand.ExecuteReader();
if (reader.Read())
{
car = new CarAutopark(Convert.ToInt32(reader[0].ToString()), reader[1].ToString(),
reader[2].ToString(), reader[3].ToString(), Convert.ToInt32(reader[4].ToString()),
reader[5].ToString(), Convert.ToInt32(reader[6].ToString()), reader[7].ToString(),
Convert.ToInt32(reader[8].ToString()));
}
base.Close();
reader.Close();
return(car);
}
else
{
MessageBox.Show("Error: ошибка получения автомобиля по ID");
base.Close();
return(null);
}
}
public CarBlock(CarAutopark myCar, object butL, object butR)
{
lastPhotoButTem = butL;
nextPhotoButTem = butR;
this.myCar = myCar;
myCarPhotos = menej.GetPhotosByCar(myCar.id);
}
public AuctionBlock(CarAutopark myCar, object butL, object butR, Auction auction)
{
this.auction = auction;
lastPhotoButTem = butL;
nextPhotoButTem = butR;
this.myCar = myCar;
myCarPhotos = menej.GetPhotosByCar(myCar.id);
}
public bool CreateCarFromAutoPark(CarAutopark c)
{
string sql1 = "INSERT INTO cars (`type`, `brend`, `model`, `year`, `fuel`, `mileage`, `context`, `id_user`) " +
"VALUES ('" + c.type + "', '" + c.brend + "', '" + c.model + "', '" + c.year + "', '" + c.fuel + "', '" + c.mileage + "', " +
"'" + c.context + "' , " + "'" + c.id_user.ToString() + "');";
try
{
MySqlCommand myCommand = new MySqlCommand(sql1, conn);
Open();
myCommand.ExecuteNonQuery();
Close();
return(true);
}
catch
{
MessageBox.Show("Ошибка создания авто в автопарке(объявления)");
Close();
return(false);
}
}
private void But_Add_Car(object sender, RoutedEventArgs e)
{
if (CheckInfoValid(brend, model, body_type, year, fuel, milleage, context))
{
try
{
TryAddContext();
if (ver03.Properties.Settings.Default.Autoriz)
{
sp_CarPhotos.Children.Clear();
Thread thread = new Thread(UpCarInfo);
thread.Start();
void UpCarInfo()
{
CarAutopark car = new CarAutopark(-1, body_type, brend, model,
year, fuel, milleage, context, ver03.Properties.Settings.Default.UserID);
dbf.CreateCarFromAutoPark(car); //+
int carId = dbl.GetLastCarID(); //+
menej.FTPCreateCarPhotoFolder(carId); //+
foreach (CarPhoto uri in carPhotos)
{
menej.UploadCarPhoto(carId, uri.fullName, uri.name);
}
}
}
else
{
MessageBox.Show("Нужна авторизация");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void CreateCarBlock(CarAutopark car)
{
CarBlock cb = new CarBlock(car, FindResource("LastPhoto"), FindResource("NextPhoto"));
spCarList.Children.Add(cb.GetBlock());
}
void LoadCar()
{
car = dbl.GetAutoParkCarByID(auct.car_id);
}
