public void UpdateCommodity(Commodity commodity)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     var updateCommodity = (from s in dispositionDb.Commodities
                                 where s.CommodityID == commodity.CommodityID
                                 select s).Single();
     updateCommodity.Code = commodity.Code;
     updateCommodity.Description = commodity.Description;
     updateCommodity.Obsolete = commodity.Obsolete;
     dispositionDb.SubmitChanges();
 }
 public void CreateCommodity(Commodity commodity)
 {
     DispositionDataContext dispositionDb = new DispositionDataContext();
     dispositionDb.Commodities.InsertOnSubmit(commodity);
     dispositionDb.SubmitChanges();
 }
 partial void UpdateCommodity(Commodity instance);
 partial void DeleteCommodity(Commodity instance);
 partial void InsertCommodity(Commodity instance);