private void UpdateCustomerComplaintsButton_Click(object sender, RoutedEventArgs e)
{
using (var db = new PSDB())
{
foreach (var c in CustomerComplaints)
{
var ms = db.CustomerComplaints.Find(c.CustomerComplaintID);
if (ms == null)
{
continue;
}
ms.Jan = c.Jan;
ms.Feb = c.Feb;
ms.Mar = c.Mar;
ms.Apr = c.Apr;
ms.May = c.May;
ms.Jun = c.Jun;
ms.Jul = c.Jul;
ms.Aug = c.Aug;
ms.Sep = c.Sep;
ms.Oct = c.Oct;
ms.Nov = c.Nov;
ms.Dec = c.Dec;
}
db.SaveChanges();
MessageBox.Show("Update Complete", "Update Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void UpdateStatsButton_Click(object sender, RoutedEventArgs e)
{
using (var db = new PSDB())
{
EventDictionary["CustomerComplaintDate"].Timestamp = CustomerComplaintDatePicker.SelectedDate;
EventDictionary["LastAccidentDate"].Timestamp = AccidentDatePicker.SelectedDate;
foreach (var m in MonthlyStats)
{
// try to retrieve existing entity
var ms = db.MonthlyStats.Find(m.ID);
ms.Inventory_Actual = m.Inventory_Actual;
ms.Inventory_Average = m.Inventory_Average;
ms.Inventory_Target = m.Inventory_Target;
ms.LPC_Actual = m.LPC_Actual;
ms.LPC_Target = m.LPC_Target;
ms.NQC_Actual = m.NQC_Actual;
ms.NQC_Target = m.NQC_Target;
ms.OEE_Actual = m.OEE_Actual;
ms.OEE_Target = m.OEE_Target;
}
foreach (Event ev in EventDictionary.Values)
{
var eve = db.Events.Find(ev.ID);
eve.Timestamp = ev.Timestamp;
}
db.SaveChanges();
MessageBox.Show("Update Complete", "Update Info", MessageBoxButton.OK, MessageBoxImage.Information);
}
}