}//UpdateItemToDatabase
/// <summary>
/// Clear_Database_Table - delete all records from the table "user" in the database
/// <input> theTable - the table name</input>
/// </summary>
public void Clear_Database_Table()
{
string strCommand = "DELETE FROM " + theTable;
if (!DBUtils.ExecuteSqlNonQuery(strCommand))
{
LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in user.cs:Clear_Database_Table. ExecuteSqlNonQuery");
}
}//Clear_Database_Table
}//UpdateItemToDatabas
//---------------------------------------------------------------------------------------------------------------
/// <summary>
/// Clear_Database_Table - delete all records from the table "mapping_note" database
/// <input> theTable - the table name</input>
/// </summary>
public void Clear_Database_Table()
{
if (CountRows() == 0)
{
return;
}
string strCommand = "DELETE FROM " + theTable;
if (!DBUtils.ExecuteSqlNonQuery(strCommand))
{
LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in mapping_note_Table.cs:Clear_Database_Table.ExecuteSqlNonQuery()");
}
}
}//UpdateItemToDatabase
//---------------------------------------------------------------------------------------------------------------
/// <summary>
/// Clear_Database_Table - delete all records from the table "affirmation" database
/// <input> theTable - the table name</input>
/// </summary>
public void Clear_Database_Table()
{
if (CountRows() == 0)
{
return;
}
string strCommand = "DELETE FROM " + theTable; // Delete all rows from TABLE
if (!DBUtils.ExecuteSqlNonQuery(strCommand))
{
LogManager.writeToLog("ExecuteSqlNonQuery returned: FALSE; in affirmation_Table.cs:Clear_Database_Table.ExecuteSqlNonQuery()");
}
}//Clear_Database_Table
}//UpdateItemToDatabase
//---------------------------------------------------------------------------------------------------------------
/// <summary>
/// Clear_Database_Table - delete all records from the table "process_area" in the database
/// <input> theTable - the table name</input>
/// </summary>
public void Clear_Database_Table()
{
if (CountRows() == 0)
{
return;
}
string strCommand = "DELETE from " + theTable;
if (!DBUtils.ExecuteSqlNonQuery(strCommand))
{
LogManager.writeToLog(" ExecuteSqlNonQuery returned: FALSE; in process_area_Table.cs:Clear_Database_Table. ExecuteSqlNonQuery");
}
}