public void AddSellingPoint(string address, SellingPointCategory spc, string shawarmaTitle)
{
var sp = new SellingPoint {
Address = address, SellingPointCategory = spc, ShawarmaTitle = shawarmaTitle
};
shawarmaDb.SellingPoint.Add(sp);
shawarmaDb.SaveChanges();
}
public IEnumerable GenerateSellingPointReport(SellingPoint sp, DateTime from, DateTime at)
{
return(shawarmaDb.OrderDetails
.Where(t => t.OrderHeader.Seller.SellingPoint == sp && t.OrderHeader.OrderDate > from && t.OrderHeader.OrderDate < at)
.Join(shawarmaDb.Shawarma,
a => a.ShawarmaId,
b => b.ShawarmaId,
(a, b) => new { a, b }
) as IEnumerable);
}
public void AddNewChief(string name, SellingPoint sp)
{
shawarmaDb.Seller.Add(new Seller {
SellerName = name, SellingPoint = sp
});
}
