public MailoviewObject(MailObjects mail)
{
InitializeComponent();
Sender = mail.sender;
Subject = mail.subject;
Date = mail.date;
Message = mail.message;
this.DataContext = this;
}
public static List<MailObjects> readMails()
{
List<MailObjects> mailList = new List<MailObjects>();
SQLiteCommand cmd = new SQLiteCommand(dbConnection);
cmd.CommandText = "SELECT * FROM MailList";
try
{
dbConnection.Open();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
MailObjects nextMail = new MailObjects(reader.GetString(0), reader.GetString(1), reader.GetString(2), reader.GetString(3), reader.GetString(4), reader.GetString(5));
mailList.Add(nextMail);
}
reader.Close();
}
catch (Exception)
{
throw;
}
finally{
dbConnection.Close();
}
return mailList;
}
