public async Task CheckOldFilesFromDirectory(string folder, string mask, int time = -10)
{
//Montako tiedostoa löytyy, joihin ei ole koskettu {time} minuutin sisällä
if (String.IsNullOrEmpty(folder) || String.IsNullOrEmpty(mask))
{
throw new ArgumentNullException();
}
List <string> files = new List <string>(Directory.GetFiles(folder));
List <string> returnFiles = new List <string>();
foreach (string file in files)
{
FileInfo fi = new FileInfo(file);
if ((fi.LastWriteTime < DateTime.Now.AddMinutes(time)) && fi.Extension == mask)
{
Console.WriteLine(fi.Extension);
returnFiles.Add(file);
}
}
if (returnFiles.Count() > 0)
{
//jippii
}
else
{
WatchDogErrorModel wdError = new WatchDogErrorModel("CheckOldFilesFromDirectory", $"Method returned 0 files.", 50, DateTime.Now, folder, mask);
WatchDogHandler watchDogHandler = new WatchDogHandler(_hubContext);
await watchDogHandler.AddWatchDogErrorToDb(wdError);
}
}
public async Task AddWatchDogErrorToDb(WatchDogErrorModel wdError)
{
if (wdError == null)
{
throw new ArgumentNullException();
}
using (var context = new WatchDogErrorContext())
{
context.WatchDogErrors.Add(wdError);
context.SaveChanges();
await _hubContext.Clients.All.UpdateWatchDogErrors(context.WatchDogErrors.ToList());
}
}
public async Task CheckSqlQueries(string query)
{
//Kantakysely
if (String.IsNullOrEmpty(query))
{
throw new ArgumentNullException();
}
using (var context = new WatchDogErrorContext())
{
var errors = context.WatchDogErrors.FromSql(query).ToList();
//lisää ehto
WatchDogErrorModel wdError = new WatchDogErrorModel("CheckSqlQueries", $"Method returned 0 rows.", 50, DateTime.Now, query);
WatchDogHandler watchDogHandler = new WatchDogHandler(_hubContext);
await watchDogHandler.AddWatchDogErrorToDb(wdError);
}
}