public void TestContexVolSkill()
{
string[] insertNames = { "Volunteer.xlsx", "Group.xlsx", "GroupVol.xlsx", "VolAddress.xlsx",
"VolAddr.xlsx", "Skill.xlsx", "VolPhone.xlsx"};
string[] removeNames = { "Volunteer.xlsx", "Group.xlsx", "GroupVol.xlsx", "VolAddress.xlsx",
"VolAddr.xlsx", "Skill.xlsx", "VolSkill.xlsx", "VolState.xlsx",
"VolEmail.xlsx", "VolPhone.xlsx"};
cExcel.RemoveAllData();
cExcel.InsertData(insertNames);
string directory = cExcel.GetHelperFilesDir();
string hdir = cExcel.GetHelperFilesDir();
sp_VolSkill_BLL volskillBLL = new sp_VolSkill_BLL();
string query = "SELECT * FROM [Sheet1$]";
DataTable dtvolskill = cExcel.QueryExcelFile(hdir + "VolSkill.xlsx", query);
DataTable dtskill = cExcel.QueryExcelFile(hdir + "Skill.xlsx", query);
foreach (DataRow row in dtvolskill.Rows)
{
//Push data into the database and then check to see if the data
//we get out the other end is the same.
volskillBLL.InsertVolSkill(new Guid(row["VolID"].ToString()), new Guid(row["SkillID"].ToString()));
var returned_Skill = volskillBLL.ListVolSkills(new Guid(row["VolID"].ToString()));
Assert.IsTrue(returned_Skill.Capacity > 0);
sp_VolSkill_DM fnd_skill = returned_Skill.Find(x => x.SkillID.Equals(new Guid(row["SkillID"].ToString())));
Assert.AreEqual(fnd_skill.SkillID, new Guid(row["SkillID"].ToString()));
}
cExcel.RemoveData(removeNames);
}