/// <summary>
/// Grids the update initial order subscriptions.
/// </summary>
/// <param name="request">The request.</param>
/// <returns></returns>
public async Task <int> Grid_UpdateInitialOrderSubscriptions(UpdateInitialOrderSubscriptionsRequest request)
{
try
{
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.Int),
new SqlParameter("@SubscriberID", SqlDbType.Int),
new SqlParameter("@BundleID", SqlDbType.Int),
new SqlParameter("@BSSPlanCode", SqlDbType.NVarChar),
new SqlParameter("@Status", SqlDbType.Int),
new SqlParameter("@ValidFrom", SqlDbType.Date),
new SqlParameter("@ValidTo", SqlDbType.Date),
};
parameters[0].Value = request.OrderID;
parameters[1].Value = request.SubscriberID;
parameters[2].Value = request.BundleID;
parameters[3].Value = request.BSSPlanCode;
parameters[4].Value = request.Status;
parameters[5].Value = request.ValidFrom.Date;
parameters[6].Value = request.ValidTo.Date;
_DataHelper = new DataAccessHelper("Grid_UpdateInitialOrderSubscriptions", parameters, _configuration);
DataTable dt = new DataTable();
return(await _DataHelper.RunAsync());
}
catch (Exception ex)
{
LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
throw;
}
finally
{
_DataHelper.Dispose();
}
}
public async Task <IActionResult> UpdateInitialOrderSubscriptions([FromHeader(Name = "Grid-Service-Header-Token")] string token, [FromForm] UpdateInitialOrderSubscriptionsRequest request)
{
try
{
if (string.IsNullOrEmpty(token))
{
return(Ok(new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = true,
Message = EnumExtensions.GetDescription(CommonErrors.TokenEmpty)
}));
}
if (!ModelState.IsValid)
{
return(StatusCode((int)HttpStatusCode.OK, new OperationResponse
{
HasSucceeded = false,
IsDomainValidationErrors = true,
Message = string.Join("; ", ModelState.Values
.SelectMany(x => x.Errors)
.Select(x => x.ErrorMessage))
}));
}
if (!ValidateGridHeaderToken(token))
{
return(Ok(new OperationResponse
{
HasSucceeded = false,
Message = EnumExtensions.GetDescription(DbReturnValue.TokenAuthFailed),
IsDomainValidationErrors = true
}));
}
var result = await _dataAccess.Grid_UpdateInitialOrderSubscriptions(request);
if (result == Enum.ReturnSuccess)
{
return(Ok(new OperationResponse
{
HasSucceeded = true,
Message = "Success",
IsDomainValidationErrors = false
}));
}
else
{
return(Ok(new OperationResponse
{
HasSucceeded = false,
Message = "Failure",
IsDomainValidationErrors = false
}));
}
}
catch (Exception ex)
{
LogInfo.Error(new ExceptionHelper().GetLogString(ex, ErrorLevel.Critical));
return(Ok(new OperationResponse
{
HasSucceeded = false,
Message = StatusMessages.ServerError,
IsDomainValidationErrors = false
}));
}
}
