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 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 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 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));
}
