public void Increment(int productID, int amount, string notes)
        {
            using (DB db = new DB()) {
                Commerce.Data.SqlRepository.InventoryRecord record = new Commerce.Data.SqlRepository.InventoryRecord();
                record.ProductID   = productID;
                record.Notes       = notes;
                record.Increment   = amount;
                record.DateEntered = DateTime.Now;
                db.InventoryRecords.InsertOnSubmit(record);

                db.SubmitChanges();
            }
        }
        public void Increment(int productID, int amount, string notes) {


            using (DB db = new DB()) {
                Commerce.Data.SqlRepository.InventoryRecord record = new Commerce.Data.SqlRepository.InventoryRecord();
                record.ProductID = productID;
                record.Notes = notes;
                record.Increment = amount;
                record.DateEntered = DateTime.Now;
                db.InventoryRecords.InsertOnSubmit(record);

                db.SubmitChanges();
            }

        }
 partial void DeleteInventoryRecord(InventoryRecord instance);
 partial void UpdateInventoryRecord(InventoryRecord instance);
 partial void InsertInventoryRecord(InventoryRecord instance);
		private void detach_InventoryRecords(InventoryRecord entity)
		{
			this.SendPropertyChanging();
			entity.Product = null;
		}