public override IEnumerable <Car> GetAll()
{
connection.Command.Parameters.Clear();
connection.Command.CommandText = "select * from общиемашины";
CarList list = new CarList();
using (MySqlDataReader reader = connection.Command.ExecuteReader())
{
if (reader.HasRows) // если есть данные
{
while (reader.Read())
{
var x = reader.GetValue(3);
var y = reader.GetValue(4);
if (x.GetType() == typeof(DBNull))
{
list.Add(new Van((int)reader.GetValue(0), (double)reader.GetValue(2), (int)reader.GetValue(4)));
}
else if (y.GetType() == typeof(DBNull))
{
list.Add(new Truck((int)reader.GetValue(0), (double)reader.GetValue(2), (double)reader.GetValue(3)));
}
else
{
list.Add(new Bus((int)reader.GetValue(0), (double)reader.GetValue(2), (double)reader.GetValue(3), (int)reader.GetValue(4)));
}
}
}
}
return(list);
}
private void CreateCar()
{
var cd = new CarDialog();
var result = cd.ShowDialog();
if (result != true)
{
return;
}
int dCount;
int wCount;
if (int.TryParse(cd.DoorCountTextBox.Text, out dCount) &&
int.TryParse(cd.WheelCountTextBox.Text, out wCount))
{
var car = new Car(wCount, dCount)
{
DetailNumber = CarList.Count + 1
};
CarList.Add(car);
}
else
{
MessageBox.Show("¬ведены неверные параметры автомобил¤!");
}
}
public ActionResult Create()
{
Random random = new Random();
int id = random.Next(00000, 99999);
var created = false;
if (HttpContext.Request.Method == "POST")
{
var name = Request.Form["name"];
var color = Request.Form["color"];
var plaque = Request.Form["plaque"];
if (Parking.carsCount() < 5)
{
Parking cars = new Parking()
{
ID = id,
Name = name,
Color = color,
Plaque = plaque,
EnterDate = DateTime.Now,
};
var DummyDataFile = Parking.DummyDataFile;
var DummyData = System.IO.File.ReadAllText(DummyDataFile);
List <Parking> CarList = new List <Parking>();
CarList = JsonConvert.DeserializeObject <List <Parking> >(DummyData);
if (CarList == null)
{
CarList = new List <Parking>();
}
CarList.Add(cars);
System.IO.File.WriteAllText(DummyDataFile, JsonConvert.SerializeObject(CarList));
created = true;
}
else
{
ViewBag.Warning = "AutoPark Full | Not car add";
}
}
if (created)
{
ViewBag.Message = "Car was created succesfully!...";
return(RedirectToAction("Index", "Parking"));
}
return(View());
}
public void City()
{
CarList <City> cities = new CarList <City>();
dbCars.GetCity();
foreach (City cc in dbCars.cities)
{
cities.Add(cc);
}
cmbx_city.DataSource = cities.GettAllData();
cmbx_city.DisplayMember = "CityName";
}
public async void Cars()
{
var cars = await carService.GetMyCars();
userid = cars[0].UserId;
foreach (CarDto car in cars)
{
CarList.Add(car.Model);
}
//OnPropertyChanged(nameof(CarList));
}
public void AddCar(int type)
{
if (GetFreePlacesCount() == 0)
{
Console.WriteLine("No enough free space");
return;
}
LastAddedCarId++;
var car = new Car(LastAddedCarId, type);
CarList.Add(car);
}
public bool AddCar(Car car)
{
if (!CarList.Contains(car))
{
CarList.Add(car);
return(true);
}
else
{
return(false);
}
}
public override void Save()
{
int id;
int.TryParse(_provider.Insert("Car", ID, _number, Grz, vin, Year, eNumber, bodyNumber, GradeID, ColorID, _isLising, _lisingDate, _invertoryNumber), out id);
ID = id;
CarList carList = CarList.getInstance();
carList.Add(this);
saveCarBuy();
}
public void CarMarka()
{
CarList <CarMarka> cars = new CarList <CarMarka>();
dbCars.GetCarsMarka();
Table <CarMarka> marka = dbCars.marka;
foreach (CarMarka marka1 in marka)
{
cars.Add(marka1);
}
cmbx_marka.DataSource = cars.GettAllData();
cmbx_marka.DisplayMember = "Markas";
}
public int Load(CarList carList)
{
var cars = dbContext.Cars;
int maxId = 0;
foreach (CarModel car in cars)
{
if (car.Id > maxId)
{
maxId = car.Id;
}
carList.Add(car);
}
return(maxId);
}
/// <summary>
/// Pobieram liste samochodów tego użytkownika
/// </summary>
public async void getCarList()
{
try
{
CarList.Clear();
var cars = await _carService.GetMyCars();
foreach (var car in cars)
{
CarList.Add(car);
}
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
public void UpdateCarList()
{
CarList.Clear();
var results = _gameDB.ExecuteQuery(
"SELECT " +
"V.VehicleName " +
"FROM Vehicles V " +
"INNER JOIN Manufacturers M " +
"ON M.ManufacturerID = V.VehicleManufacturerID " +
"WHERE " +
$"M.ManufacturerName = '{cb_Manufacturers.SelectedItem.ToString()}' " +
"ORDER BY VehicleName ");
while (results.Read())
{
CarList.Add(results.GetString(0));
}
lv_CarList.ItemsSource = null;
lv_CarList.ItemsSource = CarList;
}
static private int LoadFromAFile(string filename, CarList carList)
{
if (File.Exists(filename))
{
string json = File.ReadAllText(filename);
carList.Clear();
int maxId = 0;
CarList loadedList = JsonConvert.DeserializeObject <CarList>(json);
foreach (var car in loadedList)
{
if (car.Id > maxId)
{
maxId = car.Id;
}
carList.Add(car);
}
return(maxId + 1);
}
else
{
return(0);
}
}
