public DataTable SubCategoryWithCourseNameForList(DropDownSelectionType SelectedType)
{
DataTable dt = new DataTable();
dt = DB.ExecScalerSP_DataSet(CommandType.StoredProcedure, "USP_SubCategoryWithMainCourse_Select"
, new SqlParameter("@SelectionType", (int)SelectedType)).Tables[0];
CloseAll();
return(dt);
}
public DataTable MainCourseSelectAll(DropDownSelectionType SelectedType)
{
DataTable dt = new DataTable();
dt = DB.ExecScalerSP_DataSet(CommandType.StoredProcedure, "USP_TBL_MAIN_COURSE_Select"
, new SqlParameter("@SelectionType", (int)SelectedType)).Tables[0];
CloseAll();
return(dt);
}
public DataTable SubCategorySelectAll(DropDownSelectionType SelectedType)
{
DataTable dt = new DataTable();
dt = DB.ExecScalerSP_DataSet(CommandType.StoredProcedure, "USP_TBL_SUB_CATEGORY_Select"
, new SqlParameter("@SelectionType", (int)SelectedType)).Tables[0];
CloseAll();
return(dt);
}
public DataTable SubejctForList(DropDownSelectionType SelectedType, string SubCategoryIDs)
{
DataTable dt = new DataTable();
dt = DB.ExecScalerSP_DataSet(CommandType.StoredProcedure, "USP_SubejctForList_Select"
, new SqlParameter("@SelectionType", (int)SelectedType)
, new SqlParameter("@SubCategoryIDs", SubCategoryIDs)).Tables[0];
CloseAll();
return(dt);
}
