コード例 #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="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);
        }
コード例 #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="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);
        }
コード例 #3
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);
        }
コード例 #4
0
        /// <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);
        }