private void dgParameters_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { if (e.EditAction == DataGridEditAction.Commit) { SystemParametersDataContext context = new SystemParametersDataContext(); SystemParameter sysParams = e.Row.DataContext as SystemParameter; var matchedData = (from sp in context.SystemParameters where sp.ParameterID == sysParams.ParameterID select sp).SingleOrDefault(); if (matchedData == null) { SystemParameter sysParam = new SystemParameter(); sysParam.Description = sysParams.Description; sysParam.Value = sysParams.Value; sysParam.MiscDescription = sysParams.MiscDescription; sysParam.Created = DateTime.Now; context.SystemParameters.InsertOnSubmit(sysParam); context.SubmitChanges(); } else { matchedData.Description = sysParams.Description; matchedData.Value = sysParams.Value; matchedData.MiscDescription = sysParams.MiscDescription; context.SubmitChanges(); } } LoadDataGrid(); }
private void Window_Loaded(object sender, RoutedEventArgs e) { IsEditing = false; IsInserting = false; systemParameters = new SystemParametersDataContext(); LoadDataGrid(); }