public void Dashboard_Home_Giving_BigNumber_ByDefault()
{
TestBaseWebDriver test = base.TestContainer[Gallio.Framework.TestContext.CurrentContext.Test.Name];
GeneralMethods utility = test.GeneralMethods;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time"));
try
{
int churchId = test.SQL.FetchChurchID(test.Dashboard.ChurchCode);
int userId = test.SQL.User_FetchID(churchId, test.Dashboard.DashboardEmail, test.Dashboard.DashboardUsername);
test.SQL.Dashboard_ClearData(churchId, test.Dashboard.DashboardUsername);
test.Dashboard.LoginWebDriver();
test.GeneralMethods.WaitForPageIsLoaded();
DashboardHomePage home = new DashboardHomePage(test.Driver, test.GeneralMethods);
DashboardSettingsPage settings = new DashboardSettingsPage(test.Driver, test.GeneralMethods, test.SQL);
home.openSettingsPage();
settings.turnOnWidget(1);
settings.closeSettingsPage();
string bigNumber = home.getWidgetBigNumber(1);
double subTotalOnPage = double.Parse(bigNumber.Replace("$", "").Replace(",", ""));
DateTime[] dateRange = test.Dashboard.getDateRange(now, "week", 1);
double subTotalInDb = test.SQL.Dashboard_Giving_GetPeriodSum(churchId, userId, dateRange[0], dateRange[1]);
//verify the default big number on page is correct
TestLog.WriteLine(string.Format("{0}|{1}", subTotalOnPage, subTotalInDb));
Assert.AreEqual(subTotalOnPage, subTotalInDb);
}
finally
{
//clear test data
}
}
public void Dashboard_AttributeGroup_Home_BigNumber_NewAttributeGroup()
{
TestBaseWebDriver test = base.TestContainer[Gallio.Framework.TestContext.CurrentContext.Test.Name];
GeneralMethods utility = test.GeneralMethods;
int churchId = test.SQL.FetchChurchID(test.Dashboard.ChurchCode);
string activeAttributeGroup = utility.GetUniqueName("aag");
try
{
test.SQL.Admin_IndividualAttributeGroups_Create(churchId, activeAttributeGroup, true);
test.SQL.Admin_IndividualAttributes_Create(churchId, activeAttributeGroup, "salvation", true, true, false, false, true);
test.Dashboard.LoginWebDriver();
DashboardHomePage home = new DashboardHomePage(test.Driver, test.GeneralMethods);
DashboardSettingsPage settings = new DashboardSettingsPage(test.Driver, test.GeneralMethods, test.SQL);
home.openSettingsPage();
int widgetsTotal = settings.getWidgetsTotalOnPage();
int turnedOnWidgetTotal = settings.getTurnedOnWidgetsTotalOnPage(widgetsTotal);
for (int i = 1; i <= widgetsTotal; i++)
{
if (settings.getWidgetName(i).Contains(activeAttributeGroup))
{
Assert.IsFalse(settings.isWidgetItemChecked(i, 1), "Active attribute 'salvation' should not be checked");
if (turnedOnWidgetTotal == 6)
{
settings.turnOffMultiWidgets(widgetsTotal, 1);
}
settings.turnOnWidget(i);
settings.checkWidgetItem(i, 1);
break;
}
}
settings.closeSettingsPage();
home.selectView("year");
for (int i = 1; i <= turnedOnWidgetTotal; i++)
{
if (home.getWidgetName(i).Contains(activeAttributeGroup))
{
string bigNumber = home.getWidgetBigNumber(i);
int subTotalOnPage = int.Parse(bigNumber.Replace(",", ""));
Assert.AreEqual(subTotalOnPage, 0, "The big number of attribute group should be 0");
break;
}
}
}
finally
{
//clear test data
test.SQL.Admin_IndividualAttributes_Delete(churchId, activeAttributeGroup, "salvation");
test.SQL.Admin_IndividualAttributeGroups_Delete(churchId, activeAttributeGroup);
}
}
public void Dashboard_Giving_NewGiving_Of_ContributionFund()
{
TestBaseWebDriver test = base.TestContainer[Gallio.Framework.TestContext.CurrentContext.Test.Name];
GeneralMethods utility = test.GeneralMethods;
//Test data parameters
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time"));
int churchId = test.SQL.FetchChurchID(test.Dashboard.ChurchCode);
int userId = test.SQL.User_FetchID(churchId, test.Dashboard.DashboardEmail, test.Dashboard.DashboardUsername);
string fund_name_1 = utility.GetUniqueName("fund");
string card_number = "4111111111111111";
string card_type = "Visa";
try
{
test.SQL.Giving_Funds_Create(churchId, fund_name_1, true, null, 1, true, "Auto Testing");
test.Dashboard.LoginWebDriver();
test.GeneralMethods.WaitForPageIsLoaded();
DashboardHomePage home = new DashboardHomePage(test.Driver, test.GeneralMethods);
DashboardSettingsPage settings = new DashboardSettingsPage(test.Driver, test.GeneralMethods, test.SQL);
home.openSettingsPage();
settings.turnOnWidget(1);
settings.closeSettingsPage();
home.selectView("year");
//string bigNumber = home.getWidgetBigNumber(1);
//double subTotalOnPage = double.Parse(bigNumber.Replace("$", "").Replace(",", ""));
//Do an online giving
test.Infellowship.LoginWebDriver("*****@*****.**", "FT4life!");
test.Infellowship.Giving_GiveNow_CreditCard_WithoutValidation_WebDriver(fund_name_1, "10000", card_type, card_number, 12, (DateTime.Now.Year + 5).ToString());
test.Infellowship.LogoutWebDriver();
test.Dashboard.OpenLoginWebDriver();
home.openSettingsPage();
settings.checkSubItemByName(1, fund_name_1);
settings.closeSettingsPage();
home.selectView("year");
string bigNumberNew = home.getWidgetBigNumber(1);
//double subTotalOnPageNew = double.Parse(bigNumberNew.Replace("$", "").Replace(",", ""));
DateTime[] dateRange = test.Dashboard.getDateRange(now, "year");
double subTotalInDb = test.SQL.Dashboard_Giving_GetPeriodSum(churchId, userId, dateRange[0], dateRange[1]);
//verify the big number on page is correct
//TestLog.WriteLine(string.Format("{0}|{1}|{2}", subTotalOnPage, subTotalInDb, subTotalOnPageNew));
//Assert.IsTrue(subTotalInDb>=subTotalOnPage + 10000);
//Assert.AreEqual(subTotalInDb, subTotalOnPageNew);
Assert.AreEqual(bigNumberNew, test.Dashboard.getBigNumberStringGreaterThanMillion(subTotalInDb));
}
finally
{
//clear test data
test.SQL.Giving_Funds_Delete(churchId, fund_name_1);
}
}
public void Dashboard_Home_Giving_BigNumber_TurnOffAllFunds()
{
TestBaseWebDriver test = base.TestContainer[Gallio.Framework.TestContext.CurrentContext.Test.Name];
GeneralMethods utility = test.GeneralMethods;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time"));
string[] viewTypes = new string[] { "week", "month", "quarter", "year" };
try
{
int churchId = test.SQL.FetchChurchID(test.Dashboard.ChurchCode);
int userId = test.SQL.User_FetchID(churchId, test.Dashboard.DashboardEmail, test.Dashboard.DashboardUsername);
test.Dashboard.LoginWebDriver();
test.GeneralMethods.WaitForPageIsLoaded();
DashboardHomePage home = new DashboardHomePage(test.Driver, test.GeneralMethods);
DashboardSettingsPage settings = new DashboardSettingsPage(test.Driver, test.GeneralMethods, test.SQL);
home.openSettingsPage();
int totalItems = settings.getWidgetSubItemsOnPage(1).Count;
for (int i = 1; i <= totalItems; i++)
{
settings.uncheckWidgetItem(1, i);
}
settings.closeSettingsPage();
foreach (string viewType in viewTypes)
{
home.selectView(viewType);
string bigNumber = home.getWidgetBigNumber(1);
double subTotalOnPage = double.Parse(bigNumber.Replace("$", "").Replace(",", ""));
DateTime[] dateRange = test.Dashboard.getDateRange(now, viewType, 1);
double subTotalInDb = test.SQL.Dashboard_Giving_GetPeriodSum(churchId, userId, dateRange[0], dateRange[1]);
//verify the big number on page is correct
TestLog.WriteLine(string.Format("{0}|{1}", subTotalOnPage, subTotalInDb));
Assert.AreEqual(subTotalOnPage, subTotalInDb);
Assert.AreEqual(subTotalOnPage, 0);
}
home.openSettingsPage();
for (int i = 1; i <= totalItems; i++)
{
settings.checkWidgetItem(1, i);
}
}
finally
{
//clear test data
test.SQL.Dashboard_ClearData(test.SQL.FetchChurchID(test.Dashboard.ChurchCode), test.Dashboard.DashboardUsername);
}
}
public void Dashboard_AttributeGroup_Home_BigNumber_NewIndividual()
{
TestBaseWebDriver test = base.TestContainer[Gallio.Framework.TestContext.CurrentContext.Test.Name];
GeneralMethods utility = test.GeneralMethods;
DateTime now = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, TimeZoneInfo.FindSystemTimeZoneById("Central Standard Time"));
int churchId = test.SQL.FetchChurchID(test.Dashboard.ChurchCode);
int userId = test.SQL.User_FetchID(churchId, test.Dashboard.DashboardEmail, test.Dashboard.DashboardUsername);
string activeAttributeGroup = utility.GetUniqueName("aag");
string activeAttributeWithStartDate = utility.GetUniqueName("aa1");
string activeAttributeWithoutStartDate = utility.GetUniqueName("aa2");
string individual_1 = utility.GetUniqueName("ind1");
string individual_2 = utility.GetUniqueName("ind2");
string individual_3 = utility.GetUniqueName("ind3");
string individual_4 = utility.GetUniqueName("ind4");
test.SQL.Admin_IndividualAttributeGroups_Create(churchId, activeAttributeGroup, true);
test.SQL.Admin_IndividualAttributes_Create(churchId, activeAttributeGroup, activeAttributeWithStartDate, false, true, false, false, true);
test.SQL.Admin_IndividualAttributes_Create(churchId, activeAttributeGroup, activeAttributeWithoutStartDate, false, false, false, false, true);
test.SQL.People_Individual_Create(churchId, "AutoTest", individual_1);
test.SQL.People_Individual_Create(churchId, "AutoTest", individual_2);
test.SQL.People_Individual_Create(churchId, "AutoTest", individual_3);
test.SQL.People_Individual_Create(churchId, "AutoTest", individual_4);
int individual_1_id = test.SQL.People_Individuals_FetchID(churchId, "AutoTest " + individual_1);
int individual_2_id = test.SQL.People_Individuals_FetchID(churchId, "AutoTest " + individual_2);
int individual_3_id = test.SQL.People_Individuals_FetchID(churchId, "AutoTest " + individual_3);
int individual_4_id = test.SQL.People_Individuals_FetchID(churchId, "AutoTest " + individual_4);
int attributeGroupId = test.SQL.Admin_Fetch_AttributeGroupID(churchId, activeAttributeGroup);
int attributeId_withStartDate = test.SQL.Admin_Fetch_AttributeID(churchId, attributeGroupId, activeAttributeWithStartDate);
int attributeId_withoutStartDate = test.SQL.Admin_Fetch_AttributeID(churchId, attributeGroupId, activeAttributeWithoutStartDate);
test.SQL.Dashboard_Insert_IndividualAttribute(churchId, individual_1_id, attributeId_withStartDate, now, now.AddYears(100));
test.SQL.Dashboard_Insert_IndividualAttribute(churchId, individual_2_id, attributeId_withStartDate, now.AddDays(-370), now.AddYears(-1));
test.SQL.Dashboard_Insert_IndividualAttribute(churchId, individual_3_id, attributeId_withoutStartDate, now.AddYears(100), now.AddYears(100));
test.SQL.Dashboard_Insert_IndividualAttribute(churchId, individual_4_id, attributeId_withStartDate, now.AddDays(-2), now);
try
{
test.Dashboard.LoginWebDriver();
DashboardHomePage home = new DashboardHomePage(test.Driver, test.GeneralMethods);
DashboardSettingsPage settings = new DashboardSettingsPage(test.Driver, test.GeneralMethods, test.SQL);
home.openSettingsPage();
int widgetsTotal = settings.getWidgetsTotalOnPage();
int turnedOnWidgetTotal = settings.getTurnedOnWidgetsTotalOnPage(widgetsTotal);
for (int i = 1; i <= widgetsTotal; i++)
{
if (settings.getWidgetName(i).Contains(activeAttributeGroup))
{
if (turnedOnWidgetTotal == 6)
{
settings.turnOffMultiWidgets(widgetsTotal, 1);
}
settings.turnOnWidget(i);
settings.checkWidgetItem(i, 1);
break;
}
}
settings.closeSettingsPage();
home.selectView("year");
DateTime[] dateRange = test.Dashboard.getDateRange(now, "year");
int subTotalInDb = test.SQL.Dashboard_AttributeGroup_GetPeriodSum(churchId, userId, attributeGroupId, dateRange[0], dateRange[1]);
for (int i = 1; i <= turnedOnWidgetTotal; i++)
{
if (home.getWidgetName(i).Contains(activeAttributeGroup))
{
string bigNumber = home.getWidgetBigNumber(i);
int subTotalOnPage = int.Parse(bigNumber.Replace(",", ""));
//Verify only individual_1 will be counted
TestLog.WriteLine(string.Format("Page: {0}|Db: {1}", subTotalOnPage, subTotalInDb));
Assert.AreEqual(subTotalOnPage, subTotalInDb, string.Format("The big number of attribute group should equal to {0}", subTotalInDb));
break;
}
}
}
finally
{
//clear test data
test.SQL.Dashboard_Delete_IndividualAttribute(churchId, individual_1_id, attributeId_withStartDate);
test.SQL.Dashboard_Delete_IndividualAttribute(churchId, individual_2_id, attributeId_withStartDate);
test.SQL.Dashboard_Delete_IndividualAttribute(churchId, individual_3_id, attributeId_withoutStartDate);
test.SQL.Dashboard_Delete_IndividualAttribute(churchId, individual_4_id, attributeId_withStartDate);
test.SQL.Admin_IndividualAttributes_Delete(churchId, activeAttributeGroup, activeAttributeWithoutStartDate);
test.SQL.Admin_IndividualAttributes_Delete(churchId, activeAttributeGroup, activeAttributeWithStartDate);
test.SQL.Admin_IndividualAttributeGroups_Delete(churchId, activeAttributeGroup);
test.SQL.People_Individual_Delete(churchId, "AutoTest", individual_1);
test.SQL.People_Individual_Delete(churchId, "AutoTest", individual_2);
test.SQL.People_Individual_Delete(churchId, "AutoTest", individual_3);
test.SQL.People_Individual_Delete(churchId, "AutoTest", individual_4);
}
}