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