/// <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);
}
