partial void UpdateSample(Sample instance);
partial void DeleteSample(Sample instance);
partial void InsertSample(Sample instance);
private void detach_Samples(Sample entity) { this.SendPropertyChanging(); entity.Material = null; }
private void attach_Samples(Sample entity) { this.SendPropertyChanging(); entity.Material = this; }
/// <summary> /// Function that adds a new <see cref="Sample"/>. /// </summary> public void _AddSampleCommand() { int? newSampleID = DatabaseUtils.AddNewSample(); if (newSampleID == null) return; Sample newSample = Database.Samples.FirstOrDefault(x => x.SampleID == newSampleID); Samples.Add(newSample); SelectedSample = newSample; }
/// <summary> /// Function that adds a new sample to the database. /// </summary> /// <param name="SampleName">The name of the new sample.</param> /// <returns>The SampleID of the sample added to the database.</returns> public static int? AddNewSample(string SampleName) { using (DatabaseDataContext Database = MyGlobals.Database) { Sample sample = Database.Samples.FirstOrDefault(x => x.SampleName == SampleName); if (sample != null) { trace.Value.TraceEvent(TraceEventType.Warning, 0, "Can't create new sample: sample already exists"); MessageBoxResult result = MessageBox.Show("Sample already exists in database!", "Info", MessageBoxButton.OK, MessageBoxImage.Information); return sample.SampleID; } // New sample Sample newSample = new Sample(); newSample.SampleName = SampleName; newSample.MaterialID = 1; Database.Samples.InsertOnSubmit(newSample); Database.SubmitChanges(); trace.Value.TraceEvent(TraceEventType.Information, 0, "New sample '" + newSample.SampleName + "' created"); return newSample.SampleID; } }