protected void btnDeleteHomework_Click(object sender, EventArgs e)
{
Homework homework = new Homework();
Question question = new Question();
IssuedHomework issuedHomework = new IssuedHomework();
QuestionToAnswer questionToAnswer = new QuestionToAnswer();
ArrayList issHwIds = new ArrayList();
issHwIds = issuedHomework.selectAllIssuedHomeworkFromCore(hwID);
for (int i = 0; i < issHwIds.Count; i++)
{
questionToAnswer.deleteIssuedQuestions(issHwIds[i].ToString());
}
issuedHomework.deleteIssuedHomework(hwID);
question.deleteQuestions(hwID);
homework.deleteCoreHomework(hwID);
Session["SelectedHomework"] = null;
Response.Redirect("Teacher_View_All_Homework.aspx");
}
private void displayMarked()
{
string query = "SELECT * FROM IssuedHomework WHERE StudentID = " + userID + " AND Marked = '1'";
ArrayList queryCount = new ArrayList();
IssuedHomework homework = new IssuedHomework();
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader re = cmd.ExecuteReader();
while (re.Read())
{
homework = new IssuedHomework(re["IssuedHomeworkID"].ToString());
queryCount.Add(homework);
}
if (queryCount.Count != 0)
{
markedHomework.Visible = true;
}
else
{
markedHomework.Visible = false;
}
conn.Close();
}
private void displayOverdue()
{
string query = "SELECT * FROM IssuedHomework WHERE StudentID = " + userID + " AND DueDate < CURRENT_TIMESTAMP AND SubmissionDate = NULL";
ArrayList queryCount = new ArrayList();
IssuedHomework homework = new IssuedHomework();
conn.Open();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader re = cmd.ExecuteReader();
while (re.Read())
{
homework = new IssuedHomework(re["IssuedHomeworkID"].ToString());
queryCount.Add(homework);
}
if (queryCount.Count != 0)
{
overdueHomework.Visible = true;
}
else
{
overdueHomework.Visible = false;
}
conn.Close();
}
protected void displayAllQuestions()
{
currentIssuedHomeworkID = Session["SelectedHomework"].ToString();
//read issued homework
//read questions from homework
//display questions
IssuedHomework thisHomework = new IssuedHomework();
thisHomework = thisHomework.readSelectedIssuedHomework(currentIssuedHomeworkID);
Homework originalHomework = new Homework();
originalHomework.readSingleCoreHomework(thisHomework.CoreHomeworkID);
homeworkTitle.InnerText = originalHomework.hwTitle;//not sure if this is displaying
timeEstemate.InnerText = "This homework should take " + thisHomework.TimeToComplete + " minutes to complete";
ArrayList allSelectedQuestions = new ArrayList();
QuestionToAnswer question = new QuestionToAnswer();
allSelectedQuestions = question.readSelectedQuestionInHomework(currentIssuedHomeworkID);
if (allSelectedQuestions.Count == 1)
{
fillQuestion1();
}
else if (allSelectedQuestions.Count == 2)
{
fillQuestion1();
fillQuestion2();
}
else if (allSelectedQuestions.Count == 3)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
}
else if (allSelectedQuestions.Count == 4)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
}
else if (allSelectedQuestions.Count == 5)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
}
else if (allSelectedQuestions.Count == 6)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
fillQuestion6();
}
else if (allSelectedQuestions.Count == 7)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
fillQuestion6();
fillQuestion7();
}
else if (allSelectedQuestions.Count == 8)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
fillQuestion6();
fillQuestion7();
fillQuestion8();
}
else if (allSelectedQuestions.Count == 9)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
fillQuestion6();
fillQuestion7();
fillQuestion8();
fillQuestion9();
}
else if (allSelectedQuestions.Count == 10)
{
fillQuestion1();
fillQuestion2();
fillQuestion3();
fillQuestion4();
fillQuestion5();
fillQuestion6();
fillQuestion7();
fillQuestion8();
fillQuestion9();
fillQuestion10();
}
else
{
}
}
protected void btnSubmitHomework_Click(object sender, EventArgs e)
{
currentIssuedHomeworkID = Session["SelectedHomework"].ToString();
ArrayList allSelectedQuestions = new ArrayList();
QuestionToAnswer question = new QuestionToAnswer();
allSelectedQuestions = question.readSelectedQuestionInHomework(currentIssuedHomeworkID);
//bool allQsAnswered = false;// answerQuestion(){ if (txtAnswer == null) { allQAnsw = false } else { allQAnsw = true } }
if (allSelectedQuestions.Count == 1)
{
answerQuestion1();
}
else if (allSelectedQuestions.Count == 2)
{
answerQuestion1();
answerQuestion2();
}
else if (allSelectedQuestions.Count == 3)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
}
else if (allSelectedQuestions.Count == 4)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
}
else if (allSelectedQuestions.Count == 5)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
}
else if (allSelectedQuestions.Count == 6)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
answerQuestion6();
}
else if (allSelectedQuestions.Count == 7)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
answerQuestion6();
answerQuestion7();
}
else if (allSelectedQuestions.Count == 8)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
answerQuestion6();
answerQuestion7();
answerQuestion8();
}
else if (allSelectedQuestions.Count == 9)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
answerQuestion6();
answerQuestion7();
answerQuestion8();
answerQuestion9();
}
else if (allSelectedQuestions.Count == 10)
{
answerQuestion1();
answerQuestion2();
answerQuestion3();
answerQuestion4();
answerQuestion5();
answerQuestion6();
answerQuestion7();
answerQuestion8();
answerQuestion9();
answerQuestion10();
}
else
{
}
IssuedHomework thisHomework = new IssuedHomework();
thisHomework.updateSubmittedHomework(currentIssuedHomeworkID);
Session["SelectedHomework"] = null;
Response.Redirect("Student_Home.aspx");
}
protected void btnSubmitMarkedHomework_Click(object sender, EventArgs e)
{
ArrayList allSelectedQuestions = new ArrayList();
QuestionToAnswer question = new QuestionToAnswer();
allSelectedQuestions = question.readSelectedQuestionInHomework(hwID);
validateInputs = false;
string totalMarks = "";
if (allSelectedQuestions.Count == 1)
{
checkInput1();
}
else if (allSelectedQuestions.Count == 2)
{
checkInput1();
checkInput2();
}
else if (allSelectedQuestions.Count == 3)
{
checkInput1();
checkInput2();
checkInput3();
}
else if (allSelectedQuestions.Count == 4)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
}
else if (allSelectedQuestions.Count == 5)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
}
else if (allSelectedQuestions.Count == 6)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
checkInput6();
}
else if (allSelectedQuestions.Count == 7)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
checkInput6();
checkInput7();
}
else if (allSelectedQuestions.Count == 8)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
checkInput6();
checkInput7();
checkInput8();
}
else if (allSelectedQuestions.Count == 9)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
checkInput6();
checkInput7();
checkInput8();
checkInput9();
}
else if (allSelectedQuestions.Count == 10)
{
checkInput1();
checkInput2();
checkInput3();
checkInput4();
checkInput5();
checkInput6();
checkInput7();
checkInput8();
checkInput9();
checkInput10();
}
else
{
}
if (validateInputs == false)
{
if (allSelectedQuestions.Count == 1)
{
feedbackAnswer1();
totalMarks = totalMarks1Qs();
}
else if (allSelectedQuestions.Count == 2)
{
feedbackAnswer1();
feedbackAnswer2();
totalMarks = totalMarks2Qs();
}
else if (allSelectedQuestions.Count == 3)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
totalMarks = totalMarks3Qs();
}
else if (allSelectedQuestions.Count == 4)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
totalMarks = totalMarks4Qs();
}
else if (allSelectedQuestions.Count == 5)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
totalMarks = totalMarks5Qs();
}
else if (allSelectedQuestions.Count == 6)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
feedbackAnswer6();
totalMarks = totalMarks6Qs();
}
else if (allSelectedQuestions.Count == 7)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
feedbackAnswer6();
feedbackAnswer7();
totalMarks = totalMarks7Qs();
}
else if (allSelectedQuestions.Count == 8)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
feedbackAnswer6();
feedbackAnswer7();
feedbackAnswer8();
totalMarks = totalMarks8Qs();
}
else if (allSelectedQuestions.Count == 9)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
feedbackAnswer6();
feedbackAnswer7();
feedbackAnswer8();
feedbackAnswer9();
totalMarks = totalMarks9Qs();
}
else if (allSelectedQuestions.Count == 10)
{
feedbackAnswer1();
feedbackAnswer2();
feedbackAnswer3();
feedbackAnswer4();
feedbackAnswer5();
feedbackAnswer6();
feedbackAnswer7();
feedbackAnswer8();
feedbackAnswer9();
feedbackAnswer10();
totalMarks = totalMarks10Qs();
}
else
{
}
IssuedHomework thisHomework = new IssuedHomework();
thisHomework.updateMarkHomework(hwID);
thisHomework.updateHomeworkTotal(hwID, totalMarks);
Session["SelectedHomework"] = null;
Response.Redirect("Teacher_Home.aspx");
}
else
{
//incorrect input please try again with correct input
//problems could be; awarded marks are higher than maximum achivable
}
}
protected void btnAssignHomework_Click(object sender, EventArgs e)
{
string selectedHW = dropSelectHomework.SelectedValue.ToString();
string selectedClass = drpSelectClass.SelectedValue.ToString();
string setByTeacher = userID;//logged in teacher ----------------------------------------------------------------------------------------------
ArrayList studentsInSelectedClass = selectedClassStudentIDs(selectedClass);
if (dueDateIn.Text != "")
{
string timeToComplete = originalTimeToCompleteCopy();
DateTime dueDate = Convert.ToDateTime(dueDateIn.Text);
//create issued homework
for (int i = 0; i < studentsInSelectedClass.Count; i++)
{
IssuedHomework newHW = new IssuedHomework(selectedHW, studentsInSelectedClass[i].ToString(), setByTeacher, timeToComplete, dueDate);
newHW.createIssuedHomework();
}
ArrayList newIssuedHW = new ArrayList();
IssuedHomework allIssHW = new IssuedHomework();
ArrayList arrAllIssHW = allIssHW.readAllNewIssuedHomework();
//adds newest issued hw id's to arraylist
for (int i = 0; i < studentsInSelectedClass.Count; i++)
{
int currentHWID = (arrAllIssHW.Count - 1) - i;
newIssuedHW.Add(arrAllIssHW[currentHWID]);
}
string questionQuery = "SELECT * FROM CoreQuestions WHERE CoreHomeworkParent = " + selectedHW;
//ArrayList selectedQuestions = new ArrayList();
conn.Open();
SqlCommand cmd = new SqlCommand(questionQuery, conn);
//cmd.Parameters.AddWithValue("@id", selectedHW);
SqlDataReader re = cmd.ExecuteReader();
QuestionToAnswer newQ = new QuestionToAnswer();
while (re.Read())
{
for (int i = 0; i < newIssuedHW.Count; i++)//homework count
{
string IssuedHomeworkID, QuestionText, QuestionNumber, MarksForQuestion;
IssuedHomeworkID = newIssuedHW[i].ToString();
QuestionText = re["QuestionToAnswer"].ToString();
QuestionNumber = re["QuestionNumber"].ToString();
MarksForQuestion = re["MaximumMarksForQuestion"].ToString();
//homework id in the questions to answer db table is now an int
//line 99 is where it breaks, if not line 100
//the hwid should be fine as a string but the conversion is breaking somwhere, making both sides an int didnt help (the string was referencing an int)
//
newQ = new QuestionToAnswer(IssuedHomeworkID, QuestionText, QuestionNumber, MarksForQuestion);
newQ.createQuestionToAnswer();
}
}
conn.Close();
dueDateIn.Text = "";
lblErrorMessage.Visible = false;
divErrorMessage.Visible = false;
lblSuccessMessage.Visible = true;
divSuccessMessage.Visible = true;
}
else
{
lblErrorMessage.Visible = true;
divErrorMessage.Visible = true;
lblSuccessMessage.Visible = false;
divSuccessMessage.Visible = false;
}
}
