public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric) { MySqlConnection m_cn = new MySqlConnection(connectionstring); MySqlCommand cmd = new MySqlCommand("insertGraphicsCardStat", m_cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("?C_UUID", metric.card.GUID); cmd.Parameters["?C_UUID"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?T_RECORDED", metric.TimeRecorded); cmd.Parameters["?T_RECORDED"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_TEMP", metric.Temprature); cmd.Parameters["?GC_TEMP"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_POWER", metric.Power); cmd.Parameters["?GC_POWER"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_USEAGE", metric.Power); cmd.Parameters["?GC_USEAGE"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_FANSPEED", metric.FanSpeedPercent); cmd.Parameters["?GC_FANSPEED"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_FANRPM", metric.FanSpeedRPM); cmd.Parameters["?GC_FANRPM"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?T_ELAPSED", metric.TimeElapsed); cmd.Parameters["?T_ELAPSED"].Direction = ParameterDirection.Input; m_cn.Open(); cmd.ExecuteNonQuery(); m_cn.Close(); }
public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric) { string sql = String.Format("insert into CardStats (CardUUID,Time,Temp,GPUUsage,Power,FanSpeedPercent,FanSpeedRPM,TimeRecorded)" + "values ('{0}',{1},{2},{3},{4},{5},{6},{7})", metric.card.GUID, metric.TimeElapsed, metric.Temprature, metric.GPUUsage, metric.Power, metric.FanSpeedPercent, metric.FanSpeedRPM, metric.TimeRecorded); ProcessSQLNonQuery(sql); }
public static void InsertGraphicsCardMetric(Objects.GraphicsCardMetrics metric) { switch (DataSaveMethod) { case 0: DataHelper.MySQLHelper.InsertGraphicsCardMetric(metric); break; case 1: DataHelper.sqliteHelper.InsertGraphicsCardMetric(metric); break; } }
public static Objects.GraphicsCardMetrics GetGraphicsCardMetric(Objects.MiningRig rig, Objects.GraphicsCard card, double timeElapsed) { dynamic CardInfo = DataHelper.ExcavatorSocket.Client(rig, 0, "device.get", new string[] { card.ID.ToString() }); Objects.GraphicsCardMetrics metric = new Objects.GraphicsCardMetrics(); metric.card = card; metric.FanSpeedPercent = CardInfo.gpu_fan_speed; metric.FanSpeedRPM = CardInfo.gpu_fan_speed_rpm; metric.GPUUsage = CardInfo.gpu_load; metric.Power = CardInfo.gpu_power_usage; metric.Temprature = CardInfo.gpu_temp; metric.TimeElapsed = timeElapsed; metric.TimeRecorded = rig.LastCheckTime; card.LastGPUMetric = metric; return(metric); }