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