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