static void Main(string[] args)
{
var DatabaseManager = Shared.DBconnection.GetManager();
var dbManager = new Managers.DatabaseManager();
try
{
Console.WriteLine("Connection Successful");
//Equipment.AddEquipment.addEquipment("Dell Inspiron 7559", "Office B Storage Closet", "has radioactive robotics testing software");
//Deletion.Delete("parts", 7);
var table = dbManager.GetPartsTable().Result;
Console.WriteLine(table[2].serializable);
//int result = AddToSystem.Add(2, 1111);
//Console.WriteLine(result);
Console.ReadKey();
}
catch (Exception ex)
{
Console.Error.Write(ex.Message);
DatabaseManager.GetConnection().Close();
}
}
public async Task Delete(string tableName, int ID)
{
Boolean isException = false;
var DatabaseManager = Shared.DBconnection.GetManager();
try
{
//TODO change to verification method
Query getTableNamesQuery = new Query {
QueryString = "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE'"
};
var tableNames = await DatabaseManager.ExecuteTableAsync(DatabaseManager.GetConnection(), getTableNamesQuery.QueryString).ConfigureAwait(false);
Query getPrimaryKeyQuery = new Query {
QueryString = "SELECT * FROM atlas.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "'"
};
var partsTable = await DatabaseManager.ExecuteTableAsync(DatabaseManager.GetConnection(), getPrimaryKeyQuery.QueryString).ConfigureAwait(false);
string tablePrimaryKeyName = (string)partsTable[0][3];
Query getTableIDsQuery = new Query {
QueryString = "SELECT " + tablePrimaryKeyName + " FROM " + tableName
};
var tablePrimaryIDs = await DatabaseManager.ExecuteTableAsync(DatabaseManager.GetConnection(), getTableIDsQuery.QueryString).ConfigureAwait(false);
Boolean tableExists = false;
for (int i = 0; i < tableNames.Length; i++)
{
if (tableName.Equals(tableNames[i][0]))
{
tableExists = true;
}
}
if (!tableExists)
{
isException = true;
throw new Exception("Table " + tableName + " does not exist.");
}
var tableData = await databaseManager.GetPartsTable();
Boolean IDexists = false;
for (int j = 0; j < tableData.Length; j++)
{
if (ID.Equals(tablePrimaryIDs[j][0]))
{
IDexists = true;
}
}
if (!IDexists)
{
throw new Exception("ID does not exist");
}
if (!isException)
{
Query deleteQuery = new Query {
QueryString = "DELETE FROM " + tableName + " WHERE " + tablePrimaryKeyName + " = " + ID
};
DatabaseManager.ExecuteNonQueryAsync(DatabaseManager.GetConnection(), deleteQuery.QueryString, deleteQuery.Parameters).Wait();
}
}
catch (Exception ex)
{
isException = true;
Console.WriteLine(ex.Message);
//todo exeption handling
}
finally
{
DatabaseManager.GetConnection().Close();
}
}