static public void SetUpdateDate(string databaseNameToUpdate, string tableNameUpdated, SQLDataBase anySqlDB)
{
try
{
// - Init -
bool rowExist = false;
// - Init SQL Query -
string statement = "SELECT CASE WHEN EXISTS (SELECT * FROM [E2MKI-MasterData].dbo.TD_UpdateDate WHERE DatabaseName='{0}' AND TableName='{1}') THEN 1 ELSE 0 END";
statement = string.Format(statement, databaseNameToUpdate, tableNameUpdated);
// - Run SQL Query -
if ((int)anySqlDB.ExecuteScalar(statement) == 1)
{
rowExist = true;
}
// - If row exists Update else Insert -
if (rowExist == true)
{
statement = "UPDATE [E2MKI-MasterData].dbo.TD_UpdateDate SET UpdateDate=GETDATE() WHERE DatabaseName='{0}' AND TableName='{1}'";
}
else
{
statement = "INSERT INTO [E2MKI-MasterData].dbo.TD_UpdateDate (DatabaseName, TableName, UpdateDate) VALUES ('{0}', '{1}', GETDATE())";
}
// - Prepare statement -
statement = string.Format(statement, databaseNameToUpdate, tableNameUpdated);
// - Execute Statement -
anySqlDB.ExecuteNonQuery(statement);
}
catch (Exception e)
{
Console.WriteLine("Error during SetUpdateDate()\n{0}", e.Message);
}
}
public static void Truncate(SQLDataBase sqlDB, string schema, string tableName)
{
sqlDB.ExecuteNonQuery("TRUNCATE TABLE {0}.{1}", schema, tableName);
}
