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