public int EnrollCourseSave(EnrollCourses enroll)
{
Query = "INSERT INTO EnrollCourses VALUES(@studentId,@courseId,@enrollDate,'1')";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("studentId", SqlDbType.Int);
Command.Parameters["studentId"].Value = enroll.StudentId;
Command.Parameters.Add("courseId", SqlDbType.Int);
Command.Parameters["courseId"].Value = enroll.CourseId;
Command.Parameters.Add("enrollDate", SqlDbType.DateTime);
Command.Parameters["enrollDate"].Value = enroll.EnrollDate;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public ActionResult EnrollCourse(EnrollCourses enroll)
{
var students = studentManager.GetRegNo();
ViewBag.Students = students;
string msg = enrollStudentManager.Save(enroll);
ViewBag.Messages = msg;
return(View());
}
public ActionResult Enroll(EnrollCourses enroll)
{
ViewBag.Message = studentManager.EnrollCourseSave(enroll);
List <Student> students = studentManager.GetAllStudent();
ViewBag.Students = students;
List <Course> courses = courseManager.GetAllCourse();
ViewBag.Courses = courses;
return(View());
}
public ActionResult EnrollCourse(EnrollCourses enrollCourses)
{
try
{
string Alart = _enrollCourseManager.SaveCourseEnroll(enrollCourses);
ViewBag.Message = Alart;
GetAllDetail();
return(View());
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool IsStudentAssigned(EnrollCourses anEnrollCourse)
{
Query = "SELECT * FROM EnrollCourses WHERE StudentId = '" + anEnrollCourse.StudentId + "' AND CourseId = '" + anEnrollCourse.CourseId + "' AND AssignFlag = '1'";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
bool hasRows = false;
if (Reader.HasRows)
{
hasRows = true;
}
Reader.Close();
Connection.Close();
return(hasRows);
}
public string EnrollCourseSave(EnrollCourses enroll)
{
bool isStudentAssigned = studentGateway.IsStudentAssigned(enroll);
if (isStudentAssigned)
{
return("This course has already been assigned to this student");
}
else
{
int row = studentGateway.EnrollCourseSave(enroll);
if (row > 0)
{
return("The course has been assigned to the student successfully");
}
else
{
return("An error occured");
}
}
}
