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