protected override void Load() { Kunden.Clear(); foreach (KundeDto kunde in Service.GetKunden()) { Kunden.Add(kunde); } Autos.Clear(); foreach (AutoDto auto in Service.GetAutos()) { Autos.Add(auto); } Reservationen.Clear(); reservationenOriginal.Clear(); foreach (ReservationDto res in Service.GetReservationen()) { Reservationen.Add(res); reservationenOriginal.Add((ReservationDto)res.Clone()); } selectedReservation = Reservationen.FirstOrDefault(); reservationen.ToList().ForEach(r => { r.Auto = Autos.ToList().Find(a => a.Id == r.Auto.Id); r.Kunde = Kunden.ToList().Find(k => k.Id == r.Kunde.Id); }); }
private int AsignarNumeroVehiculo() { int numero = 0; while (true) { numero++; if (cbxTipoVehiculo.SelectedIndex == 0) { if (!Aviones.Exists(x => x.Numero == numero)) { break; } } if (cbxTipoVehiculo.SelectedIndex == 1) { if (!Autos.Exists(x => x.Numero == numero)) { break; } } if (cbxTipoVehiculo.SelectedIndex == 2) { if (!Colectivos.Exists(x => x.Numero == numero)) { break; } } } return(numero); }
public int actualizarAutos(Autos objAuto) { int cantidadRegistros = -1; //La estructura using es para crear recursos que solo van a existir en memoria dentro de su bloque de programación using (SqlConnection sqlCon = new SqlConnection(cadenaConexion)) { //Todos los recursos que se crean dentro de este bloque, serán automaticamente destruidos cuando se termine el bloque de programacion SqlCommand cmd = new SqlCommand(); cmd.Connection = sqlCon; cmd.CommandType = CommandType.Text; cmd.CommandText = "Update Autos " + "set MARCA = @MARCA, " + " MODELO = @MODELO, " + " PAIS = @PAIS, " + " COSTO = @COSTO " + "Where IDCARRO = @IDCARRO "; cmd.Parameters.Add(new SqlParameter("@MARCA", objAuto.MARCA)); cmd.Parameters.Add(new SqlParameter("@MODELO", objAuto.MODELO)); cmd.Parameters.Add(new SqlParameter("@PAIS", objAuto.PAIS)); cmd.Parameters.Add(new SqlParameter("@COSTO", objAuto.COSTO)); cmd.Parameters.Add(new SqlParameter("@IDCARRO", objAuto.IDCARRO)); sqlCon.Open(); cantidadRegistros = cmd.ExecuteNonQuery(); //Aqui estamos realizando el Insert en base de datos. sqlCon.Close(); } return(cantidadRegistros); }
public ActionResult Create([Bind(Include = "ID,MakeID,ModeLID,ColorID,RegistryNum")] Autos autos) { //ViewData["usID"] = ID; autos.UserID = Convert.ToInt32(Session["id"]); if (ModelState.IsValid) { db.Autos.Add(autos); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ColorID = new SelectList(db.Colors, "ID", "Color", autos.ColorID); ViewBag.MakeID = new SelectList(db.Makes, "ID", "Make", autos.MakeID); ViewBag.ModeLID = new SelectList(db.CarModels, "ID", "CarModel", autos.ModeLID); ViewBag.UserID = new SelectList(db.Users, "ID", "Email", autos.UserID); if (Session["role"].ToString() == "admin") { return(View(autos)); } else { return(View("UserCreate", autos)); } }
private void bmnNuevoVehiculo_Click(object sender, EventArgs e) { frmNuevoVehiculo form = new frmNuevoVehiculo(); form.Owner = this; form.Aviones = Aviones; form.Autos = Autos; form.Colectivos = Colectivos; form.ShowDialog(); if (form.estado) { if (form.tipo == 0) { Aviones.Add(form.Avion); srcAviones.ResetBindings(true); dgvAviones.Refresh(); } else if (form.tipo == 1) { Autos.Add(form.Auto); srcAutos.ResetBindings(true); dgvAutos.Refresh(); } else { Colectivos.Add(form.Colectivo); srcColectivos.ResetBindings(true); dgvColectivos.Refresh(); } } }
protected void ExtraModelToEntity(Autos entity, AutosModel model, ActionTypes actionType) { if (actionType == ActionTypes.Add) { entity.AutoMaterialRsps = new List<AutoMaterialRsp>(); var materialManager = GlobalConfiguration.Configuration.DependencyResolver.GetService<IMaterialsManager>(); foreach (var material in materialManager.GetEntities().Where(o => !o.DeleteDate.HasValue && o.IsForAuto).ToList()) { entity.AutoMaterialRsps.Add(new AutoMaterialRsp() { Amount = 0, Autos = entity, MaterialId = material.Id }); } entity.AutoInstrumentRsps = new List<AutoInstrumentRsp>(); var instrumentManager = GlobalConfiguration.Configuration.DependencyResolver.GetService<IInstrumentsManager>(); foreach (var instrument in instrumentManager.GetEntities().Where(o => !o.DeleteDate.HasValue && o.IsForAuto).ToList()) { entity.AutoInstrumentRsps.Add(new AutoInstrumentRsp() { Amount = 0, Autos = entity, InstrumentId = instrument.Id }); } } }
protected void ExtraModelToEntity(Autos entity, AutosModel model, ActionTypes actionType) { if (actionType == ActionTypes.Add) { entity.AutoMaterialRsps = new List <AutoMaterialRsp>(); var materialManager = GlobalConfiguration.Configuration.DependencyResolver.GetService <IMaterialsManager>(); foreach (var material in materialManager.GetEntities().Where(o => !o.DeleteDate.HasValue && o.IsForAuto).ToList()) { entity.AutoMaterialRsps.Add(new AutoMaterialRsp() { Amount = 0, Autos = entity, MaterialId = material.Id }); } entity.AutoInstrumentRsps = new List <AutoInstrumentRsp>(); var instrumentManager = GlobalConfiguration.Configuration.DependencyResolver.GetService <IInstrumentsManager>(); foreach (var instrument in instrumentManager.GetEntities().Where(o => !o.DeleteDate.HasValue && o.IsForAuto).ToList()) { entity.AutoInstrumentRsps.Add(new AutoInstrumentRsp() { Amount = 0, Autos = entity, InstrumentId = instrument.Id }); } } }
protected void LoadActive() { Reservationen.Clear(); Kunden.Clear(); Autos.Clear(); foreach (KundeDto kunde in Service.Kunde) { Kunden.Add(kunde); } foreach (AutoDto auto in Service.Autos) { Autos.Add(auto); } foreach (ReservationDto reservation in Service.Reservation) { if (DateTime.Now > reservation.Bis) { } else { Reservationen.Add(reservation); } } SelectedReservation = Reservationen.FirstOrDefault(); }
protected void GridAutos_RowUpdating(object sender, GridViewUpdateEventArgs e) { objGestion = new GestionBD(); Autos objAutos = new Autos(); objAutos.MARCA = (GridAutos.Rows[e.RowIndex].FindControl("txtMARCA") as TextBox).Text.Trim(); objAutos.MODELO = (GridAutos.Rows[e.RowIndex].FindControl("txtMODELO") as TextBox).Text.Trim(); objAutos.PAIS = (GridAutos.Rows[e.RowIndex].FindControl("txtPAIS") as TextBox).Text.Trim(); objAutos.COSTO = Convert.ToDouble((GridAutos.Rows[e.RowIndex].FindControl("txtCOSTO") as TextBox).Text.Trim()); objAutos.IDCARRO = Convert.ToInt32(GridAutos.DataKeys[e.RowIndex].Value.ToString()); int resultado = objGestion.actualizarAutos(objAutos); GridAutos.EditIndex = -1; if (resultado == 1) { cargaAuto(); mostrarMensaje("Actualización con exito", true); } else { mostrarMensaje("Existe un error en el registro de la persona", false); } }
protected override void Load() { Reservationen.Clear(); reservationenOriginal.Clear(); Kunden.Clear(); Autos.Clear(); if (Service.Kunden() != null) { foreach (KundeDto kunde in Service.Kunden()) { Kunden.Add(kunde); } } if (Service.Autos() != null) { foreach (AutoDto auto in Service.Autos()) { Autos.Add(auto); } } if (Service.Reservationen() != null) { foreach (ReservationDto reservation in Service.Reservationen()) { Reservationen.Add(reservation); reservationenOriginal.Add((ReservationDto)reservation.Clone()); } } SelectedReservation = Reservationen.FirstOrDefault(); }
public void AddAuto(Autos newAuto) { using (DBContext db = new DBContext()) { db.Autos.Add(newAuto); db.SaveChanges(); } }
public void DeleteAuto(int id) { using (DBContext db = new DBContext()) { Autos autos = db.Autos.Where(o => o.AutoID == id).FirstOrDefault(); db.Autos.Remove(autos); } }
//Hier wird ein auto zum Kill freigegeben. Tatsächlicher kill wird aber erst in dem Script gemacht welche dem Auto Als Komponente beigefügt wird public static void KillCar() { car =manageDatabase.getrandomparkingcar (); Car= GameObject.Find (car.getKennzeichen()); Car.transform.position = new Vector3(-6.35434f,0.5f,-10.67066f); Car.transform.rotation = new Quaternion (0f, 180f, 0f, 1); manageDatabase.setcartoleave (car.getKennzeichen ()); }
public ActionResult GetAuto(Autos auto) { Customers customers = (Customers)Session["Customers"]; customers.Autos = auto; Session["Customers"] = customers; return(RedirectToAction("Contact")); }
public ActionResult DeleteConfirmed(int id) { Autos autos = db.Autos.Find(id); db.Autos.Remove(autos); db.SaveChanges(); return(RedirectToAction("Index")); }
protected override void Load() { Autos.Clear(); foreach (var auto in Service.GetAutos()) { Autos.Add(auto); } SelectedAuto = Autos.FirstOrDefault(); }
public async Task <Autos> Actualizar(Autos auto, string token) { HttpClient client = GetClient(token); var response = await client.PutAsync(URL, new StringContent(JsonConvert.SerializeObject(auto), Encoding.UTF8, "application/json")); return(JsonConvert.DeserializeObject <Autos>(await response.Content.ReadAsStringAsync())); }
public ActionResult Edit([Bind(Include = "ID,Nombre,Numero_Unidad,Tipo")] Autos autos) { if (ModelState.IsValid) { db.Entry(autos).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(autos)); }
// // GET: /Autos/Delete/5 public ActionResult Delete(int id = 0) { Autos autos = db.Autos.Find(id); if (autos == null) { return(HttpNotFound()); } return(View(autos)); }
public ActionResult Edit(Autos autos) { if (ModelState.IsValid) { db.Entry(autos).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(autos)); }
private void SaveAuto(Auto auto) { AutoAddWindow autoAddWindow = new AutoAddWindow(); if (autoAddWindow.ShowDialog() ?? false) { Autos.Add(autoAddWindow.Advm.Auto); Empty = Autos.Count == 0; } }
protected override void Load() { Autos.Clear(); autosOriginal.Clear(); foreach (var auto in Service.Autos) { Autos.Add(auto); autosOriginal.Add(auto.Clone()); } SelectedAuto = Autos.FirstOrDefault(); }
public ActionResult Create(Autos autos) { if (ModelState.IsValid) { db.Autos.Add(autos); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(autos)); }
private void GetFullInfoAuto(int id) { Autos auto = new Autos(); auto = new DAO().GetFullInfoAboutAuto(id); numberTextBox.Text = auto.Number; brandTextBox.Text = auto.Brand; modelTextBox.Text = auto.Model; volumeEngineTextBox.Text = auto.Volume.ToString(); powerTextBox.Text = auto.Power.ToString(); typeBodyTextBox.Text = auto.TypeBody; engineIdTexBox.Text = auto.EngineID; bodyIdTextBox.Text = auto.BodyID; Data.IdAuto = auto.AutoID; if (auto.Helm == true) { leftCheckBox.IsChecked = true; rightCheckBox.IsEnabled = false; } else { leftCheckBox.IsChecked = false; rightCheckBox.IsEnabled = true; } yearTaxTextBox.Text = auto.YearTax.ToString(); yearLabel.Text = auto.Year.ToString(); commentTextBox.Text = auto.Comment; if (auto.Stealings.Count() >= 0) { stealingsDataGrid.ItemsSource = auto.Stealings; stealingsDataGrid.Columns[0].Visibility = Visibility.Collapsed; stealingsDataGrid.Columns[1].Header = "Дата угона"; stealingsDataGrid.Columns[2].Header = "Дата возврата"; stealingsDataGrid.Columns[3].Visibility = Visibility.Collapsed; stealingsDataGrid.Columns[4].Visibility = Visibility.Collapsed; } if (auto.TechnicalInspections.Count >= 0) { techViewAutoDataGrid.ItemsSource = auto.TechnicalInspections; techViewAutoDataGrid.Columns[0].Visibility = Visibility.Collapsed; techViewAutoDataGrid.Columns[1].Header = "Дата"; techViewAutoDataGrid.Columns[2].Header = "ФИО инспектора"; techViewAutoDataGrid.Columns[3].Header = "Оплата за знак ТО"; techViewAutoDataGrid.Columns[4].Header = "Оплата за ТО"; techViewAutoDataGrid.Columns[5].Header = "Пробег"; techViewAutoDataGrid.Columns[6].Header = "ТО пройден"; techViewAutoDataGrid.Columns[7].Header = "Заметки"; techViewAutoDataGrid.Columns[8].Visibility = Visibility.Collapsed; techViewAutoDataGrid.Columns[9].Visibility = Visibility.Collapsed; } }
public ActionResult Create([Bind(Include = "ID,Nombre,Numero_Unidad,Tipo")] Autos autos) { if (ModelState.IsValid) { db.Autos.Add(autos); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(autos)); }
public void Delete(Guid AutoID) { Autos dbEntry = context.Autos .FirstOrDefault(p => p.Id == AutoID); if (dbEntry != null) { context.Autos.Remove(dbEntry); context.SaveChanges(); } }
public void AutosPorEstado() { var mockDb = new Mock <ExamenContext>(); mockDb.Setup(o => o.Autos).Returns(Autos.GetDbSet()); var service = new AutoService(mockDb.Object); var result = service.getAuto(null, null, null, "nuevo", null, null); Assert.AreEqual(12, result.LongCount()); }
public void AutosPorPrecioMaximo() { var mockDb = new Mock <ExamenContext>(); mockDb.Setup(o => o.Autos).Returns(Autos.GetDbSet()); var service = new AutoService(mockDb.Object); var result = service.getAuto(null, null, null, null, null, 50000); Assert.AreEqual(11, result.LongCount()); }
public void TodoslosAutos() { var mockDb = new Mock <ExamenContext>(); mockDb.Setup(o => o.Autos).Returns(Autos.GetDbSet()); var service = new AutoService(mockDb.Object); var result = service.getAuto(); Assert.AreEqual(18, result.LongCount()); }
public void AutosMarcaAudi() { var mockDb = new Mock <ExamenContext>(); mockDb.Setup(o => o.Autos).Returns(Autos.GetDbSet()); var service = new AutoService(mockDb.Object); var result = service.getAuto("Audi", null, null, null, null, null); Assert.AreEqual(4, result.LongCount()); }
protected void GridAutos_RowDeleting(object sender, GridViewDeleteEventArgs e) { objGestion = new GestionBD(); Autos objAutos = new Autos(); objAutos.IDCARRO = Convert.ToInt32(GridAutos.DataKeys[e.RowIndex].Value.ToString()); objGestion.eliminarAutos(objAutos); GridAutos.EditIndex = -1; cargaAuto(); mostrarMensaje("Elimino con exito", true); }
public IActionResult Agregar([FromBody] Autos _autos) { var result = _service.agregarAutos(_autos); if (result) { return(Ok()); } else { return(BadRequest()); } }
//Diese Methode Schreibt ein Gegebenes Auto in die Datenbank. // Das Auto wird als Parameter gegeben public void addauto(Autos autodaten) { IDbConnection _connection = new SqliteConnection(_strDBName); IDbCommand _command = _connection .CreateCommand(); string sql; _connection .Open(); sql = "INSERT INTO AUTOS (KENNZEICHEN, STATUS) Values ('"+ autodaten.getKennzeichen ()+"','"+autodaten.getStatus ()+"')"; _command.CommandText = sql; _command.ExecuteNonQuery(); _command.Dispose(); _command = null; _connection .Close(); _connection.Dispose (); _connection = null; //Debug.Log (autodaten.getKennzeichen ()); }
public static void UmstellenderWayPoints() { auto = ManageDatabase.getActiveAuto (); //Debug.Log (" WaypointControl Kennzeichen " + auto.getKennzeichen ()); ManageDatabase.getParkplatzViaKennzeichencount (auto.getKennzeichen()); parki = ManageDatabase.getParkplatzViaKennzeichen (auto.getKennzeichen ()); routepoints = ManageDatabase.getRouteViaROUTEID (System.Convert.ToString(parki.getROUTENID ())); //Debug.Log (routepoints.getSize ()); //Anweisungen bei 3 Routenpunkten // Im else-Teil werden die ANweisungen für 4 Routenpunkt ausgegeben //Knoten werden von 0 bis 3 vergeben if (routepoints.getSize() == 3) { punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(0).getKnotenID())); WayPointPack11.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(1).getKnotenID())); WayPointPack12.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(2).getKnotenID())); WayPointPack13.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); WayPointPack14.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); WayPointPack31.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); WayPointPack32.transform.position=new Vector3(punkt.getX(),3.339992f,punkt.getZ()); } else if(routepoints.getSize()==4){ punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(0).getKnotenID())); WayPointPack11.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(1).getKnotenID())); WayPointPack12.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(2).getKnotenID())); WayPointPack13.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); punkt=ManageDatabase.getRoutePointViaID(System.Convert.ToString(routepoints.getRoutespecPoint(3).getKnotenID())); WayPointPack14.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); WayPointPack31.transform.position=new Vector3(punkt.getX(),0.8211908f,punkt.getZ()); WayPointPack32.transform.position=new Vector3(punkt.getX(),3.339992f,punkt.getZ()); } }
// Hier wird das Auto Geparkt also sein Status auf PArken gestellt und der QuadCopter im Status auf den Rückweg gestellt public static void ParkAuto() { car = manageDatabase.getActiveAuto (); manageDatabase.deactivateauto (car); manageDatabase.UpdateStatusDrone ("QuadCopter", "3"); GameObject.Find ("Parkplatz_new").GetComponent<Waypoint> ().idleset (); GameObject.Find ("CarCam").camera.enabled = false; GameObject.Find ("Main Camera").camera.enabled = true; GameObject.Find ("CarCam").GetComponent<SmoothFollow>().target=Car.transform; }
// Hier wird ein zufälliges PArkendes Auto zurückgesendet public Autos getrandomparkingcar() { IDbConnection _connection = new SqliteConnection(_strDBName); IDbCommand _command = _connection .CreateCommand(); string sql; IDataReader _reader; _connection .Open(); sql = "SELECT Count(KENNZEICHEN) as COUNT FROM AUTOS WHERE STATUS='2' "; _command.CommandText = sql; _reader = _command.ExecuteReader(); _reader.Read (); int zufall = UnityEngine.Random.Range (1, System.Convert.ToInt32(_reader ["COUNT"])); _reader.Close (); sql = "SELECT * FROM AUTOS WHERE STATUS = '2' LIMIT "+ zufall; _command.CommandText = sql; _reader = _command.ExecuteReader(); // Hier wird ein zufälliges Auto gesucht for (int i=0; i<zufall; i++) { _reader.Read(); } Autos car = new Autos (); //Debug.Log (_reader ["KENNZEICHEN"]); car.setKennzeichen (System.Convert.ToString (_reader ["KENNZEICHEN"])); car.setStatus("2"); _command.Dispose(); _command = null; _connection .Close(); _connection.Dispose (); _connection = null; _reader.Close (); _reader.Dispose (); _reader = null; return car; }
// Hier wird ein gegebenes Auto auf Parking gesetzt public void deactivateauto(Autos autodaten) { IDbConnection _connection = new SqliteConnection(_strDBName); IDbCommand _command = _connection .CreateCommand(); string sql; _connection .Open(); sql = "UPDATE AUTOS SET STATUS = '2' WHERE KENNZEICHEN = '"+autodaten.getKennzeichen ()+"'"; _command.CommandText = sql; _command.ExecuteNonQuery(); _command.Dispose(); _command = null; _connection .Close(); _connection.Dispose (); _connection = null; }
// Diese Funktion übernimmt die Datenbankeinträge beim Einchecken gleichzeitig wird überprüft ob noch Parkplätze frei sind public bool einchecken(String CarKennzeichen) { int anzahlfreeparkplatz = this.getanzahlfreeparkplaetzelimit1 (); // Wenn kein Parkplatz frei ist wird kein auto erzeugt if (anzahlfreeparkplatz == 0) { return false; } else { Autos auto = new Autos (); auto.setKennzeichen (CarKennzeichen); auto.setStatus ("1"); this.addauto (auto); Parkplatz park = this.getfreeParkplatzlimit1 (); this.setStatusbesetztParkplatz (CarKennzeichen,park); return true; } }
// Hier wird ein Random Parkplatz aus den Freien Parkplätzen gesucht // Der Gewählte Parkplatz wird mit dem als Parameter gegebenem Auto gefüllt // Und der gewählte Parkplatz wird zurückgesendet public Parkplatz getrandomfreeparkandfillwithcar(String Carname) { Autos auto = new Autos (); auto.setKennzeichen (Carname); auto.setStatus ("2"); this.addauto (auto); System.Random Randomizer=new System.Random(); List<Parkplatz> parkplaetze = this.getfreeParkplatz (); int anzahlfreierParkplaetze=parkplaetze.Count; Debug.Log ("ParkplätzeCount "+parkplaetze.Count); Parkplatz gewaehlt; int wohin = Randomizer.Next (0, anzahlfreierParkplaetze-1); Debug.Log ("Wohin "+wohin); gewaehlt = parkplaetze [wohin]; this.setStatusbesetztParkplatz (Carname, gewaehlt); return gewaehlt; }
// Hier wird Ein Auto aus der Datenbank genommen mit einem als Parameter gegebenem Kennzeichen // Die Rückgabe ist eine Object der Klasse Autos public Autos getAutoViaKennzeichen(String Kennzeichen) { IDbConnection _connection = new SqliteConnection(_strDBName); IDbCommand _command = _connection .CreateCommand(); string sql; IDataReader _reader; _connection .Open(); sql = "SELECT * FROM AUTOS WHERE KENNZEICHEN='"+Kennzeichen+"' "; _command.CommandText = sql; _reader = _command.ExecuteReader(); Autos auto = new Autos (); _reader.Read (); auto.setKennzeichen (System.Convert.ToString(_reader ["KENNZEICHEN"])); auto.setStatus (System.Convert.ToString(_reader ["STATUS"])); _command.Dispose (); _command = null; _connection.Close (); _connection.Dispose (); _connection = null; _reader.Close (); _reader.Dispose (); _reader = null; return auto; }