internal static List<Price> GetPriceList(int distributorID)
{
TechTestDataContext db = new TechTestDataContext();
var result = (from price in db.Prices
join priceList in db.PriceLists on price.ID equals priceList.PriceID
join distPriceList in db.DistributorPriceLists on priceList.ID equals distPriceList.PriceListID
join distributor in db.Distributors on distPriceList.ID equals distributor.DistributorPriceListID
where distributor.ID == distributorID
select price).ToList();
return result;
}
internal static int CreatePriceList()
{
TechTestDataContext db = new TechTestDataContext();
int maxID = (from distPriceList in db.DistributorPriceLists
select distPriceList.PriceListID).Max();
maxID++;
DistributorPriceList distributorPriceList = new DistributorPriceList() { PriceListID = maxID };
db.DistributorPriceLists.InsertOnSubmit(distributorPriceList);
db.SubmitChanges();
return maxID;
}
