public static string ConfigContent(FtpFileModificationDate filename)
{
using (WebClient client = new WebClient())
{
client.Credentials = new NetworkCredential("crawl", "qwerty123");
StreamReader reader2 = new StreamReader(client.OpenRead(GlobVar.ServerUri + filename.Filename));
return(reader2.ReadToEnd());
}
}
public static string ConfigContent(FtpFileModificationDate filename)
{
using (WebClient client = new WebClient())
{
client.Credentials = new NetworkCredential("crawl", "qwerty123");
StreamReader reader2 = new StreamReader(client.OpenRead(GlobVar.ServerUri + filename.Filename));
return reader2.ReadToEnd();
}
}
//Dictionary<Dictionary<string, RouterSectionItems>, Dictionary<string, RouterSectionItems>> ehonepairs;
public List<EphoneTuple> DownloadConfigurationFile(FtpFileModificationDate filename)
{
// pociagniecie configa
string fileContent = GetConfigTextContentToString.ConfigContent(filename);
_ephone.Clear();
_ephoneDn.Clear();
DownloadSection(fileContent, @"\bephone\s+\d+.*\b", "ephone");
DownloadSection(fileContent, @"\bephone-dn\s+\d+.*\b", "ephonedn");
List<EphoneTuple> ephonePairedList = new List<EphoneTuple>();
ephonePairedList = SetEphonePairs();
//Console.WriteLine(ephonePairedList);
return ephonePairedList;
}
//Dictionary<Dictionary<string, RouterSectionItems>, Dictionary<string, RouterSectionItems>> ehonepairs;
public List <EphoneTuple> DownloadConfigurationFile(FtpFileModificationDate filename)
{
// pociagniecie configa
string fileContent = GetConfigTextContentToString.ConfigContent(filename);
_ephone.Clear();
_ephoneDn.Clear();
DownloadSection(fileContent, @"\bephone\s+\d+.*\b", "ephone");
DownloadSection(fileContent, @"\bephone-dn\s+\d+.*\b", "ephonedn");
List <EphoneTuple> ephonePairedList = new List <EphoneTuple>();
ephonePairedList = SetEphonePairs();
//Console.WriteLine(ephonePairedList);
return(ephonePairedList);
}
public RouterConfigToSharepoint(List <EphoneTuple> ephonePairedList, FtpFileModificationDate filenameAndModDateAndCme)
{
const string sharepointUrl = "http://sharepoint.eot.int/kb/";
using (ClientContext ccontext = new ClientContext(sharepointUrl))
{
ccontext.Credentials = new NetworkCredential("automat.voip", "Hujkutas123", "EOT");
Web web = ccontext.Web;
List itemList = web.Lists.GetByTitle("Klienci VOIP");
ccontext.Load(itemList.Fields);
ccontext.ExecuteQuery();
GetCityNames cityNameExtension = new GetCityNames();
cityNameExtension.GetCityNamesDict();
ListItemCreationInformation newItem = new ListItemCreationInformation();
string[] splittedButton;
string[] splittedDNnumber;
string[] routerCmEname;
foreach (EphoneTuple element in ephonePairedList)
{
ListItem listItem = itemList.AddItem(newItem);
listItem["CME"] = filenameAndModDateAndCme.RouterName;
listItem["EPHONE"] = element.Item1.Value["ephone"];
routerCmEname = filenameAndModDateAndCme.RouterName.Split('_');
foreach (string key in cityNameExtension.Keys)
{
if (key == routerCmEname[3])
{
listItem["PBX"] = cityNameExtension[key];
}
}
if (element.Item1.Value.ContainsKey("mac-address"))
{
listItem["MAC"] = element.Item1.Value["mac-address"];
}
else
{
listItem["MAC"] = "BRAK!";
}
if (element.Item1.Value.ContainsKey("type"))
{
listItem["TYPE"] = element.Item1.Value["type"];
}
else
{
listItem["TYPE"] = "BRAK!";
}
if (element.Item1.Value.ContainsKey("button"))
{
splittedButton = element.Item1.Value["button"].Split(':', ' ');
listItem["PRIMARY_x0020_DN"] = splittedButton[1];
}
else
{
listItem["PRIMARY_x0020_DN"] = "BRAK!";
}
if (element.Item2.Value.ContainsKey("number"))
{
splittedDNnumber = element.Item2.Value["number"].Split(' ');
listItem["Title"] = splittedDNnumber[0]; // PRIMARY DN NUMBER
}
else
{
listItem["Title"] = "BRAK!"; //PRIMARY DN NUMBER
}
if (element.Item2.Value.ContainsKey("label"))
{
listItem["PRIMARY_x0020_DN_x0020_NUMBER"] = element.Item2.Value["label"]; // PRIMARY DN LABEL
}
else
{
listItem["PRIMARY_x0020_DN_x0020_NUMBER"] = "BRAK!"; // PRIMARY DN LABEL
}
listItem.Update();
}
ccontext.ExecuteQuery();
}
}
public RouterConfigToSharepoint(List<EphoneTuple> ephonePairedList, FtpFileModificationDate filenameAndModDateAndCme)
{
const string sharepointUrl = "http://sharepoint.eot.int/kb/";
using (ClientContext ccontext = new ClientContext(sharepointUrl))
{
ccontext.Credentials = new NetworkCredential("automat.voip", "Hujkutas123", "EOT");
Web web = ccontext.Web;
List itemList = web.Lists.GetByTitle("Klienci VOIP");
ccontext.Load(itemList.Fields);
ccontext.ExecuteQuery();
GetCityNames cityNameExtension = new GetCityNames();
cityNameExtension.GetCityNamesDict();
ListItemCreationInformation newItem = new ListItemCreationInformation();
string[] splittedButton;
string[] splittedDNnumber;
string[] routerCmEname;
foreach (EphoneTuple element in ephonePairedList)
{
ListItem listItem = itemList.AddItem(newItem);
listItem["CME"] = filenameAndModDateAndCme.RouterName;
listItem["EPHONE"] = element.Item1.Value["ephone"];
routerCmEname = filenameAndModDateAndCme.RouterName.Split('_');
foreach (string key in cityNameExtension.Keys)
{
if (key == routerCmEname[3])
{
listItem["PBX"] = cityNameExtension[key];
}
}
if (element.Item1.Value.ContainsKey("mac-address"))
{
listItem["MAC"] = element.Item1.Value["mac-address"];
}
else
{
listItem["MAC"] = "BRAK!";
}
if (element.Item1.Value.ContainsKey("type"))
{
listItem["TYPE"] = element.Item1.Value["type"];
}
else
{
listItem["TYPE"] = "BRAK!";
}
if (element.Item1.Value.ContainsKey("button"))
{
splittedButton = element.Item1.Value["button"].Split(':', ' ');
listItem["PRIMARY_x0020_DN"] = splittedButton[1];
}
else
{
listItem["PRIMARY_x0020_DN"] = "BRAK!";
}
if (element.Item2.Value.ContainsKey("number"))
{
splittedDNnumber = element.Item2.Value["number"].Split(' ');
listItem["Title"] = splittedDNnumber[0]; // PRIMARY DN NUMBER
}
else
{
listItem["Title"] = "BRAK!"; //PRIMARY DN NUMBER
}
if (element.Item2.Value.ContainsKey("label"))
{
listItem["PRIMARY_x0020_DN_x0020_NUMBER"] = element.Item2.Value["label"]; // PRIMARY DN LABEL
}
else
{
listItem["PRIMARY_x0020_DN_x0020_NUMBER"] = "BRAK!"; // PRIMARY DN LABEL
}
listItem.Update();
}
ccontext.ExecuteQuery();
}
}
