private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (cbProduct.SelectedItem != null)
{
//product ophalen uit ComboBox en opslaan in 'myProduct'
product myProduct = (product)cbProduct.SelectedItem;
//Prijs ophalen bij product
pricehistory myPH = (from ph in db.pricehistories
where ph.productId == myProduct.id
/*&& ph.enddate == null*/
select ph).FirstOrDefault();
//Dingen opslaan in variable
string sPrice = txtPrice.Text;
double iPrice = Convert.ToDouble(sPrice);
DateTime dtStartdate = dtStart.SelectedDate.Value;
DateTime dtEnddate = dtEnd.SelectedDate.Value;
//myPH.enddate = dtDate;
pricehistory myPrice = new pricehistory();
//Variable invullen
myPrice.productId = myProduct.id;
myPrice.price = (decimal)iPrice;
myPrice.startdate = dtStartdate;
myPrice.enddate = dtEnddate;
//Database klaarzetten en opslaan
db.pricehistories.InsertOnSubmit(myPrice);
db.SubmitChanges();
//Refresh Datagrid
SetData();
}
}
private void detach_pricehistories(pricehistory entity)
{
this.SendPropertyChanging();
entity.product = null;
}
partial void Updatepricehistory(pricehistory instance);
partial void Deletepricehistory(pricehistory instance);
partial void Insertpricehistory(pricehistory instance);