public static void AsignarServicio(Vehiculo_Servicio asignacion)
{
var db = new LavaCarDBEntities();
db.Vehiculo_Servicio.Add(asignacion);
db.SaveChanges();
}
public static void Editar(Vehiculo vehiculo)
{
var db = new LavaCarDBEntities();
db.Entry(vehiculo).State = EntityState.Modified;
db.SaveChanges();
}
public static void Eliminar(int ID_Vehiculo)
{
var db = new LavaCarDBEntities();
db.Database.ExecuteSqlCommand("DELETE FROM Vehiculo WHERE ID_Vehiculo = @id", new SqlParameter("@id", ID_Vehiculo));
db.SaveChanges();
}
public static void Editar(Servicios servicio)
{
var db = new LavaCarDBEntities();
db.Entry(servicio).State = EntityState.Modified;
db.SaveChanges();
}
public static void Crear(Vehiculo vehiculo)
{
var db = new LavaCarDBEntities();
db.Vehiculo.Add(vehiculo);
db.SaveChanges();
}
public static void Crear(Servicios servicio)
{
var db = new LavaCarDBEntities();
db.Servicios.Add(servicio);
db.SaveChanges();
}
public static List <Servicios> ListarServicios(int ID_Vehiculo)
{
var db = new LavaCarDBEntities();
return(db.Servicios.SqlQuery("SELECT s.ID_Servicio, s.Descripción, s.Monto from [Vehiculo-Servicio] vs INNER JOIN Servicios s ON (s.ID_Servicio = vs.ID_Servicio) WHERE ID_Vehiculo = @id",
new SqlParameter("@id", ID_Vehiculo))
.ToList <Servicios>());
}
public static List <Vehiculo> ListarVehiculos(Servicios servicio)
{
var db = new LavaCarDBEntities();
return(db.Vehiculo.SqlQuery("SELECT v.ID_Vehiculo, v.Placa, v.Dueño, v.Marca from [Vehiculo-Servicio] vs INNER JOIN Vehiculo v ON (v.ID_Vehiculo = vs.ID_Vehiculo) WHERE vs.ID_Servicio = @id",
new SqlParameter("@id", servicio.ID_Servicio))
.ToList <Vehiculo>());
}
public static Vehiculo BuscarPlaca(string Placa)
{
var db = new LavaCarDBEntities();
return(db.Database.SqlQuery <Vehiculo>("Select * FROM Vehiculo WHERE Placa LIKE '%" + Placa + "'").FirstOrDefault());
}
public static Vehiculo BuscarID(int?ID_Vehiculo)
{
var db = new LavaCarDBEntities();
return(db.Vehiculo.Find(ID_Vehiculo));
}
public static List <Vehiculo> Listar()
{
var db = new LavaCarDBEntities();
return(db.Vehiculo.ToList());
}
public static void Eliminar(Servicios servicio)
{
var db = new LavaCarDBEntities();
db.Servicios.Remove(servicio);
}
public static List <Servicios> Listar()
{
var db = new LavaCarDBEntities();
return(db.Servicios.ToList());
}
