public KeyValuePair <string, string> GetMac(string[] mac) { KeyValuePair <string, string> result = new KeyValuePair <string, string>(); using (var context = new organisationdatabaseEntities()) { try { foreach (string m in mac) { var temp = m.Replace(':', ' ').ToUpper(); if (context.classdetails.Any(x => x.deskmac.ToUpper() == temp)) { var d = context.classdetails.Where(x => x.deskmac.ToUpper() == temp).Select(y => y.ccmac).SingleOrDefault(); result = new KeyValuePair <string, string>(temp, d.ToUpper()); break; } } } finally { context.Dispose(); } } return(result); }
public List <LocationsMac> GetLocationsMac(List <int> loc) { List <LocationsMac> cc = new List <LocationsMac>(); using (var context = new organisationdatabaseEntities()) { try { cc = (from c in context.classdetails where loc.Contains(c.classID) select new { cid = c.classID, ccmac = c.ccmac, deskmac = c.deskmac }).AsEnumerable().Select(x => new LocationsMac { ClassId = x.cid, CCMac = x.ccmac, DeskMac = x.deskmac }).ToList(); } finally { context.Dispose(); } } return(cc); }
/// <summary> /// Gets the test time data. /// </summary> /// <param name="time">The time.</param> /// <param name="dbname">The dbname.</param> /// <returns>List<StrategyDesc>.</returns> public List <StrategyDesc> GetTestTimeData(string time, string dbname) { List <StrategyDesc> st = new List <StrategyDesc>(); var dayOfMonth = DateTime.Now.Day; var dayOfWeek = (int)DateTime.Now.DayOfWeek; var toDate = DateTime.Now.Date; using (var context = new organisationdatabaseEntities(dbname)) { try { var temp = (from p in context.strategydescriptions join e in context.strategyequipments on p.Equipmentid equals e.id join s in context.strategymanagements on p.StrategyRefId equals s.strategyId where s.CurrentStatus != 0 && p.strategyTime == time && p.Equipmentid == 1 && p.StrategyTimeFrame1 == "TestTime" select new { StrategyDescId = p.id, StrategyTimeFrame1 = p.StrategyTimeFrame1, StrategyTimeFrame2 = p.StrategyTimeFrame2, EquipmentId = e.id, EquipmentName = e.EquipmentsNames, ServiceConfig = p.Config ?? "", StrategyTime = p.strategyTime.ToString(), Location = s.StrategyLocation, StrategyId = s.strategyId }).AsEnumerable().Select(x => new StrategyDesc { StrategyDescId = x.StrategyDescId, StrategyTimeFrame2 = x.StrategyTimeFrame2, EquipmentId = x.EquipmentId, EquipmentName = x.EquipmentName, ServiceConfig = JsonConvert.DeserializeObject(x.ServiceConfig), StrategyTime = x.StrategyTime, Location = x.Location, StrategyId = x.StrategyId }).ToList(); if (temp.Count > 0) { st.AddRange(temp); } // var data = context.strategydescriptions.Where(x => x.strategyTime == time ); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { context.Dispose(); } } return(st); }
/// <summary> /// Gets the mac. /// </summary> /// <param name="mac">The array of desktop mac address .</param> /// <returns>desktop mac and related central control machine mac(ccmac)</returns> public KeyValuePair <string, string> GetMac(string[] mac) { KeyValuePair <string, string> result = new KeyValuePair <string, string>(); var found = false; foreach (ConnectionStringSettings c in ConfigurationManager.ConnectionStrings) { if (!found) { if (c.Name.Contains("Entities")) { using (var context = new organisationdatabaseEntities(c.Name)) { try { foreach (string m in mac) { var temp = m.Replace(':', ' ').ToUpper(); var d = context.classdetails.Where(x => x.deskmac.ToUpper() == temp).Select(y => y.ccmac).SingleOrDefault(); if (d != null) { found = true; result = new KeyValuePair <string, string>(temp, d.ToUpper()); break; } } } finally { context.Dispose(); } } } } else { break; } } return(result); }
/// <summary> /// Gets the data. /// </summary> /// <param name="time">The time.</param> /// <param name="dbname">The dbname.</param> /// <returns>List<StrategyDesc>.</returns> public List <StrategyDesc> GetData(string time, string dbname) { List <StrategyDesc> st = new List <StrategyDesc>(); var dayOfMonth = DateTime.Now.Day; var dayOfWeek = (int)DateTime.Now.DayOfWeek; var toDate = DateTime.Now.Date; try { using (var context = new organisationdatabaseEntities(dbname)) { try { var temp = (from p in context.strategydescriptions join e in context.strategyequipments on p.Equipmentid equals e.id join s in context.strategymanagements on p.StrategyRefId equals s.strategyId where s.CurrentStatus != 0 && p.strategyTime == time select new { StrategyDescId = p.id, StrategyTimeFrame1 = p.StrategyTimeFrame1, StrategyTimeFrame2 = p.StrategyTimeFrame2, EquipmentId = e.id, EquipmentName = e.EquipmentsNames, ServiceConfig = p.Config ?? "", StrategyTime = p.strategyTime.ToString(), Location = s.StrategyLocation, StrategyId = s.strategyId }).AsEnumerable().Select(x => new StrategyDesc { StrategyDescId = x.StrategyDescId, StrategyTimeFrame1 = x.StrategyTimeFrame1, StrategyTimeFrame2 = x.StrategyTimeFrame2, EquipmentId = x.EquipmentId, EquipmentName = x.EquipmentName, ServiceConfig = System.Text.Json.JsonSerializer.Deserialize <Dictionary <string, dynamic> >(x.ServiceConfig), StrategyTime = x.StrategyTime, Location = x.Location, StrategyId = x.StrategyId }).ToList(); if (temp.Count > 0) { st.AddRange(temp); } // var data = context.strategydescriptions.Where(x => x.strategyTime == time ); } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { context.Dispose(); } } } catch (Exception ex) { loggerFile.Debug(Environment.NewLine + "error in method GetData for strategy: " + ex.Message); } return(st); }