public static bool AccountExists(string accountName) { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { return(db.Accounts.Any(x => x.AccountName.Equals((accountName)))); } }
public static string GetConfigValue(string key) { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { return(db.Configurations.Where(x => x.Key.Equals(key)).Select(x => x.Value).FirstOrDefault()); } }
public static DateTime GetAccountTimestamp(string accountName) { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { return(db.Accounts.Where(x => x.AccountName == accountName).Select(y => y.Timestamp).FirstOrDefault()); } }
public static bool TestConnection() { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { try { db.Database.Connection.Open(); return(true); } catch (System.Data.SqlClient.SqlException e) { return(false); } } }
public static string GetResponderEmailAddress(int?responderId, AppConfiguration config) { try { if (responderId == null) { return(config.EMAIL_CC); } using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { return(db.Responders.Where(x => x.ResponderId == responderId).Select(y => y.EmailAddress).FirstOrDefault()); } } catch (InvalidOperationException) { throw; } }
public static void SetConfigValue(string key, string value) { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { if (!db.Configurations.Any(x => x.Key.Equals(key))) { Configuration config = new Configuration { Key = key, Value = value }; db.Configurations.Add(config); } else { Configuration config = db.Configurations.Where(x => x.Key.Equals(key)).FirstOrDefault(); config.Value = value; } db.SaveChanges(); } }
public static int GetNextDetectionID() { try { using (FalconOrchestratorDB db = new FalconOrchestratorDB()) { Detection result = db.Detections.OrderByDescending(x => x.DetectionId).FirstOrDefault(); if (result == null) { return(1); } else { return((int)result.DetectionId + 1); } } } catch (InvalidOperationException) { throw; } }