public void Update(CourseModel course)
{
var sql = @"
UPDATE Courses
SET
Name = @Name,
Department = @Department,
Number = @Number,
Section = @Section,
Professor = @Professor,
Year = @Year,
Semester = @Semester
WHERE Id = @Id";
var parameters = new[]
{
new SqlParameter("@Id", course.Id),
new SqlParameter("@Name", course.Name),
new SqlParameter("@Department", course.Department),
new SqlParameter("@Number", course.Number),
new SqlParameter("@Section", course.Section),
new SqlParameter("@Professor", course.Professor),
new SqlParameter("@Year", course.Year),
new SqlParameter("@Semester", course.Semester)
};
using (var connection = GetAndOpenConnection())
using (var command = GetCommand(sql, connection, parameters))
command.ExecuteNonQuery();
}
public IEnumerable<CourseModel> FindAll()
{
var sql = @"SELECT * FROM Courses";
var courses = new List<CourseModel>();
using (var connection = GetAndOpenConnection())
using (var command = GetCommand(sql, connection))
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
var course = new CourseModel();
course.Department = Convert.ToString(reader["Department"]);
course.Id = Guid.Parse(Convert.ToString(reader["Id"]));
course.Name = Convert.ToString(reader["Name"]);
course.Number = Convert.ToInt32(reader["Number"]);
course.Professor = Convert.ToString(reader["Professor"]);
course.Section = Convert.ToChar(reader["Section"]);
course.Semester = Convert.ToString(reader["Semester"]);
course.Year = Convert.ToInt32(reader["Year"]);
courses.Add(course);
}
}
return courses;
}
public void AddStudent()
{
var course = new CourseModel();
controller.Add(course);
mockCourseRepository.Verify(r => r.Add(course), Times.Once);
mockCourseRepository.Verify(r => r.Add(It.IsAny<CourseModel>()), Times.Once);
}
public void AddCourse()
{
var newCourse = new CourseModel();
newCourse.Id = Guid.NewGuid();
newCourse.Name = "Add Course";
newCourse.Department = "DEPT";
newCourse.Number = Random.Next();
newCourse.Professor = String.Format("Professor {0}", newCourse.Id);
newCourse.Year = DateTime.Now.Year;
newCourse.Semester = "SPRING";
newCourse.Section = 'K';
CourseRepository.Add(newCourse);
var courses = CourseRepository.FindAll();
var course = courses.First(c => c.Id == newCourse.Id);
AssertCoursesAreEqual(course, newCourse);
}
public void Add(CourseModel course)
{
var sql = @"
INSERT INTO Courses (Id, Name, Department, Number, Section, Professor, Year, Semester)
VALUES (@Id, @Name, @Department, @Number, @Section, @Professor, @Year, @Semester)";
var parameters = new[]
{
new SqlParameter("@Id", course.Id),
new SqlParameter("@Name", course.Name),
new SqlParameter("@Department", course.Department),
new SqlParameter("@Number", course.Number),
new SqlParameter("@Section", course.Section),
new SqlParameter("@Professor", course.Professor),
new SqlParameter("@Year", course.Year),
new SqlParameter("@Semester", course.Semester)
};
using (var connection = GetAndOpenConnection())
using (var command = GetCommand(sql, connection, parameters))
command.ExecuteNonQuery();
}
private CourseModel CreateCourse()
{
var course = new CourseModel();
course.Id = Guid.NewGuid();
course.Name = String.Format("Name {0}", course.Id);
course.Department = "DEPT";
course.Number = Random.Next(1000, 10000);
course.Professor = String.Format("Professor {0}", course.Id);
course.Year = DateTime.Now.Year;
course.Semester = "FALL";
course.Section = 'A';
CourseRepository.Add(course);
return course;
}
public void Update(CourseModel course)
{
courseRepository.Update(course);
}
public void Add(CourseModel course)
{
courseRepository.Add(course);
}
private CourseTakenModel CreateCourseTaken(StudentModel student, CourseModel course)
{
var courseTaken = new CourseTakenModel
{
Student = new NameModel { Id = student.Id, Name = student.FirstName },
Course = new NameModel { Id = course.Id, Name = course.Name },
Grade = Random.Next(110)
};
var sql = @"
INSERT INTO CoursesTaken (Student, Course, Grade)
VALUES (@Student, @Course, @Grade)";
var parameters = new[]
{
new SqlParameter("@Student", courseTaken.Student.Id),
new SqlParameter("@Course", courseTaken.Course.Id),
new SqlParameter("@Grade", courseTaken.Grade)
};
using (var connection = GetAndOpenConnection())
using (var command = GetCommand(sql, connection, parameters))
command.ExecuteNonQuery();
return courseTaken;
}
public void Setup()
{
student = CreateStudent();
course = CreateCourse();
}
private CourseModel CreateCourse()
{
var course = new CourseModel();
course.Id = Guid.NewGuid();
course.Name = String.Format("Name {0}", course.Id);
course.Department = "DEPT";
course.Number = Random.Next();
course.Professor = String.Format("Professor {0}", course.Id);
course.Year = DateTime.Now.Year;
course.Semester = "FALL";
course.Section = 'A';
var sql = @"
INSERT INTO Courses (Id, Name, Department, Number, Section, Professor, Year, Semester)
VALUES (@Id, @Name, @Department, @Number, @Section, @Professor, @Year, @Semester)";
var parameters = new[]
{
new SqlParameter("@Id", course.Id),
new SqlParameter("@Name", course.Name),
new SqlParameter("@Department", course.Department),
new SqlParameter("@Number", course.Number),
new SqlParameter("@Section", course.Section),
new SqlParameter("@Professor", course.Professor),
new SqlParameter("@Year", course.Year),
new SqlParameter("@Semester", course.Semester)
};
using (var connection = GetAndOpenConnection())
using (var command = GetCommand(sql, connection, parameters))
command.ExecuteNonQuery();
return course;
}
private void AssertCoursesAreEqual(CourseModel actual, CourseModel expected)
{
Assert.That(actual.Id, Is.EqualTo(expected.Id));
Assert.That(actual.Department, Is.EqualTo(expected.Department));
Assert.That(actual.Name, Is.EqualTo(expected.Name));
Assert.That(actual.Number, Is.EqualTo(expected.Number));
Assert.That(actual.Professor, Is.EqualTo(expected.Professor));
Assert.That(actual.Section, Is.EqualTo(expected.Section));
Assert.That(actual.Semester, Is.EqualTo(expected.Semester));
Assert.That(actual.Year, Is.EqualTo(expected.Year));
}
