/// <summary>
/// Verändert einen bestehenden Datensatz der Entität 'Arbeitsspeicher' in der Datenbank.
/// </summary>
/// <param name="entity">Die veränderte Entität</param>
public void Update(RandomAccessMemory entity)
{
MySqlConnection connection = this.CreateConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "UPDATE `"+ this.GetTableName() +"` SET `Beschreibung`='" + entity.Description + "', `Speicher`=" + entity.Memory + ", `Taktrate`='"
+ entity.ClockRate.ToString().Replace(',','.') + "', `ID_Hersteller`=" + entity.Producer.Id + " WHERE id = " + entity.Id;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
/// <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>
/// Speichert ein Objekt der Entität 'Arbeitsspeicher' in der Datenbank
/// </summary>
/// <param name="entity">Das Objekt, welches gespeichert wird</param>
public void Save(RandomAccessMemory entity)
{
MySqlConnection connection = this.CreateConnection();
MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO `" + this.GetTableName() + "`(`Beschreibung`, `Speicher`, `Taktrate`, "
+ "`ID_Hersteller`) VALUES ('" + entity.Description + "'," + entity.Memory + ","
+ entity.ClockRate.ToString().Replace(',','.') + "," + entity.Producer.Id + ")";
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
/// <summary>
/// Prüft die Konsistenz der Attribute der Entität 'Arbeitsspeicher'
/// </summary>
/// <param name="entity">Das Objekt, welches geprüft wird</param>
/// <returns>true: Objekt Konsistent, false: Objekt fehlerhaft</returns>
public bool CheckConsistency(RandomAccessMemory entity)
{
bool result = true;
if(entity.Memory == 0)
{
result = false;
}
if (entity.ClockRate <= 0)
{
result = false;
}
return result;
}
/// <summary>
/// Konstruktor: Setzt die Wert für die Initialisierung des Dialoges
/// </summary>
/// <param name="entity">Objekt eines Arbeitsspeichers</param>
public CreateRAM(RandomAccessMemory entity = null)
{
InitializeComponent();
this.GetProducers();
this.RamStorageUnit.SelectedIndex = 0;
if (entity != null)
{
this.entity = entity;
this.isAvailable = true;
this.SetAllFields();
}
else
{
this.entity = new RandomAccessMemory();
this.isAvailable = false;
}
}
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 validateRandomAccessMemory()
{
RandomAccessMemory ram = new RandomAccessMemory();
RandomAccessMemoryValidator validator = new RandomAccessMemoryValidator();
ram.Description = "Dies ist ein Test";
ram.Memory = 8000;
ram.ClockRate = 12000;
Assert.AreEqual(true, validator.CheckConsistency(ram));
}