protected void _addSqlCommandParameter(string PublicName, DbColumnParameterData ColumnData, MySqlParameter parameter) { bool isRequired = false; string DBColumnName = (ColumnData != null) ? ColumnData.ColumnName : "primaryKey"; if (!ParameterIsValid(PublicName, DBColumnName, parameter.ParameterName)) { return; } if (ColumnData == null || ColumnData.IsNullable) { isRequired = false; } else { isRequired = true; } SqlCmdParameter NewParameter = new SqlCmdParameter(PublicName, DBColumnName, parameter.ParameterName, parameter.MySqlDbType, isRequired, parameter.Direction); ParametersIndexedByPublicName.Add(PublicName, _sqlCmdParameters.Count); ParametersIndexedByDatabaseTableName.Add(DBColumnName, _sqlCmdParameters.Count); ParametersIndexedByParameterName.Add(parameter.ParameterName, _sqlCmdParameters.Count); _sqlCmdParameters.Add(NewParameter); }
public SqlCmdParameter(SqlCmdParameter original) { _publicName = original._publicName; _storedProcedureParameterName = original._storedProcedureParameterName; _direction = original._direction; _isRequired = original._isRequired; _type = original._type; _isValueSet = original._isValueSet; _value = original._value; _valueKey = original._valueKey; _valueInt = original._valueInt; _valueDouble = original._valueDouble; _skipInsertOfPrimaryKey = original._skipInsertOfPrimaryKey; }
protected DataTableItemBaseModel(CDataTableModel DBInterfaceModel) { _sqlCmdParameters = new List <SqlCmdParameter>(); List <SqlCmdParameter> sqlCmdParameters = DBInterfaceModel.SQLCommandParameters; foreach (SqlCmdParameter parameter in sqlCmdParameters) { SqlCmdParameter p = new SqlCmdParameter(parameter); _sqlCmdParameters.Add(p); } _parameterIndexByPublicName = new Dictionary <string, int>(DBInterfaceModel.PublicNameParameterIndex); _parameterIndexByParameterName = new Dictionary <string, int>(DBInterfaceModel.ParametersIndexByStoredProcedureName); _parameterIndexByDatabaseTableName = new Dictionary <string, int>(); _parameterIndexByDatabaseTableName = new Dictionary <string, int>(DBInterfaceModel.ParametersIndexByDbColumnName); // If a new class is created from this class make sure than any constructor that performs initialization of // parameters sets Modified to false after all the parameters are initialized. IsModified = false; }