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