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