public IEnumerable<Waste> GetWasteForSeller(Seller seller, DateTime dateFrom, DateTime dateTo)
{
dateTo = dateTo.AddDays(1);
using (var context = new EugenieEntities(connectionStringAsString))
{
var wastes =
context.Wastes.Where(
x => x.SellerID == seller.ID && x.Date.CompareTo(dateFrom) >= 0 && x.Date.CompareTo(dateTo) <= 0)
.ToList();
return wastes;
}
}
public void AddWasteToSellerAsync(Seller originalSeller, Waste waste)
{
using (var worker = new BackgroundWorker())
{
worker.DoWork += (object sender, DoWorkEventArgs e) =>
{
using (var context = new EugenieEntities(connectionStringAsString))
{
var seller = context.Sellers.Find(originalSeller.ID);
seller.Wastes.Add(waste);
context.SaveChanges();
}
};
worker.RunWorkerAsync();
}
}
