/// <summary>
/// Gets the lastest message from the Database
/// </summary>
/// <returns>ViewAdminMessageJoin Object</returns>
public ViewAdminMessageJoin GetMessagesView()
{
var message = new ViewAdminMessageJoin();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
if (conn.State == System.Data.ConnectionState.Open)
{
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "SELECT TOP 1 * FROM ViewAdminMessageJoin ORDER BY Date DESC";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
message.Username = reader.GetString(0);
message.Header = reader.GetString(1);
message.Date = reader.GetDateTime(2);
message.Text = reader.GetString(3);
}
}
}
}
}
return(message);
}
/// <summary>
/// Retrives the custom admin message from the database and sets the relevant AdminMessage element in the GUI.
/// </summary>
private void SetAdminMessage()
{
try
{
ViewAdminMessageJoin msg = messageHandler.GetNewestViewMessage();
TBlockAdminMessageTitle.Text = msg.Header;
TBlockAdminMessage.Text = msg.Text;
TBlockAdminMessageDate.Text = msg.Date.ToString("dd/MM/yyyy");
TBlockAdminMessageAuthor.Text = msg.Username;
MessageTextFormatting();
}
catch (Exception error)
{
DataValidation.SaveError(error.ToString());
}
}
