public static void InsertVolEmailData(TestContext testContext)
{
System.Diagnostics.Debug.WriteLine(String.Format("{0}", DateTime.Now));
cExcel.RemoveAllData();
cExcel.InsertData(ExcelFilenames);
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
generalTestVol = new sp_Volunteer_DM();
generalTestVol.VolFirstName = "TestFirst";
generalTestVol.VolMiddleName = "TestMiddle";
generalTestVol.VolLastName = "TestLast";
generalTestVol.ActiveFlg = true;
Guid volID = Guid.NewGuid();
generalTestVol.VolID = volID;
volBLL.InsertVolunteerContext(ref generalTestVol);
sp_VolEmail_BLL volEmail_bll = new sp_VolEmail_BLL();
primaryTestVolEmail = new sp_Email_DM();
primaryTestVolEmail.EmailAddr = "*****@*****.**";
primaryTestVolEmail.VolID = volID;
primaryTestVolEmail.ActiveFlg = true;
primaryTestVolEmail.PrimaryFlg = true;
volEmail_bll.InsertEmailContext(ref primaryTestVolEmail);
secondaryTestVolEmail = new sp_Email_DM();
secondaryTestVolEmail.EmailAddr = "*****@*****.**";
secondaryTestVolEmail.VolID = volID;
secondaryTestVolEmail.ActiveFlg = true;
secondaryTestVolEmail.PrimaryFlg = false;
volEmail_bll.InsertEmailContext(ref secondaryTestVolEmail);
}