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;
}
}
