public string GetProcessStatus()
{
try
{
using (AppNetworkCafeEntities db = new AppNetworkCafeEntities())
{
var f5ServerPath = @"D:\Services\F5ReportService\bin\Debug\Logs\AreYouAlive.txt";
if (!System.IO.File.Exists(f5ServerPath))
{
using (StreamWriter outfile = new StreamWriter(f5ServerPath))
{
outfile.Write("check");
}
Thread.Sleep(5000);
}
var log = db.DebugLogs.Where(w => w.Source == "F5DownloadService" && w.LogContent == "F5DownloadService is alive").FirstOrDefault();
if (log != null)
{
db.Database.ExecuteSqlCommand("DELETE FROM DebugLog WHERE LogContent = 'F5DownloadService is alive'");
db.SaveChanges();
return("Running");
}
return("Not Running");
}
}
catch (Exception)
{
return("Cannot Connect");
}
}
public static string GetSiteSettingValue(string dbName, string settingName)
{
if (dbName.ToLower() == "networkcafe")
{
using (AppNetworkCafeEntities Db = new AppNetworkCafeEntities())
{
var settingValue = Db.Database.SqlQuery <string>("SELECT TOP 1 SettingValue FROM SiteSettings WHERE SettingName = '" + settingName + "'").FirstOrDefault();
return(settingValue);
}
}
else if (dbName.ToLower() == "pmm")
{
using (AppPMMEntities Db = new AppPMMEntities())
{
var settingValue = Db.Database.SqlQuery <string>("SELECT TOP 1 SettingValue FROM SiteSettings WHERE SettingName = '" + settingName + "'").FirstOrDefault();
return(settingValue);
}
}
return("");
}
