public ActionResult RegisterUser(RegistrationViewModel model) { Courier_Management_SystemEntities db = new Courier_Management_SystemEntities(); siteuser usersite = new siteuser(); usersite.username = model.username; usersite.password = model.password; usersite.address = model.address; usersite.emailid = model.emailid; usersite.usertype = 1; db.siteusers.Add(usersite); db.SaveChanges(); return(View()); }
public JsonResult LoginUser(RegistrationViewModel model) { Courier_Management_SystemEntities db = new Courier_Management_SystemEntities(); siteuser user = db.siteusers.SingleOrDefault(x => x.emailid == model.emailid && x.password == model.password); string result = "Fail"; if (user != null) { Session["UserId"] = user.id; Session["UserName"] = user.username; if (user.usertype == 1) { result = "User"; } else { result = "Admin"; } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public PartialViewResult criticalview() { dashboard_alertmodel bi_alerts = new dashboard_alertmodel(); bi_alerts.Site = new List <string>(); bi_alerts.Date = new List <string>(); bi_alerts.Alert = new List <string>(); siteuser siteuser = new siteuser(); /* * Expression < Func < siteuser, \u003C\u003Ef__AnonymousType5 < string, int>>> selector = x => new * { * user_site = x.user_site, * Id = x.Id * }; * * foreach (var data in siteuser.Select(selector).ToList()) * { * var item = data; * List<int> list1 = db.hgstatus_link.Where<hgstatus_link>((Expression<Func<hgstatus_link, bool>>)(v => v.site_serial_id == item.Id && v.alert_type == 4)).Select<hgstatus_link, int>((Expression<Func<hgstatus_link, int>>)(v => v.errors_id)).ToList<int>(); * if (list1.Count<int>() != 0) * { * List<hgstatus_db> list2 = db.hgstatus_db.Where<hgstatus_db>((Expression<Func<hgstatus_db, bool>>)(x => x.serial_site_id == item.Id)).OrderByDescending<hgstatus_db, DateTime>((Expression<Func<hgstatus_db, DateTime>>)(x => x.date_record)).ToList<hgstatus_db>(); * if (list2.Count<hgstatus_db>() != 0) * { * foreach (hgstatus_db values in list2) * { * foreach (int errorlist in list1) * this.hgsataus_model(bi_alerts, errorlist, values, item.user_site); * } * } * } * } */ return(PartialView(bi_alerts)); }
public PartialViewResult site(string serial, string sitename, string tmzone) { sitemodellist sitemodellist = new sitemodellist(); sitemodellist.status = new List <string>(); sitemodellist.date_lastseen = new List <string>(); sitemodellist.sites = new List <string>(); sitemodellist.timezone = new List <string>(); sitemodellist.serialnumber = new List <string>(); sitemodellist.hgstatus_count = new List <string>(); sitemodellist.ioalarms_count = new List <string>(); sitemodellist.graph_data_count = new List <string>(); if (sitename != null && serial != null) { sitename.Replace(" ", string.Empty); int result = 0; int.TryParse(serial, out result); siteuser attaching = new siteuser(); attaching.user_site = sitename; attaching.serial_board_id = result; attaching.GMT = tmzone; db.siteuser.Add(attaching); db.SaveChanges(); // Adding the IO Alarms var id_limits = (from y in db.siteuser where y.user_site == sitename && y.serial_board_id == result select y.Id).FirstOrDefault(); // IO Alarms io_alarms naming_alarms = new io_alarms(); naming_alarms.switch_number = 1; naming_alarms.alarm_name = "sw1"; naming_alarms.site_id_link = id_limits; db.io_alarms.Add(naming_alarms); db.SaveChanges(); // Graph Data types + Limits graph_limit site_to_twenty_two = new graph_limit(); site_to_twenty_two.graph_data_type_id = 5; site_to_twenty_two.site_id_to_limit = id_limits; // 16 site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 1; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 4; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 38; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 6; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 10; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 13; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 35; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 36; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 37; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 39; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 40; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 41; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 42; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 43; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 44; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 45; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 46; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 47; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 48; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 49; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 50; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 2; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 23; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 24; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 20; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); site_to_twenty_two.graph_data_type_id = 33; site_to_twenty_two.site_id_to_limit = id_limits; site_to_twenty_two.lower_limit_to = 0; site_to_twenty_two.lower_limit_from = 0; site_to_twenty_two.upper_limit_to = 0; site_to_twenty_two.upper_limit_from = 0; db.graph_limit.Add(site_to_twenty_two); db.SaveChanges(); hgstatus_link adding_all_hg = new hgstatus_link(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 1; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 2; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 3; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 4; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 5; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 6; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 7; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 8; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 10; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 11; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 12; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 14; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 15; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 16; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 17; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 18; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 19; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 20; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 21; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 22; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 23; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 24; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 25; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 26; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 27; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 28; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 29; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 30; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 31; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 32; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 33; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 34; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 35; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 36; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 37; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 38; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 39; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 40; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 41; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 42; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 43; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 44; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 45; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 46; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 47; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 48; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 49; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 50; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 51; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 52; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 53; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); adding_all_hg.site_serial_id = id_limits; adding_all_hg.errors_id = 54; adding_all_hg.alert_type = 1; db.hgstatus_link.Add(adding_all_hg); db.SaveChanges(); } var siteuser = (from x in db.siteuser select new { lastseen = x.sitetoboards.lastseen, user_site = x.user_site, Id = x.Id, serialboard = x.sitetoboards.serialboard, GMT = x.GMT, hgstatus_link = x.hgstatus_link, io_alarms = x.io_alarms, graph_limit = x.graph_limit, }).ToList(); foreach (var item in siteuser) { sitemodellist.sites.Add(item.user_site); sitemodellist.serialnumber.Add(item.serialboard); sitemodellist.timezone.Add(item.GMT); int num1 = item.hgstatus_link.Count(); string str1 = num1.ToString(); sitemodellist.hgstatus_count.Add(str1); num1 = item.io_alarms.Count(); string str2 = num1.ToString(); sitemodellist.ioalarms_count.Add(str2); num1 = item.graph_limit.Count(); string str3 = num1.ToString(); sitemodellist.graph_data_count.Add(str3); DateTime lastseen = item.lastseen; TimeSpan timeSpan = DateTime.Now - lastseen; double totalDays = timeSpan.TotalDays; string status = "Down"; string date; if (totalDays > 10) { String Gmt_convert = item.GMT; if (Gmt_convert == null) { Gmt_convert = "AUS Eastern Standard Time"; } var est = TimeZoneInfo.FindSystemTimeZoneById(Gmt_convert); var targetTime = TimeZoneInfo.ConvertTime(lastseen, est); date = targetTime.ToString(); } else { if (totalDays.ToString("0") != "0") { date = totalDays.ToString("0") + " days ago"; } else { double minutes = timeSpan.TotalMinutes; date = minutes.ToString("0") + " minutes ago"; // UP or DOWN if (minutes < (10 * 3)) { status = "UP"; } if (minutes.ToString("0") == "0") { double seconds = timeSpan.TotalSeconds; date = seconds.ToString("0") + " seconds ago"; } } } sitemodellist.status.Add(status); sitemodellist.date_lastseen.Add(date); } return(PartialView(sitemodellist)); }