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