//pagination, get total public int getExamCount(string username, string keyword) { SearchExamTableAdapter tableAdapter = new SearchExamTableAdapter(); int count = Convert.ToInt32(tableAdapter.SearchExamCount(username, keyword, null, null, null)); return(count); }
/// <summary> /// Search exam as some condition /// </summary> /// <param name="sortName">order by which column</param> /// <param name="sortDirection">asc or desc</param> /// <param name="currentPage">paginatiion current page</param> /// <param name="pageSize">pagination per page size</param> /// <param name="keyword">all or unfinsihed or finished</param> /// <returns>exam result you query</returns> public OesDAL.UserDS.SearchExamDataTable SearchExam(string sortName, string sortDirection, int currentPage, int pageSize, string keyword, string userName) { try { SearchExamTableAdapter searchExamAdapter = new SearchExamTableAdapter(); //debug default query "admin" return(searchExamAdapter.GetData(sortName, sortDirection, currentPage, pageSize, userName, keyword)); } catch (Exception e) { Console.WriteLine(e.Message); } return(null); }
/// <summary> /// Search exam as some condition /// </summary> /// <param name="sortName">order by which column</param> /// <param name="sortDirection">asc or desc</param> /// <param name="currentPage">paginatiion current page</param> /// <param name="pageSize">pagination per page size</param> /// <param name="keyword">all or unfinsihed or finished</param> /// <returns>exam result you query</returns> public UserDS.SearchExamDataTable SearchExam(string sortName, string sortDirection, int currentPage, int pageSize, string keyword, string userName) { try { SearchExamTableAdapter searchExamAdapter = new SearchExamTableAdapter(); return(searchExamAdapter.SearchExam(sortName, sortDirection, currentPage, pageSize, userName, keyword)); } catch (Exception e) { Log4NetHelper.WriteErrorLog(typeof(ExamManager), e); } return(null); }
//pagination, get total count public int GetExamCount(string userName, string keyword) { int count = 0; try { SearchExamTableAdapter tableAdapter = new SearchExamTableAdapter(); count = Convert.ToInt32(tableAdapter.SearchExamCount(userName, keyword, null, null, null)); } catch (Exception e) { Log4NetHelper.WriteErrorLog(typeof(ExamManager), e); } return(count); }