public async Task <IActionResult> GetSubcriptionLocations([FromQuery] SubscriptionLocationsParameter subscriptionLocationsParameter)
{
var getAllSubscriptionPlansQuery = new GetAllSubscriptionLocationsQuery(subscriptionLocationsParameter);
var result = await mediator.Send(getAllSubscriptionPlansQuery);
if (result.Code == HttpStatusCode.OK)
{
Response.Headers.Add("X-Pagination", PagedList <Entity> .ToJson(result.Value as PagedList <Entity>));
}
return(StatusCode((int)result.Code, result.Value));
}
/// <summary>
/// Gets all Subscriptionlocation.
/// </summary>
/// <param name="subscriptionLocationsParameter">The Subscriptionlocation parameters.</param>
/// <returns></returns>
public async Task <PagedList <Entity> > GetAllSubscriptionLocations(SubscriptionLocationsParameter subscriptionLocationsParameter)
{
var getsubscriptionLocationsParams = new object[] {
new MySqlParameter("@p_IsForSingleSubscriptionLocation", subscriptionLocationsParameter.IsForSingleSubscriptionLocation),
new MySqlParameter("@p_IsForSubscription", subscriptionLocationsParameter.IsForSubscription),
new MySqlParameter("@p_IsForLocation", subscriptionLocationsParameter.IsForLocation),
new MySqlParameter("@p_IsForCategory", subscriptionLocationsParameter.IsForCategory),
new MySqlParameter("@p_CategoryValue", subscriptionLocationsParameter.CategoryValue),
new MySqlParameter("@p_LocationValue", subscriptionLocationsParameter.LocationValue),
new MySqlParameter("@p_Value", subscriptionLocationsParameter.Value),
};
var subscriptionLocations = await FindAll("CALL SpSelectActiveSubscriptionPlans(@p_IsForSingleSubscriptionLocation, @p_IsForSubscription, @p_IsForLocation, " +
"@p_IsForCategory, @p_Value, @p_CategoryValue, @p_Value)", getsubscriptionLocationsParams).ToListAsync();
var mappedSubscriptionLocations = subscriptionLocations.AsQueryable().ProjectTo <SubscriptionLocationResponse>(mapper.ConfigurationProvider);
var sortedSubscriptionLocations = sortHelper.ApplySort(mappedSubscriptionLocations, subscriptionLocationsParameter.OrderBy);
var shapedSubscriptionLocations = dataShaper.ShapeData(sortedSubscriptionLocations, subscriptionLocationsParameter.Fields);
return(await PagedList <Entity> .ToPagedList(shapedSubscriptionLocations, subscriptionLocationsParameter.PageNumber, subscriptionLocationsParameter.PageSize));
}
/// <summary>
/// Initializes a new instance of the <see cref="GetAllSubscriptionLocationsQuery"/> class.
/// </summary>
/// <param name="subscriptionLocationsParameter">The SubscriptionLocation parameters.</param>
public GetAllSubscriptionLocationsQuery(SubscriptionLocationsParameter subscriptionLocationsParameter)
{
SubscriptionLocationsParameter = subscriptionLocationsParameter;
}
public Task <APIResponse> GetSubcriptionLocations(SubscriptionLocationsParameter subscriptionLocationsParameter)
{
throw new NotImplementedException();
}
public async Task <IActionResult> GetSubcriptionLocations([FromQuery] SubscriptionLocationsParameter subscriptionLocationsParameter)
{
var result = await subscriptionlocationService.GetSubcriptionLocations(subscriptionLocationsParameter);
return(StatusCode((int)result.Code, result.Value));
}
