public List <Usuario> GetAllUsuarios() { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.AspNetUsers select e).ToList(); return(new ConvertType().UsuarioDBToUsuario(ListEmp)); } }
public void DeleteVehiculo(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { db.Vehiculos.Remove(db.Vehiculos.Find(id)); db.SaveChanges(); } }
public List <LecturaSensor> GetAllLecturas(int id_sens) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.LecturaSensores where e.Id_Sensor == id_sens select e).ToList(); return(new ConvertType().LecturaDBToLectura(ListEmp)); } }
public Usuario GetUsuarioMail(string id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.AspNetUsers where e.Email.Equals(id) select e).ToList(); return(new ConvertType().UsuarioDBToUsuario(ListEmp).First()); } }
public List <Evento> GetAllEvento() { using (CEREBROEntities1 db = new CEREBROEntities1()) { var List = (from e in db.Eventos select e).ToList(); return(new ConvertType().EventoDBToEvento(List)); } }
public Vehiculo GetVehiculo(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Vehiculos where e.Id == id select e).ToList(); return(new ConvertType().VehiculoDBToVehiculo(ListEmp).First()); } }
public Sensor GetSensor(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Sensores where e.Id == id select e).ToList(); return(new ConvertType().SensorDBToSensor(ListEmp).First()); } }
public AspNetRoles GetRole(String id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.AspNetRoles where e.Id.Equals(id) select e).ToList(); return(ListEmp.First()); } }
public List <Sensor> GetAllSensor() { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Sensores select e).ToList(); return(new ConvertType().SensorDBToSensor(ListEmp)); } }
public List <Vehiculo> GetAllVehiculos() { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Vehiculos select e).ToList(); return(new ConvertType().VehiculoDBToVehiculo(ListEmp)); } }
public void DeleteTipo_Evento(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { db.Tipo_Evento.Remove(db.Tipo_Evento.Find(id)); db.SaveChanges(); } }
public void DeleteSensor(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { db.Sensores.Remove(db.Sensores.Find(id)); db.SaveChanges(); } }
public void DeleteEmpleado(int Id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { db.Empleados.Remove(db.Empleados.Find(Id)); db.SaveChanges(); } }
public Tipo_Evento GetTipo_Evento(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Tipo_Evento where e.Id == id select e).ToList(); return(new ConvertType().Tipo_EventoDBToTipo_Evento(ListEmp).First()); } }
public Evento GetEvento(int id) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var List = (from e in db.Eventos where e.Id == id select e).ToList(); return(new ConvertType().EventoDBToEvento(List).First()); } }
public List <LecturaSensor> GetLast10Lecturas(int id_sens) { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.LecturaSensores where e.Id_Sensor == id_sens select e).OrderByDescending(e => e.Id).Take(10).ToList(); return(new ConvertType().LecturaDBToLectura(ListEmp)); } }
public List <Tipo_Evento> GetAllTipo_Evento() { using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Tipo_Evento select e).ToList(); return(new ConvertType().Tipo_EventoDBToTipo_Evento(ListEmp)); } }
public void DeleteUsuario(string mail) { using (CEREBROEntities1 db = new CEREBROEntities1()) { db.AspNetUsers.Remove(db.AspNetUsers.Find(mail)); db.SaveChanges(); } }
public void AddTipo_Evento(Tipo_Evento eve) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Tipo_Eventos nuevo = new Tipo_Eventos(); nuevo.setModel(eve); db.Tipo_Evento.Add(nuevo); db.SaveChanges(); } }
public Empleado GetEmpleado(int Id) { List <Empleado> listaRetorno = new List <Empleado>(); using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Empleados where e.Ci == Id select e).ToList(); return(new ConvertType().EmpleadoDBToEmpleado(ListEmp).First()); } }
public List <Empleado> GetAllEmpleados() { List <Empleado> listaRetorno = new List <Empleado>(); using (CEREBROEntities1 db = new CEREBROEntities1()) { var ListEmp = (from e in db.Empleados select e).ToList(); return(new ConvertType().EmpleadoDBToEmpleado(ListEmp)); } }
public void AddUsuario(Usuario usu) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Usuarios nuevo = new Usuarios(); nuevo.setModel(usu); db.AspNetUsers.Add(nuevo); db.SaveChanges(); } }
public void AddSensor(Sensor sen) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Sensores nuevo = new Sensores(); nuevo.setModel(sen); db.Sensores.Add(nuevo); db.SaveChanges(); } }
public void UpdateEvento(Evento e) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Eventos even = new Eventos(); even = db.Eventos.Find(e.Id); even.setModel(e); db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateTipo_Evento(Tipo_Evento eve) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Tipo_Eventos e = new Tipo_Eventos(); e = db.Tipo_Evento.Find(eve.Id); e.setModel(eve); db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateSensor(Sensor sen) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Sensores e = new Sensores(); e = db.Sensores.Find(sen.Id); e.setModel(sen); db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateEmpleado(Empleado emp) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Empleados e = new Empleados(); e = db.Empleados.Find(emp.Ci); e.setModel(emp); db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } }
public void UpdateVehiculo(Vehiculo vehi) { using (CEREBROEntities1 db = new CEREBROEntities1()) { Vehiculos e = new Vehiculos(); e = db.Vehiculos.Find(vehi.Id); e.setModel(vehi); db.Entry(e).State = EntityState.Modified; db.SaveChanges(); } }
public void AddEmpleado(Empleado emp) { using (CEREBROEntities1 db = new CEREBROEntities1()) { if (emp != null) { Empleados nuevo = new Empleados(); nuevo.setModel(emp); db.Empleados.Add(nuevo); db.SaveChanges(); } } }
public void AddVehiculo(Vehiculo vehi) { using (CEREBROEntities1 db = new CEREBROEntities1()) { if (vehi != null) { Vehiculos nuevo = new Vehiculos(); nuevo.setModel(vehi); db.Vehiculos.Add(nuevo); db.SaveChanges(); } } }