public void Delete(int id) { AutoParsing pars = GetById(id); db.Entry(pars).State = EntityState.Deleted; db.SaveChanges(); }
public IActionResult ConfirmDelete(int id) { if (id != null) { AutoParsing parsing = db.AutoParsingDb.GetById(id); if (parsing != null) { return(View(parsing)); } } return(NotFound()); }
public IActionResult Edit(AutoParsing autoParsing, int id) { var data = db.AutoParsingDb.GetById(id); data.CustomeURL = autoParsing.CustomeURL; data.ParamHosting = autoParsing.ParamHosting; data.ParamIp = autoParsing.ParamIp; data.ParamPort = autoParsing.ParamPort; data.ParamServer = autoParsing.ParamServer; data.ParamSpeed = autoParsing.ParamSpeed; data.ParamServerId = autoParsing.ParamServerId; db.AutoParsingDb.Update(data); //helper.Edit(autoParsing.CustomeURL, autoParsing.ParamServer, autoParsing.ParamServerId, autoParsing.ParamIp, autoParsing.ParamPort, autoParsing.ParamHosting); return(RedirectToAction("Index")); }
public IActionResult Delete(int id) { var data = db.PerfDb.GetAll(); AutoParsing parsing = db.AutoParsingDb.GetById(id); foreach (var a in data) { if (a.Site == parsing.CustomeURL) { db.PerfDb.Delete(a.PerfId); } } db.AutoParsingDb.Delete(id); return(RedirectToAction("Index")); }
internal void AutoParsTable(string url, string param, int paramserv, int paramip, int paramport, int paramhost) { var obj = new AutoParsing { CustomeURL = url, ParamServer = param, ParamServerId = paramserv, ParamHosting = paramhost, ParamIp = paramip, ParamPort = paramport, DateTime = DateTime.Now }; db.AutoParsingDb.Insert(obj); string result = ""; var getdata = db.AutoParsingDb.GetAll(); int updatelentharr = 1; int count = 0; string[] arr = new string[updatelentharr]; foreach (var check in getdata) { WebClient webClient = new WebClient(); string page = webClient.DownloadString(check.CustomeURL); HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument(); doc.LoadHtml(page); List <List <string> > table = doc.DocumentNode.SelectSingleNode(check.ParamServer) .Descendants("tr") .Skip(1) .Where(tr => tr.Elements("td").Count() > 1) .Select(tr => tr.Elements("td").Select(td => td.InnerText.Trim()).ToList()) .ToList(); foreach (var go in table) { result = go.ElementAt(paramport); arr[count] = result; count++; updatelentharr++; var send = new iPerf3 { Server = go.ElementAt(paramserv), Port = arr, IPVersion = go.ElementAt(paramip), Hosting = go.ElementAt(paramhost), DateTime = DateTime.Now, Site = url }; db.PerfDb.Check(send, go.ElementAt(0)); } } }
internal void AutoParseLine(string url, string path) { WebClient webClient = new WebClient(); string page = webClient.DownloadString(url); HtmlAgilityPack.HtmlDocument doc = new HtmlAgilityPack.HtmlDocument(); doc.LoadHtml(page); var tdNodes = doc.DocumentNode.SelectNodes(path); var obj2 = new AutoParsing { CustomeURL = url, ParamServer = path, DateTime = DateTime.Now }; db.AutoParsingDb.Insert(obj2); int speed = 0; int updatelentharr = 1; int count = 0; string[] arr = new string[updatelentharr]; for (int i = 0; i < tdNodes.Count; i++) { string format2result = ""; string format3result = ""; string checkformat = ""; //server string format = tdNodes[i].InnerText; format = format.Replace("iperf3", ""); format = format.Replace("-c", ""); format = format.Replace("-R", ""); format = format.Replace("-P", ""); format = format.Replace("-p", ""); format = format.Replace("-r", ""); format = format.Replace("-V", ""); format = format.Replace("(for IPv4)", ""); format = format.Replace("(for IPv6)", ""); format = format.Replace("IPv4", ""); format = format.Replace("IPv6", ""); format = format.Replace("4", ""); format = format.Replace("6", ""); format = format.Replace("-4", ""); format = format.Replace("-6", ""); format = format.Replace("5002", ""); format = format.Replace("-10", ""); format = format.Replace("10", ""); format = format.Replace("wget", ""); format = format.Replace("-O", ""); format = format.Replace("(für IPv4)", ""); format = format.Replace("$", ""); //ip string format2 = tdNodes[i].InnerText; if (format2.Contains("IPv4") == true) { format2result = "IPv4"; format.Replace("IPv4", ""); } else { format2result = "IPv6"; format.Replace("IPv6", ""); } //port List <string> ports = new List <string>(); string result = ""; ports.Add("5002"); ports.Add("4"); ports.Add("6"); ports.Add("10"); ports.Add("5200"); ports.Add("5209"); ports.Add("5202"); ports.Add("5201"); ports.Add("5203"); string format3 = tdNodes[i].InnerText; foreach (var checkport in ports) { if (format3.Contains(checkport) == true) { result = checkport; arr[count] = result; updatelentharr++; checkformat = format.Replace(checkport, ""); checkformat = format.Replace("-" + checkport, ""); format = format.Trim(); } } string format4result = "unknown"; if (url == "http://iperf.volia.net/") { format4result = "Volia"; } if (url == "http://iperf.volia.net/") { speed = 1; } var obj = new iPerf3 { Server = checkformat, IPVersion = format2result, Port = arr, Site = url, Hosting = format4result, Speed = speed, DateTime = DateTime.Now }; db.PerfDb.Insert(obj); } }
public void Update(AutoParsing pars) { db.Update(pars); }
public void Insert(AutoParsing pars) { db.Insert(pars); }
public void Update(AutoParsing parsing) { db.Entry(parsing).State = EntityState.Modified; db.SaveChanges(); }
public void Insert(AutoParsing parsing) { db.Entry(parsing).State = EntityState.Added; db.SaveChanges(); }