public List<sp_Volunteer_DM> hSelectVolunteer()
{
List<sp_Volunteer_DM> VOLList = null;
sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL();
VOLList = VOlBll.ListVolunteers();
return VOLList;
}
public sp_Volunteer_DM hSelectVolunteer(Guid VolID)
{
sp_Volunteer_DM VOL = new sp_Volunteer_DM();
sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL();
VOL = VOlBll.ListVolunteers(VolID);
return VOL;
}
public static void InsertVolEmailData(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;
Guid volID = Guid.NewGuid();
generalTestVol.VolID = volID;
volBLL.InsertVolunteerContext(ref generalTestVol);
sp_VolEmail_BLL volEmail_bll = new sp_VolEmail_BLL();
primaryTestVolEmail = new sp_Email_DM();
primaryTestVolEmail.EmailAddr = "*****@*****.**";
primaryTestVolEmail.VolID = volID;
primaryTestVolEmail.ActiveFlg = true;
primaryTestVolEmail.PrimaryFlg = true;
volEmail_bll.InsertEmailContext(ref primaryTestVolEmail);
secondaryTestVolEmail = new sp_Email_DM();
secondaryTestVolEmail.EmailAddr = "*****@*****.**";
secondaryTestVolEmail.VolID = volID;
secondaryTestVolEmail.ActiveFlg = true;
secondaryTestVolEmail.PrimaryFlg = false;
volEmail_bll.InsertEmailContext(ref secondaryTestVolEmail);
}
public static void InsertVolPhoneData(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;
System.Guid volID = Guid.NewGuid();
generalTestVol.VolID = volID;
volBLL.InsertVolunteerContext(ref generalTestVol);
sp_VolPhone_BLL volPhone_bll = new sp_VolPhone_BLL();
primaryTestVolPhone = new sp_Phone_DM();
primaryTestVolPhone.PhoneNbr = "1357924680";
primaryTestVolPhone.VolID = volID;
primaryTestVolPhone.ActiveFlg = true;
primaryTestVolPhone.PrimaryFlg = true;
volPhone_bll.InsertPhoneContext(primaryTestVolPhone);
secondaryTestVolPhone = new sp_Phone_DM();
secondaryTestVolPhone.PhoneNbr = "2468013579";
secondaryTestVolPhone.VolID = volID;
secondaryTestVolPhone.ActiveFlg = true;
secondaryTestVolPhone.PrimaryFlg = false;
volPhone_bll.InsertPhoneContext(secondaryTestVolPhone);
}
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
//Log the user in
FormsAuthentication.SetAuthCookie(RegisterUser.UserName, createPersistentCookie: false);
// Create Volunteer Record
RadTextBox userNameTextBox = (RadTextBox)CreateUserWizardStep1.ContentTemplateContainer.FindControl("UserName");
MembershipUser user = Membership.GetUser(userNameTextBox.Text);
sp_Volunteer_BLL BLL = new sp_Volunteer_BLL();
sp_VolEmail_BLL VolEmailBLL = new sp_VolEmail_BLL();
sp_Volunteer_DM vol = new sp_Volunteer_DM();
sp_Email_DM volEmail = new sp_Email_DM();
vol.VolID = (Guid)user.ProviderUserKey;
vol.VolFirstName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTFirstName") as RadTextBox).Text.Trim();
vol.VolMiddleName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTMiddleName") as RadTextBox).Text.Trim();
vol.VolLastName = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("rTXTLastName") as RadTextBox).Text.Trim();
vol.ActiveFlg = true;
vol = BLL.InsertVolunteerContext(ref vol);
volEmail.VolID = (Guid)user.ProviderUserKey;
volEmail.EmailAddr = (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Email") as RadTextBox).Text.Trim();
volEmail.ActiveFlg = true;
volEmail.PrimaryFlg = true;
VolEmailBLL.InsertEmailContext(ref volEmail);
cMail.SendMessage("*****@*****.**", (CreateUserWizardStep1.ContentTemplateContainer.FindControl("Email") as RadTextBox).Text.Trim(), "VolTeer Registration", "Please click link to confirm");
string continueUrl = ConfigurationManager.AppSettings["HomePage"].ToString();
Response.Redirect(continueUrl);
}
public void hUpdateVolunteer(sp_Volunteer_DM VOL, string strFirstName, string strMiddleName, string strLastName)
{
sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL();
VOL.VolFirstName = strFirstName;
VOL.VolMiddleName = strMiddleName;
VOL.VolLastName = strLastName;
VOlBll.UpdateVolunteerContext(VOL);
}
public static void RemoveVolunteerData()
{
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
if (createTestVol != null)
volBLL.DeleteVolunteerContext(createTestVol);
volBLL.DeleteVolunteerContext(secondaryTestVol);
foreach (sp_Volunteer_DM volunteer in volunteersToRemove)
volBLL.DeleteVolunteerContext(volunteer);
cExcel.RemoveData(ExcelFilenames);
}
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_Volunteer_DM hCreateVolunteer(string strFirstName, string strMiddleName, string strLastName)
{
sp_Volunteer_DM VOL = new sp_Volunteer_DM();
sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL();
VOL.VolID = Guid.NewGuid();
VOL.ActiveFlg = true;
VOL.VolFirstName = strFirstName;
VOL.VolMiddleName = strMiddleName;
VOL.VolLastName = strLastName;
VOL = VOlBll.InsertVolunteerContext(ref VOL);
return VOL;
}
public static void RemoveVolPhoneData()
{
sp_VolPhone_BLL volPhoneBLL = new sp_VolPhone_BLL();
volPhoneBLL.DeletePhonesContext(secondaryTestVolPhone);
volPhoneBLL.DeletePhonesContext(primaryTestVolPhone);
if (createTestVolPhone != null)
volPhoneBLL.DeletePhonesContext(createTestVolPhone);
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
volBLL.DeleteVolunteerContext(generalTestVol);
if (createTestVol != null)
volBLL.DeleteVolunteerContext(createTestVol);
cExcel.RemoveData(ExcelFilenames);
}
public static void InsertVolunteerData(TestContext testContext)
{
volunteersToRemove = new List<sp_Volunteer_DM>();
System.Diagnostics.Debug.WriteLine(String.Format("{0}", DateTime.Now));
cExcel.RemoveAllData();
cExcel.InsertData(ExcelFilenames);
secondaryTestVol = new sp_Volunteer_DM();
secondaryTestVol.ActiveFlg = true;
secondaryTestVol.VolFirstName = "first2";
secondaryTestVol.VolMiddleName = "middle2";
secondaryTestVol.VolLastName = "last2";
secondaryTestVol.VolID = Guid.NewGuid();
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
vol_bll.InsertVolunteerContext(ref secondaryTestVol);
}
public static void RemoveVolEmailData()
{
sp_VolEmail_BLL volEmailBLL = new sp_VolEmail_BLL();
volEmailBLL.DeleteEmailsContext(secondaryTestVolEmail);
volEmailBLL.DeleteEmailsContext(primaryTestVolEmail);
//Make sure we don't pass it null because we didn't run one of the tests
if (createTestVolEmail != null)
volEmailBLL.DeleteEmailsContext(createTestVolEmail);
sp_Volunteer_BLL volBLL = new sp_Volunteer_BLL();
volBLL.DeleteVolunteerContext(generalTestVol);
//Make sure we don't pass it null because we didn't run one of the tests
if (createTestVolEmail != null)
volBLL.DeleteVolunteerContext(createTestVol);
cExcel.RemoveData(ExcelFilenames);
}
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 TestVolunteerCreate()
{
createTestVol = new sp_Volunteer_DM();
string volFirst = "TestFirst";
string volMiddle = "TestMiddle";
string volLast = "TestLast";
bool ActiveFlg = true;
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
sp_Volunteer_DM vol_dm = new sp_Volunteer_DM();
vol_dm.VolFirstName = volFirst;
vol_dm.VolMiddleName = volMiddle;
vol_dm.VolLastName = volLast;
vol_dm.ActiveFlg = ActiveFlg;
System.Guid volID = Guid.NewGuid();
vol_dm.VolID = volID;
createTestVol = vol_dm;
vol_bll.InsertVolunteerContext(ref vol_dm);
sp_Volunteer_DM vol_dm_selected = vol_bll.ListVolunteers(volID);
Assert.IsTrue(VolEquals(vol_dm, vol_dm_selected));
}
public void TestVolunteerUpdate()
{
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
List<sp_Volunteer_DM> allVols = vol_bll.ListVolunteers();
Assert.IsTrue(allVols.Count > 0, "The ListVolunteers() is broken, or no data in DB");
sp_Volunteer_DM firstVol = allVols[0];
firstVol.VolID = Guid.NewGuid();
vol_bll.InsertVolunteerContext(ref firstVol);
String newFirst = "NewFirst";
String newMiddle = "NewMiddle";
String newLast = "NewLast";
firstVol.VolFirstName = newFirst;
firstVol.VolMiddleName = newMiddle;
firstVol.VolLastName = newLast;
vol_bll.UpdateVolunteerContext(firstVol);
volunteersToRemove.Add(firstVol);
sp_Volunteer_DM selectedVol = vol_bll.ListVolunteers(firstVol.VolID);
Assert.IsTrue(VolEquals(firstVol, selectedVol));
Assert.AreEqual(newFirst, selectedVol.VolFirstName);
Assert.AreEqual(newMiddle, selectedVol.VolMiddleName);
Assert.AreEqual(newLast, selectedVol.VolLastName);
}
public void TestVolunteerRead()
{
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "Volunteer.xlsx"));
var excelDMs = getVolDMs(dt);
var numRows = cExcel.getNumRecordsFromDB("[Vol].[tblVolunteer]");
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
List<sp_Volunteer_DM> allVols = vol_bll.ListVolunteers();
Assert.AreEqual(numRows, allVols.Count);
foreach (sp_Volunteer_DM testVol in excelDMs)
{
sp_Volunteer_DM selectedVol = vol_bll.ListVolunteers(testVol.VolID);
Assert.IsTrue(VolEquals(testVol, selectedVol));
}
}
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 TestVolEmailCreate()
{
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 = vol_bll.InsertVolunteerContext(ref vol_dm).VolID;
vol_dm.VolID = volID;
string volEmailAddr = "*****@*****.**";
bool PrimaryFlg = true;
bool ActiveFlg = true;
sp_VolEmail_BLL volEmail_bll = new sp_VolEmail_BLL();
sp_Email_DM volEmail_dm = new sp_Email_DM();
volEmail_dm.EmailAddr = volEmailAddr;
volEmail_dm.VolID = volID;
volEmail_dm.ActiveFlg = ActiveFlg;
volEmail_dm.PrimaryFlg = PrimaryFlg;
volEmail_bll.InsertEmailContext(ref volEmail_dm);
int volEmailID = volEmail_dm.EmailID;
List<sp_Email_DM> volEmailDMs_selected = volEmail_bll.ListEmails(volEmail_dm);
Assert.IsTrue(EmailListContains(volEmailDMs_selected,volEmail_dm));
}
public void hDeleteVolunteer(sp_Volunteer_DM VOL)
{
sp_Volunteer_BLL VOlBll = new sp_Volunteer_BLL();
VOlBll.DeleteVolunteerContext(VOL);
}
public void TestVolPhoneCreate()
{
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 = vol_bll.InsertVolunteerContext(ref vol_dm).VolID;
vol_dm.VolID = volID;
string volPhoneNbr = "0123456789";
bool PrimaryFlg = true;
bool ActiveFlg = true;
sp_VolPhone_BLL volPhone_bll = new sp_VolPhone_BLL();
sp_Phone_DM volPhone_dm = new sp_Phone_DM();
volPhone_dm.PhoneNbr = volPhoneNbr;
volPhone_dm.VolID = volID;
volPhone_dm.ActiveFlg = ActiveFlg;
volPhone_dm.PrimaryFlg = PrimaryFlg;
volPhone_bll.InsertPhoneContext(volPhone_dm);
int volPhoneID = volPhone_dm.PhoneID;
List<sp_Phone_DM> volPhoneDMs_selected = volPhone_bll.ListPhones(volPhone_dm);
Assert.IsTrue(PhoneListContains(volPhoneDMs_selected, volPhone_dm));
}
public void TestVolunteerDelete()
{
sp_Volunteer_BLL vol_bll = new sp_Volunteer_BLL();
vol_bll.DeleteVolunteerContext(secondaryTestVol);
sp_Volunteer_DM selectedVol = vol_bll.ListVolunteers(secondaryTestVol.VolID);
secondaryTestVol.ActiveFlg = false;
Assert.IsNotNull(selectedVol.ActiveFlg);
Assert.IsFalse(selectedVol.ActiveFlg == true);
Assert.IsTrue(selectedVol.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));
}
