From 00a491d93733d4625ad329b2ba8237f445364b3f Mon Sep 17 00:00:00 2001 From: Mirta Date: Wed, 30 Dec 2020 16:39:52 +0200 Subject: merge --- .../PPC/Tango.PPC.Shared/SQL/ExecuteSqlRequest.cs | 13 -- .../PPC/Tango.PPC.Shared/SQL/ExecuteSqlResponse.cs | 19 --- .../PPC/Tango.PPC.Shared/SQL/RemoteSqlColumn.cs | 52 ------ .../SQL/RemoteSqlColumnCollection.cs | 78 --------- .../PPC/Tango.PPC.Shared/SQL/RemoteSqlDataSet.cs | 188 --------------------- .../PPC/Tango.PPC.Shared/SQL/RemoteSqlRow.cs | 153 ----------------- 6 files changed, 503 deletions(-) delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlRequest.cs delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlResponse.cs delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumn.cs delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumnCollection.cs delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlDataSet.cs delete mode 100644 Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlRow.cs (limited to 'Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL') diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlRequest.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlRequest.cs deleted file mode 100644 index 7802fc3f7..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlRequest.cs +++ /dev/null @@ -1,13 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Linq; -using System.Text; -using System.Threading.Tasks; - -namespace Tango.PPC.Shared.SQL -{ - public class ExecuteSqlRequest - { - public String SQL { get; set; } - } -} diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlResponse.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlResponse.cs deleted file mode 100644 index 2db90a336..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/ExecuteSqlResponse.cs +++ /dev/null @@ -1,19 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Linq; -using System.Text; -using System.Threading.Tasks; - -namespace Tango.PPC.Shared.SQL -{ - public class ExecuteSqlResponse - { - public int AffectedRecords { get; set; } - public RemoteSqlDataSet DataSet { get; set; } - - public ExecuteSqlResponse() - { - DataSet = new RemoteSqlDataSet(); - } - } -} diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumn.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumn.cs deleted file mode 100644 index 54431bdbe..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumn.cs +++ /dev/null @@ -1,52 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Linq; -using System.Text; -using System.Threading.Tasks; - -namespace Tango.PPC.Shared.SQL -{ - /// - /// Represents a column. - /// - public class RemoteSqlColumn - { - /// - /// Gets or sets the column name. - /// - public String Name { get; set; } - - /// - /// Gets or sets the column index. - /// - public int Index { get; set; } - - /// - /// Initializes a new instance of the class. - /// - public RemoteSqlColumn() - { - - } - - /// - /// Initializes a new instance of the class. - /// - /// The column name. - public RemoteSqlColumn(String name) - { - Name = name; - } - - /// - /// Returns a that represents this instance. - /// - /// - /// A that represents this instance. - /// - public override string ToString() - { - return Name; - } - } -} diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumnCollection.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumnCollection.cs deleted file mode 100644 index dfda6c3b7..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlColumnCollection.cs +++ /dev/null @@ -1,78 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Collections.ObjectModel; -using System.Linq; -using System.Text; -using System.Threading.Tasks; - -namespace Tango.PPC.Shared.SQL -{ - /// - /// Represents a columns collection. - /// - /// - public class RemoteSqlColumnCollection : Collection - { - private Dictionary _dictionary; - - /// - /// Initializes a new instance of the class. - /// - public RemoteSqlColumnCollection() - { - _dictionary = new Dictionary(); - } - - /// - /// Inserts an element into the at the specified index. - /// - /// The zero-based index at which should be inserted. - /// The object to insert. The value can be null for reference types. - protected override void InsertItem(int index, RemoteSqlColumn item) - { - item.Index = Count; - _dictionary.Add(item.Name, item); - base.InsertItem(index, item); - } - - /// - /// Removes the element at the specified index of the . - /// - /// The zero-based index of the element to remove. - /// - protected override void RemoveItem(int index) - { - throw new NotSupportedException(); - } - - /// - /// Removes all elements from the . - /// - protected override void ClearItems() - { - _dictionary.Clear(); - base.ClearItems(); - } - - /// - /// Replaces the element at the specified index. - /// - /// The zero-based index of the element to replace. - /// The new value for the element at the specified index. The value can be null for reference types. - /// - protected override void SetItem(int index, RemoteSqlColumn item) - { - throw new NotSupportedException(); - } - - /// - /// Gets the column index by column name. - /// - /// Column name. - /// - public int GetIndexOf(String columnName) - { - return _dictionary[columnName].Index; - } - } -} diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlDataSet.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlDataSet.cs deleted file mode 100644 index 72b8d2eb2..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlDataSet.cs +++ /dev/null @@ -1,188 +0,0 @@ -using System; -using System.Collections.Generic; -using System.Collections.ObjectModel; -using System.Collections.Specialized; -using System.Data.SqlClient; -using System.Linq; -using System.Text; -using System.Threading.Tasks; - -namespace Tango.PPC.Shared.SQL -{ - /// - /// Represents remote database query result composed of rows and columns. - /// - /// - /// - /// - /// The following example demonstrates how to set the connected machine's demo state and query for the connected machine's jobs. - /// - /// - /// - /// - public class RemoteSqlDataSet - { - /// - /// Gets or sets the dataset columns. - /// - public RemoteSqlColumnCollection Columns { get; set; } - - private ObservableCollection _rows; - /// - /// Gets or sets the dataset rows. - /// - public ObservableCollection Rows - { - get { return _rows; } - set { _rows = value; OnRowsChanged(); } - } - - /// - /// Initializes a new instance of the class. - /// - public RemoteSqlDataSet() - { - Columns = new RemoteSqlColumnCollection(); - Rows = new ObservableCollection(); - } - - private void OnRowsChanged() - { - if (Rows != null) - { - Rows.CollectionChanged -= Rows_CollectionChanged; - Rows.CollectionChanged += Rows_CollectionChanged; - - InitRows(); - } - } - - private void Rows_CollectionChanged(object sender, NotifyCollectionChangedEventArgs e) - { - InitRows(); - } - - private void InitRows() - { - if (Rows != null) - { - foreach (var row in Rows.ToList()) - { - row.Init( - (key) => - { - return row.Values[Columns.GetIndexOf(key)]; - }, - (index) => - { - return row.Values[index]; - }); - } - } - } - - /// - /// Creates a new using the specified . - /// - /// The reader. - /// - public static Task Load(SqlDataReader reader) - { - return Task.Factory.StartNew(() => - { - bool columnsRead = false; - RemoteSqlDataSet dataSet = new RemoteSqlDataSet(); - - try - { - while (reader.Read()) - { - RemoteSqlRow row = new RemoteSqlRow(); - - for (int i = 0; i < reader.FieldCount; i++) - { - if (!columnsRead) - { - dataSet.Columns.Add(new RemoteSqlColumn() - { - Name = reader.GetName(i) - }); - } - - row.Values.Add(reader.GetValue(i)); - } - - columnsRead = true; - dataSet.Rows.Add(row); - } - } - finally - { - reader.Close(); - } - - return dataSet; - }); - } - - /// - /// Returns a that represents this instance. - /// - /// - /// A that represents this instance. - /// - public override string ToString() - { - return String.Join(", ", Columns.Select(x => x.Name)) + "\n" + String.Join(Environment.NewLine, Rows.Select(x => x.ToString())); - } - - /// - /// Formats this dataset as a string with columns and rows. - /// - /// - public String ToTableString() - { - Dictionary columnsMaxLength = new Dictionary(); - - for (int i = 0; i < Columns.Count; i++) - { - columnsMaxLength.Add(i, Columns[i].Name.Length); - } - - foreach (var row in Rows) - { - for (int i = 0; i < row.Values.Count; i++) - { - int valueLength = row.Values[i].ToStringSafe().Length; - - if (valueLength > columnsMaxLength[i]) - { - columnsMaxLength[i] = valueLength; - } - } - } - - String str = String.Empty; - - for (int i = 0; i < Columns.Count; i++) - { - str += $"{Columns[i].Name.PadRight(columnsMaxLength[i])}{(i < Columns.Count - 1 ? " | " : "")}"; - } - - int width = str.Length; - str += Environment.NewLine + String.Empty.PadRight(width, '-'); - - foreach (var row in Rows) - { - str += Environment.NewLine; - - for (int i = 0; i < row.Values.Count; i++) - { - str += $"{row.Values[i].ToStringSafe().PadRight(columnsMaxLength[i])}{(i < Columns.Count - 1 ? " | " : "")}"; - } - } - - return str; - } - } -} diff --git a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlRow.cs b/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlRow.cs deleted file mode 100644 index dfabacfea..000000000 --- a/Software/Visual_Studio/PPC/Tango.PPC.Shared/SQL/RemoteSqlRow.cs +++ /dev/null @@ -1,153 +0,0 @@ -using System; -using System.Collections.Generic; -using System.ComponentModel.DataAnnotations.Schema; -using System.Diagnostics; -using System.Linq; -using System.Reflection; -using System.Text; -using System.Threading.Tasks; -using Tango.BL.Entities; - -namespace Tango.PPC.Shared.SQL -{ - /// - /// Represents a row. - /// - /// - /// - /// - /// The following example demonstrates how to set the connected machine's demo state and query for the connected machine's jobs. - /// - /// - /// - /// - public class RemoteSqlRow - { - private Func _getFuncKey; - private Func _getFuncIndex; - - /// - /// Gets or sets the row values. - /// - public List Values { get; set; } - - /// - /// Initializes a new instance of the class. - /// - public RemoteSqlRow() - { - Values = new List(); - } - - /// - /// Gets a row value by its column name. - /// - /// Name of the column. - /// The column value. - public Object Get(String columnName) - { - return _getFuncKey.Invoke(columnName); - } - - /// - /// Gets a row value by its column index. - /// - /// Index of the column. - /// The column value. - public Object Get(int columnIndex) - { - return _getFuncIndex.Invoke(columnIndex); - } - - /// - /// Gets a row value as type T by its column name. - /// - /// Expected column type. - /// Name of the column. - /// The column value. - public T Get(String columnName) - { - var value = _getFuncKey.Invoke(columnName); - - if (typeof(T) != value.GetType()) - { - return (T)Convert.ChangeType(value, typeof(T)); - } - else - { - return (T)value; - } - } - - /// - /// Gets a row value by its column index. - /// - /// Expected column type - /// Index of the column. - /// The column value. - public T Get(int columnIndex) - { - var value = _getFuncIndex.Invoke(columnIndex); - - if (typeof(T) != value.GetType()) - { - return (T)Convert.ChangeType(value, typeof(T)); - } - else - { - return (T)value; - } - } - - internal void Init(Func getFuncKey, Func getFuncIndex) - { - _getFuncKey = getFuncKey; - _getFuncIndex = getFuncIndex; - } - - /// - /// Returns a that represents this instance. - /// - /// - /// A that represents this instance. - /// - public override string ToString() - { - return String.Join(", ", Values); - } - - /// - /// Creates an object of type T and maps this row to it based on its properties decorated with . - /// - /// - /// - public T Map() where T : class, new() - { - var obj = Activator.CreateInstance(); - Map(obj); - return obj; - } - - /// - /// Maps this row to the specified object based on its properties decorated with . - /// - /// Model type - /// The object. - public void Map(T obj) where T : class - { - foreach (var prop in typeof(T).GetPropertiesWithAttribute()) - { - try - { - var columnName = prop.GetCustomAttribute().Name; - var value = Get(columnName).ToStringSafe(); - prop.SetValue(obj, Convert.ChangeType(value, prop.PropertyType)); - } - catch (Exception ex) - { - Debug.WriteLine(ex); - } - } - } - } -} -- cgit v1.3.1