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