public string[] Select(string tableread, string kezdo, string veg) { using (var context = new tc_dataCollectionContext()) { DateTime Dkezdo = DateTime.ParseExact(kezdo, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); DateTime Dveg = DateTime.ParseExact(veg, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); context.DBMS = "MySQL"; context.ConnectionString = ConnectionString; context.Tablename = tableread; var Records = context.Chambers.Where <RecordModell>(r => r.Dátum > Dkezdo && r.Dátum < Dveg); RecordModell[] dataarray = new RecordModell[Records.Count()]; int i = 0; foreach (var record in Records) { //var data = new StringBuilder(); //data.AppendLine($"Dátum: {record.Dátum}"); //data.AppendLine($"temp_set: {record.temp_set}"); //data.AppendLine($"temp_act: {record.temp_act}"); //data.AppendLine($"hum_set: {record.hum_set}"); //data.AppendLine($"hum_act: {record.hum_act}"); //Console.WriteLine(data.ToString()); dataarray[i] = record; i++; } return(recordmodell_arr_to_str_arr(dataarray)); } }
public void CreateTable(string tablecreate) { using (var context = new tc_dataCollectionContext()) { context.DBMS = "MySQL"; context.ConnectionString = ConnectionString; context.Tablename = tablecreate; RelationalDatabaseCreator databaseCreator = (RelationalDatabaseCreator)context.Database.GetService <IDatabaseCreator>(); databaseCreator.CreateTables(); } Console.WriteLine("table created: " + tablecreate); }
public void Insert(string tablewrite, RecordModell record) { using (var context = new tc_dataCollectionContext()) { context.ConnectionString = ConnectionString; context.DBMS = "SQLite"; context.Tablename = tablewrite; context.Chambers.Add(record); context.SaveChanges(); } Console.WriteLine("record successfully inserted to : " + tablewrite); }
public void Insert(string tablewrite, RecordModell record) { using (var context = new tc_dataCollectionContext()) { // context.ConnectionString = ConnectionString; context.DBMS = "MySQL"; context.ConnectionString = ConnectionString; context.Tablename = tablewrite; context.Chambers.Add(record); try { context.SaveChanges(); } catch (Exception) { Console.WriteLine("error inserting to MySQL DB"); throw; } } Console.WriteLine("record successfully inserted to : " + tablewrite); }
public string[] Select(string tableread, string kezdo, string veg) { DateTime Dkezdo = DateTime.ParseExact(kezdo, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); DateTime Dveg = DateTime.ParseExact(veg, "yyyy-MM-dd HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); using (var context = new tc_dataCollectionContext()) { context.ConnectionString = ConnectionString; context.DBMS = "SQLite"; context.Tablename = tableread; var Records = context.Chambers.Where <RecordModell>(r => r.Dátum > Dkezdo && r.Dátum < Dveg); RecordModell[] dataarray = new RecordModell[Records.Count()]; int i = 0; foreach (var record in Records) { dataarray[i] = record; i++; } Console.WriteLine("select lefutott"); return(recordmodell_arr_to_str_arr(dataarray)); } }