private void BuildMonitorInformationToDB()
{
try
{
if (this.monitor_manager.device_list.Count > 0)
{
//System.Diagnostics.Debug.Print("BuildMonitorInformationToDB() --> Start to Insert IOT_STATUS_MONITOR: " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
cls_LogMessage log_msg = new cls_LogMessage("INFO", "MonitorService", "BuildMInfoToDB", "Delete IOT_STATUS_MONITOR...");
_logger.LogInformation(log_msg.get_log_message());
var tmp = this.db.IOT_STATUS_MONITOR.Where(x => x.id > 0);
this.db.IOT_STATUS_MONITOR.RemoveRange(tmp);
this.db.SaveChanges();
log_msg.message = "Delete IOT_STATUS_MONITOR finished";
_logger.LogInformation(log_msg.get_log_message());
log_msg.message = "Start to Insert IOT_STATUS_MONITOR...";
_logger.LogInformation(log_msg.get_log_message());
foreach (cls_Monitor_Device_Info mdi in this.monitor_manager.device_list)
{
IOT_STATUS_MONITOR ism = new IOT_STATUS_MONITOR();
ism.gateway_id = mdi.gateway_id;
ism.device_id = mdi.device_id;
if (mdi.virtual_flag)
{
ism.virtual_flag = "Y";
}
else
{
ism.virtual_flag = "N";
}
ism.device_type = mdi.device_type;
ism.device_status = mdi.device_status;
ism.iotclient_status = mdi.iotclient_status;
ism.hb_status = mdi.hb_status;
ism.plc_ip = mdi.plc_ip;
ism.plc_port = mdi.plc_port;
ism.device_location = mdi.device_location;
ism.last_alarm_code = mdi.last_alarm_code;
ism.last_alarm_app = mdi.last_alarm_app;
ism.last_edc_time = mdi.last_edc_time;
ism.hb_report_time = mdi.hb_report_time;
ism.last_alarm_datetime = mdi.last_alarm_datetime;
this.db.IOT_STATUS_MONITOR.Add(ism);
}
this.db.SaveChanges();
log_msg.message = "Insert IOT_STATUS_MONITOR finished";
_logger.LogInformation(log_msg.get_log_message());
//System.Diagnostics.Debug.Print("BuildMonitorInformationToDB() --> End to Insert IOT_STATUS_MONITOR: " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
}
}
catch (Exception ex)
{
//Console.WriteLine("BuildMonitorInformationToDB error -> " + ex.Message);
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "BuildMInfoToDB", "Exception: " + ex.Message);
_logger.LogInformation(log_msg.get_log_message());
}
}
private void UpdateMonitorDB(string gateway_id, string device_id)
{
var db_record = this.db.IOT_STATUS_MONITOR.Where(p => (p.gateway_id == gateway_id) && (p.device_id == device_id)).FirstOrDefault();
cls_Monitor_Device_Info mdi = this.monitor_manager.device_list.Where(o => (o.gateway_id == gateway_id) && (o.device_id == device_id)).FirstOrDefault();
if ((db_record != null) && (mdi != null))
{
db_record.device_status = mdi.device_status;
db_record.iotclient_status = mdi.iotclient_status;
db_record.hb_status = mdi.hb_status;
db_record.last_alarm_code = mdi.last_alarm_code;
db_record.last_alarm_app = mdi.last_alarm_app;
db_record.last_edc_time = mdi.last_edc_time;
db_record.hb_report_time = mdi.hb_report_time;
db_record.last_alarm_datetime = mdi.last_alarm_datetime;
db_record.last_alarm_message = mdi.last_alarm_message;
this.db.IOT_STATUS_MONITOR.Update(db_record);
this.db.SaveChanges();
}
else
{
string msg = String.Format("[{0}][{1}]", gateway_id, device_id) + " query data error";
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "UpdateMonitorDB", msg);
_logger.LogInformation(log_msg.get_log_message());
}
}
private bool ConnectDatabase()
{
try
{
//System.Diagnostics.Debug.Print("DB COnnect Start" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
cls_LogMessage log_msg = new cls_LogMessage("INFO", "MonitorService", "ConnectDatabase", "DB Connect Start...");
_logger.LogInformation(log_msg.get_log_message());
this.db = new IOT_DbContext(this.service_initial.db_info.db_type, this.service_initial.db_info.connection_string);
//System.Diagnostics.Debug.Print("DB COnnect End & init Start" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
log_msg.message = "DB Connect End & init Start";
_logger.LogInformation(log_msg.get_log_message());
this.db.ChangeTracker.AutoDetectChangesEnabled = false;
this.db.ChangeTracker.LazyLoadingEnabled = false;
this.db.IOT_STATUS_MONITOR.FirstOrDefault();
//System.Diagnostics.Debug.Print("DB COnnect init End" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"));
log_msg.message = "DB Init End";
_logger.LogInformation(log_msg.get_log_message());
return(true);
}
catch (Exception ex)
{
//Console.WriteLine("Connect Database error -> " + ex.Message);
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "ConnectDatabase", "Exception: " + ex.Message);
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
}
public void ReadDataAck(xmlMessage InputData)
{
if (!gw_info_loaded)
{
return;
}
// Parse Mqtt Topic
string[] Topic = InputData.MQTTTopic.Split('/'); // /IEW/GateWay/Device/Cmd/ReadData/Ack
string GateWayID = Topic[2].ToString();
string DeviceID = Topic[3].ToString();
cls_LogMessage log_msg = new cls_LogMessage("MQTT", GateWayID, DeviceID, "Receive ReadData Ack");
_logger.LogInformation(log_msg.get_log_message());
cls_ReadDataAck rc = new cls_ReadDataAck();
rc = JsonConvert.DeserializeObject <cls_ReadDataAck>(InputData.MQTTPayload.ToString());
cls_Monitor_Device_Info mdv = this.monitor_manager.device_list.Where(o => o.gateway_id == GateWayID && o.device_id == DeviceID).FirstOrDefault();
if (mdv != null)
{
if (rc.Cmd_Result == "OK")
{
mdv.device_status = "Idle";
mdv.hb_status = "Idle";
mdv.hb_report_time = DateTime.ParseExact(rc.Trace_ID, "yyyyMMddHHmmssfff", CultureInfo.InvariantCulture);
}
else
{
mdv.device_status = "Down";
mdv.hb_status = "Down";
mdv.hb_report_time = DateTime.ParseExact(rc.Trace_ID, "yyyyMMddHHmmssfff", CultureInfo.InvariantCulture);
}
log_msg.message = "ReadData Ack Result = " + rc.Cmd_Result;
}
else
{
log_msg.message = "Cannot find monitor information!";
}
_logger.LogInformation(log_msg.get_log_message());
SaveMonitorInformation(GateWayID, DeviceID);
}
private bool LoadGatewayConfig()
{
try
{
cls_LogMessage log_msg = new cls_LogMessage("INFO", "MonitorService", "LoadGatewayConfig", "");
if (!File.Exists(this.service_initial.ccs_gateway_config_path))
{
//Console.WriteLine("No Gateway Congatefig file exists!");
log_msg.message = "No Gateway Congatefig file exists!";
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
StreamReader inputFile = new StreamReader(this.service_initial.ccs_gateway_config_path);
string json_string = inputFile.ReadToEnd();
this.gw_manager = JsonConvert.DeserializeObject <GateWayManager>(json_string);
if (this.gw_manager.gateway_list == null)
{
//Console.WriteLine("No Gateway config exists!");
log_msg.message = "No Gateway config exists!";
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
inputFile.Close();
log_msg.message = "Load Gateway Config File Successful";
_logger.LogInformation(log_msg.get_log_message());
}
catch (Exception ex)
{
//Console.WriteLine("Gateway Config file loading error -> " + ex.Message);
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "LoadGatewayConfig", "Exception: " + ex.Message);
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
return(true);
}
private bool LoadInitial()
{
try
{
cls_LogMessage log_msg = new cls_LogMessage("INFO", "MonitorService", "LoadInitial", "No Service Initial file exists!");
if (!File.Exists("C:\\Gateway\\Config\\Monitor_Service_Init.json"))
{
//Console.WriteLine("No Service Initial file exists!");
log_msg.message = "No Service Initial file exists!";
_logger.LogInformation(log_msg.get_log_message());
this.service_initial = new cls_MonitorServiceInitial();
return(false);
}
StreamReader inputFile = new StreamReader("C:\\Gateway\\Config\\Monitor_Service_Init.json");
string json_string = inputFile.ReadToEnd();
this.service_initial = JsonConvert.DeserializeObject <cls_MonitorServiceInitial>(json_string);
if (this.service_initial == null)
{
//Console.WriteLine("No Initial config exists!");
log_msg.message = "No Initial config exists!";
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
inputFile.Close();
log_msg.message = "Load Initial File Successful";
_logger.LogInformation(log_msg.get_log_message());
}
catch (Exception ex)
{
//Console.WriteLine("Service Initial file loading error -> " + ex.Message);
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "LoadInitial", "Exception: " + ex.Message);
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
return(true);
}
public void ConfigAck(xmlMessage InputData)
{
if (!gw_info_loaded)
{
return;
}
// Parse Mqtt Topic
string[] Topic = InputData.MQTTTopic.Split('/'); // /IEW/GateWay/Device/Cmd/Config/Ack
string GateWayID = Topic[2].ToString();
string DeviceID = Topic[3].ToString();
cls_LogMessage log_msg = new cls_LogMessage("MQTT", GateWayID, DeviceID, "Receive Config Ack");
_logger.LogInformation(log_msg.get_log_message());
cls_ConfigAck ca = new cls_ConfigAck();
ca = JsonConvert.DeserializeObject <cls_ConfigAck>(InputData.MQTTPayload.ToString());
cls_Monitor_Device_Info mdv = this.monitor_manager.device_list.Where(o => o.gateway_id == GateWayID && o.device_id == DeviceID).FirstOrDefault();
if (mdv != null)
{
if (ca.Cmd_Result == "OK")
{
mdv.iotclient_status = "Ready";
}
else
{
mdv.iotclient_status = "Off";
}
log_msg.message = "Config Ack Result = " + ca.Cmd_Result;
}
else
{
log_msg.message = "Cannot find monitor information!";
}
_logger.LogInformation(log_msg.get_log_message());
SaveMonitorInformation(GateWayID, DeviceID);
}
public void ReceiveAlarm(xmlMessage InputData)
{
//_alarm_logger.LogWarning("Receive Alarm message!!");
if (!gw_info_loaded)
{
return;
}
// Parse Mqtt Topic
string[] Topic = InputData.MQTTTopic.Split('/'); // /IEW/GateWay/Device/Status/Alarm
string GateWayID = Topic[2].ToString();
string DeviceID = Topic[3].ToString();
cls_Alarm ca = new cls_Alarm();
ca = JsonConvert.DeserializeObject <cls_Alarm>(InputData.MQTTPayload.ToString());
cls_LogMessage log_msg = new cls_LogMessage("Alarm", GateWayID, DeviceID, ca.AlarmDesc);
log_msg.alarm_app = ca.AlarmApp;
log_msg.alarm_code = ca.AlarmCode;
log_msg.alarm_level = ca.AlarmLevel;
cls_Monitor_Device_Info mdv = this.monitor_manager.device_list.Where(o => o.gateway_id == GateWayID && o.device_id == DeviceID).FirstOrDefault();
if (mdv != null)
{
mdv.last_alarm_code = ca.AlarmCode;
mdv.last_alarm_app = ca.AlarmApp;
mdv.last_alarm_datetime = DateTime.ParseExact(ca.DateTime, "yyyyMMddHHmmssfff", CultureInfo.InvariantCulture);
mdv.last_alarm_message = ca.AlarmDesc;
}
else
{
log_msg.message = "Cannot find monitor information!";
}
_alarm_logger.LogWarning(log_msg.get_log_message());
SaveMonitorInformation(GateWayID, DeviceID);
}
public void ReceiveHeartBeat(xmlMessage InputData)
{
if (!gw_info_loaded)
{
return;
}
// Parse Mqtt Topic
string[] Topic = InputData.MQTTTopic.Split('/'); // /IEW/GateWay/Device/Status/HeartBeat
string GateWayID = Topic[2].ToString();
string DeviceID = Topic[3].ToString();
cls_LogMessage log_msg = new cls_LogMessage("MQTT", GateWayID, DeviceID, "Receive Heart Beat");
_logger.LogInformation(log_msg.get_log_message());
cls_HeartBeat hb = new cls_HeartBeat();
hb = JsonConvert.DeserializeObject <cls_HeartBeat>(InputData.MQTTPayload.ToString());
cls_Monitor_Device_Info mdv = this.monitor_manager.device_list.Where(o => o.gateway_id == GateWayID && o.device_id == DeviceID).FirstOrDefault();
if (mdv != null)
{
mdv.device_status = hb.Status;
mdv.hb_status = hb.Status;
mdv.hb_report_time = DateTime.ParseExact(hb.HBDatetime, "yyyyMMddHHmmssfff", CultureInfo.InvariantCulture);
log_msg.message = "HB Status = " + hb.Status;
}
else
{
log_msg.message = "Cannot find monitor information!";
}
_logger.LogInformation(log_msg.get_log_message());
SaveMonitorInformation(GateWayID, DeviceID);
}
private bool BuildMonitorInformationFromFile()
{
//Build Monitor Status file
try
{
string json_string;
cls_LogMessage log_msg = new cls_LogMessage("INFO", "MonitorService", "BuildMInfoFromFile", "");
if (!File.Exists(this.service_initial.monitor_status_path))
{
//FileStream fs = File.Create(this.service_initial.monitor_status_path);
//fs.Close();
log_msg.message = "Monitor Status file does not exist";
_logger.LogInformation(log_msg.get_log_message());
if (this.gw_manager.gateway_list.Count > 0)
{
foreach (cls_Gateway_Info gi in this.gw_manager.gateway_list)
{
if (gi.device_info.Count > 0)
{
foreach (cls_Device_Info di in gi.device_info)
{
cls_Monitor_Device_Info mdi = new cls_Monitor_Device_Info();
mdi.gateway_id = gi.gateway_id;
mdi.device_id = di.device_name;
mdi.virtual_flag = gi.virtual_flag;
mdi.device_type = di.device_type;
mdi.device_status = "Off";
mdi.iotclient_status = "Off";
mdi.hb_status = "Off";
mdi.plc_ip = di.plc_ip_address;
mdi.plc_port = di.plc_port_id;
mdi.device_location = di.device_location;
this.monitor_manager.device_list.Add(mdi);
}
}
}
}
}
else
{
log_msg.message = "Monitor Status file exists";
_logger.LogInformation(log_msg.get_log_message());
StreamReader inputFile = new StreamReader(this.service_initial.monitor_status_path);
json_string = inputFile.ReadToEnd();
inputFile.Close();
this.monitor_manager = JsonConvert.DeserializeObject <MonitorManager>(json_string);
if (this.gw_manager.gateway_list.Count > 0)
{
foreach (cls_Gateway_Info gi in this.gw_manager.gateway_list)
{
if (gi.device_info.Count > 0)
{
foreach (cls_Device_Info di in gi.device_info)
{
cls_Monitor_Device_Info mdi = this.monitor_manager.device_list.Where(p => (p.gateway_id == gi.gateway_id) && (p.device_id == di.device_name)).FirstOrDefault();
if (mdi == null)
{
cls_Monitor_Device_Info tmp = new cls_Monitor_Device_Info();
tmp.gateway_id = gi.gateway_id;
tmp.device_id = di.device_name;
tmp.virtual_flag = gi.virtual_flag;
tmp.device_type = di.device_type;
tmp.device_status = "Off";
tmp.iotclient_status = "Off";
tmp.hb_status = "Off";
tmp.plc_ip = di.plc_ip_address;
tmp.plc_port = di.plc_port_id;
tmp.device_location = di.device_location;
this.monitor_manager.device_list.Add(tmp);
}
}
}
}
}
}
json_string = JsonConvert.SerializeObject(this.monitor_manager, Newtonsoft.Json.Formatting.Indented);
StreamWriter output = new StreamWriter(this.service_initial.monitor_status_path);
output.Write(json_string);
output.Close();
log_msg.message = "Build Monitor Info Successful";
_logger.LogInformation(log_msg.get_log_message());
return(true);
}
catch (Exception ex)
{
//Console.WriteLine("Build Monitor Status file failed -> " + ex.Message);
cls_LogMessage log_msg = new cls_LogMessage("ERROR", "MonitorService", "BuildMInfoFromFile", "Exception: " + ex.Message);
_logger.LogInformation(log_msg.get_log_message());
return(false);
}
}
