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); } }