public JsonResult GetCourses()
{
DataTableGenerator dtGen = new DataTableGenerator();
DataTable coursesDT = new DataTable();
coursesDT = dtGen.GetDataTable(@"SELECT id,coursename,par,blueteeRating,WhiteTeeRating,CourseSlope,AddressID From Courses");
string coursesDTstring = dtGen.ConvertDataTableToJSONString(coursesDT);
return Json(coursesDTstring, JsonRequestBehavior.AllowGet);
}
public JsonResult GetUsers()
{
DataTableGenerator dtGen = new DataTableGenerator();
DataTable usersDT = new DataTable();
usersDT = dtGen.GetDataTable("Select id,fname,lname,email,username from Users");
string usersJSONString = dtGen.ConvertDataTableToJSONString(usersDT);
return Json(usersJSONString, JsonRequestBehavior.AllowGet);
}
public JsonResult GetScores()
{
DataTableGenerator dtGen = new DataTableGenerator();
DataTable scoresDT = new DataTable();
scoresDT = dtGen.GetDataTable(@"
select top 20 scores.id,users.id,scores.courseid,courses.coursename,scores.score,scores.dateplayed,scores.adjustedscore
from scores inner join users
on scores.userid = users.id
inner join courses on courses.id = scores.courseid
where users.id = " + Convert.ToInt32(Session["id"]) + "order by scores.dateplayed DESC");
string scoresJSONString = dtGen.ConvertDataTableToJSONString(scoresDT);
return Json(scoresJSONString, JsonRequestBehavior.AllowGet);
}
public decimal AdjustScore(int score, int courseid)
{
DataTable courseDT = new DataTable();
DataTableGenerator dtGen = new DataTableGenerator();
courseDT = dtGen.GetDataTable("SELECT * FROM Courses where id = " + courseid);
DataRow dr = courseDT.Rows[0];
CoursesModel course = new CoursesModel();
course.id = Convert.ToInt32(dr["id"]);
course.coursename = dr["coursename"].ToString();
course.whiteteerating = Convert.ToDecimal(dr["whiteteerating"]);
course.courseslope = Convert.ToDecimal(dr["courseslope"]);
decimal adjustedScore = (score - course.whiteteerating) * 113 / course.courseslope;
return(adjustedScore);
}
public decimal AdjustScore(int score,int courseid)
{
DataTable courseDT = new DataTable();
DataTableGenerator dtGen = new DataTableGenerator();
courseDT = dtGen.GetDataTable("SELECT * FROM Courses where id = " + courseid);
DataRow dr = courseDT.Rows[0];
CoursesModel course = new CoursesModel();
course.id = Convert.ToInt32(dr["id"]);
course.coursename = dr["coursename"].ToString();
course.whiteteerating = Convert.ToDecimal(dr["whiteteerating"]);
course.courseslope = Convert.ToDecimal(dr["courseslope"]);
decimal adjustedScore = (score - course.whiteteerating) * 113 / course.courseslope;
return adjustedScore;
}
