public string SaveStudentResult(CourseAssignToStudent courseAssignToStudent)
{
if (studentResultGateway.SaveStudentResultInCourse(courseAssignToStudent)>0)
{
return "Resutl Saved Successfull for : " + courseAssignToStudent.StudentRegNum;
}
else
{
return "Resutl failled to Saved for : " + courseAssignToStudent.StudentRegNum+" !!!";
}
}
public int AssignedCourseToStudent(CourseAssignToStudent courseAssignToStudent)
{
connection.ConnectionString = connectionString;
string sqlQuery = "INSERT INTO StudentTakenCourse VALUES('" + courseAssignToStudent.StudentRegNum + "','" +
courseAssignToStudent.CourseId + "','"+courseAssignToStudent.Date+"','')";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
int isInserted = command.ExecuteNonQuery();
connection.Close();
return isInserted;
}
public int SaveStudentResultInCourse(CourseAssignToStudent courseAssignToStudent)
{
connection.ConnectionString = connectionString;
string sqlQuery = "UPDATE StudentTakenCourse SET grade='"+courseAssignToStudent.Grade+"' WHERE student_registration_number='" +
courseAssignToStudent.StudentRegNum + "' AND courseId='" + courseAssignToStudent.CourseId +
"'";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
int isInserted = command.ExecuteNonQuery();
connection.Close();
return isInserted;
}
public string SaveAssignCourseToStudent(CourseAssignToStudent courseAssignToStudent)
{
if (!courseAssignToStudentGateway.IsTakenCourse(courseAssignToStudent))
{
if (courseAssignToStudentGateway.AssignedCourseToStudent(courseAssignToStudent) > 0)
{
return "Course Enrolled Successfull .";
}
else
{
return "Course Enrolled Failled !!!";
}
}
else
{
return "Course Is Already Assigned !!!";
}
}
public bool IsTakenCourse(CourseAssignToStudent courses)
{
connection.ConnectionString = connectionString;
string sqlQuery =
"SELECT student_registration_number,courseId FROM StudentTakenCourse WHERE student_registration_number='" +
courses.StudentRegNum + "' AND courseId='" + courses.CourseId + "'";
SqlCommand command = new SqlCommand(sqlQuery, connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
connection.Close();
return true;
}
else
{
connection.Close();
return false;
}
}
public ActionResult CourseAssignToStudents(CourseAssignToStudent courseAssignToStudent)
{
ViewBag.Message = courseAssignToStudentManager.SaveAssignCourseToStudent(courseAssignToStudent);
ViewBag.StudentRegNumList = studentManager.GetStudentRegNumList();
return View();
}
