public virtual IEnumerable <TEntity> PaginadorConsultasProceadas(int limiteInferior, int limiteSuperior, string where, bool esIgual)
{
IEnumerable <TEntity> exec = new List <TEntity>();
using (var ctx = new AsocajasBDEntities())
{
var LimiteInferior = new SqlParameter
{
ParameterName = "LimiteInferior",
Value = limiteInferior
};
var LimiteSuperior = new SqlParameter
{
ParameterName = "LimiteSuperior",
Value = limiteSuperior
};
var Where = new SqlParameter
{
ParameterName = "Where",
Value = where
};
var EsIgual = new SqlParameter
{
ParameterName = "EsIgual",
Value = esIgual
};
exec = ctx.Database.SqlQuery <TEntity>("exec LogConsultasProcesadas @LimiteInferior,@LimiteSuperior,@Where,@EsIgual ", LimiteInferior, LimiteSuperior, Where, EsIgual).ToList <TEntity>();
//var EXEC = ctx.INSERTSOLicitud(IdSolicitudAntigua, IdSolicitudNueva);
}
return(exec);
}
public virtual int CountPaginadorConsultasProcesadas(string where, bool esIgual)
{
int exec = 0;
using (var ctx = new AsocajasBDEntities())
{
var Where = new SqlParameter
{
ParameterName = "Where",
Value = where
};
var EsIgual = new SqlParameter
{
ParameterName = "EsIgual",
Value = esIgual
};
exec = ctx.Database.SqlQuery <int>("exec CountLogConsultasProcesadas @Where,@EsIgual ", Where, EsIgual).FirstOrDefault();
}
return(exec);
}
public virtual int CountPaginadorConsultas(string where)
{
var propPk = typeof(TEntity);
int exec = 0;
using (var ctx = new AsocajasBDEntities())
{
var Tabla = new SqlParameter
{
ParameterName = "Tabla",
Value = propPk.Name
};
var Where = new SqlParameter
{
ParameterName = "Where",
Value = where
};
exec = ctx.Database.SqlQuery <int>("exec CountPaginadorConsultas @Tabla,@Where ", Tabla, Where).FirstOrDefault();
}
return(exec);
}
public virtual IEnumerable <TEntity> PaginadorConsultas(int limiteInferior, int limiteSuperior, string where)
{
var propPk = typeof(TEntity);
IEnumerable <TEntity> exec = new List <TEntity>();
using (var ctx = new AsocajasBDEntities())
{
var LimiteInferior = new SqlParameter
{
ParameterName = "LimiteInferior",
Value = limiteInferior
};
var LimiteSuperior = new SqlParameter
{
ParameterName = "LimiteSuperior",
Value = limiteSuperior
};
var Tabla = new SqlParameter
{
ParameterName = "Tabla",
Value = propPk.Name
};
var Where = new SqlParameter
{
ParameterName = "Where",
Value = where
};
exec = ctx.Database.SqlQuery <TEntity>("exec PaginadorConsultas @LimiteInferior,@LimiteSuperior,@Tabla,@Where ", LimiteInferior, LimiteSuperior, Tabla, Where).ToList <TEntity>();
//var EXEC = ctx.INSERTSOLicitud(IdSolicitudAntigua, IdSolicitudNueva);
}
return(exec);
}
