Ejemplo n.º 1
0
 /// <summary>Fetches instances of the the typed view row 'CreateEmployeeClassificationResultRow' class using a stored procedure call. </summary>
 /// <typeparam name="T">The type of the typed view row</typeparam>
 /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCreateEmployeeClassificationResultTypedViewProjection().</param>
 /// <param name="employeeClassificationName">Input parameter of stored procedure</param>
 /// <param name="isExempt">Input parameter of stored procedure</param>
 /// <param name="isEmployee">Input parameter of stored procedure</param>
 /// <returns>The results in a List</returns>
 public static List <T> FetchCreateEmployeeClassificationResultTypedView <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee)
 {
     using (var adapter = new DataAccessAdapter())
     {
         return(FetchCreateEmployeeClassificationResultTypedView(adapter, projectionOfTypedView, employeeClassificationName, isExempt, isEmployee));
     }
 }
Ejemplo n.º 2
0
 /// <summary>Fetches instances of the the typed view row 'GetEmployeeClassificationsResultRow' class using a stored procedure call. </summary>
 /// <typeparam name="T">The type of the typed view row</typeparam>
 /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetGetEmployeeClassificationsResultTypedViewProjection().</param>
 /// <param name="employeeClassificationKey">Input parameter of stored procedure</param>
 /// <returns>The results in a List</returns>
 public static List <T> FetchGetEmployeeClassificationsResultTypedView <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, Nullable <System.Int32> employeeClassificationKey)
 {
     using (var adapter = new DataAccessAdapter())
     {
         return(FetchGetEmployeeClassificationsResultTypedView(adapter, projectionOfTypedView, employeeClassificationKey));
     }
 }
 /// <summary>Fetches instances of the the typed view row 'VenueDistanceResultRow' class using a stored procedure call. </summary>
 /// <typeparam name="T">The type of the typed view row</typeparam>
 /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetVenueDistanceResultTypedViewProjection().</param>
 /// <param name="maxDistance">Input parameter of stored procedure</param>
 /// <param name="lat">Input parameter of stored procedure</param>
 /// <param name="lng">Input parameter of stored procedure</param>
 /// <returns>The results in a List</returns>
 public static List <T> FetchVenueDistanceResultTypedView <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.Double maxDistance, System.Double lat, System.Double lng)
 {
     using (var adapter = new DataAccessAdapter())
     {
         return(FetchVenueDistanceResultTypedView(adapter, projectionOfTypedView, maxDistance, lat, lng));
     }
 }
Ejemplo n.º 4
0
        /// <summary>Fetches instances of the the typed view row 'CreateEmployeeClassificationResultRow' class using a stored procedure call. </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCreateEmployeeClassificationResultTypedViewProjection().</param>
        /// <param name="employeeClassificationName">Input parameter of stored procedure</param>
        /// <param name="isExempt">Input parameter of stored procedure</param>
        /// <param name="isEmployee">Input parameter of stored procedure</param>
        /// <returns>The results in a List</returns>
        public static List <T> FetchCreateEmployeeClassificationResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee)
        {
            StoredProcedureCall call  = CreateCreateEmployeeClassificationCall(adapter, employeeClassificationName, isExempt, isEmployee);
            IRetrievalQuery     query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);

            return(toReturn);
        }
Ejemplo n.º 5
0
        /// <summary>Fetches instances of the the typed view row 'CountEmployeesByClassificationResultRow' class using a stored procedure call. </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCountEmployeesByClassificationResultTypedViewProjection().</param>
        /// <returns>The results in a List</returns>
        public static List <T> FetchCountEmployeesByClassificationResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView)
        {
            StoredProcedureCall call  = CreateCountEmployeesByClassificationCall(adapter);
            IRetrievalQuery     query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);

            return(toReturn);
        }
Ejemplo n.º 6
0
 /// <summary>Fetches instances of the the typed view row 'CountEmployeesByClassificationResultRow' class using a stored procedure call. </summary>
 /// <typeparam name="T">The type of the typed view row</typeparam>
 /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCountEmployeesByClassificationResultTypedViewProjection().</param>
 /// <returns>The results in a List</returns>
 public static List <T> FetchCountEmployeesByClassificationResultTypedView <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView)
 {
     using (var adapter = new DataAccessAdapter())
     {
         return(FetchCountEmployeesByClassificationResultTypedView(adapter, projectionOfTypedView));
     }
 }
Ejemplo n.º 7
0
        /// <summary>Fetches instances of the the typed view row 'GetEmployeeClassificationsResultRow' class using a stored procedure call. </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetGetEmployeeClassificationsResultTypedViewProjection().</param>
        /// <param name="employeeClassificationKey">Input parameter of stored procedure</param>
        /// <returns>The results in a List</returns>
        public static List <T> FetchGetEmployeeClassificationsResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, Nullable <System.Int32> employeeClassificationKey)
        {
            StoredProcedureCall call  = CreateGetEmployeeClassificationsCall(adapter, employeeClassificationKey);
            IRetrievalQuery     query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);

            return(toReturn);
        }
        /// <summary>Fetches instances of the the typed view row 'VenueDistanceResultRow' class using a stored procedure call. Async variant </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetVenueDistanceResultTypedViewProjection().</param>
        /// <param name="maxDistance">Input parameter of stored procedure</param>
        /// <param name="lat">Input parameter of stored procedure</param>
        /// <param name="lng">Input parameter of stored procedure</param>
        /// <param name="cancellationToken">The cancellation token to use</param>
        /// <returns>The results in a list.</returns>
        public static async Task <List <T> > FetchVenueDistanceResultTypedViewAsync <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.Double maxDistance, System.Double lat, System.Double lng, CancellationToken cancellationToken)
        {
            var call  = CreateVenueDistanceCall(adapter, maxDistance, lat, lng);
            var query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var typedView = await adapter.FetchQueryFromSourceAsync(projectionOfTypedView, query, cancellationToken).ConfigureAwait(false);

            return(typedView);
        }
        /// <summary>Fetches instances of the the typed view row 'VenueDistanceResultRow' class using a stored procedure call. Async variant</summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetVenueDistanceResultTypedViewProjection().</param>
        /// <param name="maxDistance">Input parameter of stored procedure</param>
        /// <param name="lat">Input parameter of stored procedure</param>
        /// <param name="lng">Input parameter of stored procedure</param>
        /// <param name="cancellationToken">The cancellation token to use</param>
        /// <returns>The results in a list.</returns>
        public static async Task <List <T> > FetchVenueDistanceResultTypedViewAsync <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.Double maxDistance, System.Double lat, System.Double lng, CancellationToken cancellationToken)
        {
            using (var adapter = new DataAccessAdapter())
            {
                var toReturn = await FetchVenueDistanceResultTypedViewAsync(adapter, projectionOfTypedView, maxDistance, lat, lng, cancellationToken).ConfigureAwait(false);

                return(toReturn);
            }
        }
        /// <summary>Fetches instances of the the typed view row 'VenueDistanceResultRow' class using a stored procedure call. </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetVenueDistanceResultTypedViewProjection().</param>
        /// <param name="maxDistance">Input parameter of stored procedure</param>
        /// <param name="lat">Input parameter of stored procedure</param>
        /// <param name="lng">Input parameter of stored procedure</param>
        /// <returns>The results in a List</returns>
        public static List <T> FetchVenueDistanceResultTypedView <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.Double maxDistance, System.Double lat, System.Double lng)
        {
            StoredProcedureCall call  = CreateVenueDistanceCall(adapter, maxDistance, lat, lng);
            IRetrievalQuery     query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var toReturn = adapter.FetchQueryFromSource(projectionOfTypedView, query);

            return(toReturn);
        }
        /// <summary>Fetches instances of the the typed view row 'CountEmployeesByClassificationResultRow' class using a stored procedure call. Async variant </summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="adapter">The adapter.</param>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCountEmployeesByClassificationResultTypedViewProjection().</param>
        /// <param name="cancellationToken">The cancellation token to use</param>
        /// <returns>The results in a list.</returns>
        public static async Task <List <T> > FetchCountEmployeesByClassificationResultTypedViewAsync <T>(IDataAccessAdapter adapter, SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, CancellationToken cancellationToken)
        {
            var call  = CreateCountEmployeesByClassificationCall(adapter);
            var query = call.ToRetrievalQuery();

            query.ResultsetNumber = 1;
            var typedView = await adapter.FetchQueryFromSourceAsync(projectionOfTypedView, query, cancellationToken).ConfigureAwait(false);

            return(typedView);
        }
        /// <summary>Fetches instances of the the typed view row 'CountEmployeesByClassificationResultRow' class using a stored procedure call. Async variant</summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCountEmployeesByClassificationResultTypedViewProjection().</param>
        /// <param name="cancellationToken">The cancellation token to use</param>
        /// <returns>The results in a list.</returns>
        public static async Task <List <T> > FetchCountEmployeesByClassificationResultTypedViewAsync <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, CancellationToken cancellationToken)
        {
            using (var adapter = new DataAccessAdapter())
            {
                var toReturn = await FetchCountEmployeesByClassificationResultTypedViewAsync(adapter, projectionOfTypedView, cancellationToken).ConfigureAwait(false);

                return(toReturn);
            }
        }
        /// <summary>Fetches instances of the the typed view row 'CreateEmployeeClassificationResultRow' class using a stored procedure call. Async variant</summary>
        /// <typeparam name="T">The type of the typed view row</typeparam>
        /// <param name="projectionOfTypedView">The projection of the typed view, created using the method QueryFactory.GetCreateEmployeeClassificationResultTypedViewProjection().</param>
        /// <param name="employeeClassificationName">Input parameter of stored procedure</param>
        /// <param name="isExempt">Input parameter of stored procedure</param>
        /// <param name="isEmployee">Input parameter of stored procedure</param>
        /// <param name="cancellationToken">The cancellation token to use</param>
        /// <returns>The results in a list.</returns>
        public static async Task <List <T> > FetchCreateEmployeeClassificationResultTypedViewAsync <T>(SD.LLBLGen.Pro.QuerySpec.DynamicQuery <T> projectionOfTypedView, System.String employeeClassificationName, System.Boolean isExempt, System.Boolean isEmployee, CancellationToken cancellationToken)
        {
            using (var adapter = new DataAccessAdapter())
            {
                var toReturn = await FetchCreateEmployeeClassificationResultTypedViewAsync(adapter, projectionOfTypedView, employeeClassificationName, isExempt, isEmployee, cancellationToken).ConfigureAwait(false);

                return(toReturn);
            }
        }