public string AddEnrollment(Enrollment enrollment)
{
var errors = new List<string>();
var repository = new EnrollmentRepository(this.entities);
var service = new EnrollmentService(repository);
service.AddEnrollment(enrollment.StudentId, enrollment.ScheduleId, ref errors);
if (errors.Count == 0)
{
return "ok";
}
return "error";
}
public List<POCO.Enrollment> GetAllStudentEnrolledSchedules(string studentId, ref List<string> errors)
{
IEnumerable<enrollment> studentEnrollments;
List<POCO.Enrollment> pocoEnrollmentList = new List<POCO.Enrollment>();
try
{
studentEnrollments = this.context.enrollments.Include("course_schedule").Where(x => x.student_id == studentId);
foreach (enrollment enrolled in studentEnrollments)
{
var poco = new POCO.Enrollment();
poco.EnrolledSchedule = new Schedule();
poco.EnrolledSchedule.Course = new Course();
poco.EnrolledSchedule.Instructor = new Instructor();
poco.EnrolledSchedule.Day = new ScheduleDay();
poco.EnrolledSchedule.Time = new ScheduleTime();
poco.ScheduleId = enrolled.schedule_id;
poco.StudentId = enrolled.student_id;
poco.Grade = enrolled.grade;
poco.EnrolledSchedule.ScheduleId = enrolled.course_schedule.schedule_id;
poco.EnrolledSchedule.Year = enrolled.course_schedule.year.ToString();
poco.EnrolledSchedule.Quarter = enrolled.course_schedule.quarter;
poco.EnrolledSchedule.Session = enrolled.course_schedule.session;
poco.EnrolledSchedule.Course.CourseId = enrolled.course_schedule.course.course_id;
poco.EnrolledSchedule.Course.Title = enrolled.course_schedule.course.course_title;
poco.EnrolledSchedule.Instructor.InstructorId = enrolled.course_schedule.instructor.instructor_id;
poco.EnrolledSchedule.Instructor.FirstName = enrolled.course_schedule.instructor.first_name;
poco.EnrolledSchedule.Instructor.LastName = enrolled.course_schedule.instructor.last_name;
poco.EnrolledSchedule.Day.DayId = enrolled.course_schedule.schedule_day.schedule_day_id;
poco.EnrolledSchedule.Day.Day = enrolled.course_schedule.schedule_day.schedule_day1;
poco.EnrolledSchedule.Time.TimeId = enrolled.course_schedule.schedule_time.schedule_time_id;
poco.EnrolledSchedule.Time.Time = enrolled.course_schedule.schedule_time.schedule_time1;
pocoEnrollmentList.Add(poco);
}
}
catch (Exception e)
{
errors.Add("Error: " + e);
}
return pocoEnrollmentList;
}
public void AddEnrollmentTest()
{
//// Arranage
var errors = new List<string>();
Mock<IEnrollmentRepository> mockRepository = new Mock<IEnrollmentRepository>();
EnrollmentService iserv = new EnrollmentService(mockRepository.Object);
Enrollment s = new Enrollment { StudentId = "99", ScheduleId = 1000, Grade = "A+", GradeValue = 3.0f };
mockRepository.Setup(x => x.AddEnrollment("99", 1000, ref errors));
mockRepository.Setup(x => x.IsNotDuplicateEnrollment("99", 1000, ref errors)).Returns(true);
//// Act
iserv.AddEnrollment("99", 1000, ref errors);
//// Assert
mockRepository.Verify(x => x.AddEnrollment("99", 1000, ref errors), Times.Once());
}
public string UpdateEnrollment(Enrollment er)
{
var errors = new List<string>();
var repository = new EnrollmentRepository(this.entities);
var service = new EnrollmentService(repository);
service.UpdateEnrollment(er, ref errors);
if (errors.Count == 0)
{
return "ok";
}
return "error";
}
public List<Enrollment> GetEnrollments(string studentId, ref List<string> errors)
{
IEnumerable<enrollment> db_EnrollmentList;
List<Enrollment> poco_EnrollmentList = new List<Enrollment>();
try
{
db_EnrollmentList = this.context.enrollments.Where(x => x.student_id == studentId);
foreach (enrollment enrolledSchedule in db_EnrollmentList)
{
Enrollment poco_Enrollment = new Enrollment();
poco_Enrollment.Grade = enrolledSchedule.grade;
poco_Enrollment.ScheduleId = enrolledSchedule.schedule_id;
poco_Enrollment.StudentId = studentId;
poco_EnrollmentList.Add(poco_Enrollment);
}
}
catch (Exception e)
{
errors.Add("Error occured in StudentRepository.GetEnrollments: " + e);
}
return poco_EnrollmentList;
}
public Enrollment GetEnrollmentDetail(string studentId, int scheduleId, ref List<string> errors)
{
var db_Enrollment = new enrollment();
var poco = new Enrollment();
try
{
db_Enrollment = this.context.enrollments.Where(x => x.schedule_id == scheduleId && x.student_id == studentId).First();
poco.StudentId = db_Enrollment.student_id;
poco.ScheduleId = db_Enrollment.schedule_id;
poco.Grade = db_Enrollment.grade;
}
catch (Exception e)
{
errors.Add("Error occured in EnrollmentRepository.AddEnrollment: " + e);
}
return poco;
}
public void UpdateEnrollment(Enrollment er, ref List<string> errors)
{
var db_Enrollment = new enrollment();
try
{
db_Enrollment = this.context.enrollments.Where(x => x.schedule_id == er.ScheduleId && x.student_id == er.StudentId).First();
db_Enrollment.grade = er.Grade;
this.context.SaveChanges();
}
catch (Exception e)
{
errors.Add("Error occured in EnrollmentRepository.AddEnrollment: " + e);
}
}
public List<Enrollment> GetEnrollments(string studentId)
{
var conn = new SqlConnection(ConnectionString);
var enrollmentList = new List<Enrollment>();
try
{
var adapter = new SqlDataAdapter(GetEnrollmentListProcedure, conn)
{
SelectCommand =
{
CommandType = CommandType.StoredProcedure
}
};
adapter.SelectCommand.Parameters.Add(new SqlParameter("@student_id", SqlDbType.VarChar, 20));
adapter.SelectCommand.Parameters["@student_id"].Value = studentId;
var dataSet = new DataSet();
adapter.Fill(dataSet);
if (dataSet.Tables[0].Rows.Count == 0)
{
return null;
}
for (var i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
var enrollment = new Enrollment
{
StudentId = dataSet.Tables[0].Rows[i]["student_id"].ToString(),
ScheduleId =
(int)
Convert.ToInt32(dataSet.Tables[0].Rows[i]["schedule_id"].ToString()),
Grade = dataSet.Tables[0].Rows[i]["grade"].ToString(),
GradeChange =
(bool)
Convert.ToBoolean(dataSet.Tables[0].Rows[i]["grade_change"].ToString()),
GradingOption = dataSet.Tables[0].Rows[i]["grading_opt"].ToString(),
};
enrollmentList.Add(enrollment);
}
}
catch (Exception e)
{
throw e;
}
finally
{
conn.Dispose();
}
return enrollmentList;
}
public void UpdateEnrollment(Enrollment er, ref List<string> errors)
{
this.repository.UpdateEnrollment(er, ref errors);
}