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 <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 void AddDnr(IWebDriver driver, DnrModel dialInNumber)
{
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.ADD_NEW_BUTTON)).Click();
Utils.Pause(5000);
var dialInCategory = new SelectElement(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.DIAL_IN_CATEGORY_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.DIAL_IN_CATEGORY_DROPDOWN)).Click();
dialInCategory.SelectByText(dialInNumber.DialInCategory);
var carrier = new SelectElement(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.CARRIER_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.CARRIER_DROPDOWN)).Click();
carrier.SelectByText(dialInNumber.Carrier);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.DNRE164_FIELD)).SendKeys(dialInNumber.DnrE164);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.DISPLAY_LABEL_FIELD)).SendKeys(dialInNumber.DisplayName);
var mediaServer = new SelectElement(driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.MEDIA_SERVER_DROPDOWN)));
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.MEDIA_SERVER_DROPDOWN)).Click();
mediaServer.SelectByText(dialInNumber.MediaServer);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.DNIS_FIELD)).SendKeys(dialInNumber.Dnis);
driver.FindElement(By.Id(CygnusPages.GlobalToolsPages.APPLY_MOBILE_DNIS)).Click();
Utils.Pause(3000);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.MOBILE_DNIS_FIELD)).SendKeys(dialInNumber.MobileDnis);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.CUSTOM_ALLOCATION_FIELD)).SendKeys(dialInNumber.CustomAllocation);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.NOTES_FIELD)).SendKeys(dialInNumber.Notes);
driver.FindElement(By.XPath(CygnusPages.GlobalToolsPages.SAVE_BUTTON)).Click();
Utils.Pause(10000);
}
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);
}
