public static uWiMP.TVServer.MPClient.Client GetClientByHostname(string hostname) { uWiMP.TVServer.MPClient.Client MPClient = new uWiMP.TVServer.MPClient.Client(); string connStr = ConfigurationManager.ConnectionStrings["uWiMPConnString"].ConnectionString; SQLiteConnection conn = new SQLiteConnection(connStr); SQLiteDataReader reader; SQLiteCommand cmd = new SQLiteCommand("SELECT Friendly, MACAddress, Port, UsesMovingPictures, UsesTVSeries FROM `MPClients` WHERE Hostname = $Hostname", conn); cmd.Parameters.Add("$Hostname", DbType.String, 255).Value = hostname.ToLower(); try { conn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { MPClient.Friendly = reader.GetString(0); MPClient.Hostname = hostname; MPClient.MACAddress = reader.GetString(1); MPClient.Port = reader.GetString(2); } } reader.Close(); } catch (SQLiteException ex) { return MPClient; } finally { conn.Close(); } return MPClient; }
public static List<uWiMP.TVServer.MPClient.Client> GetClients() { List<uWiMP.TVServer.MPClient.Client> mpclients = new List<uWiMP.TVServer.MPClient.Client>(); string connStr = ConfigurationManager.ConnectionStrings["uWiMPConnString"].ConnectionString; SQLiteConnection conn = new SQLiteConnection(connStr); SQLiteDataReader reader; SQLiteCommand cmd = new SQLiteCommand("SELECT Friendly FROM `MPClients`", conn); try { conn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { uWiMP.TVServer.MPClient.Client mpclient = new uWiMP.TVServer.MPClient.Client(); mpclient.Friendly = reader.GetString(0); mpclients.Add(mpclient); } } reader.Close(); } catch (SQLiteException ex) { return null; } finally { conn.Close(); } return mpclients; }
public static uWiMP.TVServer.MPClient.Client GetClient(string friendly) { uWiMP.TVServer.MPClient.Client MPClient = new uWiMP.TVServer.MPClient.Client(); string connStr = "Data Source=|DataDirectory|uWiMP.db;"; SQLiteConnection conn = new SQLiteConnection(connStr); SQLiteDataReader reader; SQLiteCommand cmd = new SQLiteCommand("SELECT Hostname, MACAddress, Port, UsesMovingPictures, UsesTVSeries FROM `MPClients` WHERE Friendly = $Friendly", conn); cmd.Parameters.Add("$Friendly", DbType.String, 255).Value = friendly.ToLower(); try { conn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { MPClient.Friendly = friendly; MPClient.Hostname = reader.GetString(0); MPClient.MACAddress = reader.GetString(1); MPClient.Port = reader.GetString(2); int usesMovingPictures = reader.GetInt32(3); int usesTVSeries = reader.GetInt32(4); if (reader.GetInt32(3) == 1) { MPClient.usesMovingPictures = true; } else { MPClient.usesMovingPictures = false; } if (reader.GetInt32(4) == 1) { MPClient.usesTVSeries = true; } else { MPClient.usesTVSeries = false; } } } reader.Close(); } catch (SQLiteException ex) { return MPClient; } finally { conn.Close(); } return MPClient; }