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); } }
/// <summary> /// Check if a row match the WHERE criteria. (SQL Query / Include already the WHERE keyword) /// </summary> /// <param name="anyDB"></param> /// <param name="anyTableName"></param> /// <param name="whereClause"></param> /// <returns></returns> public static bool Exists(SQLDataBase anyDB, string tableName, string whereClause) { // - Return true if at least 1 line meat the where criteria - return((int)anyDB.ExecuteScalar(string.Format("SELECT CASE WHEN EXISTS (SELECT * FROM {0} WHERE {1}) THEN 1 ELSE 0 END", tableName, whereClause)) == 1); }