public static async Task <ControlQueue> FirstControlQueue(int controlId)
{
string query = $@"SELECT * FROM controlqueue
WHERE controlId = {controlId}
ORDER BY insertedAt ASC
LIMIT 1";
return((await MySQLService.Query(query, ControlQueue.FromReader)).FirstOrDefault());
}
public static async Task <int> UserIdByMetric(int metricId)
{
string query = $@"SELECT
u.chatId AS CHATID
FROM
user u JOIN device d ON d.userId = u.userId
JOIN metric m ON m.deviceId = d.deviceId
WHERE m.metricId = {metricId}";
return((await MySQLService.Query(query, reader => reader.GetInt32("CHATID"))).FirstOrDefault());
}
public static async Task <KeyValuePair <int, string> > ControlToken(int controlId)
{
string query = $@"SELECT
c.controlId AS CONTROL,
u.token AS TOKEN
FROM
user u JOIN device d ON d.userId = u.userId
JOIN control c ON c.deviceId = d.deviceId
WHERE c.controlId = {controlId}";
return((await MySQLService.Query(query, reader => new KeyValuePair <int, string>(reader.GetInt32("CONTROL"), reader.GetString("TOKEN")))).FirstOrDefault());
}
public static async Task <KeyValuePair <int, string> > MetricToken(int metricId)
{
string query = $@"SELECT
m.metricId AS METRIC,
u.token AS TOKEN
FROM
user u JOIN device d ON d.userId = u.userId
JOIN metric m ON m.deviceId = d.deviceId
WHERE m.metricId = {metricId}";
return((await MySQLService.Query(query, reader => new KeyValuePair <int, string>(reader.GetInt32("METRIC"), reader.GetString("TOKEN")))).FirstOrDefault());
}
public static Task <IEnumerable <Control> > ControlsByDevice(int deviceId)
{
return(MySQLService.Query($"SELECT * FROM Control WHERE deviceId = {deviceId}", Control.FromReader));
}
public static Task <IEnumerable <Metric> > MetricsByDevice(int deviceId)
{
return(MySQLService.Query($"SELECT * FROM metric WHERE deviceId = {deviceId}", Metric.FromReader));
}
public static Task <IEnumerable <Device> > DevicesByUser(int userId)
{
return(MySQLService.Query($"SELECT * FROM device WHERE userId = {userId}", Device.FromReader));
}
public static async Task <User> FindUserByUsername(string username)
{
return((await MySQLService.Query($"SELECT * FROM user WHERE username = '******';", User.FromDataReader)).FirstOrDefault());
}
public static Task <IEnumerable <Watch> > WatchesByMetric(int metricId)
{
return(MySQLService.Query($"SELECT * FROM Watch WHERE metricId = {metricId}", Watch.FromReader));
}
