public static void UpdateGraphicsCardFirendlyName(Objects.GraphicsCard card) { switch (DataSaveMethod) { case 0: DataHelper.MySQLHelper.UpdateGraphicsCardFirendlyName(card); break; case 1: DataHelper.sqliteHelper.UpdateGraphicsCardFirendlyName(card); break; } }
public static void UpdateGraphicsCardFirendlyName(Objects.GraphicsCard card) { MySqlConnection m_cn = new MySqlConnection(connectionstring); MySqlCommand cmd = new MySqlCommand("UpdateGraphicsCardFirendlyName", m_cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("?F_NAME", card.FriendlyName); cmd.Parameters["?F_NAME"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?UU_ID", card.GUID); cmd.Parameters["?UU_ID"].Direction = ParameterDirection.Input; m_cn.Open(); cmd.ExecuteNonQuery(); m_cn.Close(); }
public static string GetGraphicsCardDetailsString(Objects.MiningRig rig, Objects.GraphicsCard card) { dynamic CardInfo = DataHelper.ExcavatorSocket.Client(rig, 0, "device.get", new string[] { card.ID.ToString() }); return(string.Format("DeviceName:\t{0}" + "\tTemp:\t{1}" + "\tLoad:\t{2}" + "\tPower (Watts):" + "\t{3}", CardInfo.name, CardInfo.gpu_temp, CardInfo.gpu_load, CardInfo.gpu_power_usage)); }
public static string CreateOrUpdateGraphicsCard(Objects.GraphicsCard cardInfo) { switch (DataSaveMethod) { case 0: return(DataHelper.MySQLHelper.CreateOrUpdateGraphicsCard(cardInfo)); break; case 1: return(DataHelper.sqliteHelper.CreateOrUpdateGraphicsCard(cardInfo)); } return(""); }
public static string CreateOrUpdateGraphicsCard(Objects.GraphicsCard cardInfo) { string sql; string FriendlyName = GetSingleValue("GraphicsCard", "FriendlyName", String.Format("Where uuid = '{0}'", cardInfo.GUID)); if (FriendlyName == null) { sql = string.Format("insert into GraphicsCard (uuid, RigID, Name, DeviceID) Values('{0}',{1},'{2}',{3})", cardInfo.GUID, cardInfo.RigID, cardInfo.DeviceName, cardInfo.ID); } else { sql = string.Format("update GraphicsCard set RigID = {0}, Name = '{1}',DeviceID = {2} where uuid = '{3}'", cardInfo.RigID, cardInfo.DeviceName, cardInfo.ID, cardInfo.GUID); } ProcessSQLNonQuery(sql); return(FriendlyName); }
public static List <Objects.GraphicsCard> GetGraphicsCardDataForRig(Objects.MiningRig rig) { List <Objects.GraphicsCard> cards = new List <Objects.GraphicsCard>(); dynamic deviceList = DataHelper.ExcavatorSocket.Client(rig, 0, "device.list", new string[0]); if (deviceList != null) { foreach (dynamic device in deviceList.devices) { Objects.GraphicsCard card = new Objects.GraphicsCard(); card.ID = device.device_id; card.DeviceName = device.name; FillExtraGCDetails(rig, card); card.RigID = rig.ID; cards.Add(card); } } return(cards); }
public static string CreateOrUpdateGraphicsCard(Objects.GraphicsCard cardInfo) { MySqlConnection m_cn = new MySqlConnection(connectionstring); MySqlCommand cmd = new MySqlCommand("createOrUpdateGraphicsCard", m_cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("?Rig_ID", cardInfo.RigID); cmd.Parameters["?Rig_ID"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?UU_ID", cardInfo.GUID); cmd.Parameters["?UU_ID"].Direction = ParameterDirection.Input; cmd.Parameters.AddWithValue("?GC_NAME", cardInfo.DeviceName); cmd.Parameters["?GC_NAME"].Direction = ParameterDirection.Input; cmd.Parameters.Add("?F_NAME", MySqlDbType.VarChar); cmd.Parameters["?F_NAME"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("?D_ID", cardInfo.ID); cmd.Parameters["?D_ID"].Direction = ParameterDirection.Input; m_cn.Open(); cmd.ExecuteNonQuery(); m_cn.Close(); return(cmd.Parameters["?F_NAME"].Value.ToString()); }
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); }
public static void FillExtraGCDetails(Objects.MiningRig rig, Objects.GraphicsCard card) { dynamic CardInfo = DataHelper.ExcavatorSocket.Client(rig, 0, "device.get", new string[] { card.ID.ToString() }); card.GUID = CardInfo.uuid; }
public static void UpdateGraphicsCardFirendlyName(Objects.GraphicsCard card) { string sql = String.Format("Update GraphicsCard set FriendlyName = '{0}' where uuid = '{1}'", card.FriendlyName, card.GUID); ProcessSQLNonQuery(sql); }