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));
}
