public void NotifyObservers(INewsMessage NewsMessage)
{
if (NewsEvents.ContainsKey(NewsMessage.ObserverName))
{
NewsEvents[NewsMessage.ObserverName]?.Invoke(NewsMessage.Message);
}
}
public void CreateNewsMessage(INewsMessage newsMessage)
{
var _newsMessage = new NewsMessage()
{
ID = newsMessage.ID,
AccountID = newsMessage.AccountID,
Title = newsMessage.Title,
Message = newsMessage.Message
};
NewsMessageDataBaseHandler.CreateNewsMessage(_newsMessage);
}
//GetById
public INewsMessage GetById(INewsMessage newsMessage)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
string query = "SELECT * FROM NewsMessage WHERE ID = @ID; ";
using (MySqlCommand command = new MySqlCommand(query, conn))
{
command.Parameters.AddWithValue("@ID", newsMessage.ID);
}
}
return(newsMessage);
}
//Update in CRUD
public void UpdateNewsMessage(INewsMessage NM1)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
string query = "UPDATE newsmessage SET ID = @ID, AccountID = @AccountID, Title=@Title,Message=@Message WHERE ID=@ID; ";
using (MySqlCommand command = new MySqlCommand(query, conn))
{
command.Parameters.AddWithValue("@ID", NM1.ID);
command.Parameters.AddWithValue("@AccountID", NM1.AccountID);
command.Parameters.AddWithValue("@Title", NM1.Title);
command.Parameters.AddWithValue("@Message", NM1.Message);
command.ExecuteNonQuery();
}
}
}
//Create in CRUD
public void CreateNewsMessage(INewsMessage NM1)
{
using (MySqlConnection conn = new MySqlConnection(connectionString))
{
string query = "INSERT INTO newsmessage VALUES(@AccountID,@Title,@Message); ";
using (MySqlCommand command = new MySqlCommand(query, conn))
{
command.Parameters.AddWithValue("@AccountID", NM1.AccountID);
command.Parameters.AddWithValue("@Title", NM1.Title);
command.Parameters.AddWithValue("@Message", NM1.Message);
command.ExecuteNonQuery();
}
}
}
public INewsMessage UpdateNewsMessage(INewsMessage newsMessage)
{
NewsMessageDataBaseHandler.UpdateNewsMessage(newsMessage);
return(newsMessage);
}
public INewsMessage GetById(INewsMessage newsMessage)
{
throw new NotImplementedException();
}
