public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
{
Dictionary <string, object> _loginResult = SCHUtil.GetInfoLogin("", "");
Dictionary <string, object> _searchResult = new Dictionary <string, object>();
DataSet _ds = new DataSet();
DataRow[] _dr = null;
string _username = _loginResult["Username"].ToString();
string _userlevel = _loginResult["Userlevel"].ToString();
string _systemGroup = _loginResult["SystemGroup"].ToString();
int _recordCount = 0;
int _recordCountPrimary = 0;
StringBuilder _list = new StringBuilder();
StringBuilder _navPage = new StringBuilder();
_ds = SCHDB.GetListStudent(_username, _userlevel, _systemGroup, _paramSearch);
_dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
_recordCount = _ds.Tables[0].Rows.Count;
_recordCountPrimary = _ds.Tables[0].Rows.Count;
_list = SCHRegisterScholarshipUI.ListUI.GetMain(_dr);
_navPage = SCHUtil.GetNavPage(_recordCount, (int)(_paramSearch["CurrentPage"]), SCHUtil.PAGE_REGISTERSCHOLARSHIP_MAIN, (int)(_paramSearch["RowPerPage"]));
_ds.Dispose();
_searchResult.Add("RecordCount", _recordCount);
_searchResult.Add("RecordCountPrimary", _recordCountPrimary);
_searchResult.Add("Sum", 0);
_searchResult.Add("List", _list);
_searchResult.Add("NavPage", _navPage);
return(_searchResult);
}
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
{
Dictionary <string, object> _searchResult = new Dictionary <string, object>();
DataSet _ds = new DataSet();
DataRow[] _dr = null;
int _recordCount = 0;
int _recordCountPrimary = 0;
StringBuilder _list = new StringBuilder();
StringBuilder _navPage = new StringBuilder();
string _page = String.Empty;
_ds = SCHDB.GetListApprovalReceiveFinance(_paramSearch);
_dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
_recordCount = _ds.Tables[0].Rows.Count;
_recordCountPrimary = _ds.Tables[0].Rows.Count;
if (_paramSearch["ScholarshipsTypeGroup"].Equals(SCHUtil.SUBJECT_ICL))
{
_list = SCHFinanceScholarshipUI.ICLUI.ApprovalReceiveFinanceUI.ListUI.GetMain(_dr);
_page = SCHUtil.PAGE_FINANCESCHOLARSHIPTYPEGROUPICLAPPROVALRECEIVEFINANCE_MAIN;
}
_navPage = SCHUtil.GetNavPage(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"]));
_ds.Dispose();
_searchResult.Add("RecordCount", _recordCount);
_searchResult.Add("RecordCountPrimary", _recordCountPrimary);
_searchResult.Add("Sum", 0);
_searchResult.Add("List", _list);
_searchResult.Add("NavPage", _navPage);
return(_searchResult);
}
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
{
Dictionary <string, object> _loginResult = SCHUtil.GetInfoLogin("", "");
Dictionary <string, object> _searchResult = new Dictionary <string, object>();
DataSet _ds = new DataSet();
DataRow[] _dr = null;
string _username = _loginResult["Username"].ToString();
string _userlevel = _loginResult["Userlevel"].ToString();
string _systemGroup = _loginResult["SystemGroup"].ToString();
int _recordCount = 0;
int _recordCountPrimary = 0;
object _sum = 0;
StringBuilder _list = new StringBuilder();
StringBuilder _navPage = new StringBuilder();
_ds = SCHDB.GetListTranStudentFinanceScholarshipClassificationRecipient(_username, _userlevel, _systemGroup, _paramSearch);
_dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
_recordCount = _ds.Tables[0].Rows.Count;
_recordCountPrimary = _ds.Tables[0].Rows.Count;
_sum = _ds.Tables[0].Compute("SUM(tuition)", "");
_list = SCHReportScholarshipUI.ListOfPeopleApprovedFinanceFromICLUI.ListUI.GetMain(_dr);
_navPage = SCHUtil.GetNavPage(_recordCount, (int)(_paramSearch["CurrentPage"]), SCHUtil.PAGE_REPORTLISTOFPEOPLEAPPROVEDFINANCEFROMICL_MAIN, (int)(_paramSearch["RowPerPage"]));
_ds.Dispose();
_searchResult.Add("RecordCount", _recordCount);
_searchResult.Add("RecordCountPrimary", _recordCountPrimary);
_searchResult.Add("Sum", (!String.IsNullOrEmpty(_sum.ToString()) ? _sum : 0));
_searchResult.Add("List", _list);
_searchResult.Add("NavPage", _navPage);
return(_searchResult);
}
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
{
Dictionary <string, object> _searchResult = new Dictionary <string, object>();
DataSet _ds = new DataSet();
DataRow[] _dr = null;
int _recordCount = 0;
int _recordCountPrimary = 0;
StringBuilder _list = new StringBuilder();
StringBuilder _navPage = new StringBuilder();
_ds = SCHDB.GetListCheque(_paramSearch);
_dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
_recordCount = _ds.Tables[0].Rows.Count;
_recordCountPrimary = _ds.Tables[0].Rows.Count;
_list = SCHFinanceScholarshipUI.ICLUI.PayChequeUI.ListUI.GetMain(_dr);
_navPage = SCHUtil.GetNavPage(_recordCount, (int)(_paramSearch["CurrentPage"]), SCHUtil.PAGE_FINANCESCHOLARSHIPTYPEGROUPICLPAYCHEQUE_MAIN, (int)(_paramSearch["RowPerPage"]));
_ds.Dispose();
_searchResult.Add("RecordCount", _recordCount);
_searchResult.Add("RecordCountPrimary", _recordCountPrimary);
_searchResult.Add("Sum", 0);
_searchResult.Add("List", _list);
_searchResult.Add("NavPage", _navPage);
return(_searchResult);
}
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch)
{
Dictionary <string, object> _loginResult = SCHUtil.GetInfoLogin("", "");
Dictionary <string, object> _searchResult = new Dictionary <string, object>();
DataSet _ds = new DataSet();
DataRow[] _dr = null;
string _username = _loginResult["Username"].ToString();
string _userlevel = _loginResult["Userlevel"].ToString();
string _systemGroup = _loginResult["SystemGroup"].ToString();
string[] _scholarshipsTypeGroup = _paramSearch["ScholarshipsId"].ToString().Split(':');
int _recordCount = 0;
int _recordCountPrimary = 0;
StringBuilder _list = new StringBuilder();
StringBuilder _navPage = new StringBuilder();
_ds = SCHDB.GetListTranStudentManageScholarship(_username, _userlevel, _systemGroup, _paramSearch);
_dr = _ds.Tables[0].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]);
_recordCount = _ds.Tables[0].Rows.Count;
_recordCountPrimary = _ds.Tables[0].Rows.Count;
if (_paramSearch["ScholarshipsTypeGroup"].Equals(""))
{
_list = SCHManageScholarshipUI.StudentCancelUI.ListUI.GetMain(_dr);
}
if (_paramSearch["ScholarshipsTypeGroup"].Equals(SCHUtil.SUBJECT_ICL))
{
_list = SCHManageScholarshipUI.ICLUI.StudentCancelUI.ListUI.GetMain(_dr);
}
_navPage = SCHUtil.GetNavPage(_recordCount, (int)(_paramSearch["CurrentPage"]), SCHUtil.PAGE_MANAGESCHOLARSHIPSTUDENTCANCEL_MAIN, (int)(_paramSearch["RowPerPage"]));
_ds.Dispose();
_searchResult.Add("RecordCount", _recordCount);
_searchResult.Add("RecordCountPrimary", _recordCountPrimary);
_searchResult.Add("Sum", 0);
_searchResult.Add("List", _list);
_searchResult.Add("NavPage", _navPage);
return(_searchResult);
}