1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
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
{
/// <summary>
/// Represents a <see cref="RemoteSqlDataSet"/> row.
/// </summary>
/// <example>
/// <para>
/// <i>
/// The following example demonstrates how to set the connected machine's demo state and query for the connected machine's jobs.
/// </i>
/// </para>
/// <code lang="C#" source="../Tango.FSE.Procedures/Examples/Sql/Program.cs" title="Remote SQL" region="Example" />
/// </example>
public class RemoteSqlRow
{
private Func<String, Object> _getFuncKey;
private Func<int, Object> _getFuncIndex;
/// <summary>
/// Gets or sets the row values.
/// </summary>
public List<Object> Values { get; set; }
/// <summary>
/// Initializes a new instance of the <see cref="RemoteSqlRow"/> class.
/// </summary>
public RemoteSqlRow()
{
Values = new List<object>();
}
/// <summary>
/// Gets a row value by its column name.
/// </summary>
/// <param name="columnName">Name of the column.</param>
/// <returns>The column value.</returns>
public Object Get(String columnName)
{
return _getFuncKey.Invoke(columnName);
}
/// <summary>
/// Gets a row value by its column index.
/// </summary>
/// <param name="columnIndex">Index of the column.</param>
/// <returns>The column value.</returns>
public Object Get(int columnIndex)
{
return _getFuncIndex.Invoke(columnIndex);
}
/// <summary>
/// Gets a row value as type T by its column name.
/// </summary>
/// <typeparam name="T">Expected column type.</typeparam>
/// <param name="columnName">Name of the column.</param>
/// <returns>The column value.</returns>
public T Get<T>(String columnName)
{
var value = _getFuncKey.Invoke(columnName);
if (typeof(T) != value.GetType())
{
return (T)Convert.ChangeType(value, typeof(T));
}
else
{
return (T)value;
}
}
/// <summary>
/// Gets a row value by its column index.
/// </summary>
/// <typeparam name="T">Expected column type</typeparam>
/// <param name="columnIndex">Index of the column.</param>
/// <returns>The column value.</returns>
public T Get<T>(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<String, Object> getFuncKey, Func<int, Object> getFuncIndex)
{
_getFuncKey = getFuncKey;
_getFuncIndex = getFuncIndex;
}
/// <summary>
/// Returns a <see cref="System.String" /> that represents this instance.
/// </summary>
/// <returns>
/// A <see cref="System.String" /> that represents this instance.
/// </returns>
public override string ToString()
{
return String.Join(", ", Values);
}
/// <summary>
/// Creates an object of type T and maps this row to it based on its properties decorated with <see cref="ColumnAttribute"/>.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <returns></returns>
public T Map<T>() where T : class, new()
{
var obj = Activator.CreateInstance<T>();
Map<T>(obj);
return obj;
}
/// <summary>
/// Maps this row to the specified object based on its properties decorated with <see cref="ColumnAttribute"/>.
/// </summary>
/// <typeparam name="T">Model type</typeparam>
/// <param name="obj">The object.</param>
public void Map<T>(T obj) where T : class
{
foreach (var prop in typeof(T).GetPropertiesWithAttribute<ColumnAttribute>())
{
try
{
var columnName = prop.GetCustomAttribute<ColumnAttribute>().Name;
var value = Get(columnName).ToStringSafe();
prop.SetValue(obj, Convert.ChangeType(value, prop.PropertyType));
}
catch (Exception ex)
{
Debug.WriteLine(ex);
}
}
}
}
}
|
