public void TestGetValue()
{
string value1 = ValuesList.GetValue(0);
string value2 = ValuesList.GetValue(1);
string value3 = ValuesList.GetValue(2);
Assert.AreEqual(value1, "value1");
Assert.AreEqual(value2, "value2");
Assert.AreEqual(value3, "value3");
}
public static DataTable PagedTable <T>(IList <T> SourceList)
{
Type columnType = typeof(T);
DataTable TableToReturn = new DataTable();
try
{
foreach (var Column in columnType.GetProperties())
{
TableToReturn.Columns.Add(Column.Name, Nullable.GetUnderlyingType(Column.PropertyType) ?? Column.PropertyType);
}
foreach (object item in SourceList)
{
DataRow ReturnTableRow = TableToReturn.NewRow();
foreach (var Column in columnType.GetProperties())
{
if (Column.GetValue(item) != null)
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
}
TableToReturn.Rows.Add(ReturnTableRow);
}
return(TableToReturn);
}
catch (Exception ex) {
throw ex;
}
}
/// <summary>
/// Gets the data value for specified column.
/// </summary>
/// <param name="column">The column.</param>
/// <param name="beforeEdit">Indicates whether should get value before editing.</param>
/// <returns>The data value.</returns>
public object this[Column column, bool beforeEdit]
{
get
{
column = VerifyColumn(column, nameof(column));
return(DataRow == null ? null : column.GetValue(DataRow, beforeEdit));
}
}
public void TestSetValue()
{
Column c2 = new Column("column1");
c2.AddValue("value1");
c2.AddValue("value2");
c2.AddValue("value3");
c2.SetValue(2, "newValue");
Assert.AreEqual("newValue", c2.GetValue(2));
}
private DataTable PagedTable(ArrayList list, bool rez)
{
if (rez)
{
Type columnType = typeof(Zapis);
DataTable table = new DataTable();
foreach (var Column in columnType.GetProperties())
{
table.Columns.Add(Column.Name, Column.PropertyType);
}
List <Zapis> list1 = new List <Zapis>();
foreach (Zapis item in list)
{
list1.Add(item);
}
foreach (object item in list1)
{
DataRow ReturnTableRow = table.NewRow();
foreach (var Column in columnType.GetProperties())
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
table.Rows.Add(ReturnTableRow);
}
return(table);
}
else
{
Type columnType = typeof(ZapisMin);
DataTable table = new DataTable();
foreach (var Column in columnType.GetProperties())
{
table.Columns.Add(Column.Name, Column.PropertyType);
}
List <ZapisMin> list1 = new List <ZapisMin>();
foreach (ZapisMin item in list)
{
list1.Add(item);
}
foreach (object item in list1)
{
DataRow ReturnTableRow = table.NewRow();
foreach (var Column in columnType.GetProperties())
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
table.Rows.Add(ReturnTableRow);
}
return(table);
}
}
// Find out if any parent nodes are NOT active, and if they are not return FALSE.
private Object getTreeNodeCellActive(BaseTreeNode treeNode, Boolean value)
{
while (treeNode.Parent != null)
{
if ((bool?)Column.GetValue(treeNode.Parent) == false)
{
value = false;
break;
}
treeNode = treeNode.Parent;
}
return(value);
}
public override void Update <T>(T entity)
{
var result = _inMemoryConnection.Update(entity);
return;
var table = BaseContext.TableByType(entity.GetType());
var sb = new StringBuilder();
sb.Append("UPDATE ["); sb.Append(table.NameDB); sb.Append("]SET");
Column primaryColumn = null;
foreach (var column in table.Columns)
{
if (column.IsPrimary)
{
primaryColumn = column;
}
else
{
sb.Append("["); sb.Append(column.NameDB); sb.Append("]");
sb.Append('=');
var value = column.GetValue(entity as IEntity);
sb.Append(FormatValue(value, column.Type));
sb.Append(',');
}
}
if (primaryColumn == null)
{
throw new Exception("Can't update entity without primary key column");
}
sb.Length--;
sb.Append(" WHERE[");
sb.Append(primaryColumn.NameDB);
sb.Append("]");
sb.Append("=");
sb.Append(primaryColumn.GetValue(entity as IEntity));
var query = sb.ToString();
this._inMemoryConnection.Query <T>(query);
}
public void TestAddRow()
{
List <String> values = new List <string>();
values.Add("value1");
values.Add("value2");
Table tableRow = new Table("TableRow");
Column columnRow1 = new Column("ColumnRow");
Column columnRow2 = new Column("ColumnRow");
tableRow.AddColumn(columnRow1);
tableRow.AddColumn(columnRow2);
tableRow.AddRow(values);
columnRow1.AddValue("value3");
int index = columnRow1.GetIndex("value1");
Assert.AreEqual("value1", columnRow1.GetValue(index));
}
public DataTable PageTable(IList SourceList)
{
DataTable TableToReturn = new DataTable();
foreach (var Column in DataType.GetProperties())
{
TableToReturn.Columns.Add(Column.Name, Column.PropertyType);
}
foreach (object item in SourceList)
{
DataRow ReturnTableRow = TableToReturn.NewRow();
foreach (var Column in DataType.GetProperties())
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
TableToReturn.Rows.Add(ReturnTableRow);
}
return(TableToReturn);
}
private DataTable PagedTable <T>(IEnumerable <T> SourceList)
{
Type columnType = typeof(T);
DataTable TableToReturn = new DataTable();
foreach (var Column in columnType.GetProperties())
{
TableToReturn.Columns.Add(Column.Name, Column.PropertyType);
}
foreach (object item in SourceList)
{
DataRow ReturnTableRow = TableToReturn.NewRow();
foreach (var Column in columnType.GetProperties())
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
TableToReturn.Rows.Add(ReturnTableRow);
}
return(TableToReturn);
}
/// <summary>
/// Get the cluster key by which the given model will be partitioned by this strategy
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public override object GetClusterKey(object model)
{
// Get the data attribute we want from the given model
// Make sure the returned value is a DateTime
var dateTime = Column.GetValue(model) as DateTime?;
if (!dateTime.HasValue)
{
return(null);
}
// Extract the parts of the datetime that we are intereted in.
// Even if we aren't interested in a particular portion, we still have to give it a reasonable default
// otherwise we won't be able to build a DateTime object for it
int year = ((Portions & DateTimePortion.Year) == DateTimePortion.Year) ? dateTime.Value.Year : 1;
int month = ((Portions & DateTimePortion.Month) == DateTimePortion.Month) ? dateTime.Value.Month : 1;
int day = ((Portions & DateTimePortion.Day) == DateTimePortion.Day) ? dateTime.Value.Day : 1;
int hour = ((Portions & DateTimePortion.Hour) == DateTimePortion.Hour) ? dateTime.Value.Hour : 0;
int minute = ((Portions & DateTimePortion.Minute) == DateTimePortion.Minute) ? dateTime.Value.Minute : 0;
int second = ((Portions & DateTimePortion.Second) == DateTimePortion.Second) ? dateTime.Value.Second : 0;
return(new DateTime(year, month, day, hour, minute, second));
}
public DataTable PageTable(IList SourceList)
{
DataTable TableToReturn = new DataTable();
ResourceManager rm = new ResourceManager("VirtualDoctor.Shared.Config.language", Assembly.GetExecutingAssembly());
CultureInfo cultureInfo = Thread.CurrentThread.CurrentCulture;
foreach (var Column in DataType.GetProperties())
{
TableToReturn.Columns.Add(Column.Name, Column.PropertyType);
}
foreach (object item in SourceList)
{
DataRow ReturnTableRow = TableToReturn.NewRow();
foreach (var Column in DataType.GetProperties())
{
ReturnTableRow[Column.Name] = Column.GetValue(item);
}
TableToReturn.Rows.Add(ReturnTableRow);
}
return(TableToReturn);
}
/// <inheritdoc />
public override object GetClusterKey(object model)
{
return(((string)Column.GetValue(model)).Replace(", ", ",").Split(','));
}
public override object GetValue(DBItem row)
{
return(temp ?? Column.GetValue(row));
}
/// <summary>
/// Get the cluster key by which the given model will be partitioned by this strategy
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public virtual object GetClusterKey(object model)
{
return(Column.GetValue(model));
}
