public IQueryable <Models.Product> GetRegions([ScopedService] NakodaAgenciesDbContext context) { try { return(context.Products.AsQueryable()); //return null; } catch (Exception ex) { throw; } }
public async Task <UpdateProductPayload> UpdateProductAsync( UpdateProductInput input, [ScopedService] NakodaAgenciesDbContext context, [Service] ITopicEventSender eventSender, CancellationToken cancellationToken ) { try { var region = context.Products.Where(c => c.ProductId.Equals(input.ProductId)).FirstOrDefault(); if (region == null) { throw new Exception("No Region found for" + input.ProductId); } if (!string.IsNullOrEmpty(input.ProductName)) { region.ProductName = input.ProductName; } if (!string.IsNullOrEmpty(Convert.ToString(input.Active))) { region.Active = input.Active; } context.Products.Update(region); await context.SaveChangesAsync(cancellationToken); await eventSender.SendAsync(nameof(ProductSubscription.OnProductUpdated), region, cancellationToken); var regionResponse = (from _region in context.Products where _region.ProductId.Equals(region.ProductId) select new Models.Product { ProductId = _region.ProductId ?? default(Guid), ProductName = _region.ProductName, Active = _region.Active, CreatedDate = _region.CreatedDate }).FirstOrDefault(); return(new UpdateProductPayload(regionResponse)); } catch (Exception ex) { throw; } }
public async Task <AddProductPayload> AddProductAsync( AddProductInput input, [ScopedService] NakodaAgenciesDbContext context, [Service] ITopicEventSender eventSender, CancellationToken cancellationToken ) { try { //List<TestGraphQL.Models.Product> _address = Builder<TestGraphQL.Models.Product>.CreateListOfSize(10000).All() // .With(c => c.ProductName = Faker.Address.StreetName()) // ).Build().ToList(); var region = new TestGraphQL.Models.Product { ProductName = input.ProductName, Active = true, CreatedDate = DateTime.Now }; context.Products.AddRange(region); await context.SaveChangesAsync(cancellationToken); await eventSender.SendAsync(nameof(ProductSubscription.OnProductAdded), region, cancellationToken); var _regionResponse = (from _region in context.Products where _region.ProductId.Equals(region.ProductId) select new Models.Product { ProductId = _region.ProductId ?? default(Guid), ProductName = _region.ProductName, Active = _region.Active, CreatedDate = _region.CreatedDate }).FirstOrDefault(); return(new AddProductPayload(_regionResponse)); } catch (Exception ex) { throw; } }