/// <summary> /// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/> /// The key query criteria of this set of query is: Common. /// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime /// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria: /// internal _GetQueryOfEntityOf...(...) gives the Linq Query /// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// *public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null /// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null /// </summary> /// <param name="currentIndex">current page index</param> /// <param name="pageSize">page size</param> /// <param name="queryOrderBySettingCollection">query OrderBy setting</param> /// <returns>an instance of <see cref="Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean"/></returns> public Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean ExistsOfKeyInformationOfByIdentifier( Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier ,int currentIndex ,int pageSize ,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection ) { log.Info(string.Format("{0}: ExistsOfKeyInformationOfByIdentifier", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString())); Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean(); try { bool _retval = _ExistsOfKeyInformationOfByIdentifier( criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier ,currentIndex ,pageSize ,queryOrderBySettingCollection ); _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Success; _retMessage.Result = _retval; } catch (Exception ex) { _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Fail; _retMessage.Result = false; _retMessage.Message = ex.Message; log.Error(string.Format("{0}: ExistsOfKeyInformationOfByIdentifier", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex); } log.Info(string.Format("{0}: ExistsOfKeyInformationOfByIdentifier", Framework.LoggingOptions.Data_Access_Layer_Process_Ended.ToString())); return _retMessage; }
/// <summary> /// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/> /// The key query criteria of this set of query is: Common. /// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime /// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria: /// internal _GetQueryOfEntityOf...(...) gives the Linq Query /// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// *public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null /// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null /// </summary> /// <param name="currentIndex">current page index</param> /// <param name="pageSize">page size</param> /// <param name="queryOrderBySettingCollection">query OrderBy setting</param> /// <returns>an instance of <see cref="Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean"/></returns> public Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean ExistsOfDefaultOfCommon( Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon ,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon ,Framework.EntityContracts.QuerySystemInt32EqualsCriteria criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon ,Framework.EntityContracts.QuerySystemStringContainsCriteria criteriaOfMessageOftOfCommonOfCommonOfCommon ,Framework.EntityContracts.QuerySystemDateTimeRangeCriteria criteriaOfEventTimeOftOfCommonOfCommonOfCommon ,int currentIndex ,int pageSize ,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection ) { log.Info(string.Format("{0}: ExistsOfDefaultOfCommon", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString())); Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean(); try { bool _retval = _ExistsOfDefaultOfCommon( criteriaOfIdOfBuild_B1_1OfCommonOfCommonOfCommon ,criteriaOfIdOfSolution_S1_1OfCommonOfCommonOfCommon ,criteriaOfIdOfBuildEventCode_B2_1OfCommonOfCommonOfCommon ,criteriaOfMessageOftOfCommonOfCommonOfCommon ,criteriaOfEventTimeOftOfCommonOfCommonOfCommon ,currentIndex ,pageSize ,queryOrderBySettingCollection ); _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Success; _retMessage.Result = _retval; } catch (Exception ex) { _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Fail; _retMessage.Result = false; _retMessage.Message = ex.Message; log.Error(string.Format("{0}: ExistsOfDefaultOfCommon", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex); } log.Info(string.Format("{0}: ExistsOfDefaultOfCommon", Framework.LoggingOptions.Data_Access_Layer_Process_Ended.ToString())); return _retMessage; }
/// <summary> /// The return value of this set of query is: <see cref="ASPNETDB_CACHE.DataSourceEntities.AspNet_SqlCacheTablesForChangeNotification"/> /// The key query criteria of this set of query is: Common. /// Common is a built-in set of query criteria, which will query all foreign keys, string/text value, and range of datatime /// There are 7 methods, 1 internal, 2 private and 4 public, for one set of return value and query criteria: /// internal _GetQueryOfEntityOf...(...) gives the Linq Query /// private _ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// private _GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// public GetCountOfEntityOf...(...) returns count if there is any records meets Query Criteria, otherwise 0 /// *public ExistsOfEntityOf...(...) returns true if there is any records meets Query Criteria, otherwise false /// public GetSingleOfEntityOf...(...) returns the first record if there is any records meets Query Criteria, otherwise null /// public GetCollectionOfEntityOf...(...) returns all records if there is any records meets Query Criteria, otherwise null /// </summary> /// <param name="currentIndex">current page index</param> /// <param name="pageSize">page size</param> /// <param name="queryOrderBySettingCollection">query OrderBy setting</param> /// <returns>an instance of <see cref="Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean"/></returns> public Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean ExistsOfNameValuePairOfAll( int currentIndex ,int pageSize ,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection ) { log.Info(string.Format("{0}: ExistsOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString())); Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfBoolean(); try { bool _retval = _ExistsOfNameValuePairOfAll( currentIndex ,pageSize ,queryOrderBySettingCollection ); _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Success; _retMessage.Result = _retval; } catch (Exception ex) { _retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Fail; _retMessage.Result = false; _retMessage.Message = ex.Message; log.Error(string.Format("{0}: ExistsOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex); } log.Info(string.Format("{0}: ExistsOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Ended.ToString())); return _retMessage; }