/// <summary> /// Saves the alarm messages /// </summary> /// <param name="ip">The ip.</param> /// <param name="msg">The MSG.</param> /// <param name="altime">The altime.</param> /// <returns>System.Int32.</returns> public int SaveMonitoringDetails(string ip, string msg, string altime) { int result = 0; try { using (var context = new organisationdatabaseEntities()) { var cid = context.classdetails.Where(x => x.camipS == ip || x.camipT == ip).Select(x => x.classID).FirstOrDefault(); var monitorobj = new alarmmonitorlog() { almMessage = msg, almTime = Convert.ToDateTime(altime), Classid = cid, deviceip = ip }; context.alarmmonitorlogs.Add(monitorobj); result = context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex.Message); } return(result); }
/// <summary> /// Saves the power usage information. /// </summary> /// <param name="pow">The pow.</param> /// <param name="mac">The mac.</param> /// <param name="typ">The typ.</param> /// <returns>System.Int32.</returns> public int SavePowerUsageInfo(int pow, string mac, string typ) { int r = 0; var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { try { using (var context = new organisationdatabaseEntities(c.Name)) { var cid = context.classdetails.Where(x => x.ccmac == mac) .Select(x => x.classID).FirstOrDefault(); if (cid > 0) { found = true; machineusagelogs_minute m = new machineusagelogs_minute() { classid = cid, value = pow, attribute = typ, recordtime = DateTime.Now }; context.machineusagelogs_minute.Add(m); r = context.SaveChanges(); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } } } else { break; } } return(r); }
/// <summary> /// Updates the projector configuration. /// </summary> /// <param name="mac">The mac.</param> /// <param name="val">The value.</param> /// <returns>System.Int32.</returns> public int UpdateProjectorConfig(string mac, string val) { int r = 0; string stat = ""; var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { if (val == "True") { stat = "Registered"; } else { stat = "Pending"; } using (var context = new organisationdatabaseEntities(c.Name)) { var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault(); if (classid != 0) { found = true; var d = context.projectorconfiginfoes.Where(x => x.Classid == classid).Select(x => x).FirstOrDefault(); if (d != null) { d.status = stat; } } r = context.SaveChanges(); } } } else { break; } } return(r); }
/// <summary> /// Gets the power usage information. /// </summary> /// <param name="mac">The mac.</param> /// <param name="typ">The typ.</param> /// <returns>System.String.</returns> public string GetPowerUsageInfo(string mac, string typ) { int r = 0; var data = ""; var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { try { using (var context = new organisationdatabaseEntities(c.Name)) { var cid = context.classdetails.Where(x => x.ccmac == mac).OrderBy(x => x.classID) .Select(x => x.classID).FirstOrDefault(); if (cid > 0) { found = true; data = context.Database.ExecuteSqlCommand("SELECT sum(value) as " + "value from organisationdatabase.machineusagelogs_minute WHERE " + "date(recordtime)= date(now()) and attribute = 'Power'" + " and classid =" + cid).ToString(); r = context.SaveChanges(); } } } catch (Exception ex) { Console.WriteLine(ex.Message); } } } else { break; } } return(data); }
/// <summary> /// Saves the reader log. /// </summary> /// <param name="message">The message.</param> /// <param name="mac">The mac.</param> /// <param name="cardid">The cardid.</param> /// <returns>System.Int32.</returns> public int SaveReaderLog(string message, string mac, string cardid) { int result = 0; var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { try { using (var context = new organisationdatabaseEntities(c.Name)) { var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault(); if (classid != 0) { found = true; cardlog cardlog = new cardlog() { Message = message, ClassId = classid, cardId = cardid, ActionTime = DateTime.Now }; context.cardlogs.Add(cardlog); result = context.SaveChanges(); } } } catch (Exception) { } } } else { break; } } return(result); }
/// <summary> /// Updates the status of card reg. /// </summary> /// <param name="stat">The stat.</param> /// <param name="mac">The mac.</param> /// <param name="cid">The cid.</param> /// <returns>System.Int32.</returns> public int UpdateStatCardReg(string stat, string mac, string cid) { int result = 0; var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { using (var context = new organisationdatabaseEntities(c.Name)) { var classid = context.classdetails.Where(x => x.ccmac == mac).Select(x => x.classID).FirstOrDefault(); if (context.card_registration.Any(x => x.calssId == classid && x.OneCardId == cid)) { var row = context.card_registration.Where(x => x.calssId == classid && x.OneCardId == cid) .Select(x => x).FirstOrDefault(); if (row != null) { found = true; Console.WriteLine("status: " + row.Status); row.Status = stat; row.UpdateTime = DateTime.Now; } result = context.SaveChanges(); } Console.WriteLine("UpdatedRows:" + result); } } } else { break; } } return(result); }