public IHttpActionResult GetRestaurentScores() { using (RHSEntities db = new RHSEntities()) { var scores = db.SP_GetAvgScoresByRestaurent().ToList(); return(Ok(scores)); } }
public IHttpActionResult GetZipScores() { using (RHSEntities db = new RHSEntities()) { var scores = db.SP_GetScoresByZip().ToList(); return(Ok(scores)); } }
public IHttpActionResult GetScores() { using (RHSEntities db = new RHSEntities()) { List <SP_GetScores_Result> scores = db.SP_GetScores().ToList <SP_GetScores_Result>(); return(Ok(scores)); } }
public IHttpActionResult getKPI() { try { using (RHSEntities db = new RHSEntities()) { int total = db.latest_scores.Count(); int aTotal = db.latest_scores.Where(s => s.ins_grade == "A").Count(); int bTotal = db.latest_scores.Where(s => s.ins_grade == "B").Count(); int cTotal = db.latest_scores.Where(s => s.ins_grade == "C").Count(); int dTotal = db.latest_scores.Where(s => s.ins_grade == "D").Count(); return(Ok(new { Total = total, ATotal = aTotal, BTotal = bTotal, CTotal = cTotal })); } } catch (Exception e) { return(Ok(new { Total = 0, ATotal = 0, BTotal = 0, CTotal = 0, ErrorMessage = e.Message })); } }