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 AddSales(AddSalesRequest addSales) { using (DataAccess dataAccess = new DataAccess()) { Sales sales = new Sales(); sales.SellerID = sellerService.GetSellerID(new Contracts.Request.Seller.GetSellerID(addSales.SellerName, addSales.SellerSurname, addSales.SellerEmail)); sales.CustomerID = addSales.CustomerID; sales.ProductID = addSales.ProductID; sales.SalesNumber = addSales.SalesNumber; sales.Cost = addSales.Cost; dataAccess.Sales.Add(sales); UpdateStockNumber(new UpdateStockNumberRequest(addSales.ProductID, addSales.SalesNumber)); dataAccess.SaveChanges(); var addedsales = dataAccess.Sales.Where(x => x.CustomerID == sales.CustomerID && x.SellerID == sales.SellerID && x.ProductID == sales.ProductID && x.SalesNumber == sales.SalesNumber && x.Cost == sales.Cost).OrderBy(x => x.SalesID); AddNotf(new AddNotificationRequest(addedsales.FirstOrDefault().SalesID)); return(dataAccess.SaveChanges()); } }