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()); }