public IActionResult CreateTable(TableCreateModel model, int primaryField)
{
model.Fields[primaryField].IsPrimaryKey = true;
string cs = @"Data source=C:\BSU_Season5\ServiceOrientedProgramming\Lab1Work\Lab1\DB\data.db";
using var con = new SQLiteConnection(cs);
con.Open();
using var cmd = con.CreateCommand();
string fieldsStr = "";
for (int i = 0; i < model.Fields.Count; i++)
{
fieldsStr += model.Fields[i].FieldName + " " + SqliteDbConverter.GetDbType(model.Fields[i].FieldType);
if (model.Fields[i].IsPrimaryKey)
{
fieldsStr += " PRIMARY KEY";
}
if (i < model.Fields.Count - 1)
{
fieldsStr += ", ";
}
}
cmd.CommandText = "DROP TABLE IF EXISTS newTable";
cmd.ExecuteNonQuery();
cmd.CommandText = $"CREATE TABLE IF NOT EXISTS newTable ({fieldsStr})";
cmd.VerifyOnly();
cmd.ExecuteNonQuery();
TempData["TableCreateModel"] = JsonSerializer.Serialize(model, typeof(TableCreateModel));
return(RedirectToAction("Index", "EditTable"));
}
public IActionResult EditSavedTable()
{
DbTableModel model = SqliteDbConverter.GetModel(@"Data source=C:\BSU_Season5\ServiceOrientedProgramming\Lab1Work\Lab1\DB\data.db", "newTable");
return(EditReadyModel(model));
}
