public void TestGroupCreate()
{
string groupName = "TestGroup";
string shortDesc = "We Rock!";
string longDesc = "We will, we will, rock you!";
int levelID = 5;
var group_bll = new sp_Group_BLL();
var group_dm = new sp_Group_DM();
group_dm.GroupName = groupName;
group_dm.ShortDesc = shortDesc;
group_dm.LongDesc = longDesc;
group_dm.ParticipationLevelID = levelID;
var groupID = group_bll.InsertGroupContext(ref group_dm).GroupID;
group_dm.GroupID = groupID;
var group_dm_selected = group_bll.ListGroups(groupID);
Assert.IsTrue(Equals(group_dm, group_dm_selected));
}
public void TestGroupAddrCreate()
{
var group_bll = new sp_Group_BLL();
var groupAddr_bll = new sp_GroupAddr_BLL();
var groupAddr_dm = new sp_GroupAddr_DM();
var allGroups = group_bll.ListGroups();
Assert.IsTrue(allGroups.Count > 0, "The allGroups() is broken, or no data in DB");
groupAddr_dm.GroupID = allGroups[0].GroupID;
groupAddr_dm.PrimaryAddrID = true;
groupAddr_dm.ActiveFlg = true;
var volAddress_bll = new sp_Vol_Address_BLL();
var volAddress_dm = volAddress_bll.ListAddress(new sp_Vol_Address_DM());
groupAddr_bll.InsertAddressContext(ref volAddress_dm, ref groupAddr_dm);
groupAddr_dm.AddrID = volAddress_dm.AddrID;
var groupAddr_dm_selected = groupAddr_bll.ListAddress(groupAddr_dm);
Assert.IsTrue(Equals(groupAddr_dm, groupAddr_dm_selected));
}
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 TestGroupDelete()
{
var group_bll = new sp_Group_BLL();
var allGroups = group_bll.ListGroups();
Assert.IsTrue(allGroups.Count > 0, "The ListGroups() is broken, or no data in DB");
var currGroup = allGroups[0];
//TODO: change activeflg to bool not bool?
var notActive = currGroup.ActiveFlg != true;
var i = 1;
while (notActive)
{
currGroup = allGroups[i];
notActive = currGroup.ActiveFlg != true;
}
group_bll.DeleteGroupContext(currGroup);
var selectedGroup = group_bll.ListGroups(currGroup.GroupID);
//TODO: change activeflg to bool not bool?
Assert.IsNotNull(selectedGroup.ActiveFlg);
Assert.IsFalse(selectedGroup.ActiveFlg == true);
Assert.IsTrue(selectedGroup.ActiveFlg == false);
}
public void TestGroupRead()
{
//Pull our data from the excel file
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "Group.xlsx"));
var excelDMs = DMsFrom(dt);
//Pull our data directly from the DB
var numRows = cExcel.getNumRecordsFromDB("[Vol].[tblGroup]");
//Pull our data from the DB through the BLL
var group_bll = new sp_Group_BLL();
var allGroups = group_bll.ListGroups();
//Test the data from the BLL
Assert.AreEqual(numRows, allGroups.Count);
foreach (var testGroup in excelDMs)
{
var selectedGroup = group_bll.ListGroups(testGroup.GroupID);
Assert.IsTrue(Equals(testGroup, selectedGroup));
}
}
public void TestGroupUpdate()
{
var group_bll = new sp_Group_BLL();
var allGroups = group_bll.ListGroups();
Assert.IsTrue(allGroups.Count > 0, "The ListGroups() is broken, or no data in DB");
var firstGroup = allGroups[0];
var newGroupName = "Updated Group Name";
firstGroup.GroupName = newGroupName;
group_bll.UpdateGroupContext(firstGroup);
var selectedGroup = group_bll.ListGroups(firstGroup.GroupID);
Assert.IsTrue(Equals(firstGroup, selectedGroup));
Assert.AreEqual(newGroupName, selectedGroup.GroupName);
}