public void Test_Find_FindsCourseInDatabase()
        {
            Course testCourse = new Course("Intro to programming",975,"Epicodus","5 weeks");
              testCourse.Save();

              Course foundCourse = Course.Find(testCourse.GetId());

              Assert.Equal(testCourse, foundCourse);
        }
        public void Test_Save_SavesToDatabase()
        {
            Course testCourse = new Course("Intro to programming",975,"Epicodus","5 weeks");

              testCourse.Save();
              List<Course> result = Course.GetAll();
              List<Course> testList = new List<Course>{testCourse};

              Assert.Equal(testList, result);
        }
        public void Test_Save_AssignsIdToObject()
        {
            Course testCourse=new Course("Intro to programming",975,"Epicodus","5 weeks");

              testCourse.Save();
              Course savedCourse = Course.GetAll()[0];
              int result=savedCourse.GetId();
              int testId=testCourse.GetId();

              Assert.Equal(testId,result);
        }
        public HomeModule()
        {
            Get["/"] = _ => {
            return View["index.cshtml"];
              };

              Get["/all"] = _ => {
            List<Course> allCourses=Course.GetAll();
            return View["view_all.cshtml", allCourses];
              };

              Post["/results"] = _ => {
            Course newCourse = new Course(
            Request.Form["new-course"],
            Request.Form["new-cost"],
            Request.Form["new-company"],
            Request.Form["new-duration"]);
            newCourse.Save();
            List<Course> allCourses=Course.GetAll();
            return View["results.cshtml", allCourses];
              };
              Get["/find"] = _ => {

            return View["find.cshtml"];
              };

              Get["/delete"] = _ => {

            return View["delete.cshtml"];
              };

              Get["/findForm"] = _ => {
            int idName = int.Parse(Request.Query["old-id"]);
            Course newCourse=Course.Find(idName);
            return View["find-result.cshtml",newCourse];
              };

              Post["/delete"] = _ => {
            Course.DeleteAll();
            return View["confirm.cshtml"];
              };
        }
Beispiel #5
0
        public static Course Find(int id)
        {
            SqlConnection conn = DB.Connection();
              conn.Open();
              SqlCommand cmd = new SqlCommand("SELECT * FROM courses WHERE id =@CourseId;", conn);
              SqlParameter courseIdParameter = new SqlParameter();
              courseIdParameter.ParameterName="@CourseId";
              courseIdParameter.Value=id.ToString();
              cmd.Parameters.Add(courseIdParameter);
              SqlDataReader rdr = cmd.ExecuteReader();

              int foundCourseId=0;
              string foundCourseName= null;
              int foundCourseCost= 0;
              string foundCourseCompany= null;
              string foundCourseDuration= null;

              while(rdr.Read())
              {
            foundCourseId=rdr.GetInt32(0);
            foundCourseName=rdr.GetString(1);
            foundCourseCost=rdr.GetInt32(2);
            foundCourseCompany=rdr.GetString(3);
            foundCourseDuration=rdr.GetString(4);

              }
              Course foundCourse = new Course(foundCourseName, foundCourseCost,foundCourseCompany, foundCourseDuration,foundCourseId);
              if(rdr != null)
              {
            rdr.Close();
              }
              if(conn !=null)
              {
            conn.Close();
              }
              return foundCourse;
        }
Beispiel #6
0
        public static List<Course> GetAll()
        {
            List<Course> allCourses = new List<Course>{};

              SqlConnection conn = DB.Connection();
              conn.Open();

              SqlCommand cmd = new SqlCommand("SELECT * FROM courses;", conn);
              SqlDataReader rdr = cmd.ExecuteReader();

              while(rdr.Read())
              {
            int courseId = rdr.GetInt32(0);
            string courseName = rdr.GetString(1);
            int courseCost = rdr.GetInt32(2);
            string courseComapny=rdr.GetString(3);
            string courseDuration=rdr.GetString(4);
            Course newCourse = new Course(courseName, courseCost,courseComapny,courseDuration,courseId);
            allCourses.Add(newCourse);
              }

              if (rdr != null)
              {
            rdr.Close();
              }
              if (conn != null)
              {
            conn.Close();
              }

              return allCourses;
        }
 public void Test_Equal_ReturnsTrueIfDescriptionsAreTheSame()
 {
     Course firstCourse = new Course("Intro to programming",975,"Epicodus","5 weeks");
       Course secondCourse = new Course("Intro to programming",975,"Epicodus","5 weeks");
       Assert.Equal(firstCourse,secondCourse);
 }