public ActionResult StudentResultEntry(Enrollment enrollment)
{
LoadDropdownList(enrollment);
if (enrollment.StudentId == 0 || enrollment.CourseId == 0 || enrollment.GradeLetterId == null)
{
ViewBag.Message = "All fields are required.";
return(View());
}
GradeLetter gradeLetter = (db.GradeLetters.Where(g => g.GradeLetterId == enrollment.GradeLetterId)).Single();
Course course = (db.Courses.Where(c => c.CourseId == enrollment.CourseId)).Single();
Student student = (db.Students.Where(s => s.StudentId == enrollment.StudentId)).Single();
Enrollment enrolled = (db.Enrollments.Where(e => (e.StudentId == student.StudentId && e.CourseId == course.CourseId))).Single();
bool check = db.Enrollments.Count(e => (e.StudentId == student.StudentId && e.CourseId == course.CourseId && e.GradeLetter != null)) == 1;
enrollment = enrolled;
enrollment.GradeLetter = gradeLetter;
enrollment.GradeLetterId = gradeLetter.GradeLetterId;
enrollment.Student = enrolled.Student;
enrollment.StudentId = enrolled.StudentId;
enrollment.Course = course;
if (!check)
{
db.Entry(enrollment).State = EntityState.Modified;
db.SaveChanges();
//return RedirectToAction("Index");
ViewBag.Saved = student.Name + " got " + gradeLetter.Name + " in " + course.Name;
return(View(enrollment));
}
ViewBag.Message = course.Name + " course grade already assigned for " + student.Name;
return(View(enrollment));
}
public void Quiz100PercentTest(double per, GradeLetter letter)
{
var answer = new Answer()
{
CorrectAnswer = 1, UserInput = per
};
var gradeScore = new QuizScorer(new AnswerScorerPercent());
var grade = gradeScore.CalculateScore(new [] { answer });
Assert.AreEqual(letter, grade.GradeLetter);
}
public List <GradeLetter> AllGradeLetters()
{
string query = "SELECT * FROM GradeLetterTB";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <GradeLetter> gradeLetters = new List <GradeLetter>();
while (Reader.Read())
{
GradeLetter grade = new GradeLetter();
grade.Id = Convert.ToInt32(Reader["Id"]);
grade.GradeLetterMarkes = Reader["GradeLetterMarkes"].ToString();
gradeLetters.Add(grade);
}
Connection.Close();
return(gradeLetters);
}
public List <GradeLetter> GetAllGradeLetters()
{
Query = "SELECT * FROM Grade_tb";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <GradeLetter> gradeLetters = new List <GradeLetter>();
while (Reader.Read())
{
GradeLetter aGradeLetter = new GradeLetter()
{
Id = Convert.ToInt32(Reader["Id"]),
Grade = Convert.ToString(Reader["Grade"])
};
gradeLetters.Add(aGradeLetter);
}
Connection.Close();
Reader.Close();
return(gradeLetters);
}
public List <GradeLetter> GetAllGradeLetters()
{
string query = "SELECT * FROM GradeLetter";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <GradeLetter> gradeLetterList = new List <GradeLetter>();
while (Reader.Read())
{
GradeLetter gradeLetter = new GradeLetter();
gradeLetter.GradeLetterId = Convert.ToInt32(Reader["GradeLetterId"]);
gradeLetter.GradeLetterName = Reader["GradeLetterName"].ToString();
gradeLetterList.Add(gradeLetter);
}
Connection.Close();
return(gradeLetterList);
}
