public void CreateAccount(string name, string surname, string phoneNumber, string email, string password)
{
using (var conn = new DatabaseManipulation.DatabaseManager())
{
LogProgress("Connecting to database");
conn.Open();
LogProgress("Clearing pre-registered users");
conn.ChangeInDB("truncate table email_token");
LogProgress($"Deleting from DB user with email:{email}");
conn.ChangeInDB($"delete from users where email = '{email}'");
}
LogProgress("Navigating to register page");
var registerPage = welcomePage.SignUp();
LogProgress($"Entering data to registration fields - Name:{name}, Surname:{surname}, Phone number:{phoneNumber}, Email:{email}");
var googlePage = registerPage.Register(name, surname, phoneNumber, email, password);
LogProgress($"Entering email\"{email}\" to login");
var passPage = googlePage.EnterEmail(email);
LogProgress($"Entering password\"{password}\" to login");
var emailsPage = passPage.EnterPassword(password);
LogProgress("Opening email with confirm link");
var mailPage = emailsPage.OpenMail();
LogProgress("Clicking on confirm link");
var loginPage = mailPage.ConfirmEmail();
LogProgress("Checking able of loggining");
var homePage = loginPage.LoginAsUser(email, password);
Assert.IsTrue(driver.GetUrl().Contains("http://localhost:8080/home"));
}
public void VerifyHistoryIsVisible()
{
using (var conn = new DatabaseManipulation.DatabaseManager())
{
var prevMonthDate = DateTime.Today.AddMonths(-1);
var currentMothDate = DateTime.Today;
var todayStr = currentMothDate.ToString().Replace('.', '-');
var prevMothStr = prevMonthDate.ToString().Replace('.', '-');
conn.Open();
conn.ChangeInDB("Truncate table schedule_history");
conn.ChangeInDB($"insert into schedule_history values (16,'Overdue visit','{todayStr}','OVERDUE','{todayStr}',16,109)");
conn.ChangeInDB($"insert into schedule_history values (17,'Overdue visit','{prevMothStr}','OVERDUE','{prevMothStr}',16,109)");
}
var inspectorPage = homePage.NavigateToInspectorsList();
LogProgress("Manager is choosing inspector: Oleg Adamov");
var schedulePage = inspectorPage.NavigateToInspectorsSchedule("Oleg Adamov");
LogProgress("Manager is clicking on tab history");
var tabHistory = schedulePage.ClickOnTabHistory();
LogProgress("Manager is clicking on current month button");
var tabCurrentMonth = tabHistory.ClickOnCurrentMonthButton();
var currentMonthContainsAddress = tabHistory.CurrentMonthContainsAddress("вулиця Пушкіна ", $"{DateTime.Today.ToString("dd.M.yyyy")}");
Assert.AreEqual(true, currentMonthContainsAddress, "Current month history is not visible");
var tabPreviousMonth = tabHistory.ClickOnPreviousMonthButton();
var previousMonthContainsAddress = tabHistory.PreviousMonthContainsAddress($"{DateTime.Today.AddMonths(-1).ToString("dd.M.yyyy")}");
Assert.AreEqual(true, previousMonthContainsAddress, $"Previous month history doesn't contain date: {DateTime.Today.AddMonths(-1).ToString("dd.M.yyyy")}");
}
public void AddInspector()
{
using (var conn = new DatabaseManipulation.DatabaseManager())
{
conn.Open();
conn.ChangeInDB("insert into users values(113, null, null, '*****@*****.**', null, 'Ivan', 'Admin123', '+380968780876', 'INSPECTOR', 'Ivanov', 'ACTIVE')");
}
LogProgress("Manager is going to list of inspectors");
var listOfInspectors = homePage.NavigateToInspectorsList();
LogProgress("Manager is adding Ivan Ivanov to the list of inspectors");
var addIvan = listOfInspectors.ClickToAddInspector();
addIvan.AddInspector("Ivan Ivanov");
var isInspectorDisplayed = listOfInspectors.GetInspector("Ivan Ivanov").IsDisplayed();
Assert.AreEqual(true, isInspectorDisplayed, "Ivan Ivanov isn't displayed");
// postCondition
LogProgress("Manager is removing Ivan Ivanov from the list of inspectors");
var removeIvan = listOfInspectors.RemoveInspector("Ivan Ivanov");
removeIvan.ConfirmRemoving();
using (var conn = new DatabaseManipulation.DatabaseManager())
{
conn.Open();
conn.ChangeInDB("delete from users where user_id = 113");
}
}
public void AbleSetNewValueMetrix()
{
LogProgress("Try navigate to Check Counters page");
var checkCounters = homePage.NavigateToCheckCounters();
LogProgress($"Try sellect address + {address}");
var utility = checkCounters.SelectAddress(address);
LogProgress("Try set new value metrix");
var row = utility.GetFirstRow();
using (var db = new DatabaseManipulation.DatabaseManager())
{
db.Open();
db.ChangeInDB("update counters set is_active = true, is_fixed = false where address_id = 9");
}
var setCurrentValue = row.SetNewValueUtility(address);
LogProgress("Try set value '44' metrix");
setCurrentValue.FillNewCurrentValue("44");
LogProgress("Try click on btn apply");
setCurrentValue.ClickApplyButton();
var isSuccsess = setCurrentValue.IsSuccsess();
Assert.AreEqual(true, isSuccsess, "Error message on page");
}
public void DisconnectUtilities()
{
using (var conn = new DatabaseManipulation.DatabaseManager())
{
conn.Open();
conn.ChangeInDB("update counters set is_active = true where debt_id = 23");
}
LogProgress("User is going to utilities");
var utilities = homePage.NavigateToConnectedUtilitiesPage();
LogProgress("User choosing address ");
utilities.SelectAddress("Чернівці City, вулиця Шевченка Str., 44/54");
LogProgress("User disconects Utility");
var newUtilities = utilities.Disconect();
LogProgress("User choosing address ");
newUtilities.SelectAddress("Чернівці City, вулиця Шевченка Str., 44/54");
var result = newUtilities.VerifyThatUtilitiExist();
Assert.IsNull(result, "Utility wasn't disconnected");
}
public void NotAvailableToAddInspector()
{
using (var conn = new DatabaseManipulation.DatabaseManager())
{
conn.Open();
conn.ChangeInDB("insert into users values(1209, null, null, '*****@*****.**', null, 'Ivan', 'Admin123', '+380968780876', 'INSPECTOR', 'Ivanov', 'ACTIVE')");
}
LogProgress("Manager is going to list of inspectors");
var listOfInspectors = homePage.NavigateToInspectorsList();
// preCondition
LogProgress("Manager is adding Ivan Ivanov to the list of inspectors");
var addIvan = listOfInspectors.ClickToAddInspector();
addIvan.AddInspector("Ivan Ivanov");
LogProgress("Manager is trying to add an inspector to the list of inspectors");
var close = listOfInspectors.ClickToAddInspector();
var actualCaption = close.GetCaption();
Assert.AreEqual("All inspectors are busy", actualCaption, "Busy isn't displayed");
close.CloseWindow();
// postCondition
LogProgress("Manager is removing Ivan Ivanov from the list of inspectors");
var removeIvan = listOfInspectors.RemoveInspector("Ivan Ivanov");
removeIvan.ConfirmRemoving();
using (var conn = new DatabaseManipulation.DatabaseManager())
{
conn.Open();
conn.ChangeInDB("delete from utilities_users where user_id = 1209;");
conn.ChangeInDB("delete from users where user_id = 1209");
}
}