public static ShowcaseModel GetShowcaseById(Guid showcaseId) { DBContext _context = new DBContext(); ShowcaseModel showcase = ShowcaseMapper.Mapper(_context.Showcases.Where(x => x.Id == showcaseId).FirstOrDefault()); showcase.ShowcaseItems = ShowcaseItemsMapper.Mapper(_context.ShowcaseItems.Where(x => x.ShowCaseId == showcaseId).Include(x => x.Sku).Include(x => x.ShowCase).ToList()); return(showcase); }
public static List <ShowcaseModel> GetAllAvailableShowcases() { DBContext _context = new DBContext(); List <ShowcaseModel> showcases = ShowcaseMapper.Mapper(_context.Showcases.Where(x => x.StartDate <= DateTime.Now && x.EndDate >= DateTime.Now).ToList()); foreach (var item in showcases) { item.ShowcaseItems = ShowcaseItemsMapper.Mapper(_context.ShowcaseItems.Where(y => y.ShowCaseId == item.Id).Include(x => x.Sku).ToList()); foreach (var sku in item.ShowcaseItems) { sku.Sku.Product = ProductMapper.Mapper(_context.Products.Where(x => x.Id == sku.Sku.ProductId).FirstOrDefault()); } } return(showcases); }
public IActionResult Upsert(ShowcaseModel sc) { var SkuCodes = sc.ShowCaseItemCodes.Split("\r\n"); DBContext _context = new DBContext(); if (sc.Id == new Guid()) { sc.Id = Guid.NewGuid(); _context.Showcases.Add(ShowcaseMapper.Mapper(sc)); foreach (var item in SkuCodes) { ShowcaseItemsModel scs = new ShowcaseItemsModel(); scs.ShowCase = sc; scs.Sku = SkuMapper.Mapper(_context.Skus.Where(x => x.Barcode == item).FirstOrDefault()); _context.ShowcaseItems.Add(ShowcaseItemsMapper.Mapper(scs)); } _context.SaveChanges(); } return(RedirectToAction("Index")); }
public IActionResult Carregar() { var buyer = this.User.FindFirstValue(ClaimTypes.NameIdentifier); DBContext _context = new DBContext(); OrderModel validacao = OrderMapper.Mapper(_context.Order.Include(x => x.Address).Include(x => x.Buyer).Include(x => x.Seller).Where(x => x.BuyerId == Guid.Parse(buyer)).FirstOrDefault()); if (validacao == null) { ProductModel p1 = new ProductModel { Id = Guid.NewGuid(), Code = "0001", Name = "Coca-Cola", Description = "Refrigerante", ImageUrl = "https://i.imgur.com/ps6alt2.jpg", Skus = new List <SkuModel>() }; SkuModel s1 = new SkuModel { Id = Guid.NewGuid(), Barcode = "793001215", Name = "350 ml", Color = "#ff0000", Price = 4.50 }; SkuModel s2 = new SkuModel { Id = Guid.NewGuid(), Barcode = "793001216", Name = "2 L", Color = "#ff0000", ImageUrl = "https://i.imgur.com/ps6alt2.jpg", Price = 7.00 }; p1.Skus.Add(s1); p1.Skus.Add(s2); _context.Products.Add(ProductMapper.Mapper(p1)); ProductModel p2 = new ProductModel { Id = Guid.NewGuid(), Name = "Fanta Laranja", Code = "0002", Description = "Refri de laranja", ImageUrl = "https://i.imgur.com/cxKXQ0k.png", Skus = new List <SkuModel>() }; SkuModel s3 = new SkuModel { Id = Guid.NewGuid(), Name = "350 ml", Barcode = "79300251362", Price = 4.50, Color = "#f24f00", ImageUrl = "https://i.imgur.com/cxKXQ0k.png" }; p2.Skus.Add(s3); _context.Products.Add(ProductMapper.Mapper(p2)); UserModel u = new UserModel { Id = Guid.NewGuid(), FullName = "Shopping Palladium", Document = "08355847000109", Discriminator = Models.Enums.DiscriminatorEnum.Seller }; _context.Users.Add(UserMapper.Mapper(u)); SkuStocksModel ss = new SkuStocksModel { Id = Guid.NewGuid(), AvailableQuantity = 52, LastUpdate = DateTime.Now, Sku = s2, Seller = u }; SkuStocksModel ss2 = new SkuStocksModel { Id = Guid.NewGuid(), AvailableQuantity = 31, LastUpdate = DateTime.Now, Sku = s3, Seller = u }; _context.Stocks.Add(StockMapper.Mapper(ss)); _context.Stocks.Add(StockMapper.Mapper(ss2)); ShowcaseModel sc = new ShowcaseModel { Id = Guid.NewGuid(), Name = "Inverno", StartDate = DateTime.Now, EndDate = DateTime.Now, LastUpdate = DateTime.Now }; ShowcaseItemsModel scp1 = new ShowcaseItemsModel() { Id = Guid.NewGuid(), ShowCase = sc, Sku = s2 }; ShowcaseItemsModel scp2 = new ShowcaseItemsModel() { Id = Guid.NewGuid(), ShowCase = sc, Sku = s3 }; ShowcaseItemsMapper.Mapper(scp1); ShowcaseItemsMapper.Mapper(scp2); _context.Showcases.Add(ShowcaseMapper.Mapper(sc)); _context.ShowcaseItems.Add(ShowcaseItemsMapper.Mapper(scp1)); _context.ShowcaseItems.Add(ShowcaseItemsMapper.Mapper(scp2)); AddressModel address = new AddressModel { Id = Guid.NewGuid() }; _context.Add(AddressMapper.Mapper(address)); PaymentModel payment = new PaymentModel { Id = Guid.NewGuid() }; _context.Add(PaymentMapper.Mapper(payment)); OrderModel order = new OrderModel { Id = Guid.NewGuid(), CreateDate = DateTime.Now, Discount = 0, SubTotal = 0, Total = 0, FriendlyCode = "S&T-X3VI5A", Buyer = new UserModel { Id = Guid.Parse(this.User.FindFirstValue(ClaimTypes.NameIdentifier)), }, Seller = new UserModel { Id = u.Id, }, Address = address, Payment = payment }; _context.Order.Add(OrderMapper.Mapper(order)); _context.SaveChanges(); } return(RedirectToAction("Index")); }