public void AddSale(Product product, Buyer buyer, History history)
{
using (var context = new BlessDiamondContext(_connectionString))
{
context.Products.Add(product);
Buyer b = context.Buyers.FirstOrDefault(i => i.BuyerName == buyer.BuyerName);
if (b != null)
{
buyer.Id = b.Id;
}
else
{
context.Buyers.Add(buyer);
}
Sale sale = new Sale
{
DateOfSale = DateTime.Now,
BuyerId = buyer.Id,
ProductId = product.Id
};
context.Sales.Add(sale);
History h = new History
{
Date = DateTime.Now,
Amount = history.Amount,
SaleProductId = product.Id,
SaleBuyerId = buyer.Id
};
context.History.Add(h);
context.SaveChanges();
}
}
public Sale GetSale(int id)
{
using (var context = new BlessDiamondContext(_connectionString))
{
var s = context.Sales.FirstOrDefault(i => i.ProductId == id);
s.Buyer = context.Buyers.FirstOrDefault(b => b.Id == s.BuyerId);
s.Product = context.Products.FirstOrDefault(p => p.Id == s.ProductId);
s.History = context.History.Where(h => h.SaleProductId == id).ToList();
return(s);
}
}
public void AddPayment(int id, decimal amount)
{
using (var context = new BlessDiamondContext(_connectionString))
{
History h = new History();
h.Amount = amount;
h.Date = DateTime.Now;
h.SaleProductId = id;
context.History.Add(h);
context.SaveChanges();
}
}
public IEnumerable <Sale> GetAllSales()
{
using (var context = new BlessDiamondContext(_connectionString))
{
var s = context.Sales.ToArray();
foreach (Sale sale in s)
{
sale.Buyer = context.Buyers.FirstOrDefault(b => b.Id == sale.BuyerId);
sale.Product = context.Products.FirstOrDefault(p => p.Id == sale.ProductId);
}
return(s);
}
}