public ActionResult Index(ScenariosToGrade stg)
{
if (String.IsNullOrEmpty((string)Session["userId"]))
{
return(RedirectToAction("Login", "Account"));
}
ScenariosToGradeList stgList;
try
{
((ScenarioToGrade)Session["scenarioToGrade"]).stgID = Convert.ToInt32(Request["stgId"]);
((ScenarioToGrade)Session["scenarioToGrade"]).stgGrade = Convert.ToInt32(Request["stgGrade"]);
((ScenarioToGrade)Session["scenarioToGrade"]).stgComments = Request["stgComments"];
DatabaseUtils.addGradeForScenario(((ScenarioToGrade)Session["scenarioToGrade"]).stgID, ((ScenarioToGrade)Session["scenarioToGrade"]).stgGrade, ((ScenarioToGrade)Session["scenarioToGrade"]).stgComments);
//Call database command passing it Singleton.scenarioToGrade
stgList = DatabaseUtils.getScenariosToGrade();
}
catch (Exception ex)
{
Singleton.errorCode = "GRASEN02";
Singleton.writeErrorToFile(Singleton.errorCode, ex.Message, ex.StackTrace);
throw ex;
}
return(View(stgList));
}
public ActionResult Grades(ScenariosToGrade stg)
{
if (String.IsNullOrEmpty((string)Session["userId"]))
{
return(RedirectToAction("Login", "Account"));
}
try
{
((ScenarioToGrade)Session["scenarioToGrade"]).stgID = Convert.ToInt32(Request["stgId"]);
((ScenarioToGrade)Session["scenarioToGrade"]).stgGrade = Convert.ToInt32(Request["stgGrade"]);
((ScenarioToGrade)Session["scenarioToGrade"]).stgComments = Request["stgComments"];
DatabaseUtils.addGradeForScenario(((ScenarioToGrade)Session["scenarioToGrade"]).stgID, ((ScenarioToGrade)Session["scenarioToGrade"]).stgGrade, ((ScenarioToGrade)Session["scenarioToGrade"]).stgComments);
String name = ((StudentGrades)Session["studentGrades"]).studentName;
Session["studentGrades"] = DatabaseUtils.getStudentGrades(((ScenarioToGrade)Session["scenarioToGrade"]).stgStudentID);
((StudentGrades)Session["studentGrades"]).studentName = name;
}
catch (Exception ex)
{
Singleton.errorCode = "STUCON02";
Singleton.writeErrorToFile(Singleton.errorCode, ex.Message, ex.StackTrace);
throw ex;
}
return(View(((StudentGrades)Session["studentGrades"])));
}
/*
* This function will return a list of scenarios to grade.
*/
public static ScenariosToGradeList getScenariosToGrade(SqlConnection connection)
{
var scenariosToGradeList = new ScenariosToGradeList();
scenariosToGradeList.scenariosToGrade = new List <ScenariosToGrade>();
try
{
var questionCommand = new SqlCommand(null, connection);
questionCommand.CommandText = "SELECT SCENARIOS_TO_GRADE.STG_ID, " +
"SCENARIOS.SCENARIO_ID, " +
"SCENARIOS.SCENARIO_NAME, " +
"STUDENTS.STUDENT_ID, " +
"STUDENTS.STUDENT_NAME " +
"FROM SCENARIOS_TO_GRADE " +
"JOIN STUDENTS ON SCENARIOS_TO_GRADE.STG_STUDENT_ID = STUDENTS.STUDENT_ID " +
"JOIN SCENARIOS ON SCENARIOS_TO_GRADE.STG_SCENARIO_ID = SCENARIOS.SCENARIO_ID " +
"WHERE SCENARIOS_TO_GRADE.STG_GRADE IS NULL;";
connection.Close(); connection.Open();
questionCommand.Prepare();
using (var reader = questionCommand.ExecuteReader())
{
while (reader.Read())
{
var scenariosToGrade = new ScenariosToGrade();
scenariosToGrade.stgID = Convert.ToInt32($"{reader["STG_ID"]}");
scenariosToGrade.stgScenarioID = Convert.ToInt32($"{reader["SCENARIO_ID"]}");
scenariosToGrade.stgScenarioName = $"{reader["SCENARIO_NAME"]}";
scenariosToGrade.stgStudentID = $"{reader["STUDENT_ID"]}";
scenariosToGrade.stgStudentName = $"{reader["STUDENT_NAME"]}";
scenariosToGradeList.scenariosToGrade.Add(scenariosToGrade);
}
}
}
catch (Exception ex)
{
Singleton.errorCode = "SEN11";
Singleton.writeErrorToFile(Singleton.errorCode, ex.Message, ex.StackTrace);
throw ex;
}
finally
{
connection.Close();
}
return(scenariosToGradeList);
}