public static DataTable GetPageOfData(ref DataTable dataTable, string sort, MSearchCriteria searchCriteria) { if (dataTable == null) { throw new ArgumentNullException("dataTable", "dataTable cannot be a null reference (Nothing in VB) or empty!"); } if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be a null reference (Nothing in VB) or empty!"); } // create a dataview object DataView mSortingDataView = dataTable.DefaultView; // apply any sorting using the searchCriteria if (sort == null) { mSortingDataView.Sort = searchCriteria.OrderByColumn + " " + searchCriteria.OrderByDirection; } else { mSortingDataView.Sort = sort; } // apply filtering if (searchCriteria.WhereClause.Trim() != "1 = 1") { mSortingDataView.RowFilter = searchCriteria.WhereClause; } DataTable mTempTable = mSortingDataView.Table.Clone(); foreach (DataRowView item in mSortingDataView) { mTempTable.ImportRow(item.Row); } // add the total rows field AddTotalRowsField(ref mTempTable); // add the rownumber field AddAutoIncrementField(ref mTempTable); mSortingDataView = mTempTable.DefaultView; // apply paging data filter logic int mStartingRow = 1; if (searchCriteria.SelectedPage > 1) { mStartingRow = searchCriteria.PageSize * (searchCriteria.SelectedPage - 1); } int mEndingRow = mStartingRow + searchCriteria.PageSize; mSortingDataView.RowFilter = "RowNumber >= " + mStartingRow.ToString(CultureInfo.InvariantCulture) + " and RowNumber <= " + mEndingRow.ToString(CultureInfo.InvariantCulture); DataTable mRetTable = mSortingDataView.Table.Clone(); foreach (DataRowView item in mSortingDataView) { mRetTable.ImportRow(item.Row); } return(mRetTable); }
/// <summary> /// Retruns search results from ZFC_FUNCTIONS or ZGWSecurity.Functions /// </summary> /// <param name="searchCriteria">MSearchCriteria</param> /// <returns></returns> public DataTable Search(MSearchCriteria searchCriteria) { DataTable mRetVal = null; if (DatabaseIsOnline()) { mRetVal = m_DFunctions.Search(searchCriteria); } return(mRetVal); }
/// <summary> /// Searches security enties using the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public DataTable Search(MSearchCriteria searchCriteria) { DataTable mRetVal = null; if (ConfigSettings.DBStatus.ToUpper(CultureInfo.InvariantCulture) == "ONLINE") { mRetVal = m_DSecurityEntity.Search(searchCriteria); } return(mRetVal); }
/// <summary> /// Searches the specified search critera. /// </summary> /// <param name="searchCriteria">The search critera.</param> /// <returns>DataTable.</returns> public static DataTable Search(MSearchCriteria searchCriteria) { if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be blank or a null reference (Nothing in Visual Basic)"); } BRoles mBRoles = new BRoles(SecurityEntityUtility.CurrentProfile(), ConfigSettings.CentralManagement); return(mBRoles.Search(searchCriteria)); }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public DataTable Search(MSearchCriteria searchCriteria) { DataTable mRetVal = null; if (DatabaseIsOnline()) { mRetVal = m_DNameValuePair.Search(searchCriteria); } return(mRetVal); }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria"></param> /// <returns></returns> public static DataTable Search(MSearchCriteria searchCriteria) { if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be a null reference (Nothing in Visual Basic)!"); } MSecurityEntityProfile mSecurityProfile = SecurityEntityUtility.CurrentProfile(); BNameValuePairs mBNameValuePairs = new BNameValuePairs(mSecurityProfile); return(mBNameValuePairs.Search(searchCriteria)); }
/// <summary> /// Searches Security Entities with the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public static DataTable Search(MSearchCriteria searchCriteria) { try { BSecurityEntity mBSecurityEntities = new BSecurityEntity(SecurityEntityUtility.CurrentProfile(), ConfigSettings.CentralManagement); return(mBSecurityEntities.Search(searchCriteria)); } catch (IndexOutOfRangeException) { return(null); } }
private void bindData(MSearchCriteria searchCriteria) { DataTable mDataTable = SecurityEntityUtility.Search(searchCriteria); if (mDataTable != null && mDataTable.Rows.Count > 0) { DataView mDataView = mDataTable.DefaultView; recordsReturned.Value = mDataTable.Rows[0][0].ToString(); searchResults.DataSource = mDataTable; searchResults.DataBind(); } }
/// <summary> /// Searches groups using the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public DataTable Search(MSearchCriteria searchCriteria) { if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be a null reference (Nothing in Visual Basic)!!"); } DataTable mRetVal = null; if (DatabaseIsOnline()) { mRetVal = m_DGroups.Search(searchCriteria); } return(mRetVal); }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public static DataTable Search(MSearchCriteria searchCriteria) { try { BMessages mBMessages = new BMessages(SecurityEntityUtility.CurrentProfile(), ConfigSettings.CentralManagement); return(mBMessages.Search(searchCriteria)); } catch (IndexOutOfRangeException ex) { Logger mLog = Logger.Instance(); mLog.Debug(ex); return(null); } }
private void bindData(MSearchCriteria searchCriteria) { DataTable mDataTable = NameValuePairUtility.Search(searchCriteria); if (mDataTable != null && mDataTable.Rows.Count > 0) { DataView mDataView = mDataTable.DefaultView; recordsReturned.Value = mDataTable.Rows[0][0].ToString(); searchResults.DataSource = mDataTable; searchResults.DataBind(); } else { noResults.Visible = true; } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { noResults.Visible = false; searchResults.HeaderStyle.ForeColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.HeaderForeColor]); searchResults.HeaderStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.HeadColor]); searchResults.AlternatingRowStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.AlternatingRowBackColor]); searchResults.RowStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.RowBackColor]); if (!String.IsNullOrEmpty(GWWebHelper.GetQueryValue(Request, "Columns"))) { MSearchCriteria mSearchCriteria = new MSearchCriteria(); mSearchCriteria.Columns = GWWebHelper.GetQueryValue(Request, "Columns"); mSearchCriteria.OrderByColumn = Server.UrlDecode(GWWebHelper.GetQueryValue(Request, "OrderByColumn")); mSearchCriteria.OrderByDirection = GWWebHelper.GetQueryValue(Request, "OrderByDirection"); int mTryParse = 0; if (int.TryParse(GWWebHelper.GetQueryValue(Request, "PageSize"), out mTryParse)) { mSearchCriteria.PageSize = int.Parse(GWWebHelper.GetQueryValue(Request, "PageSize")); } else { mSearchCriteria.PageSize = 10; } if (int.TryParse(GWWebHelper.GetQueryValue(Request, "SelectedPage"), out mTryParse)) { mSearchCriteria.SelectedPage = int.Parse(GWWebHelper.GetQueryValue(Request, "SelectedPage")); } else { mSearchCriteria.SelectedPage = 1; } mSearchCriteria.WhereClause = Server.UrlDecode(GWWebHelper.GetQueryValue(Request, "WhereClause")); mSearchCriteria.WhereClause = mSearchCriteria.WhereClause.Replace("\"", String.Empty); string mDesiredPath = Server.UrlDecode(GWWebHelper.GetQueryValue(Request, "desiredPath")); if (mDesiredPath.Length != 0) { m_CurrentDirectory = mDesiredPath; } string mTestFunctionSeqID = GWWebHelper.GetQueryValue(Request, "functionSeqID"); if (!String.IsNullOrEmpty(mTestFunctionSeqID)) { int mFunctionSeqId = int.Parse(mTestFunctionSeqID); } bindData(mSearchCriteria); } }
DataTable IDRoles.Search( MSearchCriteria searchCriteria) { string mStoredProcedure = "ZGWSystem.Get_Paginated_Data"; DataTable mRetVal; SqlParameter[] mParameters = { new SqlParameter("@P_Columns", searchCriteria.Columns), new SqlParameter("@P_OrderByColumn", searchCriteria.OrderByColumn), new SqlParameter("@P_OrderByDirection", searchCriteria.OrderByDirection), new SqlParameter("@P_PageSize", searchCriteria.PageSize), new SqlParameter("@P_SelectedPage", searchCriteria.SelectedPage), new SqlParameter("@P_TableOrView", "ZGWSecurity.vwSearchRoles"), new SqlParameter("@P_WhereClause", searchCriteria.WhereClause) }; mRetVal = base.GetDataTable( mStoredProcedure, mParameters); return mRetVal; }
private void bindData(MSearchCriteria searchCriteria) { int mNVP_SeqID = int.Parse(searchCriteria.WhereClause.Replace("NVP_SEQ_ID = ", "")); searchCriteria.OrderByColumn = "Table_Name"; DataTable mDataTable = NameValuePairUtility.GetNameValuePairDetails(mNVP_SeqID); DataHelper.GetPageOfData(ref mDataTable, searchCriteria); if (mDataTable != null && mDataTable.Rows.Count > 0) { DataView mDataView = mDataTable.DefaultView; recordsReturned.Value = mDataTable.Rows[0][0].ToString(); searchResults.DataSource = mDataTable; searchResults.DataBind(); } else { noResults.Visible = true; } }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public DataTable Search(MSearchCriteria searchCriteria) { if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be a null reference (Nothing in VB) or empty!"); } DataTable mRetVal = null; if (string.IsNullOrEmpty(searchCriteria.WhereClause)) { searchCriteria.WhereClause = " Security_Entity_SeqID = " + m_SecurityEntityProfile.Id.ToString(CultureInfo.InvariantCulture); } else { searchCriteria.WhereClause += " AND Security_Entity_SeqID = " + m_SecurityEntityProfile.Id.ToString(CultureInfo.InvariantCulture); } if (DatabaseIsOnline()) { mRetVal = m_DMessages.Search(searchCriteria); } return(mRetVal); }
DataTable IDAccount.Search(MSearchCriteria searchCriteria) { if (searchCriteria == null) { throw new ArgumentNullException("searchCriteria", "searchCriteria cannot be a null reference (Nothing in Visual Basic)!"); } string mStoredProcedure = "ZGWSystem.Get_Paginated_Data"; DataTable mRetVal; SqlParameter[] mParameters = { new SqlParameter("@P_Columns", searchCriteria.Columns), new SqlParameter("@P_OrderByColumn", searchCriteria.OrderByColumn), new SqlParameter("@P_OrderByDirection", searchCriteria.OrderByDirection), new SqlParameter("@P_PageSize", searchCriteria.PageSize), new SqlParameter("@P_SelectedPage", searchCriteria.SelectedPage), new SqlParameter("@P_TableOrView", "ZGWSecurity.Accounts"), new SqlParameter("@P_WhereClause", searchCriteria.WhereClause) }; mRetVal = base.GetDataTable(mStoredProcedure, mParameters); return(mRetVal); }
/// <summary> /// Binds the data. /// </summary> /// <param name="searchCriteria">The search criteria.</param> private void bindData(MSearchCriteria searchCriteria) { try { HttpServerUtility mServer = Server; string mAction = GWWebHelper.GetQueryValue(HttpContext.Current.Request, "Action"); MFunctionProfile mFunctionProfile = FunctionUtility.GetProfile(mAction); m_DirectoryProfile = DirectoryUtility.GetProfileByFunction(mFunctionProfile.Id); string mDirectoryPath = m_DirectoryProfile.Directory + m_CurrentDirectory; DataTable mDataTable = FileUtility.GetDirectoryTableData(mDirectoryPath, m_DirectoryProfile, false); SortTable mSorter = new SortTable(); string mColName = searchCriteria.OrderByColumn; mSorter.Sort(mDataTable, mColName, searchCriteria.OrderByDirection); DataView mView = mDataTable.DefaultView; mView.Sort = "type desc"; mDataTable = DataHelper.GetTable(ref mView); //mDataTable = DataHelper.GetPageOfData(ref mDataTable, ref searchCriteria); string mSort = "type desc, " + searchCriteria.OrderByColumn + " " + searchCriteria.OrderByDirection; mDataTable = DataHelper.GetPageOfData(ref mDataTable, mSort, searchCriteria); if (mDataTable != null && mDataTable.Rows.Count > 0) { DataView mDataView = mDataTable.DefaultView; recordsReturned.Value = mDataTable.Rows[0][DataHelper.TotalRowColumnName].ToString(); searchResults.DataSource = mDataTable; searchResults.DataBind(); } else { noResults.Visible = true; } } catch (DirectoryNotFoundException) { litErrorMSG.Visible = true; litErrorMSG.Text = "The Directory has not been setup or is unavalible."; } }
/// <summary> /// Handles the Load event of the Page control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param> protected void Page_Load(object sender, EventArgs e) { m_SecurityInfo = new MSecurityInfo(FunctionUtility.CurrentProfile(), AccountUtility.CurrentProfile()); noResults.Visible = false; searchResults.HeaderStyle.ForeColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.HeaderForeColor]); searchResults.HeaderStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.HeadColor]); searchResults.AlternatingRowStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.AlternatingRowBackColor]); searchResults.RowStyle.BackColor = ColorTranslator.FromHtml(ClientChoicesState[MClientChoices.RowBackColor]); if (!String.IsNullOrEmpty(GWWebHelper.GetQueryValue(Request, "Columns"))) { MSearchCriteria mSearchCriteria = new MSearchCriteria(); mSearchCriteria.Columns = GWWebHelper.GetQueryValue(Request, "Columns"); mSearchCriteria.OrderByColumn = Server.UrlDecode(GWWebHelper.GetQueryValue(Request, "OrderByColumn")); mSearchCriteria.OrderByDirection = GWWebHelper.GetQueryValue(Request, "OrderByDirection"); int mTryParse = 0; if (int.TryParse(GWWebHelper.GetQueryValue(Request, "PageSize"), out mTryParse)) { mSearchCriteria.PageSize = int.Parse(GWWebHelper.GetQueryValue(Request, "PageSize")); } else { mSearchCriteria.PageSize = 10; } if (int.TryParse(GWWebHelper.GetQueryValue(Request, "SelectedPage"), out mTryParse)) { mSearchCriteria.SelectedPage = int.Parse(GWWebHelper.GetQueryValue(Request, "SelectedPage")); } else { mSearchCriteria.SelectedPage = 1; } mSearchCriteria.WhereClause = Server.UrlDecode(GWWebHelper.GetQueryValue(Request, "WhereClause")); mSearchCriteria.WhereClause = mSearchCriteria.WhereClause.Replace("\"", String.Empty); bindData(mSearchCriteria); } }
public static DataTable GetPageOfData(ref DataTable dataTable, MSearchCriteria searchCriteria) { return(GetPageOfData(ref dataTable, null, searchCriteria)); }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public static DataTable Search(MSearchCriteria searchCriteria) { BAccounts mBAccount = new BAccounts(SecurityEntityUtility.CurrentProfile(), ConfigSettings.CentralManagement); return(mBAccount.Search(searchCriteria)); }
/// <summary> /// Searches the specified search criteria. /// </summary> /// <param name="searchCriteria">The search criteria.</param> /// <returns>DataTable.</returns> public static DataTable Search(MSearchCriteria searchCriteria) { BFunctions mBAppFunctions = new BFunctions(SecurityEntityUtility.CurrentProfile(), ConfigSettings.CentralManagement); return(mBAppFunctions.Search(searchCriteria)); }