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