/// <summary>
/// Gets the total number of records in the Enquiry table based on search parameters
/// </summary>
public static int GetRecordCountDynamicWhere(int?enquiryId, int?courseId, string studentName, Int64?contactNo, string comments)
{
return(EnquiryDataLayer.GetRecordCountDynamicWhere(enquiryId, courseId, studentName, contactNo, comments));
}
/// <summary>
/// Gets the total number of records in the Enquiry table by EnquiryId
/// </summary>
public static int GetRecordCountByEnquiryId(int enquiryId)
{
return(EnquiryDataLayer.GetRecordCountByEnquiryId(enquiryId));
}
/// <summary>
/// Gets the total number of records in the Enquiry table by CourseId
/// </summary>
public static int GetRecordCountByCourseId(int courseId)
{
return(EnquiryDataLayer.GetRecordCountByCourseId(courseId));
}
/// <summary>
/// Deletes a record based on primary key(s)
/// </summary>
public static void Delete(int enquiryId)
{
EnquiryDataLayer.Delete(enquiryId);
}
/// <summary>
/// Gets the total number of records in the Enquiry table
/// </summary>
public static int GetRecordCount()
{
return(EnquiryDataLayer.GetRecordCount());
}
/// <summary>
/// Selects records as a collection (List) of Enquiry sorted by the sortByExpression starting from the startRowIndex, based on the search parameters
/// </summary>
public static List <Enquiry> SelectSkipAndTakeDynamicWhere(int?enquiryId, int?courseId, string studentName, Int64?contactNo, string comments, int rows, int startRowIndex, string sortByExpression)
{
sortByExpression = GetSortExpression(sortByExpression);
return(EnquiryDataLayer.SelectSkipAndTakeDynamicWhere(enquiryId, courseId, studentName, contactNo, comments, sortByExpression, startRowIndex, rows));
}
/// <summary>
/// Selects records based on the passed filters as a collection (List) of Enquiry.
/// </summary>
public static List <Enquiry> SelectAllDynamicWhere(int?enquiryId, int?courseId, string studentName, Int64?contactNo, string comments)
{
return(EnquiryDataLayer.SelectAllDynamicWhere(enquiryId, courseId, studentName, contactNo, comments));
}
/// <summary>
/// Selects EnquiryId and StudentName columns for use with a DropDownList web control, ComboBox, CheckedBoxList, ListView, ListBox, etc
/// </summary>
public static List <Enquiry> SelectEnquiryDropDownListData()
{
return(EnquiryDataLayer.SelectEnquiryDropDownListData());
}
/// <summary>
/// Selects a record by primary key(s)
/// </summary>
public static Enquiry SelectByPrimaryKey(int enquiryId)
{
return(EnquiryDataLayer.SelectByPrimaryKey(enquiryId));
}
/// <summary>
/// Selects all Enquiry by Couse, related to column CourseId
/// </summary>
public static List <Enquiry> SelectEnquiryCollectionByCourseId(int couseid)
{
return(EnquiryDataLayer.SelectEnquiryCollectionByCourseId(couseid));
}
/// <summary>
/// Selects all Enquiry by Couse, related to column CourseId, sorted by the sort expression
/// </summary>
public static List <Enquiry> SelectEnquiryCollectionByCourseId(int couseid, string sortByExpression)
{
List <Enquiry> objEnquiryCol = EnquiryDataLayer.SelectEnquiryCollectionByCourseId(couseid);
return(SortByExpression(objEnquiryCol, sortByExpression));
}
/// <summary>
/// Selects all Enquiry by Enquiry, related to column EnquiryId, sorted by the sort expression
/// </summary>
public static List <Enquiry> SelectEnquiryCollectionByEnquiryId(int enquiryId, string sortByExpression)
{
List <Enquiry> objEnquiryCol = EnquiryDataLayer.SelectEnquiryCollectionByEnquiryId(enquiryId);
return(SortByExpression(objEnquiryCol, sortByExpression));
}
/// <summary>
/// Selects all Enquiry by Enquiry, related to column EnquiryId
/// </summary>
public static List <Enquiry> SelectEnquiryCollectionByEnquiryId(int enquiryId)
{
return(EnquiryDataLayer.SelectEnquiryCollectionByEnquiryId(enquiryId));
}
/// <summary>
/// Selects records based on the passed filters as a collection (List) of Enquiry sorted by the sort expression.
/// </summary>
public static List <Enquiry> SelectAllDynamicWhere(int?enquiryId, int?courseId, string studentName, Int64?contactNo, string comments, string sortByExpression)
{
List <Enquiry> objEnquiryCol = EnquiryDataLayer.SelectAllDynamicWhere(enquiryId, courseId, studentName, contactNo, comments);
return(SortByExpression(objEnquiryCol, sortByExpression));
}
/// <summary>
/// Selects records as a collection (List) of Enquiry sorted by the sortByExpression and returns the rows (# of records) starting from the startRowIndex
/// </summary>
public static List <Enquiry> SelectSkipAndTake(int rows, int startRowIndex, string sortByExpression, bool isIncludeRelatedProperties = true)
{
sortByExpression = GetSortExpression(sortByExpression);
return(EnquiryDataLayer.SelectSkipAndTake(sortByExpression, startRowIndex, rows, isIncludeRelatedProperties));
}
/// <summary>
/// Inserts a record
/// </summary>
public int Insert()
{
Enquiry objEnquiry = (Enquiry)this;
return(EnquiryDataLayer.Insert(objEnquiry));
}
/// <summary>
/// Selects records by CourseId as a collection (List) of Enquiry sorted by the sortByExpression starting from the startRowIndex
/// </summary>
public static List <Enquiry> SelectSkipAndTakeByCourseId(int rows, int startRowIndex, string sortByExpression, int courseId)
{
sortByExpression = GetSortExpression(sortByExpression);
return(EnquiryDataLayer.SelectSkipAndTakeByCourseId(sortByExpression, startRowIndex, rows, courseId));
}
/// <summary>
/// Updates a record
/// </summary>
public void Update()
{
Enquiry objEnquiry = (Enquiry)this;
EnquiryDataLayer.Update(objEnquiry);
}
/// <summary>
/// Selects all records as a collection (List) of Enquiry
/// </summary>
public static List <Enquiry> SelectAll()
{
return(EnquiryDataLayer.SelectAll());
}
/// <summary>
/// Selects all records as a collection (List) of Enquiry sorted by the sort expression
/// </summary>
public static List <Enquiry> SelectAll(string sortByExpression)
{
List <Enquiry> objEnquiryCol = EnquiryDataLayer.SelectAll();
return(SortByExpression(objEnquiryCol, sortByExpression));
}
