Ejemplo n.º 1
0
        public ActionResult Edit([Bind(Include = "Id,Name,Address")] Store store, int[] selectedProducts)
        {
            if (ModelState.IsValid)
            {
                var storeFind = db.Stores.Find(store.Id);
                if (storeFind != null)
                {
                    storeFind.Products.Clear();
                    if (selectedProducts != null)
                    {
                        foreach (var prod in db.Products.Where(p => selectedProducts.Contains(p.Id)))
                        {
                            storeFind.Products.Add(prod);
                        }
                    }

                    db.SaveChanges();
                    db.Entry(storeFind).State = EntityState.Modified;
                }

                _storeRepository.UpdateStore(store);

                return(RedirectToAction("Index"));
            }

            return(View(store));
        }
Ejemplo n.º 2
0
        public ActionResult Edit([Bind(Include = "Id,Name,Description")]
                                 Product product)
        {
            if (ModelState.IsValid)
            {
                db.Entry(product).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(product));
        }
Ejemplo n.º 3
0
 public void UpdateStore(Store store)
 {
     context.Entry(store).State = EntityState.Modified;
     context.SaveChanges();
 }
Ejemplo n.º 4
0
        public async Task <List <HierarchyId> > DeleteDetailWithDescendantsAsync(
            int detailId,
            int?parentDetailId)
        {
            List <DetailRelation> childRelationsToDelete = null;

            await using (var transaction = await _context.Database.BeginTransactionAsync())
            {
                List <HierarchyId> parentHierarchyIds = null;

                if (parentDetailId != null)
                {
                    parentHierarchyIds = await GetDetailHierarchyIdsAsync(parentDetailId.Value);
                }
                else
                {
                    parentHierarchyIds = new List <HierarchyId>
                    {
                        HierarchyId.GetRoot()
                    };
                }

                var detailRelations = await _context.DetailRelations
                                      .AsNoTracking()
                                      .Where(x => x.DetailId == detailId)
                                      .ToListAsync()
                                      .ConfigureAwait(false);

                var ancestorRelationsToDelete = new List <DetailRelation>();

                detailRelations.ForEach(detailRelation =>
                {
                    if (parentHierarchyIds.Contains(
                            detailRelation.HierarchyId.GetAncestor(1)))
                    {
                        ancestorRelationsToDelete.Add(detailRelation);
                    }
                });

                var ancestorHierarchyIdsToDelete = ancestorRelationsToDelete
                                                   .Select(x => x.HierarchyId)
                                                   .ToList();

                IQueryable <DetailRelation> childRelationsToDeleteQuery = _context.DetailRelations
                                                                          .Where(x => false);

                ancestorHierarchyIdsToDelete.ForEach(ancestorHierarchyId =>
                {
                    var queryPart = _context.DetailRelations
                                    .Where(x => x.HierarchyId
                                           .IsDescendantOf(ancestorHierarchyId));

                    childRelationsToDeleteQuery = childRelationsToDeleteQuery.Concat(queryPart);
                });


                childRelationsToDelete = await childRelationsToDeleteQuery
                                         .ToListAsync()
                                         .ConfigureAwait(false);

                // To address: For some reason added DetailRelations are being tracked by the context
                // if use RemoveRange method, then delete query fails or don't work properly

                //_context.DetailRelations.RemoveRange(childRelationsToDelete);

                childRelationsToDelete.ForEach(x =>
                {
                    var entry   = _context.Entry(x);
                    entry.State = EntityState.Deleted;
                });

                await _context.SaveChangesAsync().ConfigureAwait(false);

                var detailIdsOfDeletedRelations = childRelationsToDelete
                                                  .Select(x => x.DetailId)
                                                  .Distinct()
                                                  .ToList();

                var detailIdsToNotDelete = await _context.DetailRelations
                                           .Where(x => detailIdsOfDeletedRelations.Contains(x.DetailId))
                                           .Select(x => x.DetailId)
                                           .Distinct()
                                           .ToListAsync()
                                           .ConfigureAwait(false);

                var detailsIdsToRemove = detailIdsOfDeletedRelations
                                         .Except(detailIdsToNotDelete)
                                         .ToList();

                if (detailsIdsToRemove.Any())
                {
                    var detailsToRemove = _context.Details
                                          .Where(x => detailsIdsToRemove.Contains(x.DetailId));

                    _context.Details.RemoveRange(detailsToRemove);

                    await _context.SaveChangesAsync().ConfigureAwait(false);
                }

                await transaction.CommitAsync().ConfigureAwait(false);
            }

            var resultListOfHierarchyIds = childRelationsToDelete?
                                           .Select(x => x.HierarchyId).ToList();

            return(resultListOfHierarchyIds);
        }
Ejemplo n.º 5
0
 public void UpdateProduct(Product product)
 {
     context.Entry(product).State = EntityState.Modified;
     context.SaveChanges();
 }