public IEnumerable <Field> GetUnassigned(int id)
{
return(DbUtil.ExecuteReaderSp <Field>("getUnassignedFieldsByFieldsetId", new { id }, Cs));
}
public IEnumerable <CrossDistrictMeasureAmountPayed> GetCrossDistrictMeasureAmountPayed(DateTime date, int measuresetId)
{
return(DbUtil.ExecuteReaderSp <CrossDistrictMeasureAmountPayed>("crossDistricMeasureAmountPayed", new { date, measuresetId }, Cs));
}
public IEnumerable <DossiersByDistrictReport> DossiersByDistrictReport(int year, int districtId)
{
return(DbUtil.ExecuteReaderSp <DossiersByDistrictReport>("DossiersByDistrictReport", new { year, districtId }, Cs));
}
public Capo GetCapo(int id)
{
return(DbUtil.ExecuteReaderSp <Capo>("getCapo", new { id }, Cs).SingleOrDefault());
}
public IEnumerable <Capo> GetCapo(int?measureId, DateTime startDate, DateTime endDate, int?poState)
{
return(DbUtil.ExecuteReaderSp <Capo>("capo", new{ measureId, startDate, endDate, poState }, Cs));
}
public IEnumerable <Competitor> Losers(int fpiId)
{
return(DbUtil.ExecuteReaderSp <Competitor>("getLosers", new { fpiId }, Cs));
}
public IEnumerable <OperInfoReport> GetOperInfoReport(int measuresetId)
{
return(DbUtil.ExecuteReaderSp <OperInfoReport>("operInfo", new { measuresetId }, Cs));
}
public IEnumerable <Measure> GetUnassigned(int measuresetId)
{
return(DbUtil.ExecuteReaderSp <Measure>("getUnassignedMeasures", new { measuresetId }, Cs));
}
public IEnumerable <Measure> GetActives()
{
return(DbUtil.ExecuteReaderSp <Measure>("getMeasures", null, Cs));
}
public IEnumerable <IndicatorValue> GetBy(int fpiId)
{
return(DbUtil.ExecuteReaderSp <IndicatorValue>("getIndicatorValues", new { fpiId }, Cs));
}
public IEnumerable <Role> GetRoles(long id)
{
return(DbUtil.ExecuteReaderSp <Role>("getRolesByUserId", new { id }, Cs));
}
public IEnumerable <RankedDossier> GetForRanking(int measuresetId, int measureId, int month)
{
return(DbUtil.ExecuteReaderSp <RankedDossier>("getDossiersForRanking", new { measuresetId, measureId, month }, 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 Fpi GetPrevious(Fpi o)
{
return(DbUtil.ExecuteReaderSp <Fpi>("getPreviousFpi", new { o.MeasuresetId, o.MeasureId, o.Month }, Cs).SingleOrDefault());
}
