public ActionResult EditTable(string tableName, string oldTableName,
int[] Ordinal,
string[] Name,
bool[] IsPrimaryKey,
string[] DataTypeName,
int[] MaxLength,
bool[] AllowDBNull,
FormCollection collection)
{
ViewBag.TableName = tableName;
if (!string.IsNullOrEmpty(tableName) && Name != null)
{
var tlts = new List <SqliteDBHelper.ColumnInfo>();
for (int i = 0; i < Name.Length; i++)
{
SqliteDBHelper.ColumnInfo ct = new SqliteDBHelper.ColumnInfo();
ct.Ordinal = Ordinal[i];
ct.Name = Name[i];
ct.IsPrimaryKey = IsPrimaryKey[i];
ct.DataTypeName = DataTypeName[i];
ct.MaxLength = MaxLength[i];
ct.AllowDBNull = AllowDBNull[i];
tlts.Add(ct);
}
if (SqliteDBHelper.ExistsTable(oldTableName))
{
if (tableName != oldTableName && !SqliteDBHelper.ExistsTable(tableName))
{
if (SqliteDBHelper.ReNameTable(tableName, oldTableName))
{
SqliteDBHelper.CreateTable(tableName, tlts);
}
}
else
{
SqliteDBHelper.CreateTable(tableName, tlts);
}
}
}
return(Redirect("/Manager/SqliteDataBase/Tables"));
}
