public void Edit(Fly_Customer obj) { try { using (var context = new flycameraEntities()) { var item = context.Fly_Customer .Include("Fly_Picture") .Include("Fly_Customer_CustomerRole_Mapping") .Include("Fly_CustomerAttribute") .Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole") .Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole.Fly_CustomerRole_Discount_Mapping") .Include("Fly_Customer_CustomerRole_Mapping.Fly_CustomerRole.Fly_CustomerRole_ProductPrice") .FirstOrDefault(x => x.CustomerID == obj.CustomerID); if (item != null) { var cusAtrr = item.Fly_CustomerAttribute.FirstOrDefault(); context.Entry(cusAtrr).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_CustomerAttribute.FirstOrDefault(), cusAtrr)); context.Entry(item).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, item)); } context.SaveChanges(); } } catch (DbEntityValidationException ex) { throw ex; } }
public void Edit(Fly_Customer_CustomerRole_Mapping obj) { try { using (var context = new flycameraEntities()) { var item = context.Fly_Customer_CustomerRole_Mapping.FirstOrDefault(x => x.CustomerRoleID == obj.CustomerRoleID); if (item != null) { context.Entry(item).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, item)); context.SaveChanges(); } } } catch (DbEntityValidationException ex) { throw ex; } }
public void Edit(Fly_RelatedProduct obj) { try { using (var context = new flycameraEntities()) { var item = context.Fly_RelatedProduct.Find(obj.RelatedProductID); if (item != null) { context.Entry(item).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, item)); context.SaveChanges(); } else { this.Add(obj); } } } catch (DbEntityValidationException ex) { throw ex; } }
public void Edit(Fly_Product obj) { try { using (var context = new flycameraEntities()) { var product = context.Fly_Product.Include("Fly_ProductVariant.Fly_ProductVariantLocalized") .Include("Fly_ProductVariant.Fly_ProductVariant_Discount_Mapping") .Include("Fly_ProductLocalized") .Include("Fly_Product_Category_Mapping") .Include("Fly_Product_Manufacturer_Mapping") .Include("Fly_ProductPicture.Fly_Picture") .Where(x => x.ProductId == obj.ProductId).FirstOrDefault(); // old Entity Data var mappingCate = product.Fly_Product_Category_Mapping.FirstOrDefault(); var mappingManufacturer = product.Fly_Product_Manufacturer_Mapping.FirstOrDefault(); var productLocalized = product.Fly_ProductLocalized.FirstOrDefault(); var productPicture = product.Fly_ProductPicture.FirstOrDefault(); var productVariant = product.Fly_ProductVariant.FirstOrDefault(); var mappingVariantDiscount = productVariant.Fly_ProductVariant_Discount_Mapping.FirstOrDefault(); var mappingVariantLocalized = productVariant.Fly_ProductVariantLocalized.FirstOrDefault(); // new Entity Data var productVariantNew = obj.Fly_ProductVariant.FirstOrDefault(); if (product != null) { if (mappingCate != null) { context.Entry(mappingCate).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_Product_Category_Mapping.FirstOrDefault(), mappingCate)); } if (mappingManufacturer != null) { context.Entry(mappingManufacturer).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_Product_Manufacturer_Mapping.FirstOrDefault(), mappingManufacturer)); } if (productLocalized != null) { context.Entry(productLocalized).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_ProductLocalized.FirstOrDefault(), productLocalized)); } if (productPicture != null) { context.Entry(productPicture).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj.Fly_ProductPicture.FirstOrDefault(), productPicture)); } if (productVariant != null) { context.Entry(productVariant).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew, productVariant)); } if (mappingVariantLocalized != null) { context.Entry(mappingVariantLocalized).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariantLocalized.FirstOrDefault(), mappingVariantLocalized)); } if (mappingVariantDiscount != null) { context.Entry(mappingVariantDiscount).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariant_Discount_Mapping.FirstOrDefault(), mappingVariantDiscount)); } if (mappingVariantDiscount != null) { context.Entry(mappingVariantDiscount).CurrentValues.SetValues(UpdateEntities.UpdateEntity(productVariantNew.Fly_ProductVariant_Discount_Mapping.FirstOrDefault(), mappingVariantDiscount)); } context.Entry(product).CurrentValues.SetValues(UpdateEntities.UpdateEntity(obj, product)); context.SaveChanges(); } } } catch (Exception ex) { throw ex; } }
public async Task Handle(UpdateEntities command) { await command.Entities.Update(); }