public int SaveMonitorMap(MonitorMap entity)
{
if (entity == null)
{
return(0);
}
if (entity.Id > 0)
{
var tracked = context.MonitorMaps.Find(entity.Id);
if (tracked == null)
{
return(0);
}
else
{
context.Entry(tracked).CurrentValues.SetValues(entity);
entity = tracked;
}
}
else
{
entity = context.MonitorMaps.Add(entity);
}
return(context.SaveChanges());
}
public void MonitorDb(MonitorMap source)
{
using (var con = new SqlConnection(source.DestinationCon))
{
con.Open();
var sql = "select count(*) from " + source.DestinationAddress;
if (!string.IsNullOrEmpty(source.DestinationFilter))
{
sql = sql + "where " + source.DestinationFilter.Replace("{LastSyncTime}", _lastDate);
}
var cmd = new SqlCommand(sql, con);
var count = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
Log.Append("" + count + "");
}
}
public void MonitorFtp(MonitorMap source)
{
var parentdi = new DirectoryInfo(source.DestinationAddress);
if (!parentdi.Exists)
{
parentdi.Create();
}
var date = Convert.ToDateTime(_lastDate);
Log.Append("downLoad files: ");
foreach (FileInfo fi in parentdi.GetFiles())
{
if (fi.CreationTime > date)
{
Log.Append(fi.Name + " ");
}
}
Log.Append(";");
}
private int SaveMap(List <MonitorMap> mapList, int systemId, int startX, int startY, int scale, MapSize size, HttpPostedFileBase uploadedFile)
{
var tracked = mapList.FirstOrDefault(x => x.MonitorSystemId == systemId && x.SizeType == (int)size);
if (tracked == null)
{
tracked = new MonitorMap {
MonitorSystemId = systemId,
SizeType = (int)size,
Name = "",
DisplayName = ""
};
}
tracked.StartX = startX;
tracked.StartY = startY;
tracked.Scale = scale;
if (uploadedFile != null && uploadedFile.ContentLength > 0)
{
var ext = Path.GetExtension(uploadedFile.FileName);
var mapName = string.Format("Map_{0}_{1}{2}", systemId, (int)size, ext);
var displayName = Path.GetFileName(uploadedFile.FileName);
var filePath = "";
if (!string.IsNullOrEmpty(tracked.Name))
{
filePath = Path.Combine(HttpContext.Server.MapPath("~/Images"), tracked.Name);
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
}
filePath = Path.Combine(HttpContext.Server.MapPath("~/Images"), mapName);
uploadedFile.SaveAs(filePath);
tracked.Name = mapName;
tracked.DisplayName = displayName;
}
return(_dao.SaveMonitorMap(tracked));
}
public static NonEscapedString Render(HtmlHelper helper, string selectedCategory, MonitorMap map) => helper.RenderPartial(new SidebarControlFromMonitor(selectedCategory, map));
public SidebarControlFromMonitor(string selectedCategory, MonitorMap map)
{
SelectedCategory = selectedCategory;
Map = map;
}
public Monitor LoadMonitorInfo(XmlNode node)
{
var monitor = new Monitor();
var jobType = node.SelectSingleNode("JobType");
if (jobType == null || string.IsNullOrEmpty(jobType.InnerText))
{
throw new Exception("Cannot find jobType info under the node: " + node);
}
monitor.JobType = jobType.InnerText;
var triggerInterval = node.SelectSingleNode("TriggerInterval");
if (triggerInterval == null || string.IsNullOrEmpty(triggerInterval.InnerText))
{
throw new Exception("Cannot find triggerInterval info under the node: " + node);
}
monitor.TriggerInterval = triggerInterval.InnerText;
var nodes = node.SelectNodes("mappings/table-mapping");
if (nodes != null)
{
monitor.Mappings = new List <MonitorMap>();
foreach (XmlNode node1 in nodes)
{
var map = new MonitorMap();
var source = node1.SelectSingleNode("source");
if (source != null)
{
map.Source = source.InnerText;
}
var dataProvider = node1.SelectSingleNode("DataProvider");
if (dataProvider != null)
{
map.DataProvider = dataProvider.InnerText;
}
var description = node1.SelectSingleNode("description");
if (description != null)
{
map.Description = description.InnerText;
}
var selectSingleNode1 = node1.SelectSingleNode("destination/type");
if (selectSingleNode1 != null)
{
map.DestinationType = selectSingleNode1.InnerText;
}
var singleNode1 = node1.SelectSingleNode("destination/address");
if (singleNode1 != null)
{
map.DestinationAddress = singleNode1.InnerText;
if (singleNode1.Attributes != null)
{
if (singleNode1.Attributes["con"] != null)
{
map.DestinationCon = singleNode1.Attributes["con"].InnerText;
}
if (singleNode1.Attributes["filter"] != null)
{
map.DestinationFilter = singleNode1.Attributes["filter"].InnerText;
}
}
}
monitor.Mappings.Add(map);
}
}
return(monitor);
}
public override void Execute()
{
WriteLiteral("\r\n");
WriteLiteral("\r\n");
#line 10 "..\..\Dashboard\MonitorPage.cshtml"
Layout = new LayoutPage(Strings.MonitorPage_Title);
string selectedCategory = this.SelectedCategory;
MonitorMap jobMap = this.Map;
JobKitOptions options = this.Options;
var availableJobs = jobMap.JobCollection.ContainsKey(selectedCategory)
? jobMap.JobCollection[selectedCategory]
: new List <MonitorJob>();
var format = selectedCategory == "Daily"
? "HH:mm" : "MM-dd HH:mm";
#line default
#line hidden
WriteLiteral("\r\n<script type=\"text/javascript\">\r\n \r\n</script>\r\n\r\n<div class=\"row\">\r\n <div" +
" class=\"col-md-3\">\r\n ");
#line 33 "..\..\Dashboard\MonitorPage.cshtml"
Write(SidebarControlFromMonitor.Render(Html, selectedCategory, jobMap));
#line default
#line hidden
WriteLiteral("\r\n </div>\r\n <h1 class=\"page-header\">");
#line 35 "..\..\Dashboard\MonitorPage.cshtml"
Write(this.SelectedCategoryText);
#line default
#line hidden
#line 35 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Title);
#line default
#line hidden
WriteLiteral("</h1>\r\n <div class=\"col-md-9\">\r\n <div class=\"table-responsive\">\r\n " +
" <table class=\"table\">\r\n <thead>\r\n <tr>\r\n" +
" <th>");
#line 41 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_Name);
#line default
#line hidden
WriteLiteral("</th>\r\n <th class=\"min-width\">");
#line 42 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_Cron);
#line default
#line hidden
WriteLiteral("</th>\r\n <th>");
#line 43 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_Action);
#line default
#line hidden
WriteLiteral("</th>\r\n <th class=\"align-right min-width\">");
#line 44 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_ScheduleTime);
#line default
#line hidden
WriteLiteral("</th>\r\n <th class=\"align-right min-width\">");
#line 45 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_ExecutedTime);
#line default
#line hidden
WriteLiteral("</th>\r\n <th class=\"align-right min-width\">");
#line 46 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorPage_Table_Status);
#line default
#line hidden
WriteLiteral("</th>\r\n \r\n </tr>\r\n </the" +
"ad>\r\n <tbody>\r\n");
#line 51 "..\..\Dashboard\MonitorPage.cshtml"
foreach (var job in availableJobs.OrderBy(x => x.MonitorTime))
{
var jobStatus = job.GetStatus(Storage);
#line default
#line hidden
WriteLiteral(" <tr class=\"js-jobs-list-row hover\">\r\n " +
" <td class=\"word-break width-15\">");
#line 56 "..\..\Dashboard\MonitorPage.cshtml"
Write(job.Name);
#line default
#line hidden
WriteLiteral("</td>\r\n <td class=\"word-break width-15\"><code>");
#line 57 "..\..\Dashboard\MonitorPage.cshtml"
Write(job.Cron);
#line default
#line hidden
WriteLiteral("</code></td>\r\n <td class=\"align-right min-width\">");
#line 58 "..\..\Dashboard\MonitorPage.cshtml"
Write(job.ActionName);
#line default
#line hidden
WriteLiteral(" </td>\r\n <td class=\"align-right min-width\">");
#line 59 "..\..\Dashboard\MonitorPage.cshtml"
Write(job.MonitorTime.ToLocalTime().ToString(format));
#line default
#line hidden
WriteLiteral(" </td>\r\n <td class=\"align-right min-width\">");
#line 60 "..\..\Dashboard\MonitorPage.cshtml"
Write(jobStatus.ExecutedTime.HasValue ? jobStatus.ExecutedTime.Value.ToLocalTime().ToString(format) : "-");
#line default
#line hidden
WriteLiteral("</td>\r\n <td class=\"align-right min-width\">\r\n");
#line 62 "..\..\Dashboard\MonitorPage.cshtml"
switch (jobStatus.Status)
{
case MonitorJobStatus.Successed:
#line default
#line hidden
WriteLiteral(" <a href=\"");
#line 65 "..\..\Dashboard\MonitorPage.cshtml"
Write(Url.JobDetails(jobStatus.ExecutedJobId));
#line default
#line hidden
WriteLiteral("\">\r\n <span class=\"badge\" style=\"backgr" +
"ound-color:#198754;\">");
#line 66 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorStatus_Successed);
#line default
#line hidden
WriteLiteral("</span>\r\n </a>\r\n");
#line 68 "..\..\Dashboard\MonitorPage.cshtml"
break;
case MonitorJobStatus.Failed:
#line default
#line hidden
WriteLiteral(" <a href=\"");
#line 70 "..\..\Dashboard\MonitorPage.cshtml"
Write(Url.JobDetails(jobStatus.ExecutedJobId));
#line default
#line hidden
WriteLiteral("\">\r\n <span class=\"badge\" style=\"backgr" +
"ound-color:#dc3545;\">");
#line 71 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorStatus_Failed);
#line default
#line hidden
WriteLiteral("</span>\r\n </a>\r\n");
#line 73 "..\..\Dashboard\MonitorPage.cshtml"
break;
case MonitorJobStatus.Invalid:
#line default
#line hidden
WriteLiteral(" <a href=\"");
#line 75 "..\..\Dashboard\MonitorPage.cshtml"
Write(Url.JobDetails(jobStatus.ExecutedJobId));
#line default
#line hidden
WriteLiteral("\">\r\n <span class=\"badge\" style=\"backgr" +
"ound-color:#ffc107;color:#000000\">");
#line 76 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorStatus_Invalid);
#line default
#line hidden
WriteLiteral("</span>\r\n </a>\r\n");
#line 78 "..\..\Dashboard\MonitorPage.cshtml"
break;
case MonitorJobStatus.Unexecuted:
#line default
#line hidden
WriteLiteral(" <span class=\"badge\">");
#line 80 "..\..\Dashboard\MonitorPage.cshtml"
Write(Strings.MonitorStatus_Unexecuted);
#line default
#line hidden
WriteLiteral("</span>\r\n");
#line 81 "..\..\Dashboard\MonitorPage.cshtml"
break;
default:
#line default
#line hidden
#line 83 "..\..\Dashboard\MonitorPage.cshtml"
Write("-");
#line default
#line hidden
#line 83 "..\..\Dashboard\MonitorPage.cshtml"
break;
}
#line default
#line hidden
WriteLiteral("\r\n </td>\r\n </tr>\r\n");
#line 89 "..\..\Dashboard\MonitorPage.cshtml"
}
#line default
#line hidden
WriteLiteral(" </tbody>\r\n </table>\r\n </div>\r\n </div>\r\n</div" +
">\r\n");
}
public MonitorPage(string selectedCategory, MonitorMap map, JobKitOptions options)
{
SelectedCategory = selectedCategory;
Map = map;
Options = options;
}
