public static Dictionary <string, object> GetSearch(string _page, Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; string _reportName = String.Empty; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); if (_page == UDSStaffUtil.PAGE_OURSERVICESDOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE_MAIN) { _reportName = UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE; } _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), _reportName, _paramSearch ); if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTLEVEL1VIEWTABLE)) { _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.AppendLine(UDSStaffOurServicesUI.DocumentStatusStudentUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString()); _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString()); } _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), "", _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 = UDSStaffOurServicesUI.CopyProfilePictureApprovedtotheStoreUI.SectionMainUI.GetList(_loginResult, _dr); _navPage = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_OURSERVICESCOPYPROFILEPICTUREAPPROVEDTOTHESTORE_MAIN, (int)(_paramSearch["RowPerPage"])); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), "", _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 = UDSStaffUploadSubmitDocumentUI.SectionMainUI.GetList(_loginResult, _dr); _navPage = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_UPLOADSUBMITDOCUMENT_MAIN, (int)(_paramSearch["RowPerPage"])); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), "", _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 = UDSStaffOurServicesUI.ExportStudentRecordsInformationForSmartCardUI.SectionMainUI.GetList(_loginResult, _dr); _navPage = Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), UDSStaffUtil.PAGE_OURSERVICESEXPORTSTUDENTRECORDSINFORMATIONFORSMARTCARD_MAIN, (int)(_paramSearch["RowPerPage"])); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }
public static Dictionary <string, object> GetSearch(Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), UDSStaffUtil.SUBJECT_SECTION_DOCUMENTSTATUSSTUDENTVIEWCHART, _paramSearch ); _recordCount = _ds.Tables[0].Rows.Count; _recordCountPrimary = _ds.Tables[0].Rows.Count; _list = UDSStaffOurServicesUI.DocumentStatusStudentUI.ViewChartUI.SectionMainUI.GetList(_loginResult, _ds); _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", new StringBuilder()); return(_searchResult); }
public static Dictionary <string, object> GetSearch(string _page, Dictionary <string, object> _paramSearch) { Dictionary <string, object> _loginResult = UDSStaffUtil.GetInfoLogin("", ""); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); DataSet _ds = new DataSet(); DataRow[] _dr = null; string _reportName = String.Empty; int _recordCount = 0; int _recordCountPrimary = 0; int _recordCountSecondary = 0; int _recordCountAllPrimary = 0; int _recordCountAllSecondary = 0; StringBuilder _list = new StringBuilder(); StringBuilder _navPage = new StringBuilder(); if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE; } if (_page.Equals(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE_MAIN)) { _reportName = UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE; } _ds = UDSStaffDB.GetListUDSStudentRecords( _loginResult["Username"].ToString(), _loginResult["Userlevel"].ToString(), _loginResult["SystemGroup"].ToString(), _reportName, _paramSearch ); if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL1VIEWTABLE)) { _dr = _ds.Tables[1].Select(); _recordCount = _ds.Tables[0].Rows.Count; _recordCountPrimary = _ds.Tables[0].Rows.Count; if (_recordCountPrimary > 0) { _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(_page, _loginResult, _dr).ToString()); _navPage.AppendLine("<div class='navpage'><div class='navpage-layout'></div></div>"); } } if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENEEDSEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLENOTSEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDRECEIVE) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLESENDNOTRECEIVE)) { _dr = _ds.Tables[2].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]); _recordCount = _ds.Tables[2].Rows.Count; _recordCountPrimary = _ds.Tables[2].Rows.Count; _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL21VIEWTABLE_MAIN, _loginResult, _dr).ToString()); _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString()); } if (_reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENEEDSEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLENOTSEND) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDRECEIVE) || _reportName.Equals(UDSStaffUtil.SUBJECT_SECTION_AUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLESENDNOTRECEIVE)) { _dr = _ds.Tables[2].Select("rowNum >= " + _paramSearch["StartRow"] + " AND rowNum <= " + _paramSearch["EndRow"]); _recordCount = _ds.Tables[2].Rows.Count; _recordCountPrimary = _ds.Tables[2].Rows.Count; _list.AppendLine(UDSStaffOurServicesUI.AuditTranscriptApprovedUI.ViewTableUI.SectionMainUI.GetList(UDSStaffUtil.PAGE_OURSERVICESAUDITTRANSCRIPTAPPROVEDLEVEL22VIEWTABLE_MAIN, _loginResult, _dr).ToString()); _navPage.AppendLine(Util.GetNavPageNew(_recordCount, (int)(_paramSearch["CurrentPage"]), _page, (int)(_paramSearch["RowPerPage"])).ToString()); } _ds.Dispose(); _searchResult.Add("RecordCount", _recordCount); _searchResult.Add("RecordCountPrimary", _recordCountPrimary); _searchResult.Add("RecordCountSecondary", _recordCountSecondary); _searchResult.Add("RecordCountAllPrimary", _recordCountAllPrimary); _searchResult.Add("RecordCountAllSecondary", _recordCountAllSecondary); _searchResult.Add("List", _list); _searchResult.Add("NavPage", _navPage); return(_searchResult); }