/// <summary>
        /// Inserts a course category into the database
        /// </summary>
        /// <param name="entity"></param>
        /// <returns></returns>
        /// 
        public override bool InsertCourseCategory(ref CourseCategoryInfo entity)
        {
            DbCommand cmd = SqlHelpers.CreateCommand(DataHelpers.ConnectionString);
            cmd.CommandText = "dbo.mon_elrn_INSERT_COURSE_CATEGORY";

            cmd.AddInputParam("@CourseId", DbType.Int32, entity.CourseId);
            cmd.AddInputParam("@CategoryId", DbType.Int32, entity.CategoryId);

            int result;
            try
            {
                result = Convert.ToInt32(cmd.ExecuteSelectTable().Rows[0].ItemArray[0].ToString());
                if (result > 0)
                    return true;
                else
                    return false;

            }
            catch (Exception ex)
            {

                throw ex;
            }

        }
 //Course Category related functions
 public static bool InsertCourseCategory(ref CourseCategoryInfo entity) { return Instance.InsertCourseCategory(ref entity); }
 public abstract bool InsertCourseCategory(ref CourseCategoryInfo entity);
 protected void CategoryCheckBoxList_SelectedIndexChanged(object sender, EventArgs e)
 {
     for (int i = 0; i < CategoryCheckBoxList.Items.Count; i++)
     {
         CourseCategoryInfo Categoryentity = new CourseCategoryInfo();
         Categoryentity.CourseId = Convert.ToInt32(this.Id);
         if (CategoryCheckBoxList.Items[i].Selected == false)
         {
             Categoryentity.CategoryId = Convert.ToInt32(CategoryCheckBoxList.Items[i].Value.ToString());
             ClassroomController.DeleteCourseCategory(Categoryentity.CourseId, Categoryentity.CategoryId);
         }
     }
     for (int i = 0; i < CategoryCheckBoxList.Items.Count; i++)
     {
         CourseCategoryInfo Categoryentity = new CourseCategoryInfo();
         Categoryentity.CourseId = Convert.ToInt32(this.Id);
         if (CategoryCheckBoxList.Items[i].Selected == true)
         {
             Categoryentity.CategoryId = Convert.ToInt32(CategoryCheckBoxList.Items[i].Value.ToString());
             ClassroomController.InsertCourseCategory(ref Categoryentity);
         }
     }
 }