public ActionResult addDatabase(DatabaseXML database)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.Databases.Add(database);
dao.update(udb);
return(Json(""));
}
public ActionResult removeDatabase(string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.removeDatabaseByName(databaseName);
dao.update(udb);
return(Json(""));
}
public ActionResult addPrimaryKey(List <string> columnNames, string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).PrimaryKey = columnNames;
dao.update(udb);
return(Json(""));
}
public void update(Column column, string previousName, string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
DatabaseXML db = udb.getDatabaseByName(databaseName);
db.getTableByName(tableName).updateColumn(previousName, column, db);
dao.update(udb);
}
public ActionResult addUniqueKey(UniqueKey uk, string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).addUniqueKey(uk);
dao.update(udb);
return(Json(""));
}
public ActionResult removePrimaryKey(string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).PrimaryKey.Clear();
dao.update(udb);
return(Json(""));
}
public ActionResult updateIndex(Index index, string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).updateIndex(index);
dao.update(udb);
return(Json(""));
}
public ActionResult addForeignKey(ForeignKey fk, string tableName, string databaseName)
{
initUser();
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).ForeignKeys.Add(fk);
dao.update(udb);
return(Json(""));
}
public ActionResult removeUniqueKey(UniqueKey uniqueKey, string tableName, string databaseName)
{
initUser();
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).UniqueKeys.Remove(uniqueKey);
dao.update(udb);
return(Json(""));
}
public ActionResult removeColumn(string columnName, string tableName, string databaseName)
{
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
try
{
udb.getDatabaseByName(databaseName).getTableByName(tableName).removeColumnByName(columnName);
}
catch (Exception e)
{
return(Json(e.Message));
}
dao.update(udb);
return(Json(""));
}
public ActionResult addForeignKey(ForeignKey fk, List <string> ColumnName, List <string> ExternColumnName, string tableName, string databaseName)
{
for (int i = 0; i < ColumnName.Count; i++)
{
fk.Info.Add(new ForeignKeyInside
{
ColumnName = ColumnName[i],
ExternColumnName = ExternColumnName[i]
});
}
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).addForeignKey(fk);
dao.update(udb);
return(Json(""));
}
public ActionResult addTable(string tableName, string databaseName, string type)
{
initUser();
Table table = new Table();
if (type != null)
{
table.Type = type;
}
table.Name = tableName;
Column pk = new Column
{
DecimalLength = 0,
isNull = 0,
Length = 0,
Name = "Id_" + tableName,
Type = Database.Type.Int_AI
};
Column isSuppr = new Column
{
DecimalLength = 0,
isNull = 0,
Length = 0,
Name = "IsSuppr",
Type = Database.Type.Boolean
};
table.Columns.Add(pk);
table.Columns.Add(isSuppr);
table.PrimaryKey.Add("Id_" + tableName);
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).Content.Add(table);
dao.update(udb);
/*table.ForeignKeys;
* table.Indexes;
* table.PrimaryKey;
* table.UniqueKeys;*/
return(Json(""));
}
public void resetDatabase(string dbName)
{
initUser();
string matricule = ((User)Session["user"]).Matricule;
UserDatabasesDAO dao = new UserDatabasesDAO();
UserDatabases udb = dao.findByMatricule(matricule);
DatabaseXML db = udb.getDatabaseByName(dbName);
db = loadDBFromConnectionString(dbName, db.ConnectionString, "");
for (int i = 0; i < udb.Databases.Count; i++)
{
if (udb.Databases[i].Name == dbName)
{
udb.Databases.RemoveAt(i);
break;
}
}
udb.Databases.Add(db);
dao.update(udb);
}
public ActionResult loadDatabase(string projectName, string host, string instance, string databaseName, string username, string password)
{
initUser();
string matricule = ((User)Session["user"]).Matricule;
UserDatabasesDAO dao = new UserDatabasesDAO();
UserDatabases udb = dao.findByMatricule(matricule);
string connectionString = "Data Source=" + host + "\\" + instance + ";Initial Catalog=" + databaseName + ";Persist Security Info=True;User ID=" + username + ";Password="******"")
{
connectionString = "Data Source=" + host + ";Initial Catalog=" + databaseName + ";Persist Security Info=True;User ID=" + username + ";Password="******"")
{
if (instance == null || instance == "")
{
connectionString = "Data Source=" + host + ";initial catalog=" + databaseName + ";integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
}
else
{
connectionString = "Data Source=" + host + "\\" + instance + ";initial catalog=" + databaseName + ";integrated security=True;MultipleActiveResultSets=True;App=EntityFramework";
}
}
DatabaseXML db = loadDBFromConnectionString(projectName, connectionString, databaseName);
for (int i = 0; i < udb.Databases.Count; i++)
{
if (udb.Databases[i].Name == databaseName)
{
udb.Databases.RemoveAt(i);
break;
}
}
udb.Databases.Add(db);
dao.update(udb);
return(RedirectToAction("index"));
}
public ActionResult addColumn(Column column, string IsNull, string columnType, string tableName, string databaseName)
{
if (IsNull == "on")
{
column.isNull = 1;
}
else
{
column.isNull = 0;
}
if (column.Length == null)
{
column.Length = 0;
}
column.Type = Database.TypeString.toType(columnType);
UserDatabasesDAO dao = new UserDatabasesDAO();
string matricule = ((User)Session["user"]).Matricule;
UserDatabases udb = dao.findByMatricule(matricule);
udb.getDatabaseByName(databaseName).getTableByName(tableName).Columns.Add(column);
dao.update(udb);
return(Json(""));
}
