public static bool HasKey(string key) { try { return(SQLiteDataAccess.GetDataTable("Select key from APIKeys where key=@param1", CommandType.Text, null, new SQLiteParameter("@param1", key)).Rows.Count != 0); } catch (Exception ex) { //Let IIS handle the errors, but using own logging. Loggers.Log(Level.Error, "Failed getting API key from database", ex, new object[] { key }); throw; } }
public static VMwareHostSystemInformation Get(string ipOrHostname) { try { var dt = SQLiteDataAccess.GetDataTable("Select * from VMwareHostSystemInformations where ipOrHostname=@param1", CommandType.Text, null, new SQLiteParameter("@param1", ipOrHostname)); if (dt.Rows.Count == 0) { return(null); } return(Parse(dt.Rows[0])); } catch (Exception ex) { //Let IIS handle the errors, but using own logging. Loggers.Log(Level.Error, "Failed retrieving vhost system info", ex, new object[] { ipOrHostname }); throw; } }
public static VMwareHostSystemInformation[] GetAll() { try { var dt = SQLiteDataAccess.GetDataTable("Select * from VMwareHostSystemInformations"); if (dt == null) { return(new VMwareHostSystemInformation[0]); } var all = new VMwareHostSystemInformation[dt.Rows.Count]; for (int i = 0; i != all.Length; i++) { all[i] = Parse(dt.Rows[i]); } return(all); } catch (Exception ex) { //Let IIS handle the errors, but using own logging. Loggers.Log(Level.Error, "Failed retrieving all vhost system info", ex); throw; } }