protected override void ProcessRecord() { var connection = DatabaseConnection.Current; using (var command = new SqlCommand("Select [Id],[Extension],[IsImage],[Ignored] from [Extension]")) { command.Connection = connection; WhereCauseBuilder whereCauseBuilder = new WhereCauseBuilder(command.Parameters); whereCauseBuilder.AddStringComparingCause("Extension", Extension, ExtensionPropertyComparingModes); whereCauseBuilder.AddBitComparingCause("IsImage", IsImage); whereCauseBuilder.AddBitComparingCause("Ignored", Ignored); command.CommandText += whereCauseBuilder.ToFullWhereCommand(); List <ImageStoreExtension> result = new List <ImageStoreExtension>(); using (var reader = command.ExecuteReader(System.Data.CommandBehavior.SequentialAccess)) { while (reader.Read()) { ImageStoreExtension line = new ImageStoreExtension((Guid)reader[0]) { Extension = (string)reader[1], IsImage = (bool)reader[2], Ignored = (bool)reader[3] }; result.Add(line); } reader.Close(); } WriteObject(result); } }
protected override void ProcessRecord() { var connection = DatabaseConnection.Current; using (var command = new SqlCommand("Select [Id],[FolderId],[Directory],[IsSubDirectoryIncluded] from [IgnoredDirectory]")) { command.Connection = connection; WhereCauseBuilder whereCauseBuilder = new WhereCauseBuilder(command.Parameters); whereCauseBuilder.AddUniqueIdentifierComparingCause("FolderId", FolderId); whereCauseBuilder.AddStringComparingCause("Directory", Directory, DirectoryPropertyComparingModes); whereCauseBuilder.AddBitComparingCause("IsSubDirectoryIncluded", IsSubDirectoryIncluded); command.CommandText += whereCauseBuilder.ToFullWhereCommand(); List <ImageStoreIgnoredDirectory> result = new List <ImageStoreIgnoredDirectory>(); using (var reader = command.ExecuteReader(System.Data.CommandBehavior.SequentialAccess)) { while (reader.Read()) { ImageStoreIgnoredDirectory line = new ImageStoreIgnoredDirectory((Guid)reader[0]) { FolderId = (Guid)reader[1], Directory = (string)reader[2], IsSubDirectoryIncluded = (bool)reader[3] }; result.Add(line); } reader.Close(); } WriteObject(result); } }
protected override void ProcessRecord() { var connection = DatabaseConnection.Current; using (var command = new SqlCommand("Select [Id],[Path],[Name],[CompareImageWith],[IsSealed] from [Folder]")) { command.Connection = connection; WhereCauseBuilder whereCauseBuilder = new WhereCauseBuilder(command.Parameters); whereCauseBuilder.AddStringComparingCause("Name", Name, NamePropertyComparingModes); whereCauseBuilder.AddStringComparingCause("Path", Path, PathPropertyComparingModes); whereCauseBuilder.AddIntComparingCause("CompareImageWith", (int?)CompareImageWith); whereCauseBuilder.AddBitComparingCause("IsSealed", IsSealed); command.CommandText += whereCauseBuilder.ToFullWhereCommand(); List <ImageStoreFolder> result = new List <ImageStoreFolder>(); using (var reader = command.ExecuteReader(System.Data.CommandBehavior.SequentialAccess)) { while (reader.Read()) { ImageStoreFolder line = new ImageStoreFolder((Guid)reader[0], (string)reader[1]) { Name = (string)reader[2], CompareImageWithCode = (int)reader[3], IsSealed = (bool)reader[4] }; result.Add(line); } reader.Close(); } WriteObject(result); } }