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));
}
