/// <summary>
/// Deprecated Method for adding a new object to the DataCollectionNodes EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToDataCollectionNodes(DataCollectionNode dataCollectionNode)
{
base.AddObject("DataCollectionNodes", dataCollectionNode);
}
public bool InsertDevice(NodeLine device)
{
try
{
using (DB db = new DB())
{
NodeLine node = (from o in db.DeviceSetups
where o.Id == device.DeviceSetupId
select new NodeLine
{
DeviceSetupId = o.Id,
Client = o.LineSetup.DataCollectionNode.Client,
AddressType = o.AddressType,
DataType = o.DataType,
DowntimeThreshold = o.LineSetup.DowntimeThreshold,
UptimeThreshold = o.LineSetup.UptimeThreshold,
IPAddress = o.IpAddress,
Line = o.LineSetup.Line,
TagType = o.TagType,
TrackDowntime = o.TrackDowntime,
TrackingType = o.TrackingType,
TagName = o.TagName
}).FirstOrDefault();
if (node != null)//Already exists
{
DeviceSetup setup = (from o in db.DeviceSetups
where o.Id == node.DeviceSetupId
select o).FirstOrDefault();
if (setup != null)
{
setup.IpAddress = device.IPAddress;
setup.TagName = device.TagName;
setup.TagType = device.TagType;
setup.TrackDowntime = device.TrackDowntime;
setup.TrackingType = device.TrackingType;
setup.AddressType = device.AddressType;
setup.DataType = device.DataType;
setup.LineSetup.Line = device.Line;
setup.LineSetup.DowntimeThreshold = device.DowntimeThreshold;
setup.LineSetup.UptimeThreshold = device.UptimeThreshold;
setup.LineSetup.DataCollectionNode.Client = device.Client;
setup.LineSetup.DataCollectionNode.ServerName = device.ServerName;
return db.SaveChanges() > 0;
}
}
else
{
DeviceSetup setup = new DeviceSetup();
setup.IpAddress = device.IPAddress;
setup.TagName = device.TagName;
setup.TagType = device.TagType;
setup.TrackDowntime = device.TrackDowntime;
setup.TrackingType = device.TrackingType;
setup.AddressType = device.AddressType;
setup.DataType = device.DataType;
DataCollectionNode dataNode = (from o in db.DataCollectionNodes
where o.Client == device.Client
select o).FirstOrDefault();
if (dataNode == null)
{
dataNode = new DataCollectionNode();
dataNode.Password = "******";
setup.LineSetup.DataCollectionNode = dataNode;
}
setup.LineSetup.DataCollectionNode.Client = device.Client;
LineSetup lineSetup = (from o in db.LineSetups
where o.DataCollectionNode.Id == dataNode.Id
select o).FirstOrDefault();
if (lineSetup == null)
{
lineSetup = new LineSetup();
setup.LineSetup = lineSetup;
}
setup.LineSetup.Line = device.Line;
setup.LineSetup.DowntimeThreshold = device.DowntimeThreshold;
setup.LineSetup.UptimeThreshold = device.UptimeThreshold;
db.AddToLineSetups(lineSetup);
return db.SaveChanges() > 0;
}
}
return false;
}
catch (Exception ex)
{
String fileName = this.Server.MapPath("~/App_Data/log.txt");
File.AppendAllText(fileName, ex.ToString());
throw ex;
}
}
/// <summary>
/// Create a new DataCollectionNode object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="serverName">Initial value of the ServerName property.</param>
/// <param name="client">Initial value of the Client property.</param>
/// <param name="password">Initial value of the Password property.</param>
/// <param name="timeZone">Initial value of the TimeZone property.</param>
/// <param name="monitor">Initial value of the Monitor property.</param>
/// <param name="uptime">Initial value of the Uptime property.</param>
public static DataCollectionNode CreateDataCollectionNode(global::System.Int32 id, global::System.String serverName, global::System.String client, global::System.String password, global::System.String timeZone, global::System.Boolean monitor, global::System.Int32 uptime)
{
DataCollectionNode dataCollectionNode = new DataCollectionNode();
dataCollectionNode.Id = id;
dataCollectionNode.ServerName = serverName;
dataCollectionNode.Client = client;
dataCollectionNode.Password = password;
dataCollectionNode.TimeZone = timeZone;
dataCollectionNode.Monitor = monitor;
dataCollectionNode.Uptime = uptime;
return dataCollectionNode;
}
