public void AddResolutions(int templateId, ResolutionCollection resolutions) { var command = SqlDbAccess.CreateTextCommand(); command.CommandText = @" INSERT INTO [Cerberus.TemplateEngine.Resolution] ( TemplateId, Width ) VALUES ( @TemplateId, @Width ); SELECT CAST(SCOPE_IDENTITY() AS INT);" ; SqlDbAccess.AddParameter(command, "@TemplateId", SqlDbType.Int, templateId); var widthParameter = SqlDbAccess.AddParameter(command, "@Width", SqlDbType.Int, 0); foreach (var resolution in resolutions) { widthParameter.Value = resolution.ResolutionValue; resolution.Id = SqlDbAccess.ExecuteScalar <int>(command); this.UpdateResolutionValues(resolution.Id, resolution.TemplateControlVisualProperties); } }
public int AddTemplate(Template template) { var command = SqlDbAccess.CreateTextCommand(); command.CommandText = @" INSERT INTO [Cerberus.TemplateEngine.Template] ( Name, VisualProperties, CreatedByUserId, CreatedDate, LastModifiedDate ) VALUES ( @Name, @VisualProperties, @CreatedByUserId, GETDATE(), GETDATE() ); DECLARE @IDENTITY INT; SELECT @IDENTITY=CAST(SCOPE_IDENTITY() AS INT); INSERT INTO [Cerberus.TemplateEngine.Resolution] ( TemplateId ) VALUES ( @IDENTITY ); SELECT @IDENTITY;" ; SqlDbAccess.AddParameter(command, "@Name", SqlDbType.NVarChar, template.Name); SqlDbAccess.AddParameter(command, "@CreatedByUserId", SqlDbType.Int, template.CreatedByUserId); SqlDbAccess.AddParameter(command, "@VisualProperties", SqlDbType.NVarChar, template.VisualProperties); return(SqlDbAccess.ExecuteScalar <int>(command)); }