public void AddCourse(Course newCourse) { using (SqlConnection cn = new SqlConnection(Settings.GetConnectionString())) { var p = new DynamicParameters(); p.Add("@TeacherId", newCourse.TeacherId); p.Add("@SubjectId", newCourse.SubjectId); p.Add("@CourseName", newCourse.CourseName); p.Add("@CourseDescription", newCourse.CourseDescription); p.Add("@GradeLevelId", newCourse.GradeLevelId); p.Add("@StartDate", newCourse.StartDate); p.Add("@EndDate", newCourse.EndDate); cn.Execute("spAddCourse", p, commandType: CommandType.StoredProcedure); } }
public Response AddCourse(Course c) { var response = new Response(); try { _courseRepository.AddCourse(c); response.Success = true; } catch (Exception ex) { response.Message = ex.Message; response.Success = false; } return response; }
public void CanAddCourse() { var c = new Course() { TeacherId = 5, SubjectId = 1, CourseName = "Java+++", CourseDescription = "Prepare for the 31st century with the basics of the Java+++ scripting language", GradeLevelId = 12, StartDate = new DateTime(3029, 08, 05), EndDate = new DateTime(3029, 12, 10) }; var count = _courseRepo.GetCoursesByTeacherId(5).Count; _courseRepo.AddCourse(c); Assert.AreEqual(_courseRepo.GetCoursesByTeacherId(5).Count, count+1); }
public Course GetCourseFromVM() { var output = new Course(); output.CourseId = this.CourseId; output.TeacherId = this.TeacherId; output.SubjectId = this.SubjectId; output.CourseName = this.CourseName; output.CourseDescription = this.CourseDescription; output.GradeLevelId = this.GradeLevelId; output.IsArchived = this.IsArchived; output.StartDate = this.StartDate; output.EndDate = this.EndDate; return output; }
public Response UpdateCourseInfo(Course course) { var response = new Response(); try { _courseRepository.UpdateCourseInfo(course); response.Success = true; } catch (Exception ex) { response.Message = ex.Message; } return response; }
public void AddCourse(Course newCourse) { newCourse.CourseId = _allCourses.Max(c => c.CourseId) + 1; _allCourses.Add(newCourse); }
public void UpdateCourseInfo(Course updatedCourse) { _allCourses.RemoveAll(c => c.CourseId == updatedCourse.CourseId); _allCourses.Add(updatedCourse); }