public void Add(StudentModel student) { if (student.MiddleName == null) student.MiddleName = String.Empty; if (student.Suffix == null) student.Suffix = String.Empty; var sql = @" INSERT INTO Students (Id, FirstName, MiddleName, LastName, Suffix, DateOfBirth) VALUES (@Id, @FirstName, @MiddleName, @LastName, @Suffix, @DateOfBirth)"; var parameters = new[] { new SqlParameter("@Id", student.Id), new SqlParameter("@FirstName", student.FirstName), new SqlParameter("@MiddleName", student.MiddleName), new SqlParameter("@LastName", student.LastName), new SqlParameter("@Suffix", student.Suffix), new SqlParameter("@DateOfBirth", student.DateOfBirth) }; using (var connection = GetAndOpenConnection()) using (var command = GetCommand(sql, connection, parameters)) command.ExecuteNonQuery(); }
public IEnumerable<StudentModel> FindAll() { var sql = @"SELECT * FROM Students"; var students = new List<StudentModel>(); using (var connection = GetAndOpenConnection()) using (var command = GetCommand(sql, connection)) using (var reader = command.ExecuteReader()) { while (reader.Read()) { var student = new StudentModel(); student.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]); student.FirstName = Convert.ToString(reader["FirstName"]); student.Id = Guid.Parse(Convert.ToString(reader["Id"])); student.LastName = Convert.ToString(reader["LastName"]); student.MiddleName = Convert.ToString(reader["MiddleName"]); student.Suffix = Convert.ToString(reader["Suffix"]); students.Add(student); } } return students; }
public void AddStudent() { var student = new StudentModel(); controller.Add(student); mockStudentRepository.Verify(r => r.Add(student), Times.Once); mockStudentRepository.Verify(r => r.Add(It.IsAny<StudentModel>()), Times.Once); }
public void AddStudent() { var newStudent = new StudentModel(); newStudent.Id = Guid.NewGuid(); newStudent.FirstName = String.Format("First Name {0}", newStudent.Id); newStudent.MiddleName = String.Format("Middle Name {0}", newStudent.Id); newStudent.LastName = String.Format("Last Name {0}", newStudent.Id); newStudent.Suffix = String.Format("Suffix {0}", newStudent.Id); newStudent.DateOfBirth = DateTime.Now.Date; StudentRepository.Add(newStudent); var students = StudentRepository.FindAll(); var student = students.First(s => s.Id == newStudent.Id); AssertStudentsAreEqual(student, newStudent); }
public void Update(StudentModel student) { if (student.MiddleName == null) student.MiddleName = String.Empty; if (student.Suffix == null) student.Suffix = String.Empty; var sql = @" UPDATE Students SET FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName, Suffix = @Suffix, DateOfBirth = @DateOfBirth WHERE Id = @Id"; var parameters = new[] { new SqlParameter("@Id", student.Id), new SqlParameter("@FirstName", student.FirstName), new SqlParameter("@MiddleName", student.MiddleName), new SqlParameter("@LastName", student.LastName), new SqlParameter("@Suffix", student.Suffix), new SqlParameter("@DateOfBirth", student.DateOfBirth) }; using (var connection = GetAndOpenConnection()) using (var command = GetCommand(sql, connection, parameters)) command.ExecuteNonQuery(); }
private void AssertStudentsAreEqual(StudentModel actual, StudentModel expected) { Assert.That(actual.Id, Is.EqualTo(expected.Id)); Assert.That(actual.FirstName, Is.EqualTo(expected.FirstName)); Assert.That(actual.MiddleName, Is.EqualTo(expected.MiddleName)); Assert.That(actual.LastName, Is.EqualTo(expected.LastName)); Assert.That(actual.Suffix, Is.EqualTo(expected.Suffix)); Assert.That(actual.DateOfBirth, Is.EqualTo(expected.DateOfBirth)); }
private StudentModel CreateStudent() { var sql = @" INSERT INTO Students (Id, FirstName, MiddleName, LastName, Suffix, DateOfBirth) VALUES (@Id, @FirstName, @MiddleName, @LastName, @Suffix, @DateOfBirth)"; var student = new StudentModel(); student.Id = Guid.NewGuid(); student.FirstName = String.Format("First Name {0}", student.Id); student.MiddleName = String.Format("Middle Name {0}", student.Id); student.LastName = String.Format("Last Name {0}", student.Id); student.Suffix = String.Format("Suffix {0}", student.Id); student.DateOfBirth = DateTime.Now.Date; var parameters = new[] { new SqlParameter("@Id", student.Id), new SqlParameter("@FirstName", student.FirstName), new SqlParameter("@MiddleName", student.MiddleName), new SqlParameter("@LastName", student.LastName), new SqlParameter("@Suffix", student.Suffix), new SqlParameter("@DateOfBirth", student.DateOfBirth) }; using (var connection = GetAndOpenConnection()) using (var command = GetCommand(sql, connection, parameters)) command.ExecuteNonQuery(); return student; }
private StudentModel CreateStudent() { var student = new StudentModel(); student.Id = Guid.NewGuid(); student.FirstName = String.Format("First Name {0}", student.Id); student.MiddleName = String.Format("Middle Name {0}", student.Id); student.LastName = String.Format("Last Name {0}", student.Id); student.Suffix = String.Format("Suffix {0}", student.Id); student.DateOfBirth = DateTime.Now.Date; StudentRepository.Add(student); return student; }
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(); }
public void Update(StudentModel student) { studentRepository.Update(student); }
public void Add(StudentModel student) { studentRepository.Add(student); }