public void TestGroupVolCreate() { var group_bll = new sp_Group_BLL(); var vol_bll = new sp_Volunteer_BLL(); var groupVol_bll = new sp_GroupVol_BLL(); var groupVol_dm = new sp_Vol_GroupVol_DM(); var allGroups = group_bll.ListGroups(); var allVols = vol_bll.ListVolunteers(); Assert.IsTrue(allGroups.Count > 0, "ListGroups() is broken or no data in DB"); Assert.IsTrue(allVols.Count > 0, "ListVolunteers() is broken or no data in DB"); groupVol_dm.GroupID = allGroups[0].GroupID; groupVol_dm.VolID = allVols[0].VolID; groupVol_dm.Admin = true; groupVol_dm.PrimaryVolID = true; groupVol_bll.InsertGroupContext(ref groupVol_dm); var groupVol_dm_selected = groupVol_bll.ListGroupVols(groupVol_dm); Assert.AreEqual(1, groupVol_dm_selected.Count); Assert.IsTrue(Equals(groupVol_dm, groupVol_dm_selected[0])); }
public void TestGroupVolRead() { //Pull our data from the excel file string helperDir = cExcel.GetHelperFilesDir(); DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "GroupVol.xlsx")); var excelDMs = DMsFrom(dt); //Pull our data directly from the DB var numRows = cExcel.getNumRecordsFromDB("[Vol].[tblGroupVol]"); //Pull our data from the DB through the BLL var groupVol_bll = new sp_GroupVol_BLL(); List<sp_GroupVol_BLL> allGroupVols = null; //Need someway to select all group vols //allGroupVols = groupVol_bll.ListGroupVols(); Assert.IsNotNull(allGroupVols, "Listing all Group Vols is broken or no data in DB"); //Test the data from the BLL Assert.AreEqual(numRows, allGroupVols.Count); foreach (var testGroup in excelDMs) { var selectedGroup = groupVol_bll.ListGroupVols(testGroup); Assert.IsTrue(Equals(testGroup, selectedGroup)); } }
public void TestGroupVolDelete() { var groupVol_bll = new sp_GroupVol_BLL(); //Grab the first groupVol we find List<sp_Vol_GroupVol_DM> allGroupVols = null; //allGroupVols = groupVol_bll.ListGroupVols(); Assert.IsNotNull(allGroupVols, "Please fix/implement ListGroupVols then uncomment it"); Assert.IsTrue(allGroupVols.Count > 0, "The ListGroupVols() is broken, or no data in DB"); var currGroupVol = allGroupVols[0]; var numRows = cExcel.getNumRecordsFromDB("[Vol].[tblGroupVol]"); groupVol_bll.DeleteGroupContext(currGroupVol); var selectedGroupVol = groupVol_bll.ListGroupVols(currGroupVol); var currNumRows = cExcel.getNumRecordsFromDB("[Vol].[tblGroupVol]"); Assert.AreEqual(numRows - 1, currNumRows); //TODO: expand test to make sure the correct record was deleted }
public void TestGroupVolUpdate() { var volAddress_bll = new sp_Vol_Address_BLL(); var groupVol_bll = new sp_GroupVol_BLL(); //Grab the first groupVol we find List<sp_Vol_GroupVol_DM> allGroupVols = null; //allGroupVols = groupVol_bll.ListGroupVols(); Assert.IsNotNull(allGroupVols, "Please fix/implement ListGroupVols then uncomment it"); Assert.IsTrue(allGroupVols.Count > 0, "The ListGroupVols() is broken, or no data in DB"); var firstGroupVol = allGroupVols[0]; //Change some data firstGroupVol.PrimaryVolID = !firstGroupVol.PrimaryVolID; firstGroupVol.Admin = !firstGroupVol.Admin; //groupVol_bll.Update(firstGroupVol); //Pull record after the changes and test if it worked var selectedgroupVol = groupVol_bll.ListGroupVols(firstGroupVol); Assert.IsTrue(Equals(firstGroupVol, selectedgroupVol)); }