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