public void AddDeployment(Deployment deployment) { if (deployment == null) { throw new ArgumentNullException("deployment"); } const string CommandText = @" INSERT INTO Deployment (Created, PipelineId, EnvironmentId) VALUES (@Created, @PipelineId, @EnvironmentId) SET @DeploymentId = @@IDENTITY"; var deploymentIdParameter = new SqlParameter("DeploymentId", SqlDbType.Int) { Direction = ParameterDirection.Output }; using (DbCommand command = CreateCommand()) { command.CommandText = CommandText; ModifyData( command, new SqlParameter("Created", deployment.Created), new SqlParameter("PipelineId", deployment.PipelineId), new SqlParameter("EnvironmentId", deployment.EnvironmentId), deploymentIdParameter); } deployment.ChangeId((int)deploymentIdParameter.Value); }
public void AddDeployment(Deployment deployment) { if (deployment == null) { throw new ArgumentNullException("deployment"); } int newId = 1; if (_deployments.Count > 0) { newId = _deployments.Max(d => d.Id.Value) + 1; } deployment.ChangeId(newId); _deployments.Add(deployment); }
public void AddDeployment(Deployment deployment) { if (deployment == null) { throw new ArgumentNullException("deployment"); } const string sql = @" INSERT INTO Deployment (Created, PipelineId, EnvironmentId) VALUES (@Created, @PipelineId, @EnvironmentId) SET @DeploymentId = Scope_Identity()"; var param = new {deployment.Created, deployment.PipelineId, deployment.EnvironmentId}; int deploymentId = _connection.ExecuteAndGetGeneratedId(sql, param, "DeploymentId"); deployment.ChangeId(deploymentId); }