public static void Insert(string[] column, PeopleToday today)
{
using (var command = new SQLiteCommand($"INSERT INTO PeopleToday ({column[0]}, {column[1]}, {column[2]}, {column[3]}, {column[4]})" +
$" VALUES ('{today.id}', '{today.name}', '{today.app}', '{today.date}', '{today.coordinate}'); ", ConnectDB.connect))
{
ConnectDB.OpenConnection();
var result = command.ExecuteReader();
ConnectDB.CloseConnection();
}
}
public static void Update(long id, PeopleToday today, string[] column)
{
using (var command = new SQLiteCommand($"UPDATE PeopleToday SET " +
$"{column[0]} = '{today.id}'," +
$"{column[1]} = '{today.name}', " +
$"{column[2]} = '{today.app}'," +
$"{column[3]} = '{today.date}'," +
$"{column[4]} = '{today.coordinate}' " +
$"WHERE Id = {id}; ", ConnectDB.connect))
{
ConnectDB.OpenConnection();
var result = command.ExecuteReader();
ConnectDB.CloseConnection();
}
}
public static List <PeopleToday> AnotherReadDB(PeopleToday today)
{
using (LibraryContext context = new LibraryContext())
{
context.PeopleToday.Add(today);
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException)
{
}
catch (System.Data.Entity.Infrastructure.DbUpdateException)
{
ConnectDB.OpenConnection();
var commandALT = new SQLiteCommand($"ALTER TABLE PeopleToday\n ADD COLUMN coordinate text;", ConnectDB.connect);
var resultALT = commandALT.ExecuteReader();
ConnectDB.CloseConnection();
}
return(context.PeopleToday.ToList());
}
}
