private static void UpdateDatabaseLockAsExpired(string numberType, int lockDuration)
{
var sqlStatement = new SqlStatement(DatabaseConnection.CurrentConnection);
var sqlFormatter = DatabaseConnection.CurrentConnection.SqlFormatter;
sqlStatement.Statement.AppendFormat("UPDATE {0} SET ", sqlFormatter.DelimitTable("numbergenerator"));
sqlStatement.Statement.Append(sqlFormatter.DelimitField("DateTimeLocked"));
sqlStatement.Statement.Append(" = ");
sqlStatement.AddParameterToStatement(DateTime.Now.AddMinutes(-1 * lockDuration - 1));
sqlStatement.Statement.Append(" WHERE ");
sqlStatement.Statement.Append(sqlFormatter.DelimitField("NumberType"));
sqlStatement.Statement.Append(" = ");
sqlStatement.AddParameterToStatement(numberType);
DatabaseConnection.CurrentConnection.ExecuteSql(sqlStatement);
}
public void TestAddingParameterToStatement()
{
var addingParamStatement = new SqlStatement(_connection);
addingParamStatement.AddParameterToStatement(1);
Assert.AreEqual("@Param0", addingParamStatement.Statement.ToString(),
"AddParameterToStatement is not building statement correctly.");
}
private static void UpdateDatabaseLockAsExpired(int lockDuration)
{
var sqlFormatter = DatabaseConnection.CurrentConnection.SqlFormatter;
var sqlStatement = new SqlStatement(DatabaseConnection.CurrentConnection);
sqlStatement.Statement.Append("UPDATE " + sqlFormatter.DelimitTable("contact_person") + " SET ");
sqlStatement.Statement.Append(sqlFormatter.DelimitField("DateTimeLocked"));
sqlStatement.Statement.Append(" = ");
sqlStatement.AddParameterToStatement(DateTime.Now.AddMinutes(-1 * lockDuration - 1));
DatabaseConnection.CurrentConnection.ExecuteSql(sqlStatement);
}
