public ArrayList getCredentials(int UserId, int RoleId)
{
Creds LoginCreds = new Creds();
ArrayList CredList = new ArrayList();
SqlCommand cmd = new SqlCommand("RetrieveCredentials", con);
cmd.Parameters.AddWithValue("@LogUserId", UserId);
cmd.Parameters.AddWithValue("@LogRoleId", RoleId);
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
using (var reader = cmd.ExecuteReader(CommandBehavior.CloseConnection)) //close con on reader.Close
{
while (reader.Read())
{
LoginCreds = new Creds
{
Username = reader["Username"].ToString(),
Password = reader["Password"].ToString(),
UserId = Convert.ToInt32(reader["UserId"].ToString()),
RoleId = Convert.ToInt32(reader["RoleId"].ToString()),
RoleType = reader["RoleName"].ToString(),
UserType = reader["UserTypeName"].ToString()
};
CredList.Add(LoginCreds);
}
} //The stored procedure should take 2 params and return creds
con.Close();
return(CredList);
}
public void NewTestCases()
{
try
{
SimulationId++;
sim.Register_External_User(driver, SimulationId);
SimulationId++;
credList = Rtrv.getCredentials(2, 5);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.PasswordRecovery(crd.Username, driver, SimulationId);
}
catch (Exception)
{
}
}
public void initiate()
{
try
{
SimulationId = 1;
// serparate Clause for CSG
try
{
credList = Rtrv.getCredentials(2, 1);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.Start(null);
sim.BeforeTest(testname, testDescription);
sim.Login(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Capture single Request";
testDescription = "checking if the request goes through";
SimulationId++;//2
Retrieve_Save_Log_Info SRI = new Retrieve_Save_Log_Info();
ArrayList SearchData = SRI.GetSearchData();
Search_Data srch = new Search_Data();
for (int i = 0; i < SearchData.Count; i++)
{
srch = (Search_Data)SearchData[i];
sim.BeforeTest(testname + " - " + srch.Province, testDescription);
sim.MakeSingleRequest(driver, SimulationId, srch.ProvinceValue, srch.ParcelType, srch.AdministrativeDistrict, srch.FarmNumber);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
}
if (finalStatus == TestStatus.Passed)
{
testname = "Cancel a Request";
testDescription = "Checking if the request can be successfully cancelled";
SimulationId++;//3
sim.BeforeTest(testname, testDescription);
sim.CancelRequest(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
}
//Bulk Req and sub processes
if (finalStatus == TestStatus.Passed)
{
testname = "Capture Bulk Request";
testDescription = "checking if the request goes through";
SimulationId++;//4
sim.BeforeTest(testname, testDescription);
sim.MakeBulkRequest(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Allocate Task";
testDescription = "Checking if the Information Manager can Allocate the Task to Officer";
SimulationId++;//5
credList = Rtrv.getCredentials(1, 2);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.Allocate_Task(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Reassign Task";
testDescription = "Checking if the Information Manager can Reallocate the Task to a different Officer";
SimulationId++;//6
sim.BeforeTest(testname, testDescription);
sim.ReAssign_Task(driver);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Effect Task";
testDescription = "Checking if the Information Officer can Effect the task";
SimulationId++;//6
credList = Rtrv.getCredentials(1, 3);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.EffectTask(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
credList = Rtrv.getCredentials(2, 1);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
testname = "Upload Proof Of Payment";
testDescription = "checking if the POP can be successfully uploaded";
SimulationId++;//7
sim.BeforeTest(testname, testDescription);
sim.Upload_pop(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
}
if (finalStatus == TestStatus.Passed)
{
testname = "Scrutinize";
testDescription = "Checking if the Task can be sucessfully Scrutinized";
SimulationId++;//8
credList = Rtrv.getCredentials(1, 4);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.Scrutinize(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Dispatch";
testDescription = "Checking if the Task can be sucessfully Dispatched";
SimulationId++;//9
sim.BeforeTest(testname, testDescription);
sim.Dispatch(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Log a Query";
testDescription = "Checking if the Query can be successfully Logged";
SimulationId++;//10
credList = Rtrv.getCredentials(2, 1);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.LogQuery(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Close Query";
testDescription = "Checking if the Query can be successfully be closed";
SimulationId++;//11
credList = Rtrv.getCredentials(1, 4);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.Close_Query(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
if (finalStatus == TestStatus.Passed)
{
testname = "Fee Calculator Config";
testDescription = "Checking if the Fixed Rate can be edited";
SimulationId++;//12
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.BeforeTest(testname, testDescription);
sim.FeeCalculatorConfiguration(driver, crd.Username, crd.Password, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Delivery Method Config";
testDescription = "Checking New delivery Method can be added";
SimulationId++;//13
sim.BeforeTest(testname, testDescription);
sim.Configure_Delivery_Method(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Fomat Types Config";
testDescription = "Checking New Fomat types can be added";
SimulationId++;//14
sim.BeforeTest(testname, testDescription);
sim.Configure_Fomat_Types(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Access Registration";
testDescription = "Checking Registration landing page can be accessed successfully";
SimulationId++;//15
sim.BeforeTest(testname, testDescription);
sim.AccessRegistration(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Register External User";
testDescription = "Checking if External user account can successfully be registered";
SimulationId++;//16
sim.BeforeTest(testname, testDescription);
sim.Register_External_User(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Forgot Password";
testDescription = "Checking if the user can sucessfully reset password";
SimulationId++;//17
sim.BeforeTest(testname, testDescription);
credList = Rtrv.getCredentials(2, 5);
for (int i = 0; i < credList.Count; i++)
{
crd = (Creds)credList[i];
}
sim.PasswordRecovery(crd.Username, driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Validate security questions";
testDescription = "Checking if the system accepts security questions";
SimulationId++;//18
sim.BeforeTest(testname, testDescription);
sim.ValidateSecurityQues(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Create New Password";
testDescription = "Checking if the User can successfully create a new password";
SimulationId++;//18
sim.BeforeTest(testname, testDescription);
sim.CreateNewPassword(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Check otp";
testDescription = "Checking if the user can successfully receive the otp after proceeding with forgot password";
SimulationId++;//19
sim.BeforeTest(testname, testDescription);
sim.ReceiveOtp(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Change password";
testDescription = "Checking if the user can successfully receive the otp after proceeding with forgot password";
SimulationId++;//19
sim.BeforeTest(testname, testDescription);
sim.ChangePassword(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Email Adress validation";
testDescription = "Checking if the email adress can be successfully validated";
SimulationId++;//20
sim.BeforeTest(testname, testDescription);
sim.ValidateEmailAdress(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Change email Adress";
testDescription = "Checking if the email adress can be successfully Changed";
SimulationId++;//21
sim.BeforeTest(testname, testDescription);
sim.ChangeEmailAdress(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Deactivate Account";
testDescription = "Checking if the user Account can be successfully Deactivated";
SimulationId++;//22
sim.BeforeTest(testname, testDescription);
sim.DeactivateAccount(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
testname = "Configure Workflow";
testDescription = "Checking if the Workflow can be successfully Configured";
SimulationId++;//23
sim.BeforeTest(testname, testDescription);
sim.ConfigureWorkflow(driver, SimulationId);
sim.CheckTest();
finalStatus = sim.AfterTest(Admin, driver, crd.Username, crd.RoleType, crd.UserType);
}
}
}
}
}
}
}
}
}
GIS();
sim.AfterConclusionReport();
}
else
{
GIS();
sim.AfterConclusionReport();
}
}
catch (Exception ex)
{
throw ex;
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
driver.Quit();
driver.Dispose();
}
}
