public void getService(Servicio_E servicioE) { using (lavacarEntities db = new lavacarEntities()) { Servicio se = db.Servicios.Find(servicioE.ID_Servicio); servicioE.Descripcion = se.Descripción; servicioE.Monto = se.Monto; } }
public void getVehicle(Vehiculo_E vehiculoE) { using (lavacarEntities db = new lavacarEntities()) { Vehiculo ve = db.Vehiculoes.Find(vehiculoE.ID_Vehiculo); vehiculoE.Placa = ve.Placa; vehiculoE.Duenno = ve.Dueño; vehiculoE.Marca = ve.Marca; } }
public void deleteService(Servicio_E servicioE) { using (lavacarEntities db = new lavacarEntities()) { Servicio se = db.Servicios.Find(servicioE.ID_Servicio); db.Servicios.Remove(se); db.SaveChanges(); } }
public void deleteVehicle(Vehiculo_E vehiculoE) { using (lavacarEntities db = new lavacarEntities()) { Vehiculo ve = db.Vehiculoes.Find(vehiculoE.ID_Vehiculo); db.Vehiculoes.Remove(ve); db.SaveChanges(); } }
public void getAllServices(List <Servicio_E> listE) { using (lavacarEntities db = new lavacarEntities()) { var listS = db.Servicios; foreach (var se in listS) { listE.Add(new Servicio_E(se.ID_Servicio, se.Descripción, se.Monto)); } } }
public void getAllVehicles(List <Vehiculo_E> listE) { using (lavacarEntities db = new lavacarEntities()) { var listV = db.Vehiculoes; foreach (var ve in listV) { listE.Add(new Vehiculo_E(ve.ID_Vehiculo, ve.Placa, ve.Dueño, ve.Marca)); } } }
public void updateService(Servicio_E servicioE) { using (lavacarEntities db = new lavacarEntities()) { Servicio se = db.Servicios.Find(servicioE.ID_Servicio); se.Descripción = servicioE.Descripcion; se.Monto = servicioE.Monto; db.Entry(se).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void addService(Servicio_E servicioE) { using (lavacarEntities db = new lavacarEntities()) { Servicio se = new Servicio(); se.Descripción = servicioE.Descripcion; se.Monto = servicioE.Monto; db.Servicios.Add(se); db.SaveChanges(); } }
public void addVeSe(int idVe, int idSe) { using (lavacarEntities db = new lavacarEntities()) { Vehiculo_Servicio vs = new Vehiculo_Servicio(); vs.ID_Vehiculo = idVe; vs.ID_Servicio = idSe; db.Vehiculo_Servicio.Add(vs); db.SaveChanges(); } }
public void updateVehicle(Vehiculo_E vehiculoE) { using (lavacarEntities db = new lavacarEntities()) { Vehiculo ve = db.Vehiculoes.Find(vehiculoE.ID_Vehiculo); ve.Placa = vehiculoE.Placa; ve.Dueño = vehiculoE.Duenno; ve.Marca = vehiculoE.Marca; db.Entry(ve).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } }
public void addGroupServicesToVehicle(int idVehicle, List <int> idServices) { using (lavacarEntities db = new lavacarEntities()) { foreach (int id in idServices) { Vehiculo_Servicio vs = new Vehiculo_Servicio(); vs.ID_Vehiculo = idVehicle; vs.ID_Servicio = id; db.Vehiculo_Servicio.Add(vs); db.SaveChanges(); } } }
public List <Vehiculo_E> getVehiclesByService(List <int> listIDs) { List <Vehiculo_E> listE = new List <Vehiculo_E>(); using (lavacarEntities db = new lavacarEntities()) { foreach (int id in listIDs) { Vehiculo ve = db.Vehiculoes.Find(id); listE.Add(new Vehiculo_E(ve.ID_Vehiculo, ve.Placa, ve.Dueño, ve.Marca)); } } return(listE); }
public List <int> getVehiclesIdByService(int idService) { List <int> listIDs = new List <int>(); using (lavacarEntities db = new lavacarEntities()) { var listVeSe = db.Vehiculo_Servicio; foreach (var veSe in listVeSe) { if (veSe.ID_Servicio == idService) { listIDs.Add(veSe.ID_Vehiculo); } } } return(listIDs); }
public void addVehicle(Vehiculo_E vehiculoE) { using (lavacarEntities db = new lavacarEntities()) { Vehiculo ve = new Vehiculo(); ve.Placa = vehiculoE.Placa; ve.Dueño = vehiculoE.Duenno; ve.Marca = vehiculoE.Marca; db.Vehiculoes.Add(ve); db.SaveChanges(); Vehiculo veG = db.Vehiculoes.Where(v => v.Placa == vehiculoE.Placa).First(); vehiculoE.ID_Vehiculo = veG.ID_Vehiculo; } }