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