/// <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>Result property will be the count of records in database, 0 if no record in database</returns>
public Framework.DataSourceEntities.DataAccessLayerMessageOfInteger GetCountOfKeyInformationOfByIdentifier(
Framework.EntityContracts.QuerySystemInt64EqualsCriteria criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,int currentIndex
,int pageSize
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
log.Info(string.Format("{0}: GetCountOfKeyInformationOfByIdentifier", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString()));
Framework.DataSourceEntities.DataAccessLayerMessageOfInteger _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfInteger();
try
{
int _retval = _GetCountOfKeyInformationOfByIdentifier(
criteriaOfIdOftOfByIdentifierOfByIdentifierOfByIdentifier
,currentIndex
,pageSize
,queryOrderBySettingCollection
);
_retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Success;
_retMessage.Result = _retval;
}
catch(Exception ex)
{
_retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Fail;
_retMessage.Result = 0;
_retMessage.Message = ex.Message;
log.Error(string.Format("{0}: GetCountOfKeyInformationOfByIdentifier", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex);
}
log.Info(string.Format("{0}: GetCountOfKeyInformationOfByIdentifier", 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>Result property will be the count of records in database, 0 if no record in database</returns>
public Framework.DataSourceEntities.DataAccessLayerMessageOfInteger GetCountOfDefaultOfCommon(
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}: GetCountOfDefaultOfCommon", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString()));
Framework.DataSourceEntities.DataAccessLayerMessageOfInteger _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfInteger();
try
{
int _retval = _GetCountOfDefaultOfCommon(
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 = 0;
_retMessage.Message = ex.Message;
log.Error(string.Format("{0}: GetCountOfDefaultOfCommon", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex);
}
log.Info(string.Format("{0}: GetCountOfDefaultOfCommon", 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>Result property will be the count of records in database, 0 if no record in database</returns>
public Framework.DataSourceEntities.DataAccessLayerMessageOfInteger GetCountOfNameValuePairOfAll(
int currentIndex
,int pageSize
,Framework.EntityContracts.QueryOrderBySettingCollection queryOrderBySettingCollection
)
{
log.Info(string.Format("{0}: GetCountOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Started.ToString()));
Framework.DataSourceEntities.DataAccessLayerMessageOfInteger _retMessage = new Framework.DataSourceEntities.DataAccessLayerMessageOfInteger();
try
{
int _retval = _GetCountOfNameValuePairOfAll(
currentIndex
,pageSize
,queryOrderBySettingCollection
);
_retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Success;
_retMessage.Result = _retval;
}
catch(Exception ex)
{
_retMessage.DataAccessLayerMessageStatus = Framework.DataSourceEntities.DataAccessLayerMessageStatus.Fail;
_retMessage.Result = 0;
_retMessage.Message = ex.Message;
log.Error(string.Format("{0}: GetCountOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Failed.ToString()), ex);
}
log.Info(string.Format("{0}: GetCountOfNameValuePairOfAll", Framework.LoggingOptions.Data_Access_Layer_Process_Ended.ToString()));
return _retMessage;
}