/// <summary>
/// Initializes a new instance of the <see cref = "ClonedPropertyValues" /> class by copying
/// values from the given dictionary.
/// </summary>
/// <param name = "original">The dictionary to clone.</param>
/// <param name = "valuesRecord">If non-null, then the values for the new dictionary are taken from this record rather than from the original dictionary.</param>
internal ClonedPropertyValues(InternalPropertyValues original, DbDataRecord valuesRecord = null)
: base(original.InternalContext, original.ObjectType, original.IsEntityValues)
{
_propertyNames = original.PropertyNames;
_propertyValues = new Dictionary<string, ClonedPropertyValuesItem>(_propertyNames.Count);
foreach (var propertyName in _propertyNames)
{
var item = original.GetItem(propertyName);
var value = item.Value;
var asValues = value as InternalPropertyValues;
if (asValues != null)
{
var nestedValuesRecord = valuesRecord == null ? null : (DbDataRecord)valuesRecord[propertyName];
value = new ClonedPropertyValues(asValues, nestedValuesRecord);
}
else if (valuesRecord != null)
{
value = valuesRecord[propertyName];
if (value == DBNull.Value)
{
value = null;
}
}
_propertyValues[propertyName] = new ClonedPropertyValuesItem(
propertyName, value, item.Type, item.IsComplex);
}
}
internal all_columnsClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
object_id = record["object_id"].Convert<int?>();
name = record["name"].Convert<string>();
column_id = record["column_id"].Convert<int?>();
system_type_id = record["system_type_id"].Convert<Byte?>();
user_type_id = record["user_type_id"].Convert<int?>();
max_length = record["max_length"].Convert<Int16?>();
precision = record["precision"].Convert<Byte?>();
scale = record["scale"].Convert<Byte?>();
collation_name = record["collation_name"].Convert<string>();
is_nullable = record["is_nullable"].Convert<Boolean?>();
is_ansi_padded = record["is_ansi_padded"].Convert<Boolean?>();
is_rowguidcol = record["is_rowguidcol"].Convert<Boolean?>();
is_identity = record["is_identity"].Convert<Boolean?>();
is_computed = record["is_computed"].Convert<Boolean?>();
is_filestream = record["is_filestream"].Convert<Boolean?>();
is_replicated = record["is_replicated"].Convert<Boolean?>();
is_non_sql_subscribed = record["is_non_sql_subscribed"].Convert<Boolean?>();
is_merge_published = record["is_merge_published"].Convert<Boolean?>();
is_dts_replicated = record["is_dts_replicated"].Convert<Boolean?>();
is_xml_document = record["is_xml_document"].Convert<Boolean?>();
xml_collection_id = record["xml_collection_id"].Convert<int?>();
default_object_id = record["default_object_id"].Convert<int?>();
rule_object_id = record["rule_object_id"].Convert<int?>();
is_sparse = record["is_sparse"].Convert<Boolean?>();
is_column_set = record["is_column_set"].Convert<Boolean?>();
}
/// <summary>
/// constructor for FirefoxExtension
/// </summary>
/// <param name="r"></param>
public FirefoxExtension(DbDataRecord r)
{
Id = r["id"].ToString();
Name = r["name"].ToString();
Version = r["version"].ToString();
userDisabled = (long)r["userDisabled"] == 1 ? "true" : "false";
isEnabled = userDisabled == "false";
}
private static Dictionary<string, object> RecordToDictionary(DbDataRecord record)
{
var dictionary = new Dictionary<string, object>();
for (var i = 0; i < record.FieldCount; i++)
dictionary.Add(record.GetName(i), record[i]);
return dictionary;
}
public void rptr_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
System.Data.Common.DbDataRecord rec = (System.Data.Common.DbDataRecord)
e.Item.DataItem;
if (rec != null) //Asegúrese de que tiene los datos.
{
Label l1 = (Label)e.Item.FindControl("lblAuthorID");
l1.Text = rec["au_id"].ToString();
}
}
protected string ModelDisplay(object o)
{
System.Data.Common.DbDataRecord dr = o as System.Data.Common.DbDataRecord;
if (o == null || o == DBNull.Value || dr == null || dr["Family"] == DBNull.Value)
{
return(Resources.LogbookEntry.FieldTotal);
}
string szFamily = (string)dr["Family"];
return(szFamily.StartsWith("(", StringComparison.CurrentCultureIgnoreCase) ? szFamily : (string)dr["ModelDisplay"]);
}
//-------------------------------------------------------------------------------------------
void ByDay_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
DateTime date = new DateTime(rd.GetInt32(0), rd.GetInt32(1), rd.GetInt32(2));
e.Item.Cells[0].Text = date.ToString("MM/dd/yy");
if (date > DateTime.Now)
{
e.Item.Cells[0].Font.Italic = true;
e.Item.Cells[0].ForeColor = System.Drawing.Color.Gray;
}
}
}
//-------------------------------------------------------------------------------------------
void ByMonth_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
DateTime monthCalc = new DateTime(Int32.Parse(YearFilter.Text), rd.GetInt32(0), 1);
e.Item.Cells[0].Text = monthCalc.ToString("MMMM");
if (monthCalc > DateTime.Now)
{
e.Item.Cells[0].Font.Italic = true;
e.Item.Cells[0].ForeColor = System.Drawing.Color.Gray;
}
}
}
//-------------------------------------------------------------------------------------------
void ByWeek_ItemDataBound(object sender, DataGridItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item ||
e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
DateTime weekStart = GetDatesForWeek(rd.GetInt32(0), Int32.Parse(YearFilter.Text));
e.Item.Cells[0].Text = weekStart.ToString("MM/dd/yy") + "-" + weekStart.AddDays(7).ToString("MM/dd/yy");
e.Item.Cells[0].ToolTip = rd.GetInt32(0).ToString();
if (weekStart > DateTime.Now)
{
e.Item.Cells[0].Font.Italic = true;
e.Item.Cells[0].ForeColor = System.Drawing.Color.Gray;
}
}
}
public static void AuditEntityDeleted(AuditEntry entry, DbDataRecord record, string prefix = "")
{
for (var i = 0; i < record.FieldCount; i++)
{
var name = record.GetName(i);
var value = record.GetValue(i);
var valueRecord = value as DbDataRecord;
if (valueRecord != null)
{
// Complex Type
AuditEntityDeleted(entry, valueRecord, string.Concat(prefix, name, "."));
}
else
{
entry.Properties.Add(new AuditEntryProperty(string.Concat(prefix, name), value, null));
}
}
}
protected void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow)
{
return;
}
System.Data.Common.DbDataRecord dbdr = e.Row.DataItem as System.Data.Common.DbDataRecord;
HyperLink hyp = (HyperLink)e.Row.FindControl("HyperLink1");
if (((string)dbdr["emailaddr"]).Length > 0)
{
hyp.ToolTip = (string)dbdr["emailaddr"];
hyp.NavigateUrl = "mailto:" + (string)dbdr["emailaddr"];
}
else
{
hyp.ToolTip = "No email available";
}
}
public bool MoveNext() {
if (null == _schemaInfo) {
BuildSchemaInfo();
}
Debug.Assert(null != _schemaInfo && null != _descriptors, "unable to build schema information!");
_current = null;
if (_reader.Read()) {
// setup our current record
object[] values = new object[_schemaInfo.Length];
_reader.GetValues(values); // this.GetValues()
_current = new DataRecordInternal(_schemaInfo, values, _descriptors, _fieldNameLookup); // this.NewRecord()
return true;
}
if (closeReader) {
_reader.Close();
}
return false;
}
public static void AuditEntityModified(Audit audit, AuditEntry entry, DbDataRecord orginalRecord, DbUpdatableDataRecord currentRecord, string prefix = "")
{
for (var i = 0; i < orginalRecord.FieldCount; i++)
{
var name = orginalRecord.GetName(i);
var originalValue = orginalRecord.GetValue(i);
var currentValue = currentRecord.GetValue(i);
var valueRecord = originalValue as DbDataRecord;
if (valueRecord != null)
{
// Complex Type
AuditEntityModified(audit, entry, valueRecord, currentValue as DbUpdatableDataRecord, string.Concat(prefix, name, "."));
}
else
{
if (audit.Configuration.IncludePropertyUnchanged || !Equals(currentValue, originalValue))
{
entry.Properties.Add(new AuditEntryProperty(string.Concat(prefix, name), originalValue, currentValue));
}
}
}
}
public bool MoveNext()
{
if (null == _schemaInfo)
{
BuildSchemaInfo();
}
Debug.Assert(null != _schemaInfo, "unable to build schema information!");
_current = null;
if (_reader.Read())
{
// setup our current record
object[] values = new object[_schemaInfo.Length];
_reader.GetValues(values); // this.GetValues()
_current = new DataRecordInternal(_schemaInfo, values, _fieldNameLookup); // this.NewRecord()
return(true);
}
if (_closeReader)
{
_reader.Dispose();
}
return(false);
}
internal key_constraintsClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
name = record["name"].Convert<string>();
object_id = record["object_id"].Convert<int?>();
principal_id = record["principal_id"].Convert<int?>();
schema_id = record["schema_id"].Convert<int?>();
parent_object_id = record["parent_object_id"].Convert<int?>();
type = record["type"].Convert<string>();
type_desc = record["type_desc"].Convert<string>();
create_date = record["create_date"].Convert<DateTime?>();
modify_date = record["modify_date"].Convert<DateTime?>();
is_ms_shipped = record["is_ms_shipped"].Convert<Boolean?>();
is_published = record["is_published"].Convert<Boolean?>();
is_schema_published = record["is_schema_published"].Convert<Boolean?>();
unique_index_id = record["unique_index_id"].Convert<int?>();
is_system_named = record["is_system_named"].Convert<Boolean?>();
}
private static string ComplexTypeString(DbDataRecord item)
{
var dbRecString = new StringBuilder();
for (var i = 0; i < item.FieldCount; i++)
{
if (item[i] == DBNull.Value)
{
dbRecString.AppendLine("");
}
else
{
dbRecString.AppendLine((String)(item[i]));
}
}
return dbRecString.ToString();
}
static object[] Converter(DbDataRecord arg)
{
var result = new object[arg.FieldCount];
for(var i = 0; i < arg.FieldCount; i++)
result[i] = arg[i];
return result;
}
public static String GetTimeZoneAdjustedDateTimeString(
DbDataRecord dataRecord,
String fieldName,
double timeZoneOffset,
String formatPattern)
{
String result = String.Empty;
log.Debug("GetTimeZoneAdjustedDateTimeString fieldname was " + fieldName);
if (
(dataRecord != null)
&& (fieldName != null)
)
{
try
{
if (dataRecord.GetOrdinal(fieldName) > -1)
{
if (dataRecord[fieldName] != DBNull.Value)
{
result = Convert.ToDateTime(dataRecord[fieldName]).AddHours(timeZoneOffset).ToString(formatPattern);
//if (CultureInfo.CurrentCulture.Name == "fa-IR")
//{
// PersianDateHelper dc = new PersianDateHelper();
// result = dc.MtoSh(Convert.ToDateTime(result));
//}
}
}
}
catch (InvalidCastException)
{ }
}
return result;
}
public static String GetTimeZoneAdjustedDateTimeString(
DbDataRecord dataRecord,
String fieldName,
double timeZoneOffset)
{
String result = String.Empty;
if (
(dataRecord != null)
&&(fieldName != null)
&&(dataRecord.GetOrdinal(fieldName) > -1)
&&(dataRecord[fieldName] != DBNull.Value)
)
{
try
{
result = Convert.ToDateTime(dataRecord[fieldName]).AddHours(timeZoneOffset).ToString();
//if (CultureInfo.CurrentCulture.Name == "fa-IR")
//{
// PersianDateHelper dc = new PersianDateHelper();
// result = dc.MtoSh(Convert.ToDateTime(result));
//}
}
catch (InvalidCastException){ }
catch (ArgumentOutOfRangeException)
{
result = DateTime.MinValue.ToString();
}
}
return result;
}
internal schemasClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
name = record["name"].Convert<string>();
schema_id = record["schema_id"].Convert<int?>();
principal_id = record["principal_id"].Convert<int?>();
}
internal foreign_key_columnsClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
constraint_object_id = record["constraint_object_id"].Convert<int?>();
constraint_column_id = record["constraint_column_id"].Convert<int?>();
parent_object_id = record["parent_object_id"].Convert<int?>();
parent_column_id = record["parent_column_id"].Convert<int?>();
referenced_object_id = record["referenced_object_id"].Convert<int?>();
referenced_column_id = record["referenced_column_id"].Convert<int?>();
}
internal indexesClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
object_id = record["object_id"].Convert<int?>();
name = record["name"].Convert<string>();
index_id = record["index_id"].Convert<int?>();
type = record["type"].Convert<Byte?>();
type_desc = record["type_desc"].Convert<string>();
is_unique = record["is_unique"].Convert<Boolean?>();
data_space_id = record["data_space_id"].Convert<int?>();
ignore_dup_key = record["ignore_dup_key"].Convert<Boolean?>();
is_primary_key = record["is_primary_key"].Convert<Boolean?>();
is_unique_constraint = record["is_unique_constraint"].Convert<Boolean?>();
fill_factor = record["fill_factor"].Convert<Byte?>();
is_padded = record["is_padded"].Convert<Boolean?>();
is_disabled = record["is_disabled"].Convert<Boolean?>();
is_hypothetical = record["is_hypothetical"].Convert<Boolean?>();
allow_row_locks = record["allow_row_locks"].Convert<Boolean?>();
allow_page_locks = record["allow_page_locks"].Convert<Boolean?>();
has_filter = record["has_filter"].Convert<Boolean?>();
filter_definition = record["filter_definition"].Convert<string>();
}
internal index_columnsClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
object_id = record["object_id"].Convert<int?>();
index_id = record["index_id"].Convert<int?>();
index_column_id = record["index_column_id"].Convert<int?>();
column_id = record["column_id"].Convert<int?>();
key_ordinal = record["key_ordinal"].Convert<Byte?>();
partition_ordinal = record["partition_ordinal"].Convert<Byte?>();
is_descending_key = record["is_descending_key"].Convert<Boolean?>();
is_included_column = record["is_included_column"].Convert<Boolean?>();
}
private static object GetDisplayValue(AuditEntryState state, NavigationProperty navigationProperty, IMemberAccessor displayMember, DbDataRecord values)
{
if (values == null)
return null;
var association = navigationProperty.RelationshipType as AssociationType;
if (association == null)
return null;
// only support first constraint
var referentialConstraint = association.ReferentialConstraints.FirstOrDefault();
if (referentialConstraint == null)
return null;
var toProperties = referentialConstraint
.ToProperties
.Select(p => p.Name)
.ToList();
var fromProperties = referentialConstraint
.FromProperties
.Select(p => p.Name)
.ToList();
// make sure key columns match
if (fromProperties.Count != toProperties.Count)
return null;
var edmType = referentialConstraint
.FromProperties
.Select(p => p.DeclaringType)
.FirstOrDefault();
if (edmType == null)
return null;
var eSql = string.Format("SELECT VALUE t FROM {0} AS t", edmType.Name);
var q = state.ObjectContext.CreateQuery<object>(eSql);
for (int index = 0; index < fromProperties.Count; index++)
{
string fromProperty = fromProperties[index];
string toProperty = toProperties[index];
var value = values.GetValue(toProperty);
var predicate = string.Format("it.{0} == @{0}", fromProperty);
var parameter = new ObjectParameter(fromProperty, value);
q = q.Where(predicate, parameter);
}
q = q.SelectValue<object>("it." + displayMember.Name);
return q.FirstOrDefault();
}
private static object GetDisplayValue(AuditEntryState state, NavigationProperty navigationProperty, IMemberAccessor displayMember, DbDataRecord values)
{
if (values == null)
return null;
var association = navigationProperty.RelationshipType as AssociationType;
if (association == null)
return null;
// only support first constraint
var referentialConstraint = association.ReferentialConstraints.FirstOrDefault();
if (referentialConstraint == null)
return null;
var toProperties = referentialConstraint
.ToProperties
.Select(p => p.Name)
.ToList();
var fromProperties = referentialConstraint
.FromProperties
.Select(p => p.Name)
.ToList();
// make sure key columns match
if (fromProperties.Count != toProperties.Count)
return null;
var edmType = referentialConstraint
.FromProperties
.Select(p => p.DeclaringType)
.FirstOrDefault();
if (edmType == null)
return null;
var entitySet = state.ObjectContext.GetEntitySet(edmType.FullName);
var sql = new StringBuilder();
sql.Append("SELECT VALUE t.")
.Append(displayMember.Name)
.Append(" FROM ")
.Append(entitySet.Name)
.Append(" as t")
.Append(" WHERE ");
var parameters = new List<ObjectParameter>();
for (int index = 0; index < fromProperties.Count; index++)
{
if (index > 0)
sql.Append(" AND ");
string fromProperty = fromProperties[index];
string toProperty = toProperties[index];
var value = values.GetValue(toProperty);
var name = "@" + fromProperty;
sql.Append(" t.").Append(fromProperty);
if (value != null)
{
sql.Append(" == ").Append(name);
parameters.Add(new ObjectParameter(fromProperty, value));
}
else
{
sql.Append(" is null");
}
}
var q = state.ObjectContext.CreateQuery<object>(
sql.ToString(),
parameters.ToArray());
return q.FirstOrDefault();
}
internal foreign_keysClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
name = record["name"].Convert<string>();
object_id = record["object_id"].Convert<int?>();
principal_id = record["principal_id"].Convert<int?>();
schema_id = record["schema_id"].Convert<int?>();
parent_object_id = record["parent_object_id"].Convert<int?>();
type = record["type"].Convert<string>();
type_desc = record["type_desc"].Convert<string>();
create_date = record["create_date"].Convert<DateTime?>();
modify_date = record["modify_date"].Convert<DateTime?>();
is_ms_shipped = record["is_ms_shipped"].Convert<Boolean?>();
is_published = record["is_published"].Convert<Boolean?>();
is_schema_published = record["is_schema_published"].Convert<Boolean?>();
referenced_object_id = record["referenced_object_id"].Convert<int?>();
key_index_id = record["key_index_id"].Convert<int?>();
is_disabled = record["is_disabled"].Convert<Boolean?>();
is_not_for_replication = record["is_not_for_replication"].Convert<Boolean?>();
is_not_trusted = record["is_not_trusted"].Convert<Boolean?>();
delete_referential_action = record["delete_referential_action"].Convert<Byte?>();
delete_referential_action_desc = record["delete_referential_action_desc"].Convert<string>();
update_referential_action = record["update_referential_action"].Convert<Byte?>();
update_referential_action_desc = record["update_referential_action_desc"].Convert<string>();
is_system_named = record["is_system_named"].Convert<Boolean?>();
}
internal typesClass(DbDataRecord record, SQLSysViews parent)
{
_parent = parent;
name = record["name"].Convert<string>();
system_type_id = record["system_type_id"].Convert<Byte?>();
user_type_id = record["user_type_id"].Convert<int?>();
schema_id = record["schema_id"].Convert<int?>();
principal_id = record["principal_id"].Convert<int?>();
max_length = record["max_length"].Convert<Int16?>();
precision = record["precision"].Convert<Byte?>();
scale = record["scale"].Convert<Byte?>();
collation_name = record["collation_name"].Convert<string>();
is_nullable = record["is_nullable"].Convert<Boolean?>();
is_user_defined = record["is_user_defined"].Convert<Boolean?>();
is_assembly_type = record["is_assembly_type"].Convert<Boolean?>();
default_object_id = record["default_object_id"].Convert<int?>();
rule_object_id = record["rule_object_id"].Convert<int?>();
is_table_type = record["is_table_type"].Convert<Boolean?>();
}
private static IEnumerable<string> GetColumnNames(DbDataRecord record)
{
// Get all of the column names for this query
for (int i = 0; i < record.FieldCount; i++)
{
yield return record.GetName(i);
}
}
public object CreateObject(DbDataRecord current, Context context) { return _createObjectFunction(current, context); }
