public void ViewArchiveEmail(int EmailAddressNo, int ArchiveNo)
{
clsEmail OneEmail = new clsEmail();
clsEmailCollection AllEmails = new clsEmailCollection();
EmailAddress = AllEmails.GetEmailAddress(EmailAddressNo);
bool IsArchive = true;
AllEmails.GetOneEmail(ArchiveNo, IsArchive, out EmailSubject, out EmailContent);
txtBxSubject.Text = EmailSubject;
txtBxContent.Text = EmailContent;
txtBxFrom.Text = EmailAddress;
}
public void GetEmailAddressOK()
{
//create instance of the class
clsEmailCollection AllEmails = new clsEmailCollection();
string LocalEmailAddress = "*****@*****.**";
//check to see if it works ok
string DatabaseEmailAdddress = AllEmails.GetEmailAddress(1);
Assert.AreEqual(LocalEmailAddress, DatabaseEmailAdddress);
}
//this will be the function that shows the new email and it accepts the emailno selected in
//the datagridview
public void NewEmail(int EmailAddressNo, int EmailNo)
{
//txtBxFrom.Text = Convert.ToString(EmailAddressNo);
clsEmail OneEmail = new clsEmail();
clsEmailCollection AllEmails = new clsEmailCollection();
EmailAddress = AllEmails.GetEmailAddress(EmailAddressNo);
bool IsArchive = false;
AllEmails.GetOneEmail(EmailNo, IsArchive, out EmailSubject, out EmailContent);
txtBxSubject.Text = EmailSubject;
txtBxContent.Text = EmailContent;
txtBxFrom.Text = EmailAddress;
}
private List<clsEmail> FillGridArchive()
{
//instance of the database connection class
clsDataConnection DB = new clsDataConnection();
List<clsEmail> allEmails = new List<clsEmail>();
//exectue the stored procedure
DB.Execute("sproc_tblArchive_SelectAll");
//get the count
Int32 RecordCount = DB.Count;
//set up index for the loop
Int32 Index = 0;
//while there are records to process
while (Index < RecordCount)
{
//create a new instance of the email class
clsEmail AEmail = new clsEmail();
//create instance of clsEmailCollection class
clsEmailCollection ACollectionEmail = new clsEmailCollection();
//get the archive number
AEmail.ArchiveNo = DB.DataTable.Rows[Index]["ArchiveNo"].ToString();
//get the email subject
AEmail.EmailSubject = DB.DataTable.Rows[Index]["EmailSubject"].ToString();
//get the primary key
AEmail.EmailNo = Convert.ToInt32(DB.DataTable.Rows[Index]["EmailNo"]);
//get the email Content
AEmail.EmailContent = DB.DataTable.Rows[Index]["EmailContent"].ToString();
//get the email address recieving
AEmail.EmailAddressNo = Convert.ToInt32(DB.DataTable.Rows[Index]["EmailAddressNo"]);
//passess the EmailAddressNo to get the EmailAddress
AEmail.EmailAddress = ACollectionEmail.GetEmailAddress(AEmail.EmailAddressNo);
//add the Email to the private data
allEmails.Add(AEmail);
//add to the index
Index++;
}
return allEmails;
}
