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 StringBuilder GetMain(Dictionary <string, object> _infoLogin, string _id) { Dictionary <string, object> _infoData = new Dictionary <string, object>(); Dictionary <string, object> _infoDataResult = UDSStaffUtil.GetInfoData(UDSStaffUtil.PAGE_SETTINGACCESSTOTHESYSTEM_EDIT, _infoData); StringBuilder _html = new StringBuilder(); _idSectionAddUpdate = _idSectionEdit; _html.AppendLine(UDSStaffUI.GetInfoBar(_infoDataResult, true).ToString()); _html.AppendLine(SectionAddUpdateUI.GetValueDataRecorded(UDSStaffUtil.SetValueDataRecorded(UDSStaffUtil.PAGE_SETTINGACCESSTOTHESYSTEM_EDIT, _id)).ToString()); _html.AppendLine(SectionAddUpdateUI.GetMain(_infoLogin).ToString()); return(_html); }
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 StringBuilder GetMain() { Dictionary <string, object> _infoData = new Dictionary <string, object>(); Dictionary <string, object> _infoDataResult = UDSStaffUtil.GetInfoData(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN, _infoData); Dictionary <string, object> _searchResult = new Dictionary <string, object>(); StringBuilder _html = new StringBuilder(); int _cookieError = Util.ChkCookie(UDSStaffUtil._myParamSearchCookieName); int _i = 0; bool _show = false; if (_cookieError.Equals(0)) { HttpCookie _objCookie = Util.GetCookie(UDSStaffUtil._myParamSearchCookieName); if (_objCookie["Command"].Equals(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN)) { _show = true; _searchResult = UDSStaffApproveDocumentUtil.GetSearch(UDSStaffUtil.SetParameterSearch(UDSStaffUtil.PAGE_APPROVEDOCUMENT_MAIN, null, true)); } } _html.AppendLine(UDSStaffUI.GetInfoBar(_infoDataResult, true).ToString()); _html.AppendLine("<div class='after-sticky main'>"); _html.AppendFormat(" <div class='table' id='{0}-table'>", _idSectionMain); _html.AppendLine(" <div class='table-layout'>"); _html.AppendLine(" <div class='table-content'>"); _html.AppendLine(" <div class='table-freeze sticky'>"); _html.AppendLine(" <div class='table-title'>"); _html.AppendFormat(" <div class='contentbody-left table-option table-rowperpage en-label'>{0}</div>", UDSStaffUI.GetComboboxRowPerPage(_idSectionMain + "-rowperpage")); _html.AppendLine(" <div class='contentbody-right table-recordcount en-label'>"); _html.AppendFormat(" <span class='recordcount-search hidden'>{0}</span>", (_show.Equals(true) ? double.Parse(_searchResult["RecordCount"].ToString()).ToString("#,##0") : String.Empty)); _html.AppendFormat(" <span class='recordcountprimary-search th-label'>{0}</span>", (_show.Equals(true) ? double.Parse(_searchResult["RecordCountPrimary"].ToString()).ToString("#,##0") : String.Empty)); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendLine(" <div class='clear'></div>"); _html.AppendLine(" <div class='table-head'>"); _html.AppendLine(" <div class='table-row'>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col1'><div class='table-col-msg'><div class='en-label'>No.</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col2'><div class='table-col-msg'><div class='en-label'>Student</div><div class='en-label'>ID</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-dynamic table-col3'><div class='table-col-msg'><div class='en-label'>Full Name</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col4'><div class='table-col-msg'><div class='en-label'>Program</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col5'><div class='table-col-msg'><div class='en-label'>Year</div><div class='en-label'>Attended</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col6'><div class='table-col-msg'><div class='en-label'>Admission</div><div class='en-label'>Type</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col7'><div class='table-col-msg'><div class='en-label'>Student</div><div class='en-label'>Status</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col8'><div class='table-col-msg'><div class='en-label'>Submitted Date</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col9'><div class='table-col-msg'><div class='en-label'>Approval</div><div class='en-label'>Status</div></div></div>"); _html.AppendLine(" <div class='table-col table-col-width-fixed table-col10'><div class='table-col-msg'><div class='en-label'>Approval Date</div></div></div>"); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendFormat(" <div class='table-list'>{0}</div>", (_show.Equals(true) ? _searchResult["List"] : String.Empty)); _html.AppendFormat(" <div class='table-navpage'>{0}</div>", (_show.Equals(true) ? _searchResult["NavPage"] : String.Empty)); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendFormat(" <div class='form mainform' id='{0}-form'>", _idSectionMain); _html.AppendLine(" <div class='form-layout mainform-layout'>"); _html.AppendLine(" <div class='form-content mainform-content'>"); _html.AppendLine(" <div class='titlebar'>"); _html.AppendLine(" <div class='th-label'></div>"); _html.AppendLine(" <div class='en-label'></div>"); _html.AppendLine(" </div>"); _html.AppendLine(" <div class='menulist'>"); _html.AppendLine(" <div class='menulist-layout'>"); _html.AppendLine(" <div class='menulist-content'>"); _html.AppendLine(" <ul>"); for (_i = 0; _i < UDSStaffApproveDocumentUtil._menu.GetLength(0); _i++) { _html.AppendFormat(" <li class='have-link'><a class='link-click link-msg' id='link-{0}' alt='{1}' href='javascript:void(0)'><div class='menu-itemtext'><div class='th-label'>{2}</div><div class='en-label'>{3}</div></div></a></li>", UDSStaffApproveDocumentUtil._menu[_i, 2].ToLower(), UDSStaffApproveDocumentUtil._menu[_i, 2], UDSStaffApproveDocumentUtil._menu[_i, 0], UDSStaffApproveDocumentUtil._menu[_i, 1]); } _html.AppendLine(" </ul>"); _html.AppendLine(" </div>"); _html.AppendLine(" <div class='button-toggle'><a class='en-label' href='javascript:void(0)'>Click to Select Document</a></div>"); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendFormat(" <input type='hidden' id='{0}-personid-hidden' value='' />", _idSectionEdit); _html.AppendFormat(" <div id='{0}-form' align='center'></div>", _idSectionEdit); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendLine(" </div>"); _html.AppendLine("</div>"); return(_html); }
public static StringBuilder GetList(Dictionary <string, object> _infoLogin, DataRow[] _dr) { StringBuilder _html = new StringBuilder(); string _userlevel = _infoLogin["Userlevel"].ToString(); string _highlight = String.Empty; string _callFunc = String.Empty; string _documentUpload = String.Empty; string _submittedStatus = String.Empty; string _submittedDate = String.Empty; string _approvalStatus = String.Empty; string _approvalDate = String.Empty; string _iconApprove = String.Empty; bool _documentUploadDual = false; int _i = 0; int _j = 0; int _k = 0; if (_dr.GetLength(0) > 0) { _html.AppendLine("<div class='table-grid'>"); foreach (DataRow _dr1 in _dr) { _documentUpload = _dr1["documentUpload"].ToString().ToLower(); _submittedStatus = String.Empty; _submittedDate = String.Empty; _approvalStatus = String.Empty; _approvalDate = String.Empty; _iconApprove = String.Empty; if (!String.IsNullOrEmpty(_documentUpload)) { if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_PROFILEPICTUREIDCARD.ToLower()) || _documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_TRANSCRIPT.ToLower())) { _documentUploadDual = true; if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_PROFILEPICTUREIDCARD.ToLower())) { _j = 1; _k = 2; } if (_documentUpload.Equals(UDSStaffUtil.SUBJECT_SECTION_TRANSCRIPT.ToLower())) { _j = 4; _k = 5; } } if (_documentUploadDual.Equals(true)) { for (_i = _j; _i <= _k; _i++) { _documentUpload = UDSStaffUtil._documentUpload[_i, 2].ToLower(); _submittedStatus = _dr1[_documentUpload + "SubmittedStatus"].ToString(); _submittedDate += (!String.IsNullOrEmpty(_dr1[_documentUpload + "SubmittedDate"].ToString()) && _submittedStatus.Equals("Y") ? ("<div class='th-label'>" + DateTime.Parse(_dr1[_documentUpload + "SubmittedDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='th-label'> </div>"); _approvalStatus = _dr1[_documentUpload + "ApprovalStatus"].ToString(); _approvalDate += (!String.IsNullOrEmpty(_dr1[_documentUpload + "ApprovalDate"].ToString()) && (_approvalStatus.Equals("Y") || _approvalStatus.Equals("N")) ? ("<div class='" + _documentUpload + "-approvaldate th-label'>" + DateTime.Parse(_dr1[_documentUpload + "ApprovalDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='" + _documentUpload + "-approvaldate th-label'> </div>"); _iconApprove += ("<div class='" + _documentUpload + "-approvalstatus uploaddocument-approvalstatus " + UDSStaffUtil.GetIconApprovalStatus(_approvalStatus) + " link-" + UDSStaffUtil.SUBJECT_SECTION_MEANINGOFAPPROVALSTATUS.ToLower() + "'><div class='en-label'>" + UDSStaffUtil._documentUpload[_i, 3] + "</div></div>"); } } else { _submittedStatus = _dr1[_documentUpload + "SubmittedStatus"].ToString(); _submittedDate = (!String.IsNullOrEmpty(_dr1[_documentUpload + "SubmittedDate"].ToString()) && _submittedStatus.Equals("Y") ? ("<div class='th-label'>" + DateTime.Parse(_dr1[_documentUpload + "SubmittedDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='th-label'> </div>"); _approvalStatus = _dr1[_documentUpload + "ApprovalStatus"].ToString(); _approvalDate = (!String.IsNullOrEmpty(_dr1[_documentUpload + "ApprovalDate"].ToString()) && (_approvalStatus.Equals("Y") || _approvalStatus.Equals("N")) ? ("<div class='" + _documentUpload + "-approvaldate th-label'>" + DateTime.Parse(_dr1[_documentUpload + "ApprovalDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss") + "</div>") : "<div class='" + _documentUpload + "-approvaldate th-label'> </div>"); _iconApprove = ("<div class='" + _documentUpload + "-approvalstatus uploaddocument-approvalstatus " + UDSStaffUtil.GetIconApprovalStatus(_approvalStatus) + " link-" + UDSStaffUtil.SUBJECT_SECTION_MEANINGOFAPPROVALSTATUS.ToLower() + "'><div class='en-label'>" + _dr1["documentUploadInitials"].ToString() + "</div></div>"); } } _highlight = (double.Parse(_dr1["rowNum"].ToString()) % 2) == 0 ? " highlight-style2" : " highlight-style1"; _callFunc = "Util.tut.getFrmPreviewDocument({" + "page:'" + UDSStaffUtil.PAGE_APPROVEDOCUMENTPROFILEPICTUREIDENTITYCARD_EDIT + "'," + "idMain:'" + _idSectionMain + "'," + "idPreview:'" + _idSectionEdit + "'," + "data:'" + _dr1["id"] + "'" + "},function(){})"; _html.AppendFormat("<div class='table-row{0}' id='table-row-id-{1}'>", _highlight, _dr1["id"]); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col1' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (double.Parse(_dr1["rowNum"].ToString()).ToString("#,##0"))); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col2' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["studentCode"].ToString()) ? _dr1["studentCode"].ToString() : "XXXXXXX")); _html.AppendFormat(" <div class='table-col table-col-width-dynamic table-col3' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, Util.GetFullName(_dr1["titlePrefixInitialsTH"].ToString(), _dr1["titlePrefixFullNameTH"].ToString(), _dr1["firstName"].ToString(), _dr1["middleName"].ToString(), _dr1["lastName"].ToString())); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col4' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["programCode"].ToString()) ? (_dr1["programCode"].ToString() + " " + _dr1["majorCode"].ToString() + " " + _dr1["groupNum"].ToString()) : String.Empty)); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col5' onclick={0}><div class='table-col-msg'><div class='th-label'>{1}</div></div></div>", _callFunc, (!String.IsNullOrEmpty(_dr1["yearEntry"].ToString()) ? _dr1["yearEntry"].ToString() : String.Empty)); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col6'><div class='table-col-msg'><div class='th-label link-click link-{0}'>{1}</div></div></div>", UDSStaffUtil.SUBJECT_SECTION_MEANINGOFADMISSIONTYPE.ToLower(), (!String.IsNullOrEmpty(_dr1["perEntranceTypeId"].ToString()) ? _dr1["perEntranceTypeId"].ToString() : String.Empty)); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col7'><div class='table-col-msg'><div class='th-label link-click link-{0}'>{1}</div></div></div>", UDSStaffUtil.SUBJECT_SECTION_MEANINGOFSTUDENTSTATUS.ToLower(), (!String.IsNullOrEmpty(_dr1["status"].ToString()) ? _dr1["status"].ToString() : String.Empty)); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col8' onclick={0}><div class='table-col-msg'>{1}</div></div>", _callFunc, _submittedDate); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col9'><div class='table-col-msg table-col-approvalstatus'>{0}</div></div>", _iconApprove); _html.AppendFormat(" <div class='table-col table-col-width-fixed table-col10' onclick={0}><div class='table-col-msg table-col-approvaldate'>{1}</div></div>", _callFunc, _approvalDate); _html.AppendLine(" </div>"); } _html.AppendLine("</div>"); } return(_html); }
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); }