public IQueryable <Incidencia> GetTopIncidences(GEPAMEContext context)
{
if (context.Incidencia.Count() > 0)
{
var incidencias = (from i in context.Incidencia
orderby i.Fecha descending
where i.Estado
select i).Take(5);
return(incidencias);
}
return(null);
}
public IQueryable <Vehiculo> GetActiveVehicles(GEPAMEContext context)
{
if (context.Vehiculo.Count() > 0)
{
var vehiculos = from v in context.Vehiculo
where v.Desplegado && v.EnServicio
select v;
return(vehiculos);
}
return(null);
}
public string GetPosicionIncidencia(GEPAMEContext context)
{
string posicion = "";
// Query for all blogs with names starting with B
if (context.Incidencia.Count() > 0)
{
var incidencias = from b in context.Incidencia
select b;
posicion = incidencias.First().Utm;
}
return(posicion);
}
public string GetSiguienteIDIncidencia(GEPAMEContext context, string tipoIncidencia)
{
string id = "1";
if (context.Incidencia.Count() > 0)
{
var identificadores = (from i in context.Incidencia
where i.TipoIncidencia == tipoIncidencia
select i).Last().IdIncidencia;
id = (int.Parse(identificadores) + 1).ToString();
}
return(id);
}
public PosicionesController(GEPAMEContext context)
{
_context = context;
}
public VehiclesController(GEPAMEContext context)
{
_context = context;
}
public IncidentsController(GEPAMEContext context)
{
_context = context;
}
public AccesoVehiculosController(GEPAMEContext context)
{
_context = context;
}
public UsuariosController(GEPAMEContext context)
{
_context = context;
}
public HomeController(GEPAMEContext context)
{
_context = context;
}
public RolsController(GEPAMEContext context)
{
_context = context;
}