/// <summary>
/// Find all group by key search
/// </summary>
/// <param name="keysSearch">contain collection of parameter of condition searching, split by '|'</param>
/// <param name="options">contain collection of parameter to custom value return</param>
/// <param name="totalRecord">Total record matching condition</param>
public static DataSet FindGroup(string keysSearch, OptionFilter options, ref int totalRecord)
{
var ds = new DataSet();
try
{
// Keys search
var groupName = Null.NullString; // Find by near value matching of GroupName
if (!string.IsNullOrEmpty(keysSearch))
{
var arrKeySearch = keysSearch.Split('|');
if (arrKeySearch.Length > 0)
{
groupName = arrKeySearch[0];
}
}
var paramTotalRecord = new OracleParameter("p_totalRecord", OracleDbType.Int32, ParameterDirection.Output);
ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_s_groups.proc_GroupUser_Find",
new OracleParameter("p_groupName", OracleDbType.Varchar2, groupName, ParameterDirection.Input),
new OracleParameter("p_orderBy", OracleDbType.Varchar2, options.OrderBy, ParameterDirection.Input),
new OracleParameter("p_startAt", OracleDbType.Decimal, options.StartAt, ParameterDirection.Input),
new OracleParameter("p_endAt", OracleDbType.Decimal, options.EndAt, ParameterDirection.Input),
paramTotalRecord,
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output));
totalRecord = Convert.ToInt32(paramTotalRecord.Value.ToString());
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(ds);
}
public PagingHelper(OptionFilter optionFilter, int totalRecord, string pagingFunctionJS)
{
this._optionFilter = optionFilter;
this._totalRecord = totalRecord;
this._pagingFunctionJS = pagingFunctionJS;
this._sequenceAdditionalPagingFunctionJs = string.Empty;
}
public PagingHelper(OptionFilter optionFilter, int totalRecord, string pagingFunctionJS, string divNumberRecordOnPage, string arrSequenceAdditionalPagingFunctionJs)
{
this._optionFilter = optionFilter;
this._totalRecord = totalRecord;
this._pagingFunctionJS = pagingFunctionJS;
this._divNumberRecordOnPage = divNumberRecordOnPage;
FilterArrSequenceAdditionalPagingFunctionJs(arrSequenceAdditionalPagingFunctionJs);
}
public void MapToQueryRequestShouldMapGemQualityType(GemQualityType gemQualityType)
{
string expected = ((int)gemQualityType).ToString();
var item = new GemItem
{
QualityType = gemQualityType
};
SearchQueryRequest result = this.gemItemSearchQueryRequestMapper.MapToQueryRequest(item) as SearchQueryRequest;
OptionFilter gemQualityTypeFilter = result.Query.Filters.MiscFilters.GemAlternateQuality;
Assert.IsNotNull(gemQualityTypeFilter);
Assert.That(gemQualityTypeFilter.Option, Is.EqualTo(expected));
}
/// <summary>
/// Find all function by key search
/// </summary>
/// <param name="keysSearch">contain collection of parameter of condition searching, split by '|'</param>
/// <param name="options">contain collection of parameter to custom value return</param>
/// <param name="totalRecord">Total record matching condition</param>
/// <returns>Dataset rows of record matching</returns>
public static DataSet FindFunction(string keysSearch, OptionFilter options, ref int totalRecord)
{
var ds = new DataSet();
try
{
// Keys search
var functionName = Null.NullString; // Find by near value matching of FunctionName/DisplayNameOnMenu
var functionType = Null.NullString; // Array FunctionType, split by ',' and user IN operator in sql for searching
var href = Null.NullString; // Find by near value matching of HrefGet/HrefPost
var parentId = Null.NullString; // Array Prid, split by ',' and user IN operator in sql for searching
var level = Null.NullString; // Array Level, split by ',' and user IN operator in sql for searching
if (!string.IsNullOrEmpty(keysSearch))
{
var arrKeySearch = keysSearch.Split('|');
if (arrKeySearch.Length == 5)
{
functionName = arrKeySearch[0];
functionType = KeySearch.FilterComboboxValue(arrKeySearch[1]);
href = arrKeySearch[2];
parentId = KeySearch.FilterComboboxValue(arrKeySearch[3]);
level = arrKeySearch[4];
}
}
var paramTotalRecord = new OracleParameter("p_total_record", OracleDbType.Int32, ParameterDirection.Output);
ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_s_function.proc_Function_Find",
new OracleParameter("p_functionName", OracleDbType.Varchar2, functionName, ParameterDirection.Input),
new OracleParameter("p_functionType", OracleDbType.Varchar2, functionType, ParameterDirection.Input),
new OracleParameter("p_href", OracleDbType.Varchar2, href, ParameterDirection.Input),
new OracleParameter("p_parentId", OracleDbType.Varchar2, parentId, ParameterDirection.Input),
new OracleParameter("p_level", OracleDbType.Varchar2, level, ParameterDirection.Input),
new OracleParameter("p_orderBy", OracleDbType.Varchar2, options.OrderBy, ParameterDirection.Input),
new OracleParameter("p_startAt", OracleDbType.Decimal, options.StartAt, ParameterDirection.Input),
new OracleParameter("p_endAt", OracleDbType.Decimal, options.EndAt, ParameterDirection.Input),
paramTotalRecord,
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output));
totalRecord = Convert.ToInt32(paramTotalRecord.Value.ToString());
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(ds);
}
public List <WikiDoc_Info> WikiDoc_DashboardSearch(ref decimal totalRecordFindResult, string P_KEY_SEARCH = "", string OPTIONS = "")
{
try
{
WikiDoc_DA _da = new WikiDoc_DA();
var optionFilter = new OptionFilter(OPTIONS);
var ds = _da.WikiDoc_Search(P_KEY_SEARCH, optionFilter, ref totalRecordFindResult);
// this.SetupPagingHtml(optionFilter, totalRecordFindResult, "wikipageListOfObjects", "wikidivNumberRecordOnPageListObjects");
return(CBO <WikiDoc_Info> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new List <WikiDoc_Info>());
}
}
public List <SearchObject_Header_Info> SEARCH_OBJECT_SEARCH(ref decimal totalRecordFindResult, string P_KEY_SEARCH = "", string OPTIONS = "")
{
try
{
SearchObject_DA _da = new SearchObject_DA();
var optionFilter = new OptionFilter(OPTIONS);
DataSet ds = _da.SEARCH_OBJECT_SEARCH(P_KEY_SEARCH, optionFilter, ref totalRecordFindResult);
this.SetupPagingHtml(optionFilter, Convert.ToInt32(totalRecordFindResult), "pageListOfObjects", "divNumberRecordOnPageListObjects");
return(CBO <SearchObject_Header_Info> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new List <SearchObject_Header_Info>());
}
}
/// <summary>
/// Find all user by key search
/// </summary>
/// <param name="keysSearch">contain collection of parameter of condition searching, split by '|'</param>
/// <param name="options">contain collection of parameter to custom value return</param>
/// <param name="totalRecord">Total record matching condition</param>
/// <returns>Data set contain rows matching</returns>
public static DataSet FindUser(string keysSearch, OptionFilter options, ref int totalRecord)
{
var ds = new DataSet();
try
{
// Keys search
var userName = Null.NullString; // Find by near value matching of UserName
var fullName = Null.NullString; // Find by near value matching of FullName
var departmentId = Null.NullString; // Array departmentId, split by ',' and user IN operator in sql for searching
var type = Null.NullString; // Find by near value matching of GroupId
var status = Null.NullString; // Array Status, split by ',' and user IN operator in sql for searching
if (!string.IsNullOrEmpty(keysSearch))
{
var arrKeySearch = keysSearch.Split('|');
if (arrKeySearch.Length == 4)
{
userName = arrKeySearch[0];
fullName = arrKeySearch[1];
type = KeySearch.FilterComboboxValue(arrKeySearch[2]);
status = KeySearch.FilterComboboxValue(arrKeySearch[3]);
}
}
var paramTotalRecord = new OracleParameter("p_totalRecord", OracleDbType.Int32, ParameterDirection.Output);
ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "pkg_s_users.proc_User_Find",
new OracleParameter("p_userName", OracleDbType.Varchar2, userName, ParameterDirection.Input),
new OracleParameter("p_fullName", OracleDbType.Varchar2, fullName, ParameterDirection.Input),
new OracleParameter("p_type", OracleDbType.Varchar2, type, ParameterDirection.Input),
new OracleParameter("p_status", OracleDbType.Varchar2, status, ParameterDirection.Input),
new OracleParameter("p_orderBy", OracleDbType.Varchar2, options.OrderBy, ParameterDirection.Input),
new OracleParameter("p_startAt", OracleDbType.Decimal, options.StartAt, ParameterDirection.Input),
new OracleParameter("p_endAt", OracleDbType.Decimal, options.EndAt, ParameterDirection.Input),
paramTotalRecord,
new OracleParameter("p_cursor", OracleDbType.RefCursor, ParameterDirection.Output));
totalRecord = Convert.ToInt32(paramTotalRecord.Value.ToString());
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(ds);
}
public List <WikiCatalogues_Info> Portal_Catalogue_Search(string P_KEY_SEARCH = "", string OPTIONS = "")
{
try
{
WikiCatalogue_DA _da = new WikiCatalogue_DA();
var optionFilter = new OptionFilter(OPTIONS);
var totalRecordFindResult = 0;
var ds = _da.Portal_Catalogue_Search(P_KEY_SEARCH, optionFilter, ref totalRecordFindResult);
this.SetupPagingHtml(optionFilter, totalRecordFindResult, "pageListOfObjects", "divNumberRecordOnPageListObjects");
return(CBO <WikiCatalogues_Info> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new List <WikiCatalogues_Info>());
}
}
public List <GroupUserInfo> FindGroup(string keysSearch = "", string options = "")
{
try
{
var optionFilter = new OptionFilter(options);
var totalRecordFindResult = 0;
var ds = GroupUserDA.FindGroup(keysSearch, optionFilter, ref totalRecordFindResult);
this.SetupPagingHtml(optionFilter, totalRecordFindResult, "pageListOfGroups", "divNumberRecordOnPageListGroups");
return(CBO <GroupUserInfo> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(Null <GroupUserInfo> .GetListCollectionNull());
}
public List <UserInfo> FindCustomer(ref decimal totalRecordFindResult, string keysSearch = "", string options = "")
{
try
{
int _totalrec = 0;
var optionFilter = new OptionFilter(options);
var ds = UserDA.FindCustomer(keysSearch, optionFilter, ref _totalrec);
totalRecordFindResult = _totalrec;
return(CBO <UserInfo> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
}
return(Null <UserInfo> .GetListCollectionNull());
}
public List <App_Class_Info> AppClassGetAll()
{
try
{
App_Class_DA _da = new App_Class_DA();
var optionFilter = new OptionFilter();
optionFilter.EndAt = 0;
optionFilter.StartAt = 0;
var totalRecordFindResult = 0;
var ds = _da.SearchAppClass("", optionFilter, ref totalRecordFindResult);
return(CBO <App_Class_Info> .FillCollectionFromDataSet(ds));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new List <App_Class_Info>());
}
}
public DataSet Portal_Catalogue_Search(string keysSearch, OptionFilter options, ref int totalRecord)
{
try
{
DataSet _Ds = new DataSet();
OracleParameter paramReturn = new OracleParameter("P_TOTAL_RECORD", OracleDbType.Decimal, ParameterDirection.Output);
_Ds = OracleHelper.ExecuteDataset(Configuration.connectionString, CommandType.StoredProcedure, "PKG_WIKI_PORTAL.PROC_SEARCH_CATALOGE",
new OracleParameter("P_KEY_SEARCH", OracleDbType.Varchar2, keysSearch.ToFillKeySearch(), ParameterDirection.Input),
new OracleParameter("P_FROM", OracleDbType.Varchar2, options.StartAt.ToString(), ParameterDirection.Input),
new OracleParameter("P_TO", OracleDbType.Varchar2, options.EndAt.ToString(), ParameterDirection.Input),
new OracleParameter("P_SORT_TYPE", OracleDbType.Varchar2, options.OrderBy, ParameterDirection.Input),
paramReturn,
new OracleParameter("P_CURSOR", OracleDbType.RefCursor, ParameterDirection.Output));
totalRecord = Convert.ToInt32(paramReturn.Value.ToString());
return(_Ds);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new DataSet());
}
}
protected void SetupPagingHtml(OptionFilter optionFilter, int totalRecordFindResult, string jsPagingFunction, string idDivNumberRecordOnPage)
{
var pagingHelper = new PagingHelper(optionFilter, totalRecordFindResult, jsPagingFunction, idDivNumberRecordOnPage);
this._pagingHtml = pagingHelper.Paging();
}
