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