public IEnumerable <T> GetAll <T>() where T : new()
{
return(DbUtil.GetAll <T>(Cs));
}
public IEnumerable <Dossier> GetBy(int measuresetId, int measureId, int month, int?stateId = null)
{
return(DbUtil.ExecuteReaderSp <Dossier>("getDossiers", new { measuresetId, measureId, month, stateId }, Cs));
}
public IEnumerable <Measure> GetActives()
{
return(DbUtil.ExecuteReaderSp <Measure>("getMeasures", null, Cs));
}
public int UpdateWhatWhere <T>(object what, object where)
{
return(DbUtil.UpdateWhatWhere <T>(what, where, Cs));
}
public IEnumerable <Field> GetUnassigned(int id)
{
return(DbUtil.ExecuteReaderSp <Field>("getUnassignedFieldsByFieldsetId", new { id }, Cs));
}
public IEnumerable <T> GetWhere <T>(object where) where T : new()
{
return(DbUtil.GetWhere <T>(where, Cs));
}
public int DeleteWhere <T>(object where)
{
return(DbUtil.DeleteWhere <T>(where, Cs));
}
public int Count(string name)
{
return(DbUtil.CountWhere <User>(new { name }, Cs));
}
public IEnumerable <Role> GetRoles()
{
return(DbUtil.GetAll <Role>(Cs));
}
public void MoveToFpi(int fpiId)
{
DbUtil.ExecuteNonQuerySp("updateToFpi", new { fpiId }, Cs);
}
public IEnumerable <Role> GetRoles(long id)
{
return(DbUtil.ExecuteReaderSp <Role>("getRolesByUserId", new { id }, Cs));
}
public void RollbackToIndicators(int fpiId)
{
DbUtil.ExecuteNonQuerySp("rollbackToIndicators", new { fpiId }, Cs);
}
public int RollbackWinners(int fpiId)
{
return(DbUtil.ExecuteNonQuerySp("rollbackWinners", new { fpiId }, Cs));
}
public IEnumerable <RankedDossier> GetForRanking(int measuresetId, int measureId, int month)
{
return(DbUtil.ExecuteReaderSp <RankedDossier>("getDossiersForRanking", new { measuresetId, measureId, month }, Cs));
}
public T Get <T>(int id) where T : new()
{
return(DbUtil.Get <T>(id, Cs));
}
public int UpdatePassword(int id, string password)
{
return(DbUtil.UpdateWhatWhere <User>(new { password }, new { id }, Cs));
}
public int Delete <T>(int id) where T : new()
{
return(DbUtil.Delete <T>(id, Cs));
}
public IEnumerable <IndicatorValue> GetBy(int fpiId)
{
return(DbUtil.ExecuteReaderSp <IndicatorValue>("getIndicatorValues", new { fpiId }, Cs));
}
public int InsertNoIdentity(object o)
{
return(DbUtil.InsertNoIdentity(o, Cs));
}
public IEnumerable <int> GetUsedIn(DateTime month)
{
return(DbUtil.ExecuteReaderSpValueType <int>("getUsedMeasureIds", Cs, new { month }));
}
public int Insert(object o)
{
return(DbUtil.Insert(o, Cs));
}
public IEnumerable <Measure> GetUnassigned(int measuresetId)
{
return(DbUtil.ExecuteReaderSp <Measure>("getUnassignedMeasures", new { measuresetId }, Cs));
}
public IEnumerable <Competitor> Losers(int fpiId)
{
return(DbUtil.ExecuteReaderSp <Competitor>("getLosers", new { fpiId }, Cs));
}
public int Unassign(int measureId, int measuresetId)
{
return(DbUtil.ExecuteNonQuerySp("unassignMeasure", new { measureId, measuresetId }, Cs));
}
public int UnassignField(int fieldId, int fieldsetId)
{
return(DbUtil.ExecuteNonQuerySp("unassignField", new { fieldId, fieldsetId }, Cs));
}
public int ChangeState(int id, DossierStates stateId)
{
return(DbUtil.ExecuteNonQuerySp("changeDossierState", new { id, stateId }, Cs));
}
