//
// GET: /Monitoring/SummaryReport/SearchMonitoringReport
public ActionResult SearchMonitoringReport(JQueryDataTableParamModel param, DateTime?txtStartEventDate, DateTime?txtEndEventDate
, string txtClientCode, string txtLocation, string ddlMessageGroup, string txtMessage, string ddlMessageStatus, int?clientID)
{
//JQueryDataTableParamModel param = new JQueryDataTableParamModel();
//HttpContext Context = System.Web.HttpContext.Current;
//param.sEcho = String.IsNullOrEmpty(Context.Request["sEcho"]) ? "0" : Context.Request["sEcho"];
//param.sSearch = String.IsNullOrEmpty(Context.Request["sSearch"]) ? "" : Context.Request["sSearch"];
//param.iDisplayStart = String.IsNullOrEmpty(Context.Request["iDisplayStart"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayStart"]);
//param.iDisplayLength = String.IsNullOrEmpty(Context.Request["iDisplayLength"]) ? 0 : Convert.ToInt32(Context.Request["iDisplayLength"]);
var sortColumnIndex = Convert.ToInt32(Request["iSortCol_0"]);
var sortDirection = Request["sSortDir_0"]; // asc or desc
param.iSortColumn = (Request["mDataProp_" + sortColumnIndex] + "_" + sortDirection).ToLower();
if (!string.IsNullOrEmpty(ddlMessageStatus) && ddlMessageStatus.Split(',').Any(m => m == ""))
{
ddlMessageStatus = "";
}
try
{
var serviceClient = new RMS.Centralize.WebSite.Proxy.SummaryReportService().summaryReportService;
var result = serviceClient.SearchSummaryMonitoring(param, txtStartEventDate, txtEndEventDate, txtClientCode, txtLocation
, ddlMessageGroup, txtMessage, ddlMessageStatus, clientID);
int?totalRecords = 0;
totalRecords = result.TotalRecords;
var data = new
{
sEcho = param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = result.ListSummaryMonitorings,
status = (result.IsSuccess) ? 1 : 0,
error = result.ErrorMessage
};
return(Json(data));
}
catch (Exception ex)
{
var data = new
{
status = 0,
error = ex.Message
};
new RMSWebException(this, "0500", "SearchMonitoringReport failed. " + ex.Message, ex, true);
return(Json(data));
}
}
// GET: /Monitoring/SummaryReport/GetClientInfo/
public ActionResult GetClientInfo(int?id)
{
try
{
if (id == null)
{
throw new ArgumentNullException("ClientID");
}
}
catch (ArgumentNullException ex)
{
new RMSWebException(this, "0500", "GetClientInfo failed. " + ex.Message, ex, true);
throw;
}
try
{
var service = new RMS.Centralize.WebSite.Proxy.SummaryReportService().summaryReportService;
var result = service.GetClientInfo(id.Value);
var ret = new
{
status = (result.IsSuccess) ? 1 : 0,
ClientID = result.Client.ClientID,
data = JsonConvert.SerializeObject(result.Client, Formatting.Indented, new JsonSerializerSettings()
{
ReferenceLoopHandling = ReferenceLoopHandling.Ignore
})
};
return(Json(ret));
}
catch (Exception ex)
{
var ret = new
{
status = -1,
error = ex.Message
};
new RMSWebException(this, "0500", "GetClientInfo failed. " + ex.Message, ex, true);
return(Json(ret));
}
}
// GET: /Monitoring/SummaryReport/ResendAction
public ActionResult ResendAction(ActionSendServiceActionSendType sentType, long?id)
{
if (id == null)
{
var idError = new
{
status = 0,
error = "ID cannot be null."
};
return(Json(idError));
}
try
{
var service = new RMS.Centralize.WebSite.Proxy.SummaryReportService().summaryReportService;
var actionRequest = service.ActionRequest(sentType, id.Value);
var ret = new
{
status = actionRequest.IsSuccess,
error = actionRequest.ErrorMessage
};
return(Json(ret));
}
catch (Exception ex)
{
var exError = new
{
status = 0,
error = ex.Message
};
new RMSWebException(this, "0500", "ResendAction failed. " + ex.Message, ex, true);
return(Json(exError));
}
}
// GET: /Monitoring/SummaryReport/SearchSummaryStatusAllClients/
public ActionResult SearchSummaryStatusAllClients(string txtClientCode, string txtLocation, int?ddlMonitoringStatus)
{
try
{
var service = new RMS.Centralize.WebSite.Proxy.SummaryReportService().summaryReportService;
var result = service.SearchSummaryStatusAllClients();
for (int i = 2; i < 50; i++)
{
SummaryStatusAllClientsInfo tmp = new SummaryStatusAllClientsInfo();
tmp.ClientID = 1;
tmp.ClientCode = "K1404-" + i.ToString().PadLeft(3, '0');
tmp.CounterOK = 16;
tmp.CounterNotOK = 0;
tmp.iRMSStatus = 10;
tmp.sRMSStatus = "RMS is up";
tmp.LocationName = "อาคารสำนักงานใหญ่ 2";
if (i == 21 || i == 32)
{
tmp.CounterOK = 15;
tmp.CounterNotOK = 1;
tmp.iRMSStatus = 0;
tmp.sRMSStatus = "RMS is down";
tmp.OldestErrorMessageDateTime = DateTime.Now.AddDays(-i);
}
if (i == 49 || i == 84)
{
tmp.CounterOK = 14;
tmp.CounterNotOK = 2;
tmp.OldestErrorMessageDateTime = DateTime.Now.AddDays(-i);
}
result.ListSummaryStatusAllClientsInfos.Add(tmp);
}
if (ddlMonitoringStatus != null && ddlMonitoringStatus == 1)
{
result.ListSummaryStatusAllClientsInfos =
new List <SummaryStatusAllClientsInfo>(
result.ListSummaryStatusAllClientsInfos.Where(
w => w.CounterNotOK > 0 || (w.iRMSStatus >= 0 && w.iRMSStatus < 10) || w.iRMSStatus >= 30));
}
List <SummaryStatusAllClientsInfo> newOrder = new List <SummaryStatusAllClientsInfo>();
newOrder.AddRange(result.ListSummaryStatusAllClientsInfos.Where(w => (w.iRMSStatus >= 0 && w.iRMSStatus < 10) || w.CounterNotOK > 0).OrderBy(o => o.OldestErrorMessageDateTime).ThenBy(o => o.ClientCode));
newOrder.AddRange(result.ListSummaryStatusAllClientsInfos.Where(w => !((w.iRMSStatus >= 0 && w.iRMSStatus < 10) || w.CounterNotOK > 0)).OrderBy(o => o.ClientCode));
result.ListSummaryStatusAllClientsInfos = newOrder;
var ret = new
{
status = (result.IsSuccess) ? 1 : 0,
error = result.ErrorMessage,
data = result.ListSummaryStatusAllClientsInfos
};
return(Json(ret));
}
catch (Exception ex)
{
var ret = new
{
status = -1,
error = ex.Message
};
new RMSWebException(this, "0500", "SearchSummaryStatusAllClients failed. " + ex.Message, ex, true);
return(Json(ret));
}
}
// GET: /Monitoring/SummaryReport/GetCurrentDeviceStatus
public ActionResult GetCurrentDeviceStatus(JQueryDataTableParamModel param, int?clientID)
{
param.iSortColumn = null;
try
{
if (clientID == null)
{
var ret = new
{
status = 0,
error = "Client ID cannot be null."
};
return(Json(ret));
}
var serviceClient = new RMS.Centralize.WebSite.Proxy.ClientService().clientService;
var clientResult = serviceClient.GetClient(GetClientBy.ClientID, clientID, null, null, true, false);
if (clientResult != null && clientResult.IsSuccess && clientID != null)
{
var service = new RMS.Centralize.WebSite.Proxy.SummaryReportService().summaryReportService;
var result = service.SearchSummaryMonitoring(param, null, null, null, null
, null, null, "1", clientID);
List <DeviceStatus> lDeviceStatuses = new List <DeviceStatus>();
foreach (var monitoringProfileDevice in clientResult.ListMonitoringProfileDevices)
{
RmsMonitoringProfileDevice device = monitoringProfileDevice;
if (result.ListSummaryMonitorings == null)
{
result.ListSummaryMonitorings = new List <ReportSummaryMonitoring>();
}
var summaryMonitorings = result.ListSummaryMonitorings.Where(smg => smg.MonitoringProfileDeviceId == device.MonitoringProfileDeviceId);
List <ReportSummaryMonitoring> lReports = new List <ReportSummaryMonitoring>(summaryMonitorings.ToList());
// ถ้าเจอ แสดงว่า ไม่ปกติ
if (lReports.Count > 0)
{
foreach (var report in lReports)
{
int?deviceTypeID = FindDeviceTypeIDByDeviceID(clientResult.ListDevices, report.DeviceId);
var dt = clientResult.ListDeviceType.First(t => t.DeviceTypeId == deviceTypeID);
if (dt != null)
{
DeviceStatus ds = new DeviceStatus(report.Id, dt.DeviceTypeId, dt.DeviceType, dt.DisplayOrder,
device.DeviceDescription
, report.Status, report.MessageId, report.Message, report.MessageRemark, report.MonitoringProfileDeviceId
, report.LastActionDateTime, report.LastActionType, report.LevelName
, report.ColorCode, report.ColorTagStart, report.ColorTagEnd, report.MessageDateTime);
lDeviceStatuses.Add(ds);
}
}
}
// ถ้าไม่พบ แสดงว่า อุปกรณ์ปกติ ให้ใส่ dummy data
else
{
int?deviceTypeID = FindDeviceTypeIDByDeviceID(clientResult.ListDevices, device.DeviceId);
var dt = clientResult.ListDeviceType.First(t => t.DeviceTypeId == deviceTypeID);
if (dt != null)
{
DeviceStatus ds = new DeviceStatus(0, dt.DeviceTypeId, dt.DeviceType, dt.DisplayOrder,
device.DeviceDescription, 0, 0, "Good", null, device.MonitoringProfileDeviceId, null, null, null, "success", "<span class=\"label label-success\">", "</span>", null);
lDeviceStatuses.Add(ds);
}
}
}
lDeviceStatuses = new List <DeviceStatus>(lDeviceStatuses.OrderBy(o => o.DisplayOrder).ThenBy(o => o.DeviceDescription).ThenBy(o => o.MessageDateTime));
string deviceName = "";
foreach (var deviceStatus in lDeviceStatuses)
{
if (deviceStatus.DeviceDescription == deviceName)
{
deviceStatus.DeviceDescription = "";
continue;
}
deviceName = deviceStatus.DeviceDescription;
}
int?totalRecords = 0;
totalRecords = lDeviceStatuses.Count;
var data = new
{
sEcho = param.sEcho,
iTotalRecords = totalRecords,
iTotalDisplayRecords = totalRecords,
aaData = lDeviceStatuses,
status = (result.IsSuccess) ? 1 : 0,
error = result.ErrorMessage
};
return(Json(data));
}
var data2 = new
{
status = 0,
error = "Client Not Found"
};
return(Json(data2));
}
catch (Exception ex)
{
var data = new
{
status = 0,
error = ex.Message
};
new RMSWebException(this, "0500", "GetCurrentDeviceStatus failed. " + ex.Message, ex, true);
return(Json(data));
}
}
