/// <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)); }
/// <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)); }
/// <summary> /// Selects all records as a collection (List) of Course /// </summary> public static List <Course> SelectAll() { return(CourseDataLayer.SelectAll()); }
/// <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)); }
/// <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)); }
/// <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)); }
/// <summary> /// Gets the total number of records in the Course table /// </summary> public static int GetRecordCount() { return(CourseDataLayer.GetRecordCount()); }
/// <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)); }
/// <summary> /// Selects a record by primary key(s) /// </summary> public static Course SelectByPrimaryKey(int courseId) { return(CourseDataLayer.SelectByPrimaryKey(courseId)); }
/// <summary> /// Deletes a record based on primary key(s) /// </summary> public static void Delete(int courseId) { CourseDataLayer.Delete(courseId); }
/// <summary> /// Updates a record /// </summary> public void Update() { Course objCourse = (Course)this; CourseDataLayer.Update(objCourse); }
/// <summary> /// Inserts a record /// </summary> public int Insert() { Course objCourse = (Course)this; return(CourseDataLayer.Insert(objCourse)); }
/// <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()); }