public ActionResult DataSitesView()
 {
     using (PingContext pingDb = new PingContext())
     {
         listDataSite    = new List <DataSite>();
         topListDataSite = new List <DataSite>();
         listDataSite    = pingDb.DataSites.ToList();
         var sortListDataSite = listDataSite.OrderByDescending(d => d.MidlResponseTime);
         int i = 0;
         foreach (DataSite d in sortListDataSite)
         {
             if (i < 10)
             {
                 topListDataSite.Add(d);
                 i++;
             }
             else
             {
                 break;
             }
         }
         ViewBag.topList = topListDataSite;
         return(View());
     }
 }
 public string PostSave(string path, string maximum, string minimum, string mid)
 {
     using (PingContext pingDb = new PingContext())
     {
         bool existe = false;
         int  id     = 0;
         foreach (DataSite d in pingDb.DataSites.ToList())
         {
             if (path == d.Path)
             {
                 existe = true;
                 id     = d.Id;
             }
         }
         if (existe)
         {
             DataSite ds = pingDb.DataSites.Find(id);
             ds.ResponseTimeMax  = Convert.ToInt32(maximum);
             ds.ResponseTimeMin  = Convert.ToInt32(minimum);
             ds.MidlResponseTime = Convert.ToInt32(mid);
             try
             {
                 pingDb.Entry(ds).State = EntityState.Modified;
                 pingDb.SaveChanges();
                 return("The data saved successfully.");
             }
             catch (Exception)
             {
                 return("The data could not be saved, please try again later.");
             }
         }
         else
         {
             DataSite dataSite = new DataSite();
             dataSite.Path             = path;
             dataSite.ResponseTimeMax  = Convert.ToInt32(maximum);
             dataSite.ResponseTimeMin  = Convert.ToInt32(minimum);
             dataSite.MidlResponseTime = Convert.ToInt32(mid);
             try
             {
                 pingDb.Entry(dataSite).State = EntityState.Added;
                 pingDb.SaveChanges();
                 return("The data saved successfully.");
             }
             catch (Exception)
             {
                 return("The data could not be saved, please try again later.");
             }
         }
     }
 }
 public string ClearDb()
 {
     using (PingContext pingDb = new PingContext())
     {
         try
         {
             foreach (DataSite d in pingDb.DataSites.ToList())
             {
                 DataSite ds = pingDb.DataSites.Find(d.Id);
                 pingDb.DataSites.Remove(ds);
                 pingDb.SaveChanges();
             }
             return("The data deleted successfully.");
         }
         catch (Exception)
         {
             return("The data could not be deleted, please try again later.");
         }
     }
 }