/// <summary>
/// Add an email to the database
/// </summary>
/// <param name="email">the email there should be added</param>
public void addEmailToDB(PopClient.emailStruct email)
{
if (getEmailByMessageID(email.messageID).Count == 0)
{
sqlCon.Open();
string sql = @"INSERT INTO Email (MessageID, SenderName, Body, TimeStamp, Cc, Subject, MailTo, Attachment, SenderEmail, Receiver, Seen) VALUES
(@messageID,@senderName,@body,@timeStamp,@cc,@subject,@mailTo,@attachment,@senderEmail,@receiver,@seen)";
sqlCom = new SQLiteCommand(sql, sqlCon);
if (String.IsNullOrEmpty(email.messageID))
{
email.messageID = "NULL";
}
sqlCom.Parameters.Add(new SQLiteParameter("@messageID", email.messageID));
sqlCom.Parameters.Add(new SQLiteParameter("@senderName", email.senderName));
sqlCom.Parameters.Add(new SQLiteParameter("@body", WebUtility.HtmlEncode(email.body)));
sqlCom.Parameters.Add(new SQLiteParameter("@timeStamp", email.timeStamp));
sqlCom.Parameters.Add(new SQLiteParameter("@cc", email.cc));
sqlCom.Parameters.Add(new SQLiteParameter("@subject", email.subject));
sqlCom.Parameters.Add(new SQLiteParameter("@mailTo", email.mailTo));
sqlCom.Parameters.Add(new SQLiteParameter("@attachment", email.attachment));
sqlCom.Parameters.Add(new SQLiteParameter("@senderEmail", email.senderEmail));
sqlCom.Parameters.Add(new SQLiteParameter("@receiver", email.receiver));
sqlCom.Parameters.Add(new SQLiteParameter("@seen", email.seen));
sqlCom.ExecuteNonQuery();
sqlCon.Close();
}
}
/// <summary>
/// Get emails from the database by the messageID
/// returns only more then 1 email if its a spam mail
/// </summary>
/// <param name="messageID">the messageID</param>
/// <returns>the list of emails</returns>
public List <PopClient.emailStruct> getEmailByMessageID(string messageID)
{
List <PopClient.emailStruct> emails = new List <PopClient.emailStruct>();
PopClient.emailStruct email = new PopClient.emailStruct();
sqlCon.Open();
string sql = "SELECT * FROM Email WHERE MessageID='" + messageID + "'";
sqlCom = new SQLiteCommand(sql, sqlCon);
SQLiteDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
email.messageID = reader["MessageID"].ToString();
email.senderName = reader["SenderName"].ToString();
email.senderEmail = reader["SenderEmail"].ToString();
email.body = WebUtility.HtmlDecode(reader["Body"].ToString());
email.timeStamp = reader["TimeStamp"].ToString();
email.cc = reader["Cc"].ToString();
email.subject = reader["Subject"].ToString();
email.mailTo = reader["MailTo"].ToString();
email.attachment = reader["Attachment"].ToString();
email.receiver = reader["Receiver"].ToString();
email.seen = Convert.ToBoolean(reader["Seen"].ToString());
emails.Add(email);
}
sqlCon.Close();
return(emails);
}
/// <summary>
/// Get emails from the database by the messageID
/// returns only more then 1 email if its a spam mail
/// </summary>
/// <param name="messageID">the messageID</param>
/// <returns>the list of emails</returns>
public List<PopClient.emailStruct> getEmailByMessageID(string messageID)
{
List<PopClient.emailStruct> emails = new List<PopClient.emailStruct>();
PopClient.emailStruct email = new PopClient.emailStruct();
sqlCon.Open();
string sql = "SELECT * FROM Email WHERE MessageID='" + messageID + "'";
sqlCom = new SQLiteCommand(sql, sqlCon);
SQLiteDataReader reader = sqlCom.ExecuteReader();
while (reader.Read())
{
email.messageID = reader["MessageID"].ToString();
email.senderName = reader["SenderName"].ToString();
email.senderEmail = reader["SenderEmail"].ToString();
email.body = WebUtility.HtmlDecode(reader["Body"].ToString());
email.timeStamp = reader["TimeStamp"].ToString();
email.cc = reader["Cc"].ToString();
email.subject = reader["Subject"].ToString();
email.mailTo = reader["MailTo"].ToString();
email.attachment = reader["Attachment"].ToString();
email.receiver = reader["Receiver"].ToString();
email.seen = Convert.ToBoolean(reader["Seen"].ToString());
emails.Add(email);
}
sqlCon.Close();
return emails;
}
/// <summary>
/// an item for EmailListShower
/// </summary>
/// <param name="_email">PopClient.emailStruct</param>
/// <param name="_mw">MainWindow</param>
public EmailListItems(PopClient.emailStruct _email, MainWindow _mw)
{
InitializeComponent();
email = _email;
mw = _mw;
}
/// <summary>
/// Show the selected email
/// </summary>
/// <param name="_email">the email to be shown</param>
public EmailShower(PopClient.emailStruct _email)
{
InitializeComponent();
email = _email;
}
/// <summary>
/// an item for EmailListShower
/// </summary>
/// <param name="_email">PopClient.emailStruct</param>
/// <param name="_mw">MainWindow</param>
public EmailListItems(PopClient.emailStruct _email, MainWindow _mw)
{
InitializeComponent();
email = _email;
mw = _mw;
}
/// <summary>
/// Show the selected email
/// </summary>
/// <param name="_email">the email to be shown</param>
public EmailShower(PopClient.emailStruct _email)
{
InitializeComponent();
email = _email;
}