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(""); }