|
public ListAddress ( |
||
| cVolAddr | ||
| return | ||
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 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 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 TestVolAddressRead()
{
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)
{
sp_Vol_Address_DM selectedVolAddress = volAddress_bll.ListAddress(testVolAddress);
Assert.IsTrue(AddressEquals(selectedVolAddress, testVolAddress));
}
}
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));
}
