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