/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'uspGetManagerEmployees'. /// /// MS_Description: Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.<br/> /// </summary> /// <param name="managerId">Input parameter of stored procedure</param> /// <returns>IRetrievalQuery object which is ready to use for datafetching</returns> public static IRetrievalQuery GetUspGetManagerEmployeesCallAsQuery(System.Int32 managerId) { string procName = SD.LLBLGen.Pro.DQE.SqlServer.DynamicQueryEngine.GetNewStoredProcedureName("[AdventureWorks].[dbo].[uspGetManagerEmployees]"); RetrievalQuery toReturn = new RetrievalQuery(new SqlCommand(procName)); toReturn.Parameters.Add(new SqlParameter("@ManagerID", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, managerId)); toReturn.Command.CommandType = CommandType.StoredProcedure; return(toReturn); }
/// <summary>Creates an IRetrievalQuery object for a call to the procedure 'usp_getShippingDetailInfo'. /// /// </summary> /// <param name="rowIndex">Input parameter of stored procedure</param> /// <param name="pageSize">Input parameter of stored procedure</param> /// <param name="status">Input parameter of stored procedure</param> /// <param name="shippingOptionId">Input parameter of stored procedure</param> /// <param name="eventId">Input parameter of stored procedure</param> /// <param name="podId">Input parameter of stored procedure</param> /// <param name="startDate">Input parameter of stored procedure</param> /// <param name="endDate">Input parameter of stored procedure</param> /// <param name="isResultReady">Input parameter of stored procedure</param> /// <returns>IRetrievalQuery object which is ready to use for datafetching</returns> public static IRetrievalQuery GetGetShippingDetailInfoCallAsQuery(System.Int32 rowIndex, System.Int32 pageSize, System.Int32 status, System.Int32 shippingOptionId, System.Int64 eventId, System.Int32 podId, System.String startDate, System.String endDate, System.Boolean isResultReady) { RetrievalQuery toReturn = new RetrievalQuery(new SqlCommand("[Falcon].[dbo].[usp_getShippingDetailInfo]")); toReturn.Parameters.Add(new SqlParameter("@RowIndex", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, rowIndex)); toReturn.Parameters.Add(new SqlParameter("@PageSize", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, pageSize)); toReturn.Parameters.Add(new SqlParameter("@Status", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, status)); toReturn.Parameters.Add(new SqlParameter("@ShippingOptionID", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, shippingOptionId)); toReturn.Parameters.Add(new SqlParameter("@EventID", SqlDbType.BigInt, 0, ParameterDirection.Input, true, 19, 0, "", DataRowVersion.Current, eventId)); toReturn.Parameters.Add(new SqlParameter("@PodID", SqlDbType.Int, 0, ParameterDirection.Input, true, 10, 0, "", DataRowVersion.Current, podId)); toReturn.Parameters.Add(new SqlParameter("@StartDate", SqlDbType.VarChar, 30, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, startDate)); toReturn.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.VarChar, 30, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, endDate)); toReturn.Parameters.Add(new SqlParameter("@IsResultReady", SqlDbType.Bit, 0, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, isResultReady)); toReturn.Command.CommandType = CommandType.StoredProcedure; return(toReturn); }