public static object GetByUserId(Usuario usuario)
{
var param = new List <SPParameter>
{
new SPParameter("ID_Usuario", usuario.ID)
};
var sp = new StoreProcedure(DataBaseConst.Calificacion.SPGetCalificationByUserId, param);
Double calification = 0.0;
var reader = sp.ExecuteReader(null);
while (reader.Read())
{
calification = Convert.ToDouble(reader[0]);
}
if (!reader.IsClosed)
{
reader.Close();
}
return(calification);
}
public static List <Publicacion> GetAllActive()
{
//Obtengo la publicacion que se encuentren activas
var param = new List <SPParameter>
{
new SPParameter("Fecha_hoy", Configuration.ConfigurationVariables.FechaSistema)
};
var sp = new StoreProcedure(DataBaseConst.Publicacion.SPGetAllActive, param);
var publications = sp.ExecuteReader <Publicacion>();
if (publications == null || publications.Count == 0)
{
return(null);
}
foreach (var pub in publications)
{
pub.GetObjectsById();
}
return(publications);
}
public static List <Publicacion> GetFinishedAuctions()
{
//Obtengo la lista de publicaciones que ya hayan vencido para pasarlas a compras
var param = new List <SPParameter>
{
new SPParameter("Fecha_Hoy", ConfigurationVariables.FechaSistema)
};
var sp = new StoreProcedure(DataBaseConst.Publicacion.SPGetFinishedAuctions, param);
var publications = sp.ExecuteReader <Publicacion>();
if (publications == null || publications.Count == 0)
{
return(new List <Publicacion>());
}
foreach (var pub in publications)
{
pub.GetObjectsById();
}
return(publications);
}
public static int GetAllActiveAndFreeByUser(int userId)
{
var param = new List <SPParameter>
{
new SPParameter("ID_Usuario", userId)
};
var quantity = 0;
var sp = new StoreProcedure(DataBaseConst.Publicacion.SPGetAllActiveAndFreeByUserId, param);
var reader = sp.ExecuteReader(null);
while (reader.Read())
{
quantity = Convert.ToInt32(reader[0]);
}
if (!reader.IsClosed)
{
reader.Close();
}
return(quantity);
}
public static List <FormaPago> GetAll()
{
var sp = new StoreProcedure(DataBaseConst.FormaPago.SPGetAllFormaPago);
return(sp.ExecuteReader <FormaPago>());
}
public static List <TipoDocumento> GetAll()
{
var sp = new StoreProcedure(DataBaseConst.TipoDocumento.SPGetAllTipoDocumento);
return(sp.ExecuteReader <TipoDocumento>());
}
public static List <Cliente> GetAllClients()
{
var sp = new StoreProcedure(DataBaseConst.Cliente.SPGetAllClients);
return(sp.ExecuteReader <Cliente>());
}
public static List <Rubro> GetAll()
{
var sp = new StoreProcedure(DataBaseConst.Rubro.SPGetAllRubro);
return(sp.ExecuteReader <Rubro>());
}
public List <Especialidad> GetAll()
{
StoreProcedure sp = new StoreProcedure(DataBaseConst.Especialidad.SP_GetAllEspecialidad);
return(sp.ExecuteReader <Especialidad>());
}
public static List <Empresa> GetAllBusiness()
{
var sp = new StoreProcedure(DataBaseConst.Empresa.SPGetAllBusiness);
return(sp.ExecuteReader <Empresa>());
}
public List <Rol> GetAll()
{
StoreProcedure sp = new StoreProcedure(DataBaseConst.Rol.SP_GetAllRol);
return(sp.ExecuteReader <Rol>());
}
public List <EstadoCivil> GetAll()
{
StoreProcedure sp = new StoreProcedure(DataBaseConst.EstadoCivil.SP_GetAllEstadoCivil);
return(sp.ExecuteReader <EstadoCivil>());
}
public List <PlanMedico> GetAll()
{
StoreProcedure sp = new StoreProcedure(DataBaseConst.PlanMedico.SP_GetAllPlanMedico);
return(sp.ExecuteReader <PlanMedico>());
}
public List <Funcionalidad> GetAll()
{
StoreProcedure sp = new StoreProcedure(DataBaseConst.Funcionalidad.SP_GetAllFuncionalidad);
return(sp.ExecuteReader <Funcionalidad>());
}