Exemple #1
0
        public static Carro ConsultarVehiculo(string placa)
        {
            try
            {
                LavacContext    s        = new LavacContext();
                List <Vehiculo> vehiculo = new List <Vehiculo>();
                List <Carro>    c        = new List <Carro>();

                Carro    carrito = new Carro();
                Vehiculo v       = new Vehiculo();
                vehiculo = s.Vehiculo.Where(a => a.Placa == placa).ToList();


                foreach (var dto in vehiculo)
                {
                    carrito.id = dto.ID_Vehiculo;
                }


                return(carrito);
            }

            catch (Exception e)
            {
                throw e;
            }
        }
Exemple #2
0
        public static List <VehiculoxServicio> ConsultarServiciosxVehiculos()
        {
            LavacContext             s = new LavacContext();
            List <VehiculoxServicio> listavehiculoxServicio = new List <VehiculoxServicio>();
            List <object>            milista = new List <object>();
            //t1 servicios  a
            //t2 vxs        h
            //t3  vehi      c
            var result = from t1 in s.Servicios
                         join t2 in s.Vehiculo_Servicio on t1.ID_Servicio equals t2.ID_Servicio
                         join t3 in s.Vehiculo on t2.ID_Vehiculo equals t3.ID_Vehiculo
                         select new
            {
                t1.ID_Servicio,
                t1.Descripción,
                t1.Monto,
                t3.Placa
            };

            foreach (var dto in result)
            {
                VehiculoxServicio vxs = new VehiculoxServicio();
                vxs.IdServicio  = dto.ID_Servicio;
                vxs.Descripción = dto.Descripción;
                vxs.Monto       = dto.Monto;
                vxs.Placa       = dto.Placa;

                listavehiculoxServicio.Add(vxs);
            }

            return(listavehiculoxServicio);
        }
Exemple #3
0
        public static List <Servicios> cargarDropList()
        {
            LavacContext     s  = new LavacContext();
            List <Servicios> li = new List <Servicios>();

            foreach (var item in s.Servicios)
            {
                li.Add(item);
            }
            return(li);
        }
Exemple #4
0
        public static List <Servicios> ConsultarServicios()
        {
            try
            {
                LavacContext     s  = new LavacContext();
                List <Servicios> li = new List <Servicios>();

                foreach (var item in s.Servicios)
                {
                    li.Add(item);
                }
                return(li);
            }

            catch (Exception e)
            {
                throw e;
            }
        }
Exemple #5
0
        public static void AgregarServicios(string descripcion, int monto)
        {
            Servicios se = new Servicios();

            se.Descripción = descripcion;
            se.Monto       = monto;

            try
            {
                using (var s = new LavacContext()) {
                    s.Servicios.Add(se);
                    s.SaveChanges();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #6
0
        public static void asociarVehiculoServicio(int idServicio, int idVehiculo)
        {
            Vehiculo_Servicio vs = new Vehiculo_Servicio();

            vs.ID_Servicio = idServicio;
            vs.ID_Vehiculo = idVehiculo;

            try
            {
                using (var s = new LavacContext())
                {
                    s.Vehiculo_Servicio.Add(vs);
                    s.SaveChanges();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Exemple #7
0
        public static void AgregarVehiculo(Carro carro)
        {
            Vehiculo vehiculo = new Vehiculo();

            vehiculo.Placa = carro.placa;
            vehiculo.Dueño = carro.dueño;
            vehiculo.Marca = carro.marca;

            try
            {
                using (var s = new LavacContext())
                {
                    s.Vehiculo.Add(vehiculo);
                    s.SaveChanges();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }