public InsertVolSkill ( System.Guid VolID, System.Guid SkillID ) : void | ||
VolID | System.Guid | |
SkillID | System.Guid | |
return | void |
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); }