public void Delete(WebStoreContext db, Product product) { db.Products.Remove(product); db.SaveChanges(); }
public void Post(WebStoreContext db, Product product) { db.Products.Add(product); db.SaveChanges(); }
public void Create(Variant item) { _context.Variants.Add(item); _context.SaveChanges(); }
public void Create(Product item) { db.Products.Add(item); db.SaveChanges(); }
public void Create(User item) { db.Users.Add(item); db.SaveChanges(); }
public static void Initialize(WebStoreContext context) { var rents = new Rent[] { new Rent { CustomerId = 1, TotalPrice = 50000, Performed = false }, new Rent { CustomerId = 1, TotalPrice = 100000, Performed = false } }; foreach (Rent r in rents) { context.Rents.Add(r); } context.SaveChanges(); var rentProductConnections = new RentProductConnection[] { new RentProductConnection { ProductModellNumber = 125, CountProduct = 1, RentId = 2, }, new RentProductConnection { ProductModellNumber = 126, CountProduct = 2, RentId = 1 }, new RentProductConnection { ProductModellNumber = 140, CountProduct = 5, RentId = 1 } }; foreach (RentProductConnection rp in rentProductConnections) { context.RentProductConnections.Add(rp); } context.SaveChanges(); var categories = new Category[] { new Category { Name = "Telefon" }, new Category { Name = "Mosógép" }, new Category { Name = "Laptop" }, new Category { Name = "Hangszoró" }, new Category { Name = "TV" }, new Category { Name = "Porszívó" }, new Category { Name = "Kábelek" } }; foreach (Category c in categories) { context.Categories.Add(c); } context.SaveChanges(); var products = new Product[] { new Product { Producer = "Apple", ModellNumber = 124, Description = "Iphone8", CategoryId = 1, Price = 200000, Inventory = 10, Available = true, }, new Product { Producer = "Apple", ModellNumber = 125, Description = "IphoneX", CategoryId = 1, Price = 300000, Inventory = 5, Available = true, }, new Product { Producer = "Apple", ModellNumber = 126, Description = "Iphone6S", CategoryId = 1, Price = 140000, Inventory = 15, Available = true, }, new Product { Producer = "Apple", ModellNumber = 127, Description = "IphoneSE", CategoryId = 1, Price = 90000, Inventory = 20, Available = true, }, new Product { Producer = "Apple", ModellNumber = 128, Description = "Iphone4", CategoryId = 1, Price = 30000, Inventory = 10, Available = true, }, new Product { Producer = "Apple", ModellNumber = 129, Description = "Iphone4/S", CategoryId = 1, Price = 45000, Inventory = 7, Available = true, }, new Product { Producer = "Apple", ModellNumber = 130, Description = "Iphone5", CategoryId = 1, Price = 50000, Inventory = 15, Available = true, }, new Product { Producer = "Apple", ModellNumber = 131, Description = "Iphone5/S", CategoryId = 1, Price = 60000, Inventory = 18, Available = true, }, new Product { Producer = "Apple", ModellNumber = 132, Description = "Iphone6", CategoryId = 1, Price = 75000, Inventory = 20, Available = true, }, new Product { Producer = "Apple", ModellNumber = 133, Description = "Iphone7", CategoryId = 1, Price = 150000, Inventory = 30, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 140, Description = "Samsung Galaxy S4", CategoryId = 1, Price = 30000, Inventory = 4, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 141, Description = "Samsung Galaxy S5", CategoryId = 1, Price = 40000, Inventory = 15, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 142, Description = "Samsung Galaxy S5 Edge", CategoryId = 1, Price = 60000, Inventory = 40, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 143, Description = "Samsung Galaxy S6", CategoryId = 1, Price = 100000, Inventory = 10, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 144, Description = "Samsung Galaxy S6 Edge", CategoryId = 1, Price = 120000, Inventory = 5, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 145, Description = "Samsung Galaxy S7", CategoryId = 1, Price = 140000, Inventory = 6, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 146, Description = "Samsung Galaxy S7 Edge", CategoryId = 1, Price = 160000, Inventory = 4, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 147, Description = "Samsung Galaxy S8", CategoryId = 1, Price = 180000, Inventory = 10, Available = true, }, new Product { Producer = "Samsung", ModellNumber = 148, Description = "Samsung Galaxy S8 Edge", CategoryId = 1, Price = 200000, Inventory = 15, Available = true, }, new Product { Producer = "Sony", ModellNumber = 160, Description = "Sony XPeria Z", CategoryId = 1, Price = 60000, Inventory = 5, Available = true, }, new Product { Producer = "Sony", ModellNumber = 161, Description = "Sony XPeria Z6", CategoryId = 1, Price = 70000, Inventory = 10, Available = true, }, new Product { Producer = "Indesit", ModellNumber = 10, Description = "IWSC 51051 C ECO mosógép", CategoryId = 2, Price = 56000, Inventory = 11, Available = true, }, new Product { Producer = "Indesit", ModellNumber = 11, Description = "IWSC 10000 C ECO mosógép", CategoryId = 2, Price = 45000, Inventory = 12, Available = true, } }; foreach (Product p in products) { context.Products.Add(p); } context.SaveChanges(); }
public void Put(WebStoreContext db, User user) { db.Update(user); db.SaveChanges(); }
public void Create(Model item) { _context.Models.Add(item); _context.SaveChanges(); }
public static void Initialize(WebStoreContext context) { context.Database.EnsureCreated(); // Look for any products. if (context.Sections.Any()) { return; } var sections = new List <Section>() { new Section() { Id = 1, Name = "firs", Order = 0, ParentId = null }, new Section() { Id = 2, Name = "two", Order = 1, ParentId = 1 }, new Section() { Id = 3, Name = "three", Order = 0, ParentId = 1 }, new Section() { Id = 4, Name = "first, parent 2", Order = 0, ParentId = null }, new Section() { Id = 5, Name = "first", Order = 1, ParentId = 4 }, new Section() { Id = 7, Name = "test", Order = 2, ParentId = 4 } }; using (var trans = context.Database.BeginTransaction()) { foreach (var section in sections) { context.Sections.Add(section); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF"); trans.Commit(); } var brands = new List <Brand>(); using (var trans = context.Database.BeginTransaction()) { foreach (var brand in brands) { context.Brand.Add(brand); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF"); trans.Commit(); } }
public void AddNew(Employee employee) { _context.Employees.Add(employee); _context.SaveChanges(); }
public void Create(Modification item) { _context.Modifications.Add(item); _context.SaveChanges(); }
public void Create(Position item) { db.Positions.Add(item); db.SaveChanges(); }
private void InitializeProducts() { if (_db.Products.Any()) { _Logger.LogInformation("Products initializing not required"); return; } _Logger.LogInformation("Sections initializing..."); var products_sections = TestData.Sections.Join( TestData.Products, section => section.id, product => product.SectionId, (section, product) => (section, product)); foreach (var(section, product) in products_sections) { section.Products.Add(product); } var products_brands = TestData.Brands.Join( TestData.Products, brand => brand.id, product => product.BrandId, (brand, product) => (brand, product)); foreach (var(brand, product) in products_brands) { brand.Products.Add(product); } var section_section = TestData.Sections.Join( TestData.Sections, parent => parent.id, child => child.ParentId, (parent, child) => (parent, child)); foreach (var(parent, child) in section_section) { child.Parent = parent; } foreach (var product in TestData.Products) { product.id = 0; product.BrandId = null; product.SectionId = 0; } foreach (var brand in TestData.Brands) { brand.id = 0; } foreach (var section in TestData.Sections) { section.id = 0; section.ParentId = null; } using (_db.Database.BeginTransaction()) { _db.Products.AddRange(TestData.Products); _db.Sections.AddRange(TestData.Sections); _db.Brands.AddRange(TestData.Brands); _db.SaveChanges(); _db.Database.CommitTransaction(); } _Logger.LogInformation("Products initialize completed."); }
public void Create(Mark item) { _context.Marks.Add(item); _context.SaveChanges(); }
public void Delete(WebStoreContext db, User user) { db.Users.Remove(user); db.SaveChanges(); }
public static void Initialize(WebStoreContext context) { context.Database.EnsureCreated(); if (context.Products.Any()) { return; } var sections = new List <Section> { new Section() { Id = 1, Name = "Sportswear", Order = 0, ParentId = null }, new Section() { Id = 2, Name = "Nike", Order = 0, ParentId = 1 }, new Section() { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Section() { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Section() { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Section() { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Section() { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Section() { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Section() { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Section() { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Section() { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Section() { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Section() { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Section() { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Section() { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Section() { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Section() { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Section() { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Section() { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Section() { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Section() { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Section() { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Section() { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Section() { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Section() { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Section() { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Section() { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Section() { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Section() { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Section() { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; using (var trans = context.Database.BeginTransaction()) { foreach (var section in sections) { context.Sections.Add(section); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF"); trans.Commit(); } var brands = new List <Brand> { new Brand() { Id = 1, Name = "Acne", Order = 0 }, new Brand() { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand() { Id = 3, Name = "Albiro", Order = 2 }, new Brand() { Id = 4, Name = "Ronhill", Order = 3 }, new Brand() { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand() { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand() { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; using (var trans = context.Database.BeginTransaction()) { foreach (var brand in brands) { context.Brands.Add(brand); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF"); trans.Commit(); } var products = new List <Product> { new Product() { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 0, SectionId = 2, BrandId = 1, Quantity = 5, Condition = "New" }, new Product() { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 1, SectionId = 2, BrandId = 1, Quantity = 7, Condition = "New" }, new Product() { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 2, SectionId = 2, BrandId = 1, Quantity = 10, Condition = "Used" }, new Product() { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 3, SectionId = 2, BrandId = 1, Quantity = 2, Condition = "New" }, new Product() { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 4, SectionId = 2, BrandId = 2, Quantity = 4, Condition = "New" }, new Product() { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 5, SectionId = 2, BrandId = 2, Quantity = 5, Condition = "Used" }, new Product() { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 6, SectionId = 2, BrandId = 2, Quantity = 2, Condition = "New" }, new Product() { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 7, SectionId = 25, BrandId = 2, Quantity = 1, Condition = "New" }, new Product() { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 8, SectionId = 25, BrandId = 2, Quantity = 3, Condition = "New" }, new Product() { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 9, SectionId = 25, BrandId = 3, Quantity = 15, Condition = "Used" }, new Product() { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 10, SectionId = 25, BrandId = 3, Quantity = 7, Condition = "Used" }, new Product() { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 11, SectionId = 25, BrandId = 3, Quantity = 0, Condition = "New" }, }; using (var trans = context.Database.BeginTransaction()) { foreach (var product in products) { context.Products.Add(product); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF"); trans.Commit(); } var employees = new List <Employee> { new Employee { Id = 1, IsMan = true, FirstName = "Иван", SecondName = "Иванов", Patronymic = "Иванович", Age = 20, SecretName = "Корпоративный герой", Position = "Продавец" }, new Employee { Id = 2, IsMan = false, FirstName = "Наталья", SecondName = "Сидорова", Patronymic = "Владимировна", Age = 23, SecretName = "Девушка с большой буквы \"С\"", Position = "Системный администратор" }, new Employee { Id = 3, IsMan = true, FirstName = "Семён", SecondName = "Семёнов", Patronymic = "Семёнович", Age = 40, SecretName = "Любитель перерывов", Position = "Бухгалтер" } }; using (var trans = context.Database.BeginTransaction()) { foreach (var employee in employees) { context.Employees.Add(employee); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Employees] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Employees] OFF"); trans.Commit(); } }
public void Post(WebStoreContext db, User user) { db.Users.Add(user); db.SaveChanges(); }
public void SaveChanges() { _context.SaveChanges(); }
public void Create(Role item) { db.Roles.Add(item); db.SaveChanges(); }
public void Create(Order item) { _context.Orders.Add(item); _context.SaveChanges(); }
public void Save() { db.SaveChanges(); }
public static void Initialize(WebStoreContext context) { context.Database.EnsureCreated(); if (context.Products.Any()) { return; } var categories = new List <Category>() { new Category() { Id = 1, Name = "Sportswear 2", Order = 0, ParentId = null }, new Category() { Id = 2, Name = "Nike", Order = 1, ParentId = 1 }, new Category() { Id = 3, Name = "Under Armour", Order = 1, ParentId = 1 }, new Category() { Id = 4, Name = "Adidas", Order = 2, ParentId = 1 }, new Category() { Id = 5, Name = "Puma", Order = 3, ParentId = 1 }, new Category() { Id = 6, Name = "ASICS", Order = 4, ParentId = 1 }, new Category() { Id = 7, Name = "Mens", Order = 1, ParentId = null }, new Category() { Id = 8, Name = "Fendi", Order = 0, ParentId = 7 }, new Category() { Id = 9, Name = "Guess", Order = 1, ParentId = 7 }, new Category() { Id = 10, Name = "Valentino", Order = 2, ParentId = 7 }, new Category() { Id = 11, Name = "Dior", Order = 3, ParentId = 7 }, new Category() { Id = 12, Name = "Versace", Order = 4, ParentId = 7 }, new Category() { Id = 13, Name = "Armani", Order = 5, ParentId = 7 }, new Category() { Id = 14, Name = "Prada", Order = 6, ParentId = 7 }, new Category() { Id = 15, Name = "Dolce and Gabbana", Order = 7, ParentId = 7 }, new Category() { Id = 16, Name = "Chanel", Order = 8, ParentId = 7 }, new Category() { Id = 17, Name = "Gucci", Order = 1, ParentId = 7 }, new Category() { Id = 18, Name = "Womens", Order = 2, ParentId = null }, new Category() { Id = 19, Name = "Fendi", Order = 0, ParentId = 18 }, new Category() { Id = 20, Name = "Guess", Order = 1, ParentId = 18 }, new Category() { Id = 21, Name = "Valentino", Order = 2, ParentId = 18 }, new Category() { Id = 22, Name = "Dior", Order = 3, ParentId = 18 }, new Category() { Id = 23, Name = "Versace", Order = 4, ParentId = 18 }, new Category() { Id = 24, Name = "Kids", Order = 3, ParentId = null }, new Category() { Id = 25, Name = "Fashion", Order = 4, ParentId = null }, new Category() { Id = 26, Name = "Households", Order = 5, ParentId = null }, new Category() { Id = 27, Name = "Interiors", Order = 6, ParentId = null }, new Category() { Id = 28, Name = "Clothing", Order = 7, ParentId = null }, new Category() { Id = 29, Name = "Bags", Order = 8, ParentId = null }, new Category() { Id = 30, Name = "Shoes", Order = 9, ParentId = null } }; var brands = new List <Brand>() { new Brand() { Id = 1, Name = "Acne 5", Order = 0 }, new Brand() { Id = 2, Name = "Grüne Erde", Order = 1 }, new Brand() { Id = 3, Name = "Albiro", Order = 2 }, new Brand() { Id = 4, Name = "Ronhill", Order = 3 }, new Brand() { Id = 5, Name = "Oddmolly", Order = 4 }, new Brand() { Id = 6, Name = "Boudestijn", Order = 5 }, new Brand() { Id = 7, Name = "Rösch creative culture", Order = 6 }, }; var Products = new List <Product>() { new Product() { Id = 1, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product1.jpg", Order = 0, CategoryId = 2, BrandId = 1 }, new Product() { Id = 2, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product2.jpg", Order = 1, CategoryId = 2, BrandId = 1 }, new Product() { Id = 3, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product3.jpg", Order = 2, CategoryId = 2, BrandId = 1 }, new Product() { Id = 4, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product4.jpg", Order = 3, CategoryId = 2, BrandId = 1 }, new Product() { Id = 5, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product5.jpg", Order = 4, CategoryId = 2, BrandId = 2 }, new Product() { Id = 6, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product6.jpg", Order = 5, CategoryId = 2, BrandId = 2 }, new Product() { Id = 7, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product7.jpg", Order = 6, CategoryId = 2, BrandId = 2 }, new Product() { Id = 8, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product8.jpg", Order = 7, CategoryId = 25, BrandId = 2 }, new Product() { Id = 9, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product9.jpg", Order = 8, CategoryId = 25, BrandId = 2 }, new Product() { Id = 10, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product10.jpg", Order = 9, CategoryId = 25, BrandId = 3 }, new Product() { Id = 11, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product11.jpg", Order = 10, CategoryId = 25, BrandId = 3 }, new Product() { Id = 12, Name = "Easy Polo Black Edition", Price = 1025, ImageUrl = "product12.jpg", Order = 11, CategoryId = 25, BrandId = 3 }, }; using (var trans = context.Database.BeginTransaction()) { foreach (var section in categories) { context.Categorys.Add(section); } context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Categories] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Categories] OFF"); context.Database.CommitTransaction(); } using (var trans = context.Database.BeginTransaction()) { foreach (var brand in brands) { context.Brands.Add(brand); } context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Brand] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Brand] OFF"); context.Database.CommitTransaction(); } using (var trans = context.Database.BeginTransaction()) { foreach (var product in Products) { context.Products.Add(product); } context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Products] ON"); context.SaveChanges(); context.Database.ExecuteSqlRaw("SET IDENTITY_INSERT [dbo].[Products] OFF"); context.Database.CommitTransaction(); } }
public void Put(WebStoreContext db, Product product) { db.Update(product); db.SaveChanges(); }
public void Create(Photo item) { _context.Photos.Add(item); _context.SaveChanges(); }
public OrderDTO CreateOrder(CreateOrderModel OrderDetails, string UserName) { using (logger.BeginScope($"Попытка добавления заказа для пользователя {UserName}")) { if (OrderDetails is null || OrderDetails.Order is null) { logger.LogError("При попытке добавления заказа обнаружено, что передана пустая ссылка на тип."); throw new ArgumentNullException(nameof(OrderDetails)); } var user = userManager.FindByNameAsync(UserName).Result; if (user is null) { logger.LogError($"Пользователь с именем {UserName} не найден в системе."); throw new ArgumentException("Пользователь не найден", nameof(UserName)); } if (OrderDetails.OrderItems?.Count > 0) { using (var trans = context.Database.BeginTransaction()) { Order order = new Order { Address = OrderDetails.Order.Address, DateTime = DateTime.Now, Phone = OrderDetails.Order.Phone, User = user }; context.Orders.Add(order); logger.LogInformation($"Добавление заказа: Адрес - {OrderDetails.Order.Address}, телефон - {OrderDetails.Order.Phone}"); foreach (var item in OrderDetails.OrderItems) { var product = context.Products.FirstOrDefault(p => p.Id == item.ProductId); if (product is null) { logger.LogError($"Товар заявленный в заказе не найден в БД магазина. (ИД {item.ProductId})"); throw new InvalidOperationException("Товар не найден в БД"); } var orderItem = new OrderItem { Order = order, Product = product, Quantity = item.Quantity, TotalPrice = item.Quantity * product.Price }; context.OrderItems.Add(orderItem); logger.LogInformation($"Добавление продукта с id {product.Id} к заказу."); } if (context.SaveChanges() > 0) { logger.LogInformation($"Заказ с id {order.Id} успешно записан в БД"); } else { logger.LogError($"При записи заказа в БД возникли ошибки."); } trans.Commit(); return(order.ToDTO()); } } else { logger.LogError($"Заказ содержит пустой список товаров."); throw new ArgumentException("OrderItems не содержит элементов", nameof(OrderDetails)); } } }