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);
}
