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