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); }