public static List <BillingCodeModel> GetExistingUserBillingCode(CygnusAutomationModel loadConfig)
{
List <BillingCodeModel> blkBillingCode = new List <BillingCodeModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = Queries.GetExistingUserBillingCode(loadConfig.AccountName);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
BillingCodeModel bcm = new BillingCodeModel();
bcm.EmailAddress = dtReader.GetValue(0).ToString();
bcm.LeaderCode = dtReader.GetValue(1).ToString();
bcm.BillingCode = dtReader.GetValue(2).ToString();
blkBillingCode.Add(bcm);
}
cnn.Close();
return(blkBillingCode);
}
public static Dictionary <string, string> BulkActivationEmailTestData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
List <ActivationEmailModel> userData = new List <ActivationEmailModel>();
List <ActivationEmailModel> getUserFromDb = CygnusBulkUtils.GetEmailFromDb(loadConfig, false, null);
if (testFailedCase)
{
string invalidUserEmail = DateTime.Now.ToString("yyyyMMdd_HHmmss");
userData.Add(
new ActivationEmailModel {
EmailAddress = "testInvalidUser" + invalidUserEmail + "@loopup.co"
}
);
}
else
{
foreach (ActivationEmailModel aem in getUserFromDb)
{
userData.Add(
new ActivationEmailModel {
EmailAddress = aem.EmailAddress, LatestActivationEmail = aem.LatestActivationEmail
}
);
lastDataInExcel["email"] = aem.EmailAddress;
}
}
new ExcelMapper().Save(bulkPath, userData, "ActivationEmail");
return(lastDataInExcel);
}
public static List <DelegateModel> GetExistingDelegate(CygnusAutomationModel loadConfig, bool getResult, string email)
{
List <DelegateModel> delegateList = new List <DelegateModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = "";
if (getResult)
{
sql = Queries.GetBulkDelegateResult(email);
}
else
{
sql = Queries.GetAvailableDelegateUser(loadConfig.AccountName);
}
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
DelegateModel dm = new DelegateModel();
dm.EmailAddress = dtReader.GetValue(0).ToString();
dm.DelegateEmailAddress = dtReader.GetValue(1).ToString();
delegateList.Add(dm);
}
cnn.Close();
return(delegateList);
}
public static List <TerminateUserModel> GetExistingUser(CygnusAutomationModel loadConfig, bool getResult, string email)
{
List <TerminateUserModel> blkTerminateUser = new List <TerminateUserModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = "";
if (getResult)
{
sql = Queries.GetTerminateUserResult(email);
}
else
{
sql = Queries.GetAvailableUserLoopupUser(loadConfig.AccountName);
}
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
TerminateUserModel tum = new TerminateUserModel();
tum.EmailAddress = dtReader.GetValue(0).ToString();
tum.UserStatus = Convert.ToInt32(dtReader.GetValue(1));
blkTerminateUser.Add(tum);
}
cnn.Close();
return(blkTerminateUser);
}
public static List <AccountDialInTemplateModel> CheckAccountDialInTemplates(CygnusAutomationModel loadConfig, string accountTemplateName)
{
List <AccountDialInTemplateModel> tagList = new List <AccountDialInTemplateModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.GetAccountDialInTemplates(accountTemplateName);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
AccountDialInTemplateModel tm = new AccountDialInTemplateModel();
tm.UfkTag = dtReader.GetValue(0).ToString();
tm.GroupDisplayName = dtReader.GetValue(1).ToString();
tm.DiscUrn = dtReader.GetValue(2).ToString();
tm.Type = dtReader.GetValue(3).ToString();
tm.UfkUser = dtReader.GetValue(4).ToString();
tagList.Add(tm);
}
cnn.Close();
return(tagList);
}
public static List <ActivationEmailModel> GetEmailFromDb(CygnusAutomationModel loadConfig, bool getResult, string email)
{
List <ActivationEmailModel> blkActEmail = new List <ActivationEmailModel>();
String sql = "";
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
if (getResult)
{
sql = Queries.GetLatestActivationEmail(email);
}
else
{
sql = Queries.GetExistingUserActivationEmail(loadConfig.AccountName);
}
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
ActivationEmailModel ae = new ActivationEmailModel();
ae.EmailAddress = dtReader.GetValue(0).ToString();
ae.LatestActivationEmail = dtReader.GetValue(1).ToString();
blkActEmail.Add(ae);
}
cnn.Close();
return(blkActEmail);
}
public static List <AccessCodeModel> CheckAccessCode(CygnusAutomationModel loadConfig, string email)
{
List <AccessCodeModel> accessCodeList = new List <AccessCodeModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = Queries.GetAccessCode(email);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
AccessCodeModel acm = new AccessCodeModel();
acm.EmailAddress = dtReader.GetValue(0).ToString();
acm.AccessCode = dtReader.GetValue(1).ToString();
accessCodeList.Add(acm);
}
cnn.Close();
return(accessCodeList);
}
public static void SearchAccount(IWebDriver driver, CygnusAutomationModel loadConfig, bool salesforceAccount)
{
// Switch environment
if (loadConfig.TestEnvironment.ToLower() != "prod")
{
Pause(5000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.ENVIRONMENT_SWITCH_BUTTON), 30).Click();
Pause(5000);
driver.FindElement(By.XPath("//*[@data-test-id='" + loadConfig.CmpEnvironment + "']"))
.Click();
}
// try to search an account
Pause(5000);
if (salesforceAccount)
{
driver.FindElement(By.XPath(CygnusPages.CygnusPages.SEARCH_FIELD)).SendKeys(loadConfig.SalesforceAccountName);
}
else
{
driver.FindElement(By.XPath(CygnusPages.CygnusPages.SEARCH_FIELD)).SendKeys(loadConfig.AccountName);
}
driver.FindElement(By.XPath(CygnusPages.CygnusPages.SEARCH_BUTTON)).Click();
Pause(5000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.GET_FIRST_ROW)).Click();
Pause(10000);
}
public static List <DnrModel> CheckDnr(CygnusAutomationModel loadConfig, string dnis)
{
List <DnrModel> dnrList = new List <DnrModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.GetDnr(dnis);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
DnrModel dm = new DnrModel();
dm.UfkDnr = dtReader.GetValue(0).ToString();
dm.DnrE164 = dtReader.GetValue(1).ToString();
dm.DisplayNumber = dtReader.GetValue(2).ToString();
dm.DisplayName = dtReader.GetValue(3).ToString();
dm.DiscUrn = dtReader.GetValue(4).ToString();
dm.CustomAllocation = dtReader.GetValue(5).ToString();
dm.IsActive = Convert.ToInt32(dtReader.GetValue(6));
dm.Notes = dtReader.GetValue(7).ToString();
dm.MediaServer = dtReader.GetValue(8).ToString();
dm.Carrier = dtReader.GetValue(9).ToString();
dm.Dnis = dtReader.GetValue(10).ToString();
dm.PartnerUri = dtReader.GetValue(11).ToString();
dnrList.Add(dm);
}
cnn.Close();
return(dnrList);
}
public static List <ExtendedProperty> CheckUserSettings(CygnusAutomationModel loadConfig, string email, string bulkUserSettingKey)
{
List <ExtendedProperty> userSettingsList = new List <ExtendedProperty>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = Queries.GetUpdateUserSettings(email, bulkUserSettingKey);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
ExtendedProperty usm = new ExtendedProperty();
usm.IntegerValue = dtReader.GetValue(0).ToString();
usm.StringValue = dtReader.GetValue(1).ToString();
userSettingsList.Add(usm);
}
cnn.Close();
return(userSettingsList);
}
public static List <DnrModel> GetUfkDnrByAppServer(CygnusAutomationModel loadConfig, bool isEdited,
bool isDnrActive, bool isDnrSetException, string dnrs)
{
List <DnrModel> ufkDnr = new List <DnrModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
string sql = Queries.GetActiveUfkDnrByAppServer(loadConfig.ApplicationServer, isEdited, isDnrActive, isDnrSetException, dnrs);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
DnrModel dm = new DnrModel();
dm.UfkDnr = dtReader.GetValue(0).ToString();
dm.DisplayName = dtReader.GetValue(1).ToString();
ufkDnr.Add(dm);
}
cnn.Close();
return(ufkDnr);
}
public static List <DialInTemplateModel> CheckTemplate(CygnusAutomationModel loadConfig, string templateNameOrUfkTemplate, bool checkAllSelection)
{
List <DialInTemplateModel> templateList = new List <DialInTemplateModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.GetTemplate(templateNameOrUfkTemplate, checkAllSelection);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
DialInTemplateModel tm = new DialInTemplateModel();
tm.DialInTemplateName = dtReader.GetValue(0).ToString();
tm.DiscUrn = dtReader.GetValue(1).ToString();
tm.Type = dtReader.GetValue(2).ToString();
tm.UfkTemplate = dtReader.GetValue(3).ToString();
templateList.Add(tm);
}
cnn.Close();
return(templateList);
}
public static Dictionary <string, string> BulkTerminateUserTestData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
string billingCodeFormat = DateTime.Now.ToString("HHmmss");
List <TerminateUserModel> userData = new List <TerminateUserModel>();
List <TerminateUserModel> getUserFromDb = CygnusBulkUtils.GetExistingUser(loadConfig, false, null);
if (testFailedCase)
{
string invalidUserEmail = $"Invalid_{DateTime.Now.ToString("yyyyMMdd_HHmmss")}";
userData.Add(new TerminateUserModel {
EmailAddress = invalidUserEmail
});
}
else
{
foreach (TerminateUserModel tum in getUserFromDb)
{
userData.Add(new TerminateUserModel {
EmailAddress = tum.EmailAddress
});
lastDataInExcel["email"] = tum.EmailAddress;
}
}
new ExcelMapper().Save(bulkPath, userData, "TerminateUser");
return(lastDataInExcel);
}
public static void ChangeActionDropdown(IWebDriver driver, CygnusAutomationModel loadConfig, string category, string feature, string action
, string pauKey, string pauValue, string email, bool checkDb)
{
var actionDropdown = new SelectElement(driver.FindElement(By.Id(CygnusPages.CygnusPages.BULK_ACTIONS_DROPDOWN)));
driver.FindElement(By.Id(CygnusPages.CygnusPages.BULK_ACTIONS_DROPDOWN)).Click();
Pause(10000);
actionDropdown.SelectByText(action);
driver.FindElement(By.Id(CygnusPages.CygnusPages.APPLY_BUTTON)).Click();
Pause(3000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.SAVE_BUTTON)).Click();
Pause(5000);
bool checkFeatureMessage = driver.FindElement(By.XPath(CygnusPages.CygnusPages.SUCCESS_UPDATED_MESSAGE), 10000)
.Text.Contains(feature + " for " + loadConfig.AccountName + " has been successfully updated.");
if (checkFeatureMessage)
{
Console.WriteLine("Category : " + category + ", Feature : " + feature + ", Actions : " + action + ", is working");
}
else
{
throw new NoSuchElementException("Failed to update " + category + ", Feature: " + feature + ", Action: " + action);
}
if (checkDb)
{
Utils.CompareDBUserSettings(loadConfig, pauKey, pauValue, email);
}
}
public static List <AccountDialInTemplateModel> GetExistingEmailAddress(CygnusAutomationModel loadConfig)
{
List <AccountDialInTemplateModel> email = new List <AccountDialInTemplateModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = Queries.GetExistingEmailAndUfkUser(loadConfig.AccountName);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
AccountDialInTemplateModel tm = new AccountDialInTemplateModel();
tm.EmailAddress = dtReader.GetValue(0).ToString();
tm.UfkUser = dtReader.GetValue(1).ToString();
email.Add(tm);
}
cnn.Close();
return(email);
}
public static void CompareDBUserSettings(CygnusAutomationModel loadConfig, string pauKey, string pauValue, string email)
{
List <ExtendedProperty> compareDb = CygnusBulkUtils.CheckUserSettings(loadConfig, email, pauKey);
if (compareDb.Count > 0)
{
if (compareDb[0].IntegerValue.Equals(pauValue))
{
Console.WriteLine($"All match for {email}");
}
else if (compareDb[0].StringValue.Equals(pauValue))
{
Console.WriteLine($"All match for {email}");
}
else
{
throw new Exception($"There's a mismatch data for this user {email}");
}
}
else
{
//This condition is for Remove Exceptions which will return 0 row
Console.WriteLine($"All match for {email}");
}
}
public static void BulkDialinNumberData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
string number = DateTime.UtcNow.Ticks.ToString().Substring(9);
List <DnrModel> dnrData = new List <DnrModel>();
if (testFailedCase)
{
dnrData.Add(
new DnrModel
{
CountryIso = "IDN",
DiscUrn = "Local",
IvrLocale = "id",
CountryLabel = "IndonesiaTest",
Carrier = "test",
DnrE164 = "628" + number,
DisplayName = "Test Indonesia(Local no)",
DisplayNumber = "628" + number,
MediaServer = loadConfig.MediaServer,
Dnis = "dnis" + number,
MobileDnis = "mobileDnis" + number,
CustomAllocation = "Custom Allocation test",
Notes = "Notes test"
}
);
}
else
{
//we'll just bulk provision 2 dial-in numbers.
for (int i = 1; i < 3; i++)
{
dnrData.Add(
new DnrModel
{
CountryIso = "IDN",
DiscUrn = "Local",
IvrLocale = "id",
CountryLabel = "IndonesiaTest" + i,
Carrier = loadConfig.Carrier,
DnrE164 = "628" + i + number,
DisplayName = "Test Indonesia(Local no)" + i,
DisplayNumber = "628" + i + number,
MediaServer = loadConfig.MediaServer,
Dnis = "dnis" + i + number,
MobileDnis = "mobileDnis" + i + number,
CustomAllocation = "Custom Allocation test" + i,
Notes = "Notes test" + i
}
);
}
}
new ExcelMapper().Save(bulkPath, dnrData, "DialinNumber");
}
public static void BulkUpdateSettings(IWebDriver driver, CygnusAutomationModel loadConfig, string category, string feature, string action
, string pauKey, string pauValue, string email, bool checkDb)
{
var categoryDropdown = new SelectElement(driver.FindElement(By.XPath(CygnusPages.CygnusPages.CATEGORY_DROPDOWN)));
var featureDropdown = new SelectElement(driver.FindElement(By.XPath(CygnusPages.CygnusPages.FEATURE_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.CygnusPages.CATEGORY_DROPDOWN)).Click();
categoryDropdown.SelectByText(category);
Pause(3000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.FEATURE_DROPDOWN)).Click();
featureDropdown.SelectByText(feature);
ChangeActionDropdown(driver, loadConfig, category, feature, action, pauKey, pauValue, email, checkDb);
}
public static void DeleteDialInNumberSets(CygnusAutomationModel loadConfig, string ufkDnrg)
{
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.DeleteDialInNumberSet(ufkDnrg, loadConfig.PartnerUri);
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.ExecuteReader();
cnn.Close();
}
public static void DeleteAccountDialInTemplate(CygnusAutomationModel loadConfig, string ufkTag)
{
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.DeleteTag(loadConfig.PartnerUri, ufkTag);
SqlCommand cmd = new SqlCommand(sql, cnn);
cmd.ExecuteReader();
cnn.Close();
}
public static void GotoGlobalTools(IWebDriver driver, CygnusAutomationModel loadConfig)
{
// Switch environment
if (loadConfig.TestEnvironment.ToLower() != "prod")
{
Pause(5000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.ENVIRONMENT_SWITCH_BUTTON), 30).Click();
Pause(5000);
driver.FindElement(By.XPath("//*[@data-test-id='" + loadConfig.CmpEnvironment + "']"))
.Click();
}
Pause(5000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.GLOBAL_TOOLS_BUTTON)).Click();
Pause(5000);
}
public static Dictionary <string, string> BulkBillingCodeTestData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
string billingCodeFormat = DateTime.Now.ToString("HHmmss");
List <BillingCodeModel> userData = new List <BillingCodeModel>();
List <BillingCodeModel> getUserFromDb = CygnusBulkUtils.GetExistingUserBillingCode(loadConfig);
if (testFailedCase)
{
string invalidUserEmail = $"Invalid_{DateTime.Now.ToString("yyyyMMdd_HHmmss")}";
string invalidAccessCode = DateTime.Now.ToString("HHmmss");
userData.Add(
new BillingCodeModel {
EmailAddress = invalidUserEmail, LeaderCode = invalidAccessCode, BillingCode = $"BC_{billingCodeFormat}"
}
);
}
else
{
int i = 0;
foreach (BillingCodeModel bcm in getUserFromDb)
{
string bc = $"BC_{++i}{billingCodeFormat}";
userData.Add(
new BillingCodeModel {
EmailAddress = bcm.EmailAddress, LeaderCode = bcm.LeaderCode, BillingCode = bc
}
);
lastDataInExcel["email"] = bcm.EmailAddress;
lastDataInExcel["bCode"] = bc;
}
}
new ExcelMapper().Save(bulkPath, userData, "BillingCode");
return(lastDataInExcel);
}
public static List <UserModel> CheckProvisionUser(CygnusAutomationModel loadConfig, string email)
{
List <UserModel> blkUser = new List <UserModel>();
UserModel um = new UserModel();
SqlConnection cnn = new SqlConnection(loadConfig.DbConnectionString);
cnn.Open();
String sql = Queries.CheckProvisionUser(email);;
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
while (dtReader.Read())
{
um.FirstName = dtReader.GetValue(0).ToString();
um.LastName = dtReader.GetValue(1).ToString();
um.EmailAddress = dtReader.GetValue(2).ToString();
um.BusinessPhone = dtReader.GetValue(3).ToString();
um.MobilePhone = dtReader.GetValue(4).ToString();
um.BillingGroup = dtReader.GetValue(5).ToString();
um.Office = dtReader.GetValue(6).ToString();
um.DialInTemplate = dtReader.GetValue(7).ToString();
um.BillingCode = dtReader.GetValue(8).ToString();
um.LeaderStartsConference = dtReader.GetValue(9).ToString();
um.LeaderEndsConference = dtReader.GetValue(10).ToString();
um.RollCall = dtReader.GetValue(11).ToString();
um.LectureMode = dtReader.GetValue(12).ToString();
um.AllowParticipantUnMute = dtReader.GetValue(13).ToString();
um.JoinTones = dtReader.GetValue(14).ToString();
um.AutoRecord = dtReader.GetValue(15).ToString();
um.UfkUser = dtReader.GetValue(16).ToString();
blkUser.Add(um);
}
cnn.Close();
return(blkUser);
}
public static List <string> CheckUfkDnrsOfDnrSet(CygnusAutomationModel loadConfig, string ufkDnrg)
{
List <string> ufkDnrsList = new List <string>();
var connection = new SqlConnection(loadConfig.DbConnectionString);
var parameters = new SqlParameter[]
{
new SqlParameter("@PARTNER_URI", loadConfig.PartnerUri),
new SqlParameter("@UFK_DNRG", ufkDnrg),
new SqlParameter("@INCLUDE_DNR", 1)
};
var dataSet = GetDataSet(connection, "antares_dnr.dbo.[stp_DNRG_Find]", parameters);
var firstTable = dataSet?.Tables?[1];
foreach (DataRow dr in firstTable.Rows)
{
string ufkDnr = dr["UFK_DNR"].ToString();
ufkDnrsList.Add(ufkDnr);
}
return(ufkDnrsList);
}
public static void UpdateBillingSettings(IWebDriver driver, CygnusAutomationModel loadConfig, String feature)
{
String value = Utils.GetBillingSettings(loadConfig.DbConnectionString, loadConfig.AccountName, feature);
var billingSettingsFeature = new SelectElement(driver.FindElement(By.XPath(CygnusPages.CygnusPages.FEATURE_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.CygnusPages.FEATURE_DROPDOWN)).Click();
billingSettingsFeature.SelectByText(feature);
var billingSettingsValue = new SelectElement(driver.FindElement(By.XPath(CygnusPages.CygnusPages.VALUE_BILLING_DROPDOWN)));
Pause(5000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.VALUE_BILLING_DROPDOWN)).Click();
Pause(5000);
if (value.Equals("CONVENTIONAL"))
{
billingSettingsValue.SelectByText("Credit card");
}
else if (value.Equals("DIRECT_DEBIT"))
{
billingSettingsValue.SelectByText("Manual");
}
else if (value.Equals("CREDIT_CARD"))
{
billingSettingsValue.SelectByText("Direct debit");
}
else if (value.Equals("1"))
{
billingSettingsValue.SelectByText("Disable");
}
else if (value.Equals("0"))
{
billingSettingsValue.SelectByText("Enable");
}
Pause(3000);
driver.FindElement(By.XPath(CygnusPages.CygnusPages.SAVE_BUTTON)).Click();
Pause(5000);
}
public static Dictionary <string, string> BulkDelegateTestData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
List <DelegateModel> userData = new List <DelegateModel>();
List <DelegateModel> getUserFromDb = CygnusBulkUtils.GetExistingDelegate(loadConfig, false, null);
if (testFailedCase)
{
string invalidUserEmail = $"Invalid_{DateTime.Now.ToString("yyyyMMdd_HHmmss")}";
string invalidDelegateEmail = $"InvalidDelegate_{DateTime.Now.ToString("HHmmss")}";
userData.Add(
new DelegateModel {
EmailAddress = invalidUserEmail, DelegateEmailAddress = invalidDelegateEmail
}
);
}
else
{
foreach (DelegateModel dm in getUserFromDb)
{
userData.Add(
new DelegateModel {
EmailAddress = dm.EmailAddress, DelegateEmailAddress = dm.DelegateEmailAddress
}
);
lastDataInExcel["email"] = dm.EmailAddress;
lastDataInExcel["delegateEmail"] = dm.DelegateEmailAddress;
}
}
new ExcelMapper().Save(bulkPath, userData, "Delegate");
return(lastDataInExcel);
}
public static List <DialInNumberSetsModel> CheckDialInNumberSetsByNameOrByUfkDnrg(CygnusAutomationModel loadConfig, string dialInNumberSetNameOrUfkDnrg)
{
List <DialInNumberSetsModel> dnrgList = new List <DialInNumberSetsModel>();
List <DnrModel> dnrsList = new List <DnrModel>();
SqlConnection cnn = new SqlConnection(loadConfig.DnrDbConnectionString);
cnn.Open();
String sql = Queries.GetDialInNumberSetsAndItsDnrs(dialInNumberSetNameOrUfkDnrg);
SqlCommand cmd = new SqlCommand(sql, cnn);
SqlDataReader dtReader = cmd.ExecuteReader();
DialInNumberSetsModel dnsm = new DialInNumberSetsModel();
while (dtReader.Read())
{
DnrModel dm = new DnrModel();
dnsm.DialInNumberSetName = dtReader.GetValue(0).ToString();
dm.UfkDnr = dtReader.GetValue(1).ToString();
dnrsList.Add(dm);
dnsm.UfkDnrg = dtReader.GetValue(2).ToString();
}
if (!string.IsNullOrWhiteSpace(dnsm.DialInNumberSetName))
{
dnrgList.Add(new DialInNumberSetsModel()
{
DialInNumberSetName = dnsm.DialInNumberSetName, DialInNumbers = dnrsList, UfkDnrg = dnsm.UfkDnrg
});
}
cnn.Close();
return(dnrgList);
}
public static List <DnrModel> AddEditDialInNumberSets(IWebDriver driver, DialInNumberSetsModel dialInNumberSets, CygnusAutomationModel loadConfig, bool isTemplateSelected, bool isEdited, bool isDnrActive, bool isDnrSetException)
{
List <DnrModel> ufkDnrs = new List <DnrModel>();
Utils.Pause(5000);
driver.FindElement(By.Name(CygnusPages.GlobalToolsPages.DIAL_IN_NUMBER_SETS_NAME)).Clear();
driver.FindElement(By.Name(CygnusPages.GlobalToolsPages.DIAL_IN_NUMBER_SETS_NAME)).SendKeys(dialInNumberSets.DialInNumberSetName);
if (!isEdited && !isDnrSetException)
{
var applicationServer = new SelectElement(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.APPLICATION_SERVER_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.APPLICATION_SERVER_DROPDOWN)).Click();
applicationServer.SelectByText(dialInNumberSets.ApplicationServer);
Utils.Pause(3000);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.SET_APP_SERVERS_BUTTON)).Click();
}
if (!isEdited && isDnrSetException)
{
var parentDnrSet = new SelectElement(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.MASTER_DIAL_IN_NUMBER_SET_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.MASTER_DIAL_IN_NUMBER_SET_DROPDOWN)).Click();
Utils.Pause(3000);
string dnrgName = dialInNumberSets.DialInNumberSetName;
string parentDnrg = dnrgName.Substring(dnrgName.LastIndexOf(':') + 1);
parentDnrSet.SelectByText(parentDnrg);
Utils.Pause(5000);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.CREATE_NUMBER_SET_EXCEPTION_BUTTON)).Click();
Utils.Pause(5000);
}
if (!isTemplateSelected)
{
Utils.Pause(3000);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.SAVE_BUTTON)).Click();
Utils.Pause(3000);
Assert.IsTrue(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.CONFIRMATION_MESSAGE))
.Text.Contains("Please select at least one dial-in number"));
}
else
{
string dnrs = "";
if (isDnrSetException)
{
string _dnrgName = dialInNumberSets.DialInNumberSetName;
string dnrgName = _dnrgName.Substring(_dnrgName.LastIndexOf(':') + 1);
List <DialInNumberSetsModel> dnrg = GlobalToolsUtils.CheckDialInNumberSetsByNameOrByUfkDnrg(loadConfig, dnrgName);
// Now we wants to exclude dnrs from parent dnrg and add it to its exception
List <DnrModel> dnrsList = dnrg[0].DialInNumbers;
List <string> usedUfkDnrsList = new List <string>();
foreach (var tmp in dnrsList)
{
usedUfkDnrsList.Add(tmp.UfkDnr);
}
dnrs = "'" + String.Join("','", usedUfkDnrsList) + "'";
}
ufkDnrs = GetUfkDnrByAppServer(loadConfig, isEdited, isDnrActive, isDnrSetException, dnrs);
foreach (var ufk in ufkDnrs)
{
driver.FindElement(By.XPath($"//option[@value='{ufk.UfkDnr}']")).Click();
Utils.Pause(1000);
}
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.SAVE_BUTTON)).Click();
Utils.Pause(8000);
}
return(ufkDnrs);
}
public static String BulkUserTestData(CygnusAutomationModel loadConfig, string bulkPath, bool testFailedCase)
{
string bulkEmailFormat = DateTime.Now.ToString("yyyyMMddHHmmss");
string userLastNameFormat = DateTime.Now.ToString("HHmmss");
string billingCodeFormat = DateTime.Now.ToString("HHmmss");
List <UserModel> userData = new List <UserModel>();
if (testFailedCase)
{
userData.Add(
new UserModel
{
FirstName = "Automation",
LastName = "usrInvalid" + userLastNameFormat,
EmailAddress = "auto.test.invalid" + bulkEmailFormat + "@loopup.co",
BusinessPhone = "14152112212",
MobilePhone = "14152001114",
BillingGroup = "test",
Office = "test",
DialInTemplate = "",
BillingCode = "bc_" + billingCodeFormat,
LeaderStartsConference = "0",
LeaderEndsConference = "0",
RollCall = "1",
LectureMode = "0",
AllowParticipantUnMute = "0",
JoinTones = "1",
AutoRecord = "1",
UfkUser = "******" + bulkEmailFormat
}
);
}
else
{
//we'll just bulk provision 3 users.
for (int i = 1; i < 4; i++)
{
userData.Add(
new UserModel
{
FirstName = "Automation",
LastName = "usr" + i + userLastNameFormat,
EmailAddress = "auto.test." + i + bulkEmailFormat + "@loopup.co",
BusinessPhone = "14152112212",
MobilePhone = "14152001114",
BillingGroup = loadConfig.BillingGroup,
Office = loadConfig.OfficeName,
DialInTemplate = "",
BillingCode = "bc_" + i + billingCodeFormat,
LeaderStartsConference = "0",
LeaderEndsConference = "0",
RollCall = "1",
LectureMode = "0",
AllowParticipantUnMute = "0",
JoinTones = "1",
AutoRecord = "1",
UfkUser = "******" + i + bulkEmailFormat
}
);
lastDataInExcel = "auto.test." + i + bulkEmailFormat + "@loopup.co";
}
}
new ExcelMapper().Save(bulkPath, userData, "ProvisionUser");
return(lastDataInExcel);
}
