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());
}