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