public int AddSales(AddShoppingBasketRequest addShoppingBasketRequest) { using (DataAccess dataAccess = new DataAccess()) { var shoppinglist = dataAccess.ShoppingBasket.Where(x => x.CustomerID == addShoppingBasketRequest.CustomerID).ToList(); foreach (var item in shoppinglist) { var seller = (from s in dataAccess.ShoppingBasket join p in dataAccess.Products on s.ProductID equals p.ProductID join sel in dataAccess.Sellers on p.SellerID equals sel.SellerID where p.ProductID == item.ProductID select new { Name = sel.Name, Surname = sel.Surname, Email = sel.Email }).ToList()[0]; AddSalesRequest addSales = new AddSalesRequest(); addSales.CustomerID = addShoppingBasketRequest.CustomerID; addSales.SellerName = seller.Name; addSales.SellerSurname = seller.Surname; addSales.SellerEmail = seller.Email; addSales.ProductID = item.ProductID; addSales.SalesNumber = item.SalesNumber; addSales.Cost = item.Cost; salesService.AddSales(addSales); dataAccess.SaveChanges(); ClearAllShoppingList(new Contracts.Request.ShoppingBasket.ClearAllShoppingList(addShoppingBasketRequest.CustomerID)); } return(dataAccess.SaveChanges()); } }
public int AddShoppingList(AddShoppingBasketRequest addShoppingBasket) { using (DataAccess dataAccess = new DataAccess()) { var added = new ShoppingBasket(); added.CustomerID = addShoppingBasket.CustomerID; added.ProductID = addShoppingBasket.ProductID; added.SalesNumber = addShoppingBasket.SalesNumber; added.Cost = addShoppingBasket.Cost; dataAccess.ShoppingBasket.Add(added); return(dataAccess.SaveChanges()); } }
public int AddShoppingList(AddShoppingBasketRequest addShoppingBasket) { return(shoppingBasketService.AddShoppingList(addShoppingBasket)); }
public int AddSales(AddShoppingBasketRequest addShoppingBasketRequest) { return(shoppingBasketService.AddSales(addShoppingBasketRequest)); }