public int EnrollNewCourseToStudent(EnrollInCourse enrollInCourse)
{
string query = "INSERT INTO AssignStudentTable Values('0','" + enrollInCourse.Date + "','" + enrollInCourse.StudentId + "','" + enrollInCourse.CourseId + "','10')";
_command = new SqlCommand(query, _connection);
_connection.Open();
int rowAffect = _command.ExecuteNonQuery();
_connection.Close();
return(rowAffect);
}
public string AssignNewCourseToStudent(EnrollInCourse enrollInCourse)
{
if (_enrollCoursesGateway.IsCourseIdAndStudentIdExist(enrollInCourse))
{
return("This Course already Taken by this Student");
}
else
{
int rowAffected = _enrollCoursesGateway.EnrollNewCourseToStudent(enrollInCourse);
return(rowAffected > 0 ? "This Course Successfully Enrolled to the Student" : "Failed");
}
}
public bool IsCourseIdAndStudentIdExist(EnrollInCourse enrollInCourse)
{
string query = @"SELECT * FROM StudentAsign WHERE CourseID = '" + enrollInCourse.CourseId + "' And StudentID='" + enrollInCourse.StudentId + "' AND Status='0'";
cmd = new SqlCommand(query, connection);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
bool isExist = reader.HasRows;
reader.Close();
connection.Close();
return(isExist);
}
public ActionResult StudentEnrollInCourse(EnrollInCourse enrollCourse)
{
if (ModelState.IsValid)
{
ViewBag.StudentsRegNo = GetAllStudentForDropDown();
string result = new EnrollCourseManager().AssignNewCourseToStudent(enrollCourse);
ViewData["Message"] = result;
ModelState.Clear();
return(View());
}
else
{
ViewData["Message"] = "";
ViewBag.StudentsRegNo = GetAllStudentForDropDown();
return(View());
}
}
public int EnrollNewCourseToStudent(EnrollInCourse enrollInCourse)
{
string query = @"insert into StudentAsign (Status, Date,StudentID,CourseID,GradeID) values(@Status,@Date, @StudentID,@CourseID,@GradeID )";
cmd = new SqlCommand(query, connection);
//cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Status", "0");
cmd.Parameters.AddWithValue("@Date", enrollInCourse.Date);
cmd.Parameters.AddWithValue("@StudentID", enrollInCourse.StudentId);
cmd.Parameters.AddWithValue("@CourseID", enrollInCourse.CourseId);
cmd.Parameters.AddWithValue("@GradeID", "14");
connection.Open();
int rowAffect = cmd.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
