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