/// <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); }