// ----------------------------------------------------- // List available report metadata // ----------------------------------------------------- public void ListAvailableForClient(int clientUID) { this.reportMetadataList = new List <ReportMetadata>(); using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + " [UID] " + " ,[Description] " + " ,[RecordType] " + " ,[FieldCode] " + " ,[ClientType] " + " ,[ClientUID] " + " ,[InformationType] " + " ,[Condition] " + " ,[CompareWith] " + " FROM [ReportMetadata] " + " WHERE RecordType = 'DF' " + " AND FieldCode not in " + " ( select FieldCode from reportmetadata where ClientUID = {0}) ", clientUID ); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ReportMetadata _reportMetadata = new ReportMetadata(); _reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString()); _reportMetadata.Description = reader["Description"].ToString(); _reportMetadata.RecordType = reader["RecordType"].ToString(); _reportMetadata.FieldCode = reader["FieldCode"].ToString(); _reportMetadata.ClientType = reader["ClientType"].ToString(); try { _reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]); } catch (Exception ex) { _reportMetadata.ClientUID = 0; } _reportMetadata.InformationType = reader["InformationType"].ToString(); _reportMetadata.Condition = reader["Condition"].ToString(); _reportMetadata.CompareWith = reader["CompareWith"].ToString(); this.reportMetadataList.Add(_reportMetadata); } } } } }
// ----------------------------------------------------- // List Global Fields // ----------------------------------------------------- public void ListDefault() { this.reportMetadataList = new List <ReportMetadata>(); using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + " [UID] " + " ,[Description] " + " ,[RecordType] " + " ,[FieldCode] " + " ,[ClientType] " + " ,[ClientUID] " + " ,[InformationType] " + " ,[Condition] " + " ,[CompareWith] " + " ,[Enabled] " + " ,[UseAsLabel] " + " FROM [ReportMetadata] " + " WHERE RecordType = '{0}'", "DF"); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ReportMetadata _reportMetadata = new ReportMetadata(); _reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString()); _reportMetadata.Description = reader["Description"].ToString(); _reportMetadata.RecordType = reader["RecordType"].ToString(); _reportMetadata.FieldCode = reader["FieldCode"].ToString(); _reportMetadata.ClientType = reader["ClientType"].ToString(); _reportMetadata.Condition = reader["Condition"].ToString(); _reportMetadata.CompareWith = reader["CompareWith"].ToString(); _reportMetadata.Enabled = Convert.ToChar(reader["Enabled"]); try { _reportMetadata.UseAsLabel = Convert.ToChar(reader["UseAsLabel"]); } catch (Exception ex) { _reportMetadata.UseAsLabel = 'N'; } try { _reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]); } catch (Exception ex) { _reportMetadata.ClientUID = 0; } _reportMetadata.InformationType = reader["InformationType"].ToString(); this.reportMetadataList.Add(_reportMetadata); } } } } }
// ----------------------------------------------------- // List metadata for a given client // ----------------------------------------------------- public void ListMetadataForClient(int clientUID, bool onlyEnabled = false) { this.reportMetadataList = new List <ReportMetadata>(); var enabledOnlyCriteria = ""; if (onlyEnabled) { enabledOnlyCriteria = " AND Enabled = 'Y' "; } using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + " [UID] " + " ,[Description] " + " ,[RecordType] " + " ,[FieldCode] " + " ,[ClientType] " + " ,[ClientUID] " + " ,[InformationType] " + " ,[Condition] " + " ,[CompareWith] " + " ,[Enabled] " + " FROM [ReportMetadata] " + " WHERE RecordType = 'CL' " + enabledOnlyCriteria + " AND ClientUID = {0} ", clientUID ); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { ReportMetadata _reportMetadata = new ReportMetadata(); _reportMetadata.UID = Convert.ToInt32(reader["UID"].ToString()); _reportMetadata.Description = reader["Description"].ToString(); _reportMetadata.RecordType = reader["RecordType"].ToString(); _reportMetadata.FieldCode = reader["FieldCode"].ToString(); _reportMetadata.ClientType = reader["ClientType"].ToString(); _reportMetadata.InformationType = reader["InformationType"].ToString(); _reportMetadata.Enabled = Convert.ToChar(reader["Enabled"]); try { _reportMetadata.ClientUID = Convert.ToInt32(reader["ClientUID"]); } catch (Exception ex) { _reportMetadata.ClientUID = 0; } _reportMetadata.InformationType = reader["InformationType"].ToString(); _reportMetadata.Condition = reader["Condition"].ToString(); _reportMetadata.CompareWith = reader["CompareWith"].ToString(); this.reportMetadataList.Add(_reportMetadata); } } } } }