Exemple #1
0
 /// <summary>
 /// Selects records based on the passed filters as a collection (List) of Course.
 /// </summary>
 public static List <Course> SelectAllDynamicWhere(int?courseId, string courseName, DateTime?startDate, DateTime?endDate, decimal?fees)
 {
     return(CourseDataLayer.SelectAllDynamicWhere(courseId, courseName, startDate, endDate, fees));
 }
Exemple #2
0
        /// <summary>
        /// Selects records based on the passed filters as a collection (List) of Course sorted by the sort expression.
        /// </summary>
        public static List <Course> SelectAllDynamicWhere(int?courseId, string courseName, DateTime?startDate, DateTime?endDate, decimal?fees, string sortByExpression)
        {
            List <Course> objCourseCol = CourseDataLayer.SelectAllDynamicWhere(courseId, courseName, startDate, endDate, fees);

            return(SortByExpression(objCourseCol, sortByExpression));
        }
Exemple #3
0
 /// <summary>
 /// Selects all records as a collection (List) of Course
 /// </summary>
 public static List <Course> SelectAll()
 {
     return(CourseDataLayer.SelectAll());
 }
Exemple #4
0
        /// <summary>
        /// Selects all records as a collection (List) of Course sorted by the sort expression
        /// </summary>
        public static List <Course> SelectAll(string sortByExpression)
        {
            List <Course> objCourseCol = CourseDataLayer.SelectAll();

            return(SortByExpression(objCourseCol, sortByExpression));
        }
Exemple #5
0
 /// <summary>
 /// Selects records as a collection (List) of Course sorted by the sortByExpression and returns the rows (# of records) starting from the startRowIndex
 /// </summary>
 public static List <Course> SelectSkipAndTake(int rows, int startRowIndex, string sortByExpression)
 {
     sortByExpression = GetSortExpression(sortByExpression);
     return(CourseDataLayer.SelectSkipAndTake(sortByExpression, startRowIndex, rows));
 }
Exemple #6
0
 /// <summary>
 /// Selects records as a collection (List) of Course sorted by the sortByExpression starting from the startRowIndex, based on the search parameters
 /// </summary>
 public static List <Course> SelectSkipAndTakeDynamicWhere(int?courseId, string courseName, DateTime?startDate, DateTime?endDate, decimal?fees, int rows, int startRowIndex, string sortByExpression)
 {
     sortByExpression = GetSortExpression(sortByExpression);
     return(CourseDataLayer.SelectSkipAndTakeDynamicWhere(courseId, courseName, startDate, endDate, fees, sortByExpression, startRowIndex, rows));
 }
Exemple #7
0
 /// <summary>
 /// Gets the total number of records in the Course table
 /// </summary>
 public static int GetRecordCount()
 {
     return(CourseDataLayer.GetRecordCount());
 }
Exemple #8
0
 /// <summary>
 /// Gets the total number of records in the Course table based on search parameters
 /// </summary>
 public static int GetRecordCountDynamicWhere(int?courseId, string courseName, DateTime?startDate, DateTime?endDate, decimal?fees)
 {
     return(CourseDataLayer.GetRecordCountDynamicWhere(courseId, courseName, startDate, endDate, fees));
 }
Exemple #9
0
 /// <summary>
 /// Selects a record by primary key(s)
 /// </summary>
 public static Course SelectByPrimaryKey(int courseId)
 {
     return(CourseDataLayer.SelectByPrimaryKey(courseId));
 }
Exemple #10
0
 /// <summary>
 /// Deletes a record based on primary key(s)
 /// </summary>
 public static void Delete(int courseId)
 {
     CourseDataLayer.Delete(courseId);
 }
Exemple #11
0
        /// <summary>
        /// Updates a record
        /// </summary>
        public void Update()
        {
            Course objCourse = (Course)this;

            CourseDataLayer.Update(objCourse);
        }
Exemple #12
0
        /// <summary>
        /// Inserts a record
        /// </summary>
        public int Insert()
        {
            Course objCourse = (Course)this;

            return(CourseDataLayer.Insert(objCourse));
        }
Exemple #13
0
 /// <summary>
 /// Selects CourseId and CourseName columns for use with a DropDownList web control, ComboBox, CheckedBoxList, ListView, ListBox, etc
 /// </summary>
 public static List <Course> SelectCourseDropDownListData()
 {
     return(CourseDataLayer.SelectCourseDropDownListData());
 }