public void TestGroupAddrDelete()
{
var volAddress_bll = new sp_Vol_Address_BLL();
var groupAddr_bll = new sp_GroupAddr_BLL();
//Grab the first GroupAddr we find
var allGroupAddrs = groupAddr_bll.ListAddresses(null, null);
Assert.IsTrue(allGroupAddrs.Count > 0, "The ListAddresses() is broken, or no data in DB");
var currGroupAddr = allGroupAddrs[0];
//TODO: change activeflg to bool not bool?
var notActive = currGroupAddr.ActiveFlg != true;
var i = 1;
while (notActive)
{
currGroupAddr = allGroupAddrs[i];
notActive = currGroupAddr.ActiveFlg != true;
}
var volAddress_dm = new sp_Vol_Address_DM();
volAddress_dm = volAddress_bll.ListAddress(volAddress_dm);
groupAddr_bll.DeleteAddressContext(volAddress_dm, currGroupAddr);
var selectedGroup = groupAddr_bll.ListAddress(currGroupAddr);
var selectedVolAddress = volAddress_bll.ListAddress(volAddress_dm);
//TODO: change activeflg to bool not bool?
Assert.IsNotNull(selectedGroup.ActiveFlg);
Assert.IsFalse(selectedGroup.ActiveFlg == true);
Assert.IsTrue(selectedGroup.ActiveFlg == false);
//TODO: change activeflg to bool not bool?
Assert.IsNotNull(selectedVolAddress.ActiveFlg);
Assert.IsFalse(selectedVolAddress.ActiveFlg == true);
Assert.IsTrue(selectedVolAddress.ActiveFlg == false);
}
public static void InsertVolAddressData(TestContext testContext)
{
System.Diagnostics.Debug.WriteLine(String.Format("{0}", DateTime.Now));
cExcel.RemoveAllData();
cExcel.InsertData(ExcelFilenames);
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
generalTestVol = new sp_Volunteer_DM();
generalTestVol.VolFirstName = "TestFirst";
generalTestVol.VolMiddleName = "TestMiddle";
generalTestVol.VolLastName = "TestLast";
generalTestVol.ActiveFlg = true;
generalTestVol.VolID = Guid.NewGuid();
volBLL.InsertVolunteerContext(ref generalTestVol);
sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL();
primaryTestVolAddress = new sp_Vol_Address_DM();
primaryTestVolAddress.AddrLine1 = "PrimaryLine1";
primaryTestVolAddress.AddrLine2 = "PrimaryLine2";
primaryTestVolAddress.AddrLine3 = "PrimaryLine3";
primaryTestVolAddress.City = "PrimaryCity";
primaryTestVolAddress.St = "PS";
primaryTestVolAddress.Zip = 12345;
primaryTestVolAddress.Zip4 = 6789;
primaryTestVolAddress.VolID = generalTestVol.VolID;
primaryTestVolAddress.ActiveFlg = true;
primaryTestVolAddress.PrimaryAddr = true;
primaryTestVolAddr = new sp_Vol_Addr_DM();
primaryTestVolAddr.VolID = generalTestVol.VolID;
primaryTestVolAddr.PrimaryAddr = true;
volAddress_bll.InsertAddressContext(ref primaryTestVolAddress, ref primaryTestVolAddr);
secondaryTestVolAddress = new sp_Vol_Address_DM();
secondaryTestVolAddress.AddrLine1 = "SecondaryLine1";
secondaryTestVolAddress.AddrLine2 = "SecondaryLine2";
secondaryTestVolAddress.AddrLine3 = "SecondaryLine3";
secondaryTestVolAddress.City = "SecondaryCity";
secondaryTestVolAddress.St = "SS";
secondaryTestVolAddress.Zip = 98765;
secondaryTestVolAddress.Zip4 = 4321;
secondaryTestVolAddress.VolID = generalTestVol.VolID;
secondaryTestVolAddress.ActiveFlg = true;
secondaryTestVolAddress.PrimaryAddr = false;
secondaryTestVolAddr = new sp_Vol_Addr_DM();
secondaryTestVolAddr.VolID = generalTestVol.VolID;
secondaryTestVolAddr.PrimaryAddr = false;
volAddress_bll.InsertAddressContext(ref secondaryTestVolAddress, ref secondaryTestVolAddr);
}
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 sp_Vol_Address_DM hCreateVolAddress(string AddrLine1,string AddrLine2,string AddrLine3,string City,string State,Nullable<int> Zip,Nullable<int> Zip4,bool PrimaryAddr,Guid VolID)
{
sp_Vol_Address_DM VolAddress = new sp_Vol_Address_DM();
sp_Vol_Addr_DM VolAddr = new sp_Vol_Addr_DM();
sp_Vol_Address_BLL VolAddressBll = new sp_Vol_Address_BLL();
VolAddress.AddrLine1 = AddrLine1;
VolAddress.AddrLine2 = AddrLine2;
VolAddress.AddrLine3 = AddrLine3;
VolAddress.City = City;
VolAddress.St = State;
VolAddress.Zip = Zip;
VolAddress.Zip4 = Zip4;
VolAddr.VolID = VolID;
VolAddr.PrimaryAddr = PrimaryAddr;
VolAddressBll.InsertAddressContext(ref VolAddress,ref VolAddr);
return VolAddress;
}
public void TestGroupAddrUpdate()
{
var volAddress_bll = new sp_Vol_Address_BLL();
var groupAddr_bll = new sp_GroupAddr_BLL();
//Grab the first GroupAddr we find
var allGroupAddrs = groupAddr_bll.ListAddresses(null, null);
Assert.IsTrue(allGroupAddrs.Count > 0, "The ListAddresses() is broken, or no data in DB");
var firstGroupAddr = allGroupAddrs[0];
//Get the volAddress the GroupAddr points to
var volAddress_dm = new sp_Vol_Address_DM();
volAddress_dm.AddrID = firstGroupAddr.AddrID;
volAddress_dm = volAddress_bll.ListAddress(volAddress_dm);
//Change some data
firstGroupAddr.PrimaryAddrID = !firstGroupAddr.PrimaryAddrID;
firstGroupAddr.ActiveFlg = !firstGroupAddr.ActiveFlg;
groupAddr_bll.UpdateAddressContext(volAddress_dm, firstGroupAddr);
//Pull record after the changes and test if it worked
var selectedGroupAddr = groupAddr_bll.ListAddress(firstGroupAddr);
Assert.IsTrue(Equals(firstGroupAddr, selectedGroupAddr));
}
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));
}
public static void RemoveVolAddressData()
{
sp_Vol_Address_BLL volAddressBLL = new sp_Vol_Address_BLL();
volAddressBLL.DeleteAddressContext(secondaryTestVolAddress, secondaryTestVolAddr);
volAddressBLL.DeleteAddressContext(primaryTestVolAddress, primaryTestVolAddr);
if (createTestVolAddress != null)
volAddressBLL.DeleteAddressContext(createTestVolAddress, createTestVolAddr);
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
volBLL.DeleteVolunteerContext(generalTestVol);
if (createTestVol != null)
volBLL.DeleteVolunteerContext(createTestVol);
cExcel.RemoveData(ExcelFilenames);
}
public void TestVolAddressUpdate()
{
sp_Vol_Address_BLL volAddressBLL = new sp_Vol_Address_BLL();
sp_Vol_Address_DM updateAddress = volAddressBLL.ListPrimaryAddress(primaryTestVolAddress);
String newAddr1 = "UpdateLine1";
String newAddr2 = "UpdateLine2";
String newAddr3 = "UpdateLine3";
String newCity = "UpdateCity";
String newSt = "US";
int newZip = 18642;
int newZip4 = 9753;
updateAddress.AddrLine1 = newAddr1;
updateAddress.AddrLine2 = newAddr2;
updateAddress.AddrLine3 = newAddr3;
updateAddress.City = newCity;
updateAddress.St = newSt;
updateAddress.Zip = newZip;
updateAddress.Zip4 = newZip4;
primaryTestVolAddress = updateAddress;
volAddressBLL.UpdateAddressContext(updateAddress,primaryTestVolAddr);
sp_Vol_Address_DM selectedAddress = volAddressBLL.ListPrimaryAddress(updateAddress);
sp_Vol_Address_DM DMToSelectAll = new sp_Vol_Address_DM();
DMToSelectAll.VolID = selectedAddress.VolID;
List<sp_Vol_Address_DM> selectedAddressList = volAddressBLL.ListAddresses(DMToSelectAll);
Assert.IsTrue(AddressListContains(selectedAddressList, updateAddress));
Assert.IsTrue(AddressListContains(selectedAddressList, secondaryTestVolAddress));
Assert.IsTrue(AddressEquals(selectedAddress, updateAddress));
Assert.AreEqual(newAddr1, selectedAddress.AddrLine1);
Assert.AreEqual(newAddr2, selectedAddress.AddrLine2);
Assert.AreEqual(newAddr3, selectedAddress.AddrLine3);
Assert.AreEqual(newCity, selectedAddress.City);
Assert.AreEqual(newSt, selectedAddress.St);
Assert.AreEqual(newZip, selectedAddress.Zip);
Assert.AreEqual(newZip4, selectedAddress.Zip4);
}
public void TestVolAddressReadAll()
{
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "VolAddress.xlsx"));
List<sp_Vol_Address_DM> excelDMs = getVolAddressDMs(dt);
sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL();
foreach (sp_Vol_Address_DM testVolAddress in excelDMs)
{
List<sp_Vol_Address_DM> selectedVolAddresses = volAddress_bll.ListAddresses(testVolAddress);
Assert.IsTrue(AddressListContains(selectedVolAddresses, testVolAddress));
}
}
public void TestVolAddressPrimaryRead()
{
sp_Vol_Address_BLL volAddressBLL = new sp_Vol_Address_BLL();
sp_Vol_Address_DM volAddressDM_selected = volAddressBLL.ListPrimaryAddress(primaryTestVolAddress);
Assert.IsTrue(AddressEquals(primaryTestVolAddress, volAddressDM_selected));
volAddressDM_selected = volAddressBLL.ListPrimaryAddress(secondaryTestVolAddress);
Assert.IsTrue(AddressEquals(primaryTestVolAddress, volAddressDM_selected));
}
public void TestVolAddressDelete()
{
sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL();
volAddress_bll.DeleteAddressContext(primaryTestVolAddress,primaryTestVolAddr);
sp_Vol_Address_DM selectedVolAddress = volAddress_bll.ListAddress(primaryTestVolAddress);
Assert.IsNull(selectedVolAddress);
//Impossible to get it back using stored procedures since the joining entry
//in VolAddr is missing. You'd have to do a direct sql query to test this.
//Assert.IsNotNull(selectedVolAddress.ActiveFlg);
//Assert.IsFalse(selectedVolAddress.ActiveFlg == true);
//Assert.IsTrue(selectedVolAddress.ActiveFlg == false);
}
public void TestVolAddressCreate()
{
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
sp_Volunteer_DM vol_dm = new sp_Volunteer_DM();
vol_dm.VolFirstName = "createFirst";
vol_dm.VolMiddleName = "createMiddle";
vol_dm.VolLastName = "createLast";
vol_dm.ActiveFlg = true;
System.Guid volID = Guid.NewGuid();
vol_dm.VolID = volID;
createTestVol = vol_dm;
vol_bll.InsertVolunteerContext(ref vol_dm);
string volAddr1 = "CreateLine1";
string volAddr2 = "CreateLine2";
string volAddr3 = "CreateLine3";
string volCity = "CreateCity";
string volSt = "CS";
int volZip = 13579;
int volZip4 = 2468;
bool PrimaryFlg = true;
bool ActiveFlg = true;
sp_Vol_Address_BLL volAddress_bll = new sp_Vol_Address_BLL();
sp_Vol_Address_DM volAddress_dm = new sp_Vol_Address_DM();
sp_Vol_Addr_DM volAddr_dm = new sp_Vol_Addr_DM();
volAddress_dm.ActiveFlg = ActiveFlg;
volAddress_dm.AddrLine1 = volAddr1;
volAddress_dm.AddrLine2 = volAddr2;
volAddress_dm.AddrLine3 = volAddr3;
volAddress_dm.City = volCity;
volAddress_dm.St = volSt;
volAddress_dm.Zip = volZip;
volAddress_dm.Zip4 = volZip4;
volAddress_dm.VolID = volID;
volAddress_dm.PrimaryAddr = PrimaryFlg;
volAddr_dm.PrimaryAddr = PrimaryFlg;
volAddr_dm.VolID = volID;
volAddress_bll.InsertAddressContext(ref volAddress_dm, ref volAddr_dm);
sp_Vol_Address_DM volAddressDMs_selected = volAddress_bll.ListAddress(volAddress_dm);
Assert.IsTrue(AddressEquals(volAddressDMs_selected, volAddress_dm));
}
