//GET ONE MESSAGE public FeedbackEntityDL GetMessage(int idMessage) { try { using (EntityFramework accessToDB = new EntityFramework()) { return(accessToDB.FeedbackEntityDLTable.Where(x => x.Id == idMessage).SingleOrDefault()); } } catch (Exception ex) { FeedbackEntityDL error = new FeedbackEntityDL("Keine Bericht", "wurde eingelesen", "Fehlerbeschreibung:", $"{ex.Message.ToString()}"); return(error); } //using (SqlConnection connection = new SqlConnection(ConnectionString)) //{ // connection.Open(); // using (SqlCommand command = new SqlCommand("SELECT id,requestType,message,email,phoneNumber FROM Messages WHERE id=@idMessage", connection)) // { // command.Parameters.AddWithValue("@idMessage", idMessage); // using (SqlDataReader reader = command.ExecuteReader()) // { // if(!reader.Read()) // { // return null; // } // return GetFeedbackEntity(reader); // } // } //} }
// ADD ONE MESSAGE FROM WEB SITE public string AddMessageFromWebSite(FeedbackEntityDL messageToDB) { string result = ""; try { using (EntityFramework accessToDB = new EntityFramework()) { accessToDB.FeedbackEntityDLTable.Add(messageToDB); accessToDB.SaveChanges(); return(result = "Wir danken für Ihre Meinung"); } } catch (Exception ex) { return(result = $"Die Bericht wurde nicht gespeichert. Fehlerbeschreibung: {ex.Message.ToString()}"); } //using (SqlConnection connection = new SqlConnection(ConnectionString)) //{ // connection.Open(); // using (SqlCommand command = new SqlCommand("INSERT INTO Messages (email, phoneNumber, message, requestType) VALUES (@email, @phoneNumber, @message, @requestType)", connection)) // { // command.Parameters.AddWithValue("@email", messageToDB.Email); // command.Parameters.AddWithValue("@phoneNumber", messageToDB.PhoneNumber ?? string.Empty); // command.Parameters.AddWithValue("@message", messageToDB.Message ?? string.Empty); // command.Parameters.AddWithValue("@requestType", messageToDB.RequestType); // command.ExecuteNonQuery(); // } //} }