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