public ActionResult FacilityOverview(int?id) { using (var db = new Models.watermentdbEntities()) { var model = new MainViewModel { countries = db.countries_with_facilites_view.ToList(), Facilites = db.facilities.Where(x => x.locations_countries_Id == id).ToList(), }; return(View(model)); } }
// GET: Main public ActionResult Index(int?id, string sortOrder) { //Compare user IDs and updates IP adresses. foreach (var item in db.facilities) { item.IP = ""; foreach (var item2 in db2.Client_Conection.Where(c => c.user == item.Id.ToString())) { item.IP = item2.ip; } } // Fetches the current row id seleted in the table facilities and sets the facility IP to // the Client IP. foreach (var item in db.facilities) { IpFacility = item.IP; if (PingHost(IpFacility) == true) { item.FacilityStatus_Id = 2; } else { item.FacilityStatus_Id = 1; } } db.SaveChanges(); using (var db1 = new Models.watermentdbEntities()) { var model = new MainViewModel { //Getting desired data from the database, and returning it to the view. Countries = db.countries.Where(c => c.continents.Id == id).ToList(), Alarms = db.alarms.Where(o => o.Status == "Active").ToList(), Equipment = db.equipments.Include(c => c.alarms).Include(c => c.facilities).ToList(), Locations = db.locations.ToList(), Maintenance = db.maintenance.OrderBy(x => x.LastMaintenance).Take(10).ToList(), Facilites = db.facilities.ToList(), NumberOfFacilities = db.facilities.Count(), NumberOnline = db.facilities.Where(x => x.FacilityStatus_Id == 2).Count(), NumberOffline = db.facilities.Where(x => x.FacilityStatus_Id == 1).Count(), noAlarms = db.alarms.Where(x => x.Status == "Active").Count(), }; return(View(model)); } }
// GET: Maintanance public ActionResult Index(int?id) { using (var db = new Models.watermentdbEntities()) { var model = new MaintenanceViewModel { //Getting desired data from the database, and returning it to the view. Equipments = db.equipments.Include(c => c.alarms).Include(c => c.facilities).ToList(), Location = db.locations.ToList(), Maintenance = db.maintenance.OrderByDescending(x => x.LastMaintenance).DistinctBy (x => x.facilities_Id).OrderBy(x => x.LastMaintenance).Take(10).ToList(), Facilites = db.facilities.ToList(), }; return(View(model)); } }
public ActionResult FacilityDetails(int?id) { if (id == null) //Error handling if "int? id" is missing from the link. { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } // Fetches the current row id selected in the table Client_Conection foreach (var item2 in db.Client_Conection.Where(c => c.user == id.ToString())) { IpClient = item2.ip; } // Fetches the current row id seleted in the table facilities and sets the facility IP to // the Client IP. foreach (var item in db.facilities.Where(c => c.Id == id)) { item.IP = IpClient; } // Saves the changes to the DB db.SaveChanges(); using (var db = new Models.watermentdbEntities()) { var model = new MainViewModel { //Getting desired data from the database, and returning it to the view. Alarms = db.alarms.Where(x => x.equipments_facilities_Id == id).Where(o => o.Status == "Active").OrderByDescending(x => x.AlarmOccured).ToList(), Facilites = db.facilities.Where(c => c.Id == id).ToList(), Countries = db.countries.ToList(), Locations = db.locations.ToList(), Users = db.User.ToList(), Equipments = db.equipments.Where(x => x.facilities_Id == id).ToList(), }; return(View(model)); } }
public ActionResult ExportAlarmsToExcel(int?id) { //Code to export Alarm list to Excel file using (var db = new Models.watermentdbEntities()) { var grid = new System.Web.UI.WebControls.GridView(); grid.DataSource = from d in db.alarms.Where(x => x.equipments_facilities_Id == id).ToList() select new { //Getting information from database, and tell the excel file what to get. ID = d.Id, ProcessValue = d.ProcessValue, Recorded = d.AlarmOccured, Status = d.Status, EqupmentName = d.equipments.Tag, Description = d.Description }; grid.DataBind(); Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=AlarmList.xls"); Response.ContentType = "application/excel"; StringWriter swriter = new StringWriter(); HtmlTextWriter hwriter = new HtmlTextWriter(swriter); grid.RenderControl(hwriter); Response.Write(swriter.ToString()); Response.End(); return(null); } }