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