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