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