public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
site_experts site_experts = await db.site_experts.FindAsync(id);
if (site_experts == null)
{
return(HttpNotFound());
}
ViewBag.count = db.Experts_comments.Count(p => p.site_experts_id == id);
ViewBag.groups = db.Groups.ToList();
return(View(site_experts));
}
public ActionResult StartMonitoring()
{
//List<technical_rating> t = db.technical_rating.OrderByDescending(p => p.date).ToList();
//List<experts_ratinng> e = db.experts_ratinng.OrderByDescending(p => p.id).ToList();
//foreach (var item in e)
//{
// int a = item.audit_object_id;
// int t1 = 0, e1 = item.sum;
// if (t.FirstOrDefault(p => p.audit_object_id == a) != null)
// {
// t1 = Convert.ToInt32(t.FirstOrDefault(p => p.audit_object_id == a).sum);
// }
// Rating r = new Rating();
// r.id = (db.Rating.Count() > 0) ? (db.Rating.Max(p => p.id) + 1) : 1;
// r.audit_object_id = a;
// r.monitoring_id = 1;
// r.sum = e1 + t1;
// db.Rating.Add(r);
// db.SaveChanges();
//}
monitoring monitoring = new monitoring(); //начался новый Мониторинг
monitoring.id = (db.monitoring.Count() > 0) ? (db.monitoring.Max(p => p.id) + 1) : 1;
monitoring.date_start = DateTime.Now;
System.TimeSpan duration = new System.TimeSpan(30, 0, 0, 0);
monitoring.date_end = monitoring.date_start.Add(duration);
monitoring.number_experts_one_site = 0;
db.monitoring.Add(monitoring);
List <experts> user_list = db.experts.Where(p => p.User.state_id == 1).ToList(); //список экспертов
List <education__institution> edu = db.education__institution.Where(p => p.state_id == 1 && p.audit_object != null).ToList();
List <audit_object> a = db.audit_object.Where(p => !p.adress_site.Equals(" ")).ToList(); //список УО для проверки
List <site_experts> site_experts = new List <site_experts>(); //список для записи новых проверок
List <technical_rating> tech = new List <technical_rating>();
int t_rating_count = (db.technical_rating.Count() > 0) ? (db.technical_rating.Max(p => p.id) + 1) : 1;
string path = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"files/");
List <audit_object> errors_site = new List <audit_object>();
for (int i = 0; i < a.Count(); ++i)//запись технического рейтинга в бд
{
if (!a[i].adress_site.Contains("\\") && !a[i].adress_site.Contains("/") && !a[i].adress_site.Contains("@"))
{
try
{
string[] dirs = Directory.GetFiles(path, a[i].adress_site.Trim() + ".json");
if (dirs.Count() != 0)
{
technical_rating t = new technical_rating();
t.id = t_rating_count++;
t.monitoring_id = monitoring.id;
t.audit_object_id = Convert.ToInt32(a[i].id);
t.date = DateTime.Now;
using (StreamReader r = new StreamReader(dirs[0]))
{
string json = r.ReadToEnd();
dynamic array = JsonConvert.DeserializeObject(json);
t.site_accessibility = array["audits"]["time-to-first-byte"]["rawValue"];
t.status_code = array["audits"]["http-status-code"]["rawValue"];
t.using_HTTPS = array["audits"]["is-on-https"]["rawValue"];
t.response_time = array["audits"]["estimated-input-latency"]["rawValue"];
t.img_title = array["audits"]["image-alt"]["rawValue"];
t.has_title = array["audits"]["bypass"]["rawValue"];
t.full_load = array["audits"]["interactive"]["rawValue"];
t.robots_txt = array["audits"]["robots-txt"]["rawValue"];
string[] dirs2 = Directory.GetFiles(path + "/majento", a[i].adress_site + ".json");
if (dirs2.Count() != 0)
{
StreamReader reader;
using (reader = new StreamReader(dirs2[0]))
{
string js = reader.ReadToEnd();
dynamic arr = System.Web.Helpers.Json.Decode(js);
t.nesting_level = arr[0]["maxLevel"];
t.broken_links_count = arr[0]["numberOfBrokenLinks"];
t.broken_links_text = string.Join(", ", arr[0]["brokenLinks"]);
}
}
int sum = 0;
if (t.status_code.Contains("True"))
{
sum += 600;
}
if (t.site_accessibility < 50)
{
sum += 400;
}
else if (t.site_accessibility < 60)
{
sum = sum + (400 - (Convert.ToInt32(t.site_accessibility) - 49) * 40);
}
if (t.robots_txt.Contains("True"))
{
sum += 50;
}
if (t.broken_links_count == 0)
{
sum += 200;
}
else if (t.broken_links_count > 0 && t.broken_links_count < 20)
{
sum = sum + (200 - (Convert.ToInt32(t.broken_links_count) * 10));
}
t.sum = sum;
}
tech.Add(t);
}
}
catch (Exception e)
{
errors_site.Add(a[i]);
}
}
else
{
errors_site.Add(a[i]);
}
}
db.technical_rating.AddRange(tech);
db.SaveChanges();
List <site_experts> experts = new List <site_experts>();
int expert_id = (db.site_experts.Count() > 0) ? (db.site_experts.Max(p => p.id) + 1) : 1;
foreach (var u in user_list)
{
string UNP = u.education__institution.UNP;
List <education__institution> p_unp = edu.Where(p => p.UNP_superior_management.Contains(UNP)).ToList();
foreach (var e in p_unp)
{
site_experts site = new site_experts();
site.id = expert_id++;
site.expert_id = u.id;
site.monitoring_id = monitoring.id;
site.date = DateTime.Now;
site.audit_object_id = Convert.ToInt32(e.audit_object_id);
experts.Add(site);
}
}
db.site_experts.AddRange(experts);
db.SaveChanges();
List <User> all_user = db.User.Where(p => p.state_id == 1).ToList();
List <events> all_events = new List <events>();
int event_id = (db.events.Count() > 0) ? (db.events.Max(p => p.id) + 1) : 0;
foreach (User item in all_user)
{
events e = new events();
e.state_id = 1;
e.id = event_id;
event_id++;
e.text = "Мониторинг сайтов государственных органов и организаций начался.";
e.date_created = DateTime.Now;
e.recipient_id = item.id;
all_events.Add(e);
}
db.events.AddRange(all_events);
db.SaveChanges();
return(Redirect("/Experts/SiteExperts"));
}
