/// <summary>
/// Ruft die Informationen aus dem Formular ab und speichert sie in die Datenbank.
/// Wirft eine Fehlermeldung, wenn die Validierung fehlschlägt.
/// </summary>
private void ProducerSave_Click(object sender, RoutedEventArgs e)
{
ProducerDataAccess dataAccess = new ProducerDataAccess();
ProducerValidator validator = new ProducerValidator();
try
{
this.setEntityWithFormData();
if (!validator.CheckConsistency(this.entity))
{
ErrorHandler.ShowErrorMessage("Validierung fehlgeschlagen", ErrorHandler.VALIDATION_FAILED);
}
else
{
if (this.isAvailable)
dataAccess.Update(this.entity);
else
dataAccess.Save(this.entity);
this.Close();
}
}
catch (FormatException exception)
{
ErrorHandler.ShowErrorMessage(exception, ErrorHandler.WRONG_FORMAT);
}
catch (MySql.Data.MySqlClient.MySqlException exception)
{
ErrorHandler.ShowErrorMessage(exception, ErrorHandler.SAVE_WENT_WRONG);
}
catch (System.OverflowException exception)
{
ErrorHandler.ShowErrorMessage(exception, ErrorHandler.DATA_TOO_LONG);
}
}
public void deleteProducerFromDatabase()
{
ProducerDataAccess dataAccess = new ProducerDataAccess();
Producer producer = dataAccess.GetLastEntity<Producer>();
dataAccess.Delete(producer.Id);
Assert.IsTrue(dataAccess.GetLastEntity<Producer>() == null || producer.Id == dataAccess.GetLastEntity<Producer>().Id);
}
/// <summary>
/// Fügt alle Hersteller aus der Datenbank dem Drop-Down-Menü hinzu
/// </summary>
private void GetProducers()
{
ProducerDataAccess dataProducers = new ProducerDataAccess();
List<Producer> producers = dataProducers.GetAllEntities<Producer>();
foreach (Producer element in producers)
{
this.RamProducer.Items.Add(element.CompanyName.ToString());
}
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Arbeitsspeicher'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>RandomAccessMemory</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
RandomAccessMemory ram = new RandomAccessMemory();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
ram.Id = Int32.Parse(reader.GetValue(0).ToString());
ram.Description = reader.GetValue(1).ToString();
ram.Memory = ulong.Parse(reader.GetValue(2).ToString());
ram.ClockRate = Double.Parse(reader.GetValue(3).ToString());
ram.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(4).ToString()));
return ram;
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Prozessor'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>Processor</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
Processor processor = new Processor();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
processor.Id = Int32.Parse(reader.GetValue(0).ToString());
processor.Description = reader.GetValue(1).ToString();
processor.Model = reader.GetValue(2).ToString();
processor.Core = uint.Parse(reader.GetValue(3).ToString());
processor.CommandSet = reader.GetValue(4).ToString();
processor.Architecture = uint.Parse(reader.GetValue(5).ToString());
processor.ClockRate = Double.Parse(reader.GetValue(6).ToString());
processor.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(7).ToString()));
return processor;
}
public void getDiskFromDatabase()
{
DiskDataAccess dataAccess = new DiskDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
PhysicalInterfaceDataAccess physicalInterfaceDataAccess = new PhysicalInterfaceDataAccess();
Disk hdd = new Disk();
hdd.Description = "Dies ist ein Test";
hdd.Capacity = 1000;
hdd.Ssd = false;
hdd.Inch = 3.5;
hdd.Producer = producerDataAccess.GetLastEntity<Producer>();
hdd.AddPhysicalInterface(new PhysicalInterfaceWithCount(physicalInterfaceDataAccess.GetLastEntity<PhysicalInterface>(), 3));
dataAccess.Save(hdd);
Disk dbHDD = dataAccess.GetLastEntity<Disk>();
Assert.AreEqual(hdd.Capacity, dbHDD.Capacity);
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Hauptplatine'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>Motherboard</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
Motherboard motherboard = new Motherboard();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
motherboard.Id = Int32.Parse(reader.GetValue(0).ToString());
motherboard.Description = reader.GetValue(1).ToString();
motherboard.Inch = Double.Parse(reader.GetValue(2).ToString());
motherboard.Socket = reader.GetValue(3).ToString();
motherboard.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(4).ToString()));
motherboard.PhysicalInterfaces = this.GetPhysicalInterfaces(motherboard);
return motherboard;
}
public void getProducerFromDatabase()
{
ProducerDataAccess dataAccess = new ProducerDataAccess();
Producer producer = new Producer();
producer.CompanyName = "Siemens";
producer.PhoneNumber = "123456";
producer.Email = "*****@*****.**";
producer.Website = "www.siemens.de";
producer.PostalCode = 21335;
producer.Place = "Lüneburg";
producer.Street = "Lüneburger Straße";
producer.HouseNumber = 1;
dataAccess.Save(producer);
Producer dbProducer = dataAccess.GetLastEntity<Producer>();
Assert.AreEqual(producer.Website, dbProducer.Website);
}
public void getMotherboardFromDatabase()
{
MotherboardDataAccess dataAccess = new MotherboardDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
PhysicalInterfaceDataAccess physicalInterfaceDataAccess = new PhysicalInterfaceDataAccess();
Motherboard motherboard = new Motherboard();
motherboard.Description = "Dies ist ein Test";
motherboard.Inch = 24.2;
motherboard.Socket = "PGA 988B";
motherboard.Producer = producerDataAccess.GetLastEntity<Producer>();
motherboard.AddPhysicalInterface(new PhysicalInterfaceWithCount(physicalInterfaceDataAccess.GetLastEntity<PhysicalInterface>(), 3));
dataAccess.Save(motherboard);
Motherboard dbMotherboard = dataAccess.GetLastEntity<Motherboard>();
Assert.AreEqual(motherboard.Socket, dbMotherboard.Socket);
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer)
{
this.entity.Description = this.description.Text;
this.entity.Inch = Convert.ToDouble(this.size.Text.Replace('.', ','));
this.entity.Producer = dataProducer.GetEntityByName<Producer>("Firma", this.producer.Text.ToString());
this.entity.Socket = this.socket.Text;
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer = null)
{
this.entity.Name = this.interfaceName.Text;
this.entity.Description = this.interfaceDescription.Text;
this.entity.Serial = Convert.ToBoolean(this.interfaceSerial.IsChecked);
this.entity.TransferRate = Convert.ToDouble(this.interfaceTransferRate.Text.Replace('.', ','));
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Grafikkarte'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>GraphicCard</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
GraphicCard graphicCard = new GraphicCard();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
graphicCard.Id = Int32.Parse(reader.GetValue(0).ToString());
graphicCard.Description = reader.GetValue(1).ToString();
graphicCard.ClockRate = Double.Parse(reader.GetValue(2).ToString());
graphicCard.Model = reader.GetValue(3).ToString();
graphicCard.Memory = ulong.Parse(reader.GetValue(4).ToString());
graphicCard.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(5).ToString()));
graphicCard.PhysicalInterfaces = this.GetPhysicalInterfaces(graphicCard);
return graphicCard;
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer)
{
this.entity.Description = this.description.Text;
this.entity.Resolution = this.resolution.Text;
this.entity.Inch = double.Parse(this.inch.Text.Replace('.',','));
this.entity.AspectRatio = this.aspectRatio.Text;
this.entity.Producer = dataProducer.GetEntityByName<Producer>("Firma", this.producer.Text.ToString());
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer)
{
this.entity.Description = this.description.Text;
this.entity.Model = this.model.Text;
this.entity.Producer = dataProducer.GetEntityByName<Producer>("Firma", this.producer.Text.ToString());
this.entity.CommandSet = this.commandSet.Text;
this.entity.Architecture = uint.Parse(this.architecture.Text);
this.entity.ClockRate = double.Parse(this.clockRate.Text.Replace(".", ","));
this.entity.Core = uint.Parse(this.cores.Text);
}
public void getGraphicCardFromDatabase()
{
GraphicCardDataAccess dataAccess = new GraphicCardDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
PhysicalInterfaceDataAccess physicalInterfaceDataAccess = new PhysicalInterfaceDataAccess();
GraphicCard graphicCard = new GraphicCard();
graphicCard.Description = "Dies ist ein Test";
graphicCard.ClockRate = 5;
graphicCard.Model = "GTX1234";
graphicCard.Memory = 2000;
graphicCard.Producer = producerDataAccess.GetLastEntity<Producer>();
graphicCard.AddPhysicalInterface(new PhysicalInterfaceWithCount(physicalInterfaceDataAccess.GetLastEntity<PhysicalInterface>(), 3));
dataAccess.Save(graphicCard);
GraphicCard dbGraphicCard = dataAccess.GetLastEntity<GraphicCard>();
Assert.AreEqual(graphicCard.Description, dbGraphicCard.Description);
}
public void getMonitorFromDatabase()
{
MonitorDataAccess dataAccess = new MonitorDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
PhysicalInterfaceDataAccess physicalInterfaceDataAccess = new PhysicalInterfaceDataAccess();
Monitor monitor = new Monitor();
monitor.Description = "Dies ist ein Test";
monitor.Resolution = "1280*800";
monitor.Inch = 24;
monitor.AspectRatio = "16:9";
monitor.Producer = producerDataAccess.GetLastEntity<Producer>();
monitor.AddPhysicalInterface(new PhysicalInterfaceWithCount(physicalInterfaceDataAccess.GetLastEntity<PhysicalInterface>(), 3));
dataAccess.Save(monitor);
Monitor dbMonitor = dataAccess.GetLastEntity<Monitor>();
Assert.AreEqual(monitor.Inch, dbMonitor.Inch);
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer)
{
this.entity.Description = this.DiskDescription.Text;
if (this.DiskCapacityUnit.Text == "MB")
{
this.entity.Capacity = Convert.ToUInt32(this.DiskCapacity.Text);
}
else if (this.DiskCapacityUnit.Text == "GB")
{
this.entity.Capacity = UnitConverter.ConvertToLower(Convert.ToUInt32(this.DiskCapacity.Text));
}
this.entity.Inch = Convert.ToDouble(this.DiskSize.Text.Replace('.', ','));
this.entity.Ssd = Convert.ToBoolean(this.DiskType.IsChecked);
this.entity.Producer = dataProducer.GetEntityByName<Producer>("Firma", this.DiskProducer.Text.ToString());
}
public void getProcessorFromDatabase()
{
ProcessorDataAccess dataAccess = new ProcessorDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
Processor processor = new Processor();
processor.Description = "Dies ist ein Test";
processor.Model = "i5";
processor.Core = 4;
processor.CommandSet = "RISC";
processor.Architecture = 64;
processor.ClockRate = 3.40;
processor.Producer = producerDataAccess.GetLastEntity<Producer>();
dataAccess.Save(processor);
Processor dbProcessor = dataAccess.GetLastEntity<Processor>();
Assert.AreEqual(processor.CommandSet, dbProcessor.CommandSet);
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Monitor'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>Monitor</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
Monitor monitor = new Monitor();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
PhysicalInterfaceDataAccess physicalInterfaceDataAccess = new PhysicalInterfaceDataAccess();
monitor.Id = Int32.Parse(reader.GetValue(0).ToString());
monitor.Description = reader.GetValue(1).ToString();
monitor.Resolution = reader.GetValue(2).ToString();
monitor.Inch = Double.Parse(reader.GetValue(3).ToString());
monitor.AspectRatio = reader.GetValue(4).ToString();
monitor.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(5).ToString()));
monitor.PhysicalInterfaces = this.GetPhysicalInterfaces(monitor);
return monitor;
}
public void getRandomAccessMemoryFromDatabase()
{
RandomAccessMemoryDataAccess dataAccess = new RandomAccessMemoryDataAccess();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
RandomAccessMemory ram = new RandomAccessMemory();
ram.Description = "Dies ist ein Test";
ram.Memory = 8000;
ram.ClockRate = 12000;
ram.Producer = producerDataAccess.GetLastEntity<Producer>();
dataAccess.Save(ram);
RandomAccessMemory dbRAM = dataAccess.GetLastEntity<RandomAccessMemory>();
Assert.AreEqual(ram.Memory, dbRAM.Memory);
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer)
{
this.entity.Description = this.RamDescription.Text.ToString();
this.entity.ClockRate = double.Parse(this.RamClockRate.Text.Replace('.', ','));
this.entity.Producer = dataProducer.GetEntityByName<Producer>("Firma", this.RamProducer.Text.ToString());
if (this.RamStorageUnit.Text == "MB")
{
this.entity.Memory = ulong.Parse(this.RamStorage.Text);
}
else if (this.RamStorageUnit.Text == "GB")
{
this.entity.Memory = UnitConverter.ConvertToLower(Convert.ToDouble(this.RamStorage.Text));
}
}
/// <summary>
/// Mappt einen Datensatz aus der Datenbank auf ein Objekt vom Typ 'Festplatte'
/// </summary>
/// <param name="reader">Der Datensatz, welcher gemappt wird</param>
/// <returns>Disk</returns>
protected override object MapToEntity(MySqlDataReader reader)
{
Disk disk = new Disk();
ProducerDataAccess producerDataAccess = new ProducerDataAccess();
disk.Id = Int32.Parse(reader.GetValue(0).ToString());
disk.Description = reader.GetValue(1).ToString();
disk.Capacity = ulong.Parse(reader.GetValue(2).ToString());
disk.Ssd = Boolean.Parse(reader.GetValue(3).ToString());
disk.Inch = Double.Parse(reader.GetValue(4).ToString());
disk.Producer = producerDataAccess.GetEntityById<Producer>(Int32.Parse(reader.GetValue(5).ToString()));
disk.PhysicalInterfaces = this.GetPhysicalInterfaces(disk);
return disk;
}
/// <summary>
/// Setzt die Werte des Formulares in der entity.
/// </summary>
/// <param name="dataProducer">Dataaccess Objekt eines Produzenten</param>
private void setEntityWithFormData(ProducerDataAccess dataProducer = null)
{
this.entity.CompanyName = this.ProducerCompanyName.Text;
this.entity.Email = this.ProducerEmail.Text;
this.entity.PhoneNumber = this.ProducerTelephone.Text;
this.entity.Website = this.ProducerWebsite.Text;
this.entity.PostalCode = uint.Parse(this.ProducerPostalCode.Text);
this.entity.Place = this.ProducerPlace.Text;
this.entity.Street = this.ProducerStreet.Text;
this.entity.HouseNumber = uint.Parse(this.ProducerHouseNumber.Text);
}