private DBDataItem getDataItem(int iddataitem) { isConnected(); String q = "SELECT * FROM `dataitems` WHERE iddataitems = '" + iddataitem + "'"; // Console.WriteLine(q); //Create Command MySqlCommand cmd = new MySqlCommand(q, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); //Read the data and store them in the list dataReader.Read(); String label = dataReader.GetString("label"); Int32 id = dataReader.GetInt32("iddataitems"); String type = dataReader.GetString("type"); TimeSpan runtime = TimeSpan.FromMilliseconds(dataReader.GetInt32("runtime")); String title = dataReader.GetString("title"); String artist = dataReader.GetString("artist"); String file = dataReader.GetString("file"); String radiovis1 = dataReader.GetString("radiovis1"); String radiovis2 = dataReader.GetString("radiovis2"); String radiovis3 = dataReader.GetString("radiovis3"); String radiovis4 = dataReader.GetString("radiovis3"); String radiovistxt = dataReader.GetString("radiovistxt"); String category = dataReader.GetString("category"); dataReader.Close(); DBDataItem item = new DBDataItem(label, id, runtime, type, title, artist,file,radiovis1, radiovis2, radiovis3, radiovis4, radiovistxt, category); return item; }
public ScheduledSlot(int idhist, int idscheduledslice, int position, string type, int iddataitem, string param, string label, DateTime scheduleddatetime) { this.idhist = idhist; this.idscheduledslice = idscheduledslice; this.position = position; this.type = type; this.iddataitem = iddataitem; this.param = param; this.label = label; this.scheduleddatetime = scheduleddatetime; this.dataitem = null; }
private DBDataItem getDataItemFromCategoryShortName(string categoryshortname) { //int idcateg = getCategoryIdFromShortName(categoryshortname); DBDataItem ret=null; isConnected(); String q = "SELECT * FROM `dataitems` WHERE category='" + categoryshortname + "' ORDER by RAND() LIMIT 1"; Console.WriteLine(q); //Create Command MySqlCommand cmd = new MySqlCommand(q, connection); //Create a data reader and Execute the command MySqlDataReader dataReader = cmd.ExecuteReader(); Console.WriteLine(dataReader.FieldCount); //Read the data and store them in the list while (dataReader.Read()) { Int32 id = dataReader.GetInt32("iddataitems"); TimeSpan runtime = TimeSpan.FromMilliseconds(dataReader.GetInt32("runtime")); String label = dataReader.GetString("label"); ret = new DBDataItem(label, id, runtime); } //close Data Reader dataReader.Close(); return ret; }