public Models.VehiculosDuenos BuscarVehiculoVista(string patente)
{
Models.VehiculosDuenos vehiculo = new Models.VehiculosDuenos();
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
var query = (from oVehiculo in db.Vehiculo
join oDueno in db.Dueno
on oVehiculo.IdDueno equals oDueno.IdDueno
where oVehiculo.Patente == patente
select new Models.VehiculosDuenos()
{
IdVehiculo = oVehiculo.IdVehiculo,
IdDueno = oDueno.IdDueno,
Nombre = oDueno.Nombre,
Apellido = oDueno.Apellido,
Patente = oVehiculo.Patente,
Marca = oVehiculo.Marca,
Modelo = oVehiculo.Modelo,
Anno = oVehiculo.Anno,
PrecioEnUF = oVehiculo.PrecioEnUF
}).First();
vehiculo = query;
}
return(vehiculo);
}
catch (Exception)
{
return(new Models.VehiculosDuenos());
}
}
public List <Models.VehiculosDuenos> ListarVehiculosDuenos(int id)
{
List <Models.VehiculosDuenos> listaVehiculosDueno = new List <Models.VehiculosDuenos>();
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
var listaVehiculosDuenosQuery = (from oDueno in db.Dueno
join oVehiculo in db.Vehiculo
on oDueno.IdDueno equals oVehiculo.IdDueno
where id == oVehiculo.IdDueno
orderby oVehiculo.IdVehiculo
select new Models.VehiculosDuenos()
{
IdVehiculo = oVehiculo.IdVehiculo,
IdDueno = oDueno.IdDueno,
Nombre = oDueno.Nombre,
Apellido = oDueno.Apellido,
Patente = oVehiculo.Patente,
Marca = oVehiculo.Marca,
Modelo = oVehiculo.Modelo,
Anno = oVehiculo.Anno,
PrecioEnUF = oVehiculo.PrecioEnUF
}).ToList();
listaVehiculosDueno = listaVehiculosDuenosQuery;
}
return(listaVehiculosDueno);
}
public bool DuenoConVehiculos(int id)
{
int tieneVehiculos = 0;
try
{
DataModels.Dueno dueno = new DataModels.Dueno();
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
dueno = db.Dueno.Single(d => d.IdDueno == id);
tieneVehiculos = dueno.Vehiculo.Count();
if (tieneVehiculos > 0)
{
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public bool CreateDueno(DataModels.Dueno dueno)
{
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
dueno.RUT = FormatoRut(dueno.RUT);
if (!string.IsNullOrEmpty(dueno.RUT))
{
db.Dueno.Add(dueno);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
}
catch (Exception)
{
return(false);
}
}
public List <DataModels.Dueno> ListarDueno()
{
List <DataModels.Dueno> listaDuenos = new List <DataModels.Dueno>();
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
listaDuenos = db.Dueno.ToList();
}
return(listaDuenos);
}
public DataModels.Dueno BuscarDueno(int idDueno)
{
DataModels.Dueno dueno = new DataModels.Dueno();
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
dueno = db.Dueno.Single(d => d.IdDueno == idDueno);
}
}
catch (Exception)
{
return(new DataModels.Dueno());
}
return(dueno);
}
public bool ActualizarDueno(DataModels.Dueno dueno)
{
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
db.Dueno.Attach(dueno);
db.Entry(dueno).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public DataModels.Dueno BuscarDuenoVista(string rut)
{
DataModels.Dueno dueno = new DataModels.Dueno();
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
dueno = db.Dueno.Single(d => d.RUT == rut);
}
return(dueno);
}
catch (Exception)
{
return(new DataModels.Dueno());
}
}
public bool EliminarVehiculo(int id)
{
try
{
DataModels.Vehiculo vehiculo = new Vehiculo();
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
vehiculo = db.Vehiculo.Single(v => v.IdVehiculo == id);
db.Vehiculo.Attach(vehiculo);
db.Entry(vehiculo).State = System.Data.EntityState.Deleted;
db.SaveChanges();
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool ActualizarVehiculo(DataModels.Vehiculo vehiculo)
{
try
{
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
if (vehiculo.Patente != null && vehiculo.IdDueno != 0)
{
db.Vehiculo.Attach(vehiculo);
db.Entry(vehiculo).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool EliminarDueno(int id)
{
try
{
DataModels.Dueno dueno = new DataModels.Dueno();
using (var db = new DataModels.BDEvaluacionVehiculosEntities())
{
dueno = db.Dueno.Single(d => d.IdDueno == id);
if (dueno.IdDueno != 0)
{
db.Dueno.Attach(dueno);
db.Entry(dueno).State = System.Data.EntityState.Deleted;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception)
{
return(false);
}
}
