public List <object> ListarVehiculos()
{
List <object> vehiculoList = new List <object>();
using (var context = new segurosEntities())
{
var query = from c in context.Vehiculos
join m in context.Modelos on c.modeloId equals m.modeloId
join ma in context.Marcas on m.marcaId equals ma.marcaId
join t in context.TipoVehiculos on m.tipoVehiculoId equals t.tipoVehiculosId
where c.vehiculoEstado == 1
select new
{
c.vehiculoId,
c.vehiculoDominio,
c.vehiculoAnio,
ma.marcaDescripcion,
m.modeloDescripcion,
c.vehiculoNumeroChasis,
c.vehiculoNumeroMotor,
t.tipoVehiculoDescripcion
};
foreach (var item in query)
{
vehiculoList.Add(item);
}
}
return(vehiculoList);
}
public void GuardarVehiculos(Vehiculos vehiculo)
{
using (segurosEntities context = new segurosEntities())
{
context.Vehiculos.Add(vehiculo);
context.SaveChanges();
}
}
public void Guardar(Polizas poliza)
{
using (segurosEntities context = new segurosEntities())
{
context.Polizas.Add(poliza);
context.SaveChanges();
};
}
public void GuardarClientes(Clientes cliente)
{
using (segurosEntities context = new segurosEntities())
{
context.Clientes.Add(cliente);
context.SaveChanges();
}
}
public void BorrarVehiculo(int vehiculoId)
{
using (segurosEntities context = new segurosEntities())
{
Vehiculos vehic = (from v in context.Vehiculos
where v.vehiculoId == vehiculoId
select v).FirstOrDefault();
vehic.vehiculoEstado = 0;
context.SaveChanges();
}
}
public Modelos BuscarModelo(int?modeloId)
{
Modelos modelos;
using (segurosEntities context = new segurosEntities())
{
modelos = (from m in context.Modelos
where m.modeloId == modeloId
select m).FirstOrDefault();
}
return(modelos);
}
public Marcas BuscarMarca(int?marcaId)
{
Marcas marcas;
using (segurosEntities context = new segurosEntities())
{
marcas = (from m in context.Marcas
where m.marcaId == marcaId
select m).FirstOrDefault();
}
return(marcas);
}
public Vehiculos BuscarVehiculo(int?vehiculoId)
{
Vehiculos vehiculo;
using (segurosEntities context = new segurosEntities())
{
vehiculo = (from v in context.Vehiculos
where v.vehiculoId == vehiculoId
select v).FirstOrDefault();
}
return(vehiculo);
}
public void BajaPoliza(int polizaId)
{
using (segurosEntities context = new segurosEntities())
{
Polizas poliza = (from p in context.Polizas
where p.polizaId == polizaId
select p).FirstOrDefault();
poliza.polizaEstado = 0;
poliza.polizaFechaBaja = DateTime.Now;
context.SaveChanges();
}
}
public List <Vehiculos> listarVehiculos()
{
List <Vehiculos> vehiculosList = new List <Vehiculos>();
using (var context = new segurosEntities())
{
var query = from v in context.Vehiculos select v;
foreach (var item in query)
{
vehiculosList.Add(item);
}
}
return(vehiculosList);
}
public void ModificarVehiculo(Vehiculos vehiculos)
{
using (segurosEntities context = new segurosEntities())
{
Vehiculos vehic = (from v in context.Vehiculos
where v.vehiculoId == vehiculos.vehiculoId
select v).FirstOrDefault();
vehic.vehiculoDominio = vehiculos.vehiculoDominio;
vehic.vehiculoAnio = vehiculos.vehiculoAnio;
vehic.modeloId = vehiculos.modeloId;
vehic.vehiculoNumeroChasis = vehiculos.vehiculoNumeroChasis;
vehic.vehiculoNumeroMotor = vehiculos.vehiculoNumeroMotor;
context.SaveChanges();
}
}
public List <Companias> LlenarComboCompanias()
{
List <Companias> companiasList = new List <Companias>();
using (var context = new segurosEntities())
{
var query = from c in context.Companias
select c;
foreach (var item in query)
{
companiasList.Add(item);
}
}
return(companiasList);
}
public List <Clientes> ListarClientes()
{
List <Clientes> clientesList = new List <Clientes>();
using (var context = new segurosEntities())
{
var query = from c in context.Clientes
select c;
foreach (var item in query)
{
clientesList.Add(item);
}
}
return(clientesList);
}
public List <Modelos> CargarComboModelo(int marcaId)
{
List <Modelos> modelosList = new List <Modelos>();
using (var context = new segurosEntities())
{
var query = from c in context.Modelos where c.marcaId == marcaId
select c;
foreach (var item in query)
{
modelosList.Add(item);
}
}
return(modelosList);
}
public List <Vehiculos> LlenarComboVehiculo()
{
List <Vehiculos> vehiculoList = new List <Vehiculos>();
using (var context = new segurosEntities())
{
var query = from c in context.Vehiculos
select c;
foreach (var item in query)
{
vehiculoList.Add(item);
}
}
return(vehiculoList);
}
public List <Marcas> CargarComboMarca()
{
List <Marcas> marcasList = new List <Marcas>();
using (var context = new segurosEntities())
{
var query = from c in context.Marcas
select c;
foreach (var item in query)
{
marcasList.Add(item);
}
}
return(marcasList);
}
public List <object> ListarPolizas()
{
List <object> listaPolizas = new List <object>();
using (var context = new segurosEntities())
{
var polizas = from p in context.Polizas
join v in context.Vehiculos on p.vehiculoId equals v.vehiculoId
join c in context.Clientes on p.clienteId equals c.clienteId
where p.polizaEstado == 1
select new{ v.vehiculoDominio, c.clienteApellido, c.clienteNombre, p.polizaNumero, p.polizaFechaVigencia, p.polizaId, p.polizaEstado };
foreach (var item in polizas)
{
listaPolizas.Add(item);
}
}
return(listaPolizas);
}
