protected override Persona Carica_Record(ref System.Data.Common.DbDataReader dr) { return(new Persona() { CF = cGB.ObjectToString(dr["CF"]), Cognome = cGB.ObjectToString(dr["Cognome"]), Nome = cGB.ObjectToString(dr["Nome"]), Sesso = cGB.ObjectToChar(dr["Sesso"], 'M'), DataDiNascita = cGB.ObjectToDateTime(dr["DataDiNascita"]), LuogoDiNascita = cGB.ObjectToString(dr["LuogoDiNascita"]), Madre_CF = cGB.ObjectToString(dr["Madre_CF"]), Padre_CF = cGB.ObjectToString(dr["Padre_CF"]), Tutore_CF = cGB.ObjectToString(dr["Tutore_CF"]), NazioneDiNascita = cGB.ObjectToString(dr["NazioneDiNascita"]), Professione = cGB.ObjectToString(dr["Professione"]), AdesioneGSG = cGB.ObjectToChar(dr["AdesioneGSG"], 'F'), ExRicerca = new Persona.sExRicerca() { Madre = cGB.ObjectToString(dr["Madre"]), Padre = cGB.ObjectToString(dr["Padre"]), Tutore = cGB.ObjectToString(dr["Tutore"]) } }); }
public VisitedSystemsClass(DbDataReader reader) { id = (long)reader["id"]; Name = (string)reader["Name"]; Time = (DateTime)reader["Time"]; Commander = (int)(long)reader["Commander"]; Source = (long)reader["Source"]; Unit = (string)reader["Unit"]; EDSM_sync = (bool)reader["edsm_sync"]; MapColour = (int)(long)reader["Map_colour"]; if (reader["X"] == DBNull.Value) { X = double.NaN; Y = double.NaN; Z = double.NaN; } else { X = (double)reader["X"]; Y = (double)reader["Y"]; Z = (double)reader["Z"]; } if (reader["id_edsm_assigned"] != DBNull.Value) { id_edsm_assigned = (long)reader["id_edsm_assigned"]; } }
protected override void MappingData(System.Data.Common.DbDataReader reader) { if (!reader.IsDBNull(reader.GetOrdinal("Id"))) { Id = (Guid)reader["Id"]; } if (!reader.IsDBNull(reader.GetOrdinal("Title"))) { Title = (string)reader["Title"]; } if (!reader.IsDBNull(reader.GetOrdinal("Path"))) { Path = (string)reader["Path"]; } if (!reader.IsDBNull(reader.GetOrdinal("CreationDate"))) { CreationDate = (DateTime)reader["CreationDate"]; CreationDateString = string.Format("{0:dd/MM/yyyy}", (DateTime)reader["CreationDate"]); } if (!reader.IsDBNull(reader.GetOrdinal("Priority"))) { Priority = (int)reader["Priority"]; } if (!reader.IsDBNull(reader.GetOrdinal("FileExtension"))) { FileExtension = (string)reader["FileExtension"]; } }
public Entity.BaseResponse <List <Entity.KitDevice> > ProvisionKit(Entity.ProvisionKitRequest request) { Entity.BaseResponse <List <Entity.KitDevice> > result = new Entity.BaseResponse <List <Entity.KitDevice> >(); try { _logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { var kitDevices = string.Join(",", request.KitDevices); List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CompanyId, component.helper.SolutionConfiguration.Version); parameters.Add(sqlDataAccess.CreateParameter("kitCode", request.KitCode, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("uniqueId", kitDevices, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("greenhouseguid", request.GreenHouseGuid, DbType.Guid, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("culture", component.helper.SolutionConfiguration.Culture, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Provision_HardwareKit]", CommandType.StoredProcedure, null), parameters.ToArray()); result.Data = DataUtils.DataReaderToList <Entity.KitDevice>(dbDataReader, null); if (parameters.Where(p => p.ParameterName.Equals("output")).FirstOrDefault().Value.ToString() == "1") { result.Message = parameters.Where(p => p.ParameterName.Equals("fieldname")).FirstOrDefault().Value.ToString(); } } _logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name); } catch (Exception ex) { _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); } return(result); }
public Entity.SearchResult <List <Model.Device> > List(Entity.SearchRequest request) { Entity.SearchResult <List <Model.Device> > result = new Entity.SearchResult <List <Model.Device> >(); try { _logger.InfoLog(LogHandler.Constants.ACTION_ENTRY, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version); parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("isParent", false, DbType.Boolean, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Device_List]", CommandType.StoredProcedure, null), parameters.ToArray()); result.Items = DataUtils.DataReaderToList <Model.Device>(dbDataReader, null); result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString()); } _logger.InfoLog(LogHandler.Constants.ACTION_EXIT, null, "", "", this.GetType().Name, MethodBase.GetCurrentMethod().Name); } catch (Exception ex) { _logger.ErrorLog(ex, this.GetType().Name, MethodBase.GetCurrentMethod().Name); } return(result); }
protected override void DoPopulateDomain(System.Data.Common.DbDataReader reader, AbstractDomain domain) { Order o = domain as Order; o.Id = CheckNull(reader, "ADSID", 0); o.ORDER_ID = CheckNull(reader, "ORDER_ID", 0); o.EVENT_ID = CheckNull(reader, "EVENT_ID", 0); o.GRAPHER_ID = CheckNull(reader, "GRAPHER_ID", ""); o.STATUS_ID = CheckNull(reader, "STATUS_ID", 0); o.USER_ID = CheckNull(reader, "USER_ID", 0); o.ORDER_DATE = CheckNull(reader, "ORDER_DATE", DateTime.Now); o.ADS_DATE = CheckNull(reader, "ADS_DATE", DateTime.Now); o.FOLDER_NAME = CheckNull(reader, "FOLDER_NAME", ""); o.PAGES = CheckNull(reader, "PAGES", 0); o.ALBUM_TYPE = CheckNull(reader, "ALBUM_TYPE", 0); o.ALBUM_STYLE = CheckNull(reader, "ALBUM_STYLE", 0); o.ALBUM_SIZE = CheckNull(reader, "ALBUM_SIZE", 0); o.ORIGINAL_ALBUM_ID = CheckNull(reader, "ORIGINAL_ALBUM_ID", 0); o.ALBUM_ID = CheckNull(reader, "ALBUM_ID", 0); o.IMAGES = CheckNull(reader, "IMAGES", 0); o.ALBUM_NAME = CheckNull(reader, "ALBUM_NAME", ""); o.ORDER_STATUS = CheckNull(reader, "ORDER_STATUS", 0); o.ALBUM_RATING = CheckNull(reader, "ALBUM_RATING", 0); o.COMMENTS = CheckNull(reader, "COMMENTS", ""); o.SPECIAL_INSTRUCTIONS = CheckNull(reader, "SPECIAL_INSTRUCTIONS", ""); o.ACTION = CheckNull(reader, "ACTION", 0); o.GENERALGUIDELINES = CheckNull(reader, "GENERALGUIDELINES", ""); o.INSTRUCTION_ID = CheckNull(reader, "INSTRUCTION_ID", 0); o.PRODUCT_NAME = CheckNull(reader, "PRODUCT_NAME", ""); o.PRIORITY = CheckNull(reader, "PRIORITY", 0); o.RELEASE_STATUS = CheckNull(reader, "RELEASE_STATUS", 0); o.IMAGE_LIST = CheckNull(reader, "IMAGE_LIST", ""); o.REDESIGN = CheckNull(reader, "REDESIGN", ""); }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["PortletId"]; _name = (string)reader["PortletName"]; _displayURL = (string)reader["PortletDisplayURL"]; _editURL = (string)reader["PortletEditURL"]; }
public Summoner(DbDataReader dataReader) { Reader reader = new Reader(dataReader); Id = reader.Integer(); Region = reader.String().ToRegionType(); AccountId = reader.Integer(); SummonerId = reader.Integer(); SummonerName = reader.String(); InternalName = reader.String(); SummonerLevel = reader.Integer(); ProfileIcon = reader.Integer(); UpdateAutomatically = reader.Boolean(); TimeCreated = reader.Time(); TimeUpdated = reader.Time(); reader.SanityCheck(Fields); Ratings = new List<SummonerRating>(); RatingDictionary = new Dictionary<MapType, Dictionary<GameModeType, SummonerRating>>(); RankedStatistics = new List<SummonerRankedStatistics>(); }
Dictionary<string, string> ReadHeaders(DbDataReader reader) { using (var textReader = reader.GetTextReader(4)) { return Serializer.Deserialize<Dictionary<string, string>>(textReader); } }
public Entity.SearchResult <List <Model.Role> > List(Entity.SearchRequest request) { Entity.SearchResult <List <Model.Role> > result = new Entity.SearchResult <List <Model.Role> >(); try { logger.Information(Constants.ACTION_ENTRY, "RoleRepository.Get"); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CurrentUserId, request.Version); parameters.Add(sqlDataAccess.CreateParameter("companyguid", component.helper.SolutionConfiguration.CompanyId, DbType.Guid, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("search", request.SearchText, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("pagesize", request.PageSize, DbType.Int32, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("pagenumber", request.PageNumber, DbType.Int32, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("orderby", request.OrderBy, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("count", DbType.Int32, ParameterDirection.Output, 16)); parameters.Add(sqlDataAccess.CreateParameter("culture", component.helper.SolutionConfiguration.Culture, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Role_List]", CommandType.StoredProcedure, null), parameters.ToArray()); result.Items = DataUtils.DataReaderToList <Model.Role>(dbDataReader, null); result.Count = int.Parse(parameters.Where(p => p.ParameterName.Equals("count")).FirstOrDefault().Value.ToString()); } logger.Information(Constants.ACTION_EXIT, "RoleRepository.Get"); } catch (Exception ex) { logger.Error(Constants.ACTION_EXCEPTION, ex); } return(result); }
public SqlReaderStream( DbDataReader reader, int columnIndex) { this.reader = reader; this.columnIndex = columnIndex; }
public WorkoutPlan(DbDataReader reader) { _id = reader.GetInt64(0); _title = reader.GetValue(1).ToString() == "" ? "" : reader.GetString(1); _period = reader.GetValue(2).ToString() == "" ? (byte)0 : reader.GetByte(2); _creatorId = reader.GetValue(3).ToString() == "" ? 0 : reader.GetInt64(3); }
public static void GetPrestataire() { String sql = "SELECT * FROM Prestataire"; using (MySqlCommand command = new MySqlCommand(sql, connection)) { try { command.Connection.Open(); } catch (MySqlException) { } using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { int Id = dbReader.GetInt32(0); String Nom = dbReader.GetString(1); String Url = dbReader.GetString(2); String Categorie = dbReader.GetString(3); String Contact = dbReader.GetString(4); String Adresse = dbReader.GetString(5); String Description = dbReader.GetString(6); Boolean Activation = dbReader.GetBoolean(7); String Prix = dbReader.GetString(8); // attente de la création de la class business Business.Prestataires.Add(new Prestataire(Id, Nom, Url, Categorie, Contact, Adresse, Description, Activation, Prix)); } } command.Connection.Close(); } }
public static void GetDevisPrestataire(Devis d) { String sql = "SELECT devisid, prestataireid, dp.prix, nom FROM DevisPrestataire dp inner join Prestataire p on dp.prestataireid = p.id WHERE devisId=@devisId "; using (MySqlCommand command = new MySqlCommand(sql, connection)) { command.Connection.Open(); command.Parameters.AddWithValue("@devisid", d.Id); using (System.Data.Common.DbDataReader dbReader = command.ExecuteReader()) { while (dbReader.Read()) { int devisid = dbReader.GetInt32(0); int prestataireid = dbReader.GetInt32(1); int prix = dbReader.GetInt32(2); string nom = dbReader.GetString(3); DevisPrestataire dp = new DevisPrestataire(devisid, prestataireid, prix) { Nom = nom }; d.DevisPrestataires.Add(dp); } } command.Connection.Close(); } }
public Entity.BaseResponse <List <Entity.DeviceAttributeChartResponse> > GetDeviceAttributeChartData(Guid deviceGuid, string attributeName, string frequency) { Entity.BaseResponse <List <Entity.DeviceAttributeChartResponse> > result = new Entity.BaseResponse <List <Entity.DeviceAttributeChartResponse> >(true); try { logger.Information(Constants.ACTION_ENTRY, "DeviceRepository.GetDeviceAttributeChartData"); using (var sqlDataAccess = new SqlDataAccess(ConnectionString)) { List <System.Data.Common.DbParameter> parameters = sqlDataAccess.CreateParams(component.helper.SolutionConfiguration.CompanyId, component.helper.SolutionConfiguration.Version); parameters.Add(sqlDataAccess.CreateParameter("guid", deviceGuid, DbType.Guid, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("attribute", attributeName, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("frequency", frequency, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("culture", component.helper.SolutionConfiguration.Culture, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("enableDebugInfo", component.helper.SolutionConfiguration.EnableDebugInfo, DbType.String, ParameterDirection.Input)); parameters.Add(sqlDataAccess.CreateParameter("syncDate", DateTime.UtcNow, DbType.DateTime, ParameterDirection.Output)); System.Data.Common.DbDataReader dbDataReader = sqlDataAccess.ExecuteReader(sqlDataAccess.CreateCommand("[Chart_QualityParameter]", CommandType.StoredProcedure, null), parameters.ToArray()); result.Data = DataUtils.DataReaderToList <Entity.DeviceAttributeChartResponse>(dbDataReader, null); if (parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault() != null) { result.LastSyncDate = Convert.ToString(parameters.Where(p => p.ParameterName.Equals("syncDate")).FirstOrDefault().Value); } } logger.Information(Constants.ACTION_EXIT, "DeviceRepository.GetDeviceAttributeChartData"); } catch (Exception ex) { logger.Error(Constants.ACTION_EXCEPTION, ex); } return(result); }
protected override void LoadFromReader(AuthRole _obj, System.Data.Common.DbDataReader reader) { _obj.RoleID = GetInt32(reader, "RoleID"); _obj.RoleName = GetString(reader, "RoleName"); _obj.Description = GetString(reader, "Description"); _obj.FullControl = GetString(reader, "FullControl"); }
public static string GetSqlValue(DbDataReader reader, int column, string dateTimePattern = "") { object val = reader[column]; var s = string.Empty; if (val == DBNull.Value) { s = "NULL"; } else { if (val is DateTime) { if (string.IsNullOrEmpty(dateTimePattern)) { dateTimePattern = "yyyy/MM/dd"; } if (((DateTime)val).Year == 1900) { s = "NULL"; } else { s = "'" + ((DateTime)val).ToString(dateTimePattern) + "'"; } } else if (val is double) { s = Math.Round((double)val, 4).ToString(); } else { s = "'" + val.ToString().Trim().Replace("'", "''") + "'"; } } return s; }
internal static Model.ContactsApplicationMapping MapToContactsApplication(System.Data.Common.DbDataReader dr) { ContactsApplicationMapping cam = new ContactsApplicationMapping(); cam.IdMap = (long)dr.GetDecimal("ID_MAP"); cam.IdTitolo = (long)dr.GetDecimal("ID_TITOLO"); cam.AppCode = dr.GetString("APP_CODE"); cam.Titolo = dr.GetString("TITOLO"); cam.TitoloCode = dr.GetString("TITOLO_PROT_CODE"); cam.IsTitoloActive = Convert.ToBoolean(dr.GetDecimal("TITOLO_ACTIVE")); cam.IdSottotitolo = (long)dr.GetDecimal("ID_SOTTOTITOLO"); cam.Sottotitolo = dr.GetString("SOTTOTITOLO"); cam.SottotitoloCode = dr.GetString("SOTTOTITOLO_PROT_CODE"); cam.IsSottotitoloActive = Convert.ToBoolean(dr.GetDecimal("SOTTOTITOLO_ACTIVE")); cam.ComCode = dr.GetString("COM_CODE"); cam.IdContact = (long)dr.GetDecimal("ID_CONTACT"); cam.Mail = dr.GetString("MAIL"); cam.Fax = dr.GetString("FAX"); cam.Telefono = dr.GetString("TELEFONO"); cam.RefIdReferral = (long)dr.GetDecimal("REF_ID_REFERRAL"); cam.IsPec = Convert.ToBoolean(dr.GetDecimal("FLG_PEC")); cam.RefOrg = (long)dr.GetDecimal("REF_ORG"); cam.IdCanale = (long)dr.GetDecimal("ID_CANALE"); cam.Codice = dr.GetString("CODICE"); cam.IdBackend = (long)dr.GetDecimal("ID_BACKEND"); cam.BackendCode = dr.GetString("BACKEND_CODE"); cam.BackendDescr = dr.GetString("BACKEND_DESCR"); cam.Category = dr.GetString("CATEGORY"); cam.DescrPlus = dr.GetString("DESCR_PLUS"); return(cam); }
public static void Write(XmlDocument target, DbDataReader source ) { /* Style: <root> <raw><name>name1</name><index>name2</index></raw> <raw><name>name1</name><index>name2</index></raw> <raw><name>name1</name><index>name2</index></raw> </root> */ XmlNode head = target.CreateNode(XmlNodeType.Element, "head", ""); XmlNode body = target.CreateNode(XmlNodeType.Element, "body", ""); for (int i = 0; i < source.FieldCount; ++i) { string vl = source.GetName(i); string local = (string)HttpContext.GetGlobalResourceObject("local", vl); if (local != null) vl = local; Util.AddNodedText(head, "column", vl, false); } while (source.Read()) { XmlNode raw = target.CreateNode(XmlNodeType.Element, "raw", ""); for (int i = 0; i < source.FieldCount; ++i) Util.AddNodedText(raw, "value", Util.GetString( source, i ), false); body.AppendChild(raw); } target.FirstChild.AppendChild(head); target.FirstChild.AppendChild(body); }
/// <summary> /// This API supports the Entity Framework Core infrastructure and is not intended to be used /// directly from your code. This API may change or be removed in future releases. /// </summary> public virtual ValueBuffer Create(DbDataReader dataReader) { Debug.Assert(dataReader != null); // hot path var fieldCount = dataReader.FieldCount; if (fieldCount == 0) { return ValueBuffer.Empty; } var values = new object[fieldCount]; dataReader.GetValues(values); _processValuesAction?.Invoke(values); for (var i = 0; i < fieldCount; i++) { if (ReferenceEquals(values[i], DBNull.Value)) { values[i] = null; } } return new ValueBuffer(values); }
private static BasicPerson ReadPersonFromDataReader (DbDataReader reader) { int personId = reader.GetInt32(0); string passwordHash = reader.GetString(1); string name = reader.GetString(2); string email = reader.GetString(3); string street = reader.GetString(4); string postalCode = reader.GetString(5); string cityName = reader.GetString(6); int countryId = reader.GetInt32(7); string phone = reader.GetString(8); int geographyId = reader.GetInt32(9); DateTime birthdate = reader.GetDateTime(10); int genderId = reader.GetInt32(11); // Fix broken names, emails email = email.ToLower().Trim(); name = name.Trim(); while (name.Contains(" ")) { name = name.Replace(" ", " "); } return new BasicPerson(personId, passwordHash, name, email, street, postalCode, cityName, countryId, phone, geographyId, birthdate, (PersonGender)genderId); }
public static DbTable LoadDb(DbDataReader reader) { if (!reader.Read()) { return null; } var tbl = new DbTable((string)reader["TABLE_NAME"]); var firstColumn = new DbColumn( (string)reader["COLUMN_NAME"], (string)reader["DATA_TYPE"] ); tbl.Columns = new List<DbColumn>() { firstColumn }; while (reader.Read()) { if (tbl.Name != (string)reader["TABLE_NAME"]) { break; } tbl.Columns.Add(new DbColumn( (string)reader["COLUMN_NAME"], (string)reader["DATA_TYPE"] )); } return tbl; }
public DynamicEntityValue(DbDataReader reader) { for(int i = 0; i < reader.FieldCount; i++) { this._nameValues.Add(reader.GetName(i), reader.GetValue(i)); } }
private void frm_load() { try { System.Data.Common.DbDataReader dbRS = null; string strSql = "SELECT * FROM CODE_DTL WHERE CODE_TYPE = 'PRIVILEGE' ORDER BY CODE_NO "; if (!clsDB.FunOpenDB()) { throw new Exception("資料庫開啟失敗!"); } if (clsDB.FunRsSql(strSql, ref dbRS)) { while (dbRS.Read()) { cboProgStytle.Items.Add(dbRS["CODE_NO"].ToString() + ":" + dbRS["CODE_NAME"].ToString()); } dbRS.Close(); // DbDataReader Close } clsDB.FunClsDB(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
internal DisposingDbDataReader(DbCommand command) { if (command == null) throw new ArgumentNullException("command"); this.command = command; reader = command.ExecuteReader(CommandBehavior.CloseConnection); }
public DataReaderInspectorDataReader(DbDataReader wrappedDataReader, IResultSetComposer composer) { this.wrappedDataReader = wrappedDataReader; this.composer = composer; this.commitNext = false; this.needCommit = false; }
private IEnumerable<KeyValuePair<Shaper<RecordState>, CoordinatorFactory<RecordState>>> GetNextResultShaperInfo( DbDataReader storeDataReader, MetadataWorkspace workspace, IEnumerable<ColumnMap> nextResultColumnMaps) { // It is important to do this lazily as the storeDataReader will have advanced to the next result set // by the time this IEnumerable is advanced return nextResultColumnMaps.Select(nextResultColumnMap => CreateShaperInfo(storeDataReader, nextResultColumnMap, workspace)); }
public double? ReadDouble(DbDataReader reader, int index) { double d = double.NaN; if (reader.IsDBNull(index)) return 0; Object obj = reader.GetValue(index); if (obj.GetType() == typeof(Decimal)) { d = Decimal.ToDouble((Decimal)obj); } else if (obj.GetType() == typeof(double)) { d = (double)obj; } else if (obj.GetType() == typeof(float)) { d = (float)obj; } else if (obj.GetType() == typeof(string)) { d = double.Parse((string)obj); } else return null; return d; }
private BasicOutboundInvoice ReadOutboundInvoiceFromDataReader(DbDataReader reader) { int outboundInvoiceId = reader.GetInt32(0); string customerName = reader.GetString(1); string invoiceAddressPaper = reader.GetString(2); string invoiceAddressMail = reader.GetString(3); int currencyId = reader.GetInt32(4); // double amount = reader.GetDouble(5); int organizationId = reader.GetInt32(6); int budgetId = reader.GetInt32(7); DateTime createdDateTime = reader.GetDateTime(8); int createdByPersonId = reader.GetInt32(9); DateTime dueDate = reader.GetDateTime(10); int reminderCount = reader.GetInt32(11); string reference = reader.GetString(12); bool domestic = reader.GetBoolean(13); bool open = reader.GetBoolean(14); bool sent = reader.GetBoolean(15); string securityCode = reader.GetString(16); string theirReference = reader.GetString(17); return new BasicOutboundInvoice(outboundInvoiceId, customerName, invoiceAddressPaper, invoiceAddressMail, currencyId, organizationId, budgetId, createdDateTime, createdByPersonId, dueDate, reminderCount, reference, domestic, open, sent, securityCode, theirReference); }
private static string[] GetColumnNames(DbDataReader dr, int numberOfColumns) { var colNames = new List<string>(); for (int i = 0; i < numberOfColumns; i++) { colNames.Add(dr.GetName(i)); } return colNames.ToArray(); }
private static void MapRow(DbDataReader dr, int numberOfColumns, ResultSet table) { var row = new object[numberOfColumns]; for (int i = 0; i < numberOfColumns; i++) { row[i] = (DBNull.Value.Equals(dr[i])) ? null : dr[i]; } table.AddRow(row); }
public override object Map(DbDataReader dataReader, RowMapperContext context) { if (context.Instance == null) { context.Instance = context.PocoData.CreateObject(dataReader); if (context.Instance == null) throw new Exception(string.Format("Cannot create POCO '{0}'. It may have no parameterless constructor or be an interface or abstract class without a Mapper factory.", context.Type.FullName)); } else { _mappingOntoExistingInstance = true; } object[] values = new object[dataReader.FieldCount]; dataReader.GetValues(values); _mapPlan(dataReader, values, context.Instance); var result = context.Instance as IOnLoaded; if (result != null) { result.OnLoaded(); } return context.Instance; }
protected override void DoPopulateDomain(System.Data.Common.DbDataReader reader, AbstractDomain domain) { Status s = domain as Status; s.Id = CheckNull(reader, "STATUS_ID", 0); s.ORDER_STATUS = CheckNull(reader, "ORDER_STATUS", ""); }
public virtual ValueBuffer CreateValueBuffer(DbDataReader dataReader) { Debug.Assert(dataReader != null); // hot path Debug.Assert(dataReader.FieldCount >= _indexMap.Count); if (_indexMap.Count == 0) { return ValueBuffer.Empty; } var values = new object[dataReader.FieldCount]; dataReader.GetValues(values); var remappedValues = new object[_indexMap.Count]; for (var i = 0; i < _indexMap.Count; i++) { remappedValues[i] = ReferenceEquals(values[_indexMap[i]], DBNull.Value) ? null : values[_indexMap[i]]; } return new ValueBuffer(remappedValues); }
public static RecTransportVehicleStd ParseTransportVehicleStd( DbDataReader dataReader ) { var record = new RecTransportVehicleStd(); record.Factory = DataConverter.Cast<string>( dataReader[0] ); record.Project = DataConverter.Cast<string>( dataReader[1] ); record.Name = DataConverter.Cast<string>( dataReader[2] ); record.Division = DataConverter.Cast<string>( dataReader[3] ); record.Description = DataConverter.Cast<string>( dataReader[4] ); record.VehicleType = DataConverter.Cast<int>( dataReader[5] ); record.TransportType = DataConverter.Cast<int>( dataReader[6] ); record.Length = DataConverter.Cast<double>( dataReader[7] ); record.Width = DataConverter.Cast<double>( dataReader[8] ); record.Height = DataConverter.Cast<double>( dataReader[9] ); record.Mass = DataConverter.Cast<double>( dataReader[10] ); record.MaxLength = DataConverter.Cast<double>( dataReader[11] ); record.MaxWidth = DataConverter.Cast<double>( dataReader[12] ); record.MaxHeight = DataConverter.Cast<double>( dataReader[13] ); record.MaxMass = DataConverter.Cast<double>( dataReader[14] ); record.Created_By = DataConverter.Cast<string>( dataReader[15] ); record.Created_Date = DataConverter.Cast<DateTime?>( dataReader[16] ); record.Changed_By = DataConverter.Cast<string>( dataReader[17] ); record.Changed_Date = DataConverter.Cast<DateTime?>( dataReader[18] ); return record; }
public void Postprocess(DbDataReader reader, IList<Exception> exceptions) { reader.Read(); var values = reader.GetFieldValue<int[]>(0); applyDataFromSproc(values); }
/// <summary> /// Assigns its properties with a record from a database. /// </summary> /// <param name="oDataReader">Data reader that holds the elements to populate itself with. Uses the abstract class <see cref="DbDataReader"/> to work with data readers for different DBMSs.</param> public void Create(DbDataReader oDataReader) { int iId; if (Int32.TryParse(oDataReader["id"].ToString(), out iId)) { Id = iId; } else { throw new InvalidCastException("Error converting id to an integer"); } Name = oDataReader["name"].ToString(); if (Int32.TryParse(oDataReader["locality_id"].ToString(), out iId)) { LocalityId = iId; } else { throw new InvalidCastException("Error converting locality id to an integer"); } if (Int32.TryParse(oDataReader["polling_location_id"].ToString(), out iId)) { PollingLocationId = iId; } else { throw new InvalidCastException("Error converting polling location id to an integer"); } }
/// <summary> /// Gets the value from the row /// </summary> /// <typeparam name="T"></typeparam> /// <param name="rw"></param> /// <param name="toSet"></param> /// <param name="ignoreMissingColumns"></param> /// <returns></returns> public static T FromRow <T>(System.Data.Common.DbDataReader rw, T toSet, bool ignoreMissingColumns = false) { return(new RowHelper(rw) { IgnoreMissingColumns = ignoreMissingColumns }.FromRow(toSet)); }
private void Fill(DbDataReader reader, Call call) { call.Start = DateUtils.ConvertFromLinuxStamp(reader.GetValueObject<long>("begin_timestamp")); call.Duration = TimeSpan.FromSeconds(reader.GetValueObject<long>("duration")); call.Host_Identity = reader.GetObject<string>("host_identity"); call.Id = reader.GetValueObject<long>("id"); }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["MenuId"]; _name = (string)reader["MenuName"]; _description = (string)reader["MenuDescription"]; _navigationURL = (string)reader["MenuNavigationURL"]; }
public static void Print(string sql, DbDataReader reader) { log.Info("Results of [" + sql + "]"); string results = "\n"; if (reader.HasRows) { for (int j = 0; j < reader.FieldCount; j++) { results += reader.GetName(j); if (j < reader.FieldCount - 1) { results += "|"; } } results += "\n"; while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results += reader.GetValue(i); if (i < reader.FieldCount - 1) { results += "|"; } } results += "\n"; } results = results.Substring(0, results.Length - 1); log.Info(results); } }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["VoteAnswerId"]; _name = (string)reader["VoteAnswerName"]; _number = (int)reader["VoteAnswerNumber"]; _order = (int)reader["VoteAnswerOrder"]; }
public GlimpseDbDataReader(DbDataReader dataReader, DbCommand command, Guid connectionId, Guid commandId) { InnerDataReader = dataReader; InnerCommand = command; ConnectionId = connectionId; CommandId = commandId; }
public NewsSubscriber(DbDataReader r) { this.ID = Convert.ToInt32(r["ID"]); this.Name = Convert.ToString(r["Name"]); this.Email = Convert.ToString(r["Email"]); this.DateCreated = Convert.ToDateTime(r["DateCreated"]); }
public static void LoadFromReader(this ISiteRole role, DbDataReader reader) { role.NormalizedRoleName = reader["RoleName"].ToString(); role.RoleName = reader["DisplayName"].ToString(); role.SiteId = new Guid(reader["SiteGuid"].ToString()); role.Id = new Guid(reader["RoleGuid"].ToString()); }
public Department(DbDataReader reader) { DepartmentId = (Int16) reader["DepartmentID"]; Name = (string) reader["Name"]; GroupName = (string) reader["GroupName"]; ModifiedDate = (DateTime) reader["ModifiedDate"]; }
public ResourceRecord(DbDataReader reader) { Page = reader.GetString(reader.GetOrdinal("resourcepage")); CultureCode = reader.GetString(reader.GetOrdinal("culturecode")); Key = reader.GetString(reader.GetOrdinal("resourcekey")); Value = reader.GetString(reader.GetOrdinal("resourcevalue")); }
protected override void LoadFromReader(AuthItem _obj, System.Data.Common.DbDataReader reader) { _obj.ParentItemID = GetInt32(reader, "ParentItemID"); _obj.ItemID = GetInt32(reader, "ItemID"); _obj.ItemName = GetString(reader, "ItemName"); _obj.Description = GetString(reader, "Description"); _obj.DisplayName = GetString(reader, "DisplayName"); }
/// <summary> /// Gets the list. /// </summary> public static List <T> GetList <T>(this IDataHelper dh, string tsqlParamed, params Params[] paramKeyAndValue) where T : new() { Data.Common.DbDataReader dr = null; using (dr = dh.Driver.CreateDataReader(tsqlParamed, CommandType.Text, CommandBehavior.CloseConnection, paramKeyAndValue)) { return(ModelHelper.GetList <T>(dr, dh.Driver.DirverType)); } }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["ModuleId"]; _name = (string)reader["ModuleName"]; _displayURL = (string)reader["ModuleDisplayURL"]; _editURL = (string)reader["ModuleEditURL"]; _pageId = (Guid)reader["PageId"]; }
protected override void DoPopulateDomain(System.Data.Common.DbDataReader reader, AbstractDomain domain) { Priority pr = domain as Priority; pr.Id = CheckNull(reader, "Id", 0); pr.Priority_Id = CheckNull(reader, "PRIORITY_ID", 0); pr.Priority_Name = CheckNull(reader, "PRIORITY_NAME", ""); }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["FeedBackId"]; _senderName = (string)reader["FeedBackSenderName"]; _senderEmail = (string)reader["FeedBackSenderEmail"]; _phone = (string)reader["FeedBackPhone"]; _content = (string)reader["FeedBackContent"]; }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["DataId"]; _name = (string)reader["Name"]; _link = (string)reader["Link"]; _SubDomainId = (Guid)reader["SubDomainId"]; //_order = (int)reader["LinkOrder"]; }
public async Task <ITEM> LoadItemAsync(int?ID_ITEM) { ITEM temp = new ITEM(); var con = _db.Database.GetDbConnection(); con.Open(); using (var command = con.CreateCommand()) { // this does a few things. First it returns the given item id, the item name, and the current rating aggregate across all ratings for it. // additionally it finds the next seqential ID, and the previous seqential ID. If none found then 0. // this is important for the 'next/previous' buttons. string q = @" SELECT top(1) b.ID ,b.TITLE ,isnull(C.RATING, 0) as RATING ,( SELECT isnull(min(a.id), 0) FROM [test].[dbo].[ITEM] a where a.id > b.ID) as [NEXT] ,( SELECT isnull(max(a.id), 0) FROM [test].[dbo].[ITEM] a where a.id < b.ID) as [PREVIOUS] FROM [test].[dbo].[ITEM] b left JOIN ( SELECT y.[ID] ,AVG(CAST(z.RATING AS FLOAT)) as RATING FROM [dbo].[ITEM] y JOIN [dbo].[ITEM_RATING] z ON y.ID = z.ID_ITEM GROUP BY y.ID ) c ON B.ID = c.ID "; if (ID_ITEM != null) { // IF there is a specific ID (say from someone clicking 'next' then load that specific item's info, next, previous, name, aggregate rating, etc. q += " WHERE b.ID = @ID_ITEM "; DbParameter tempParameter = command.CreateParameter(); tempParameter.ParameterName = "@ID_ITEM"; tempParameter.Value = ID_ITEM; command.Parameters.Add(tempParameter); } command.CommandText = q; System.Data.Common.DbDataReader reader = await command.ExecuteReaderAsync(); if (reader.HasRows) { reader.Read(); temp = new ITEM(); temp.ID = (int)reader["ID"]; temp.TITLE = (string)reader["TITLE"]; temp.RATING = Convert.ToDecimal(reader["RATING"]); temp.NEXT = (int)reader["NEXT"]; temp.PREVIOUS = (int)reader["PREVIOUS"]; } reader.Dispose(); } return(temp); }
public override void PrepareData(System.Data.Common.DbDataReader dr) { dt = (DateTime)dr[5]; total_maquinas++; if ((long)dr[4] != 0) { total_en_uso++; } }
protected override void MappingData(System.Data.Common.DbDataReader reader) { _id = (Guid)reader["Id"]; _subDomainToId = (Guid)reader["SubDomainToId"]; _articleId = (Guid)reader["ArticleId"]; _subDomainFromId = (Guid)reader["SubDomainFromId"]; _articleNewId = (Guid)reader["ArticleNewId"]; _isCheck = (bool)reader["IsCheck"]; }
public bool Fun_RsSQL(string sSQL, ref System.Data.Common.DbDataReader retRS, bool bDBClose = false) { try { sSQL = sSQL.Replace("''", "' '"); if (this.DBConn == null) { if (this.Fun_OpenDataBase() == false) { return(false); } } else { if (this.DBConn.State != System.Data.ConnectionState.Open) { if (this.Fun_OpenDataBase() == false) { return(false); } } } if (DBConn.State != System.Data.ConnectionState.Open) { return(false); } DBCommand.Connection = DBConn; DBCommand.CommandText = sSQL; retRS = DBCommand.ExecuteReader(); if (retRS.HasRows == false) { retRS.Close(); if (bDBClose == true) { Fun_CloseDB(); } return(false); } else { if (bDBClose == true) { Fun_CloseDB(); } return(true); } } catch (Exception) { return(false); } }
protected override void DoPopulateDomain(System.Data.Common.DbDataReader reader, AbstractDomain domain) { User u = domain as User; u.Id = CheckNull(reader, "USER_ID", 0); u.RealName = CheckNull(reader, "REALNAME", ""); u.LoginId = CheckNull(reader, "LOGINID", ""); u.Password = CheckNull(reader, "PASSWORD", ""); u.STATUS_ID = CheckNull(reader, "STATUS_ID", 0); }
protected override void DoPopulateDomain(System.Data.Common.DbDataReader reader, AbstractDomain domain) { Instructions s = domain as Instructions; s.Id = CheckNull(reader, "INSTRUCTION_ID", 0); s.ORDER_ID = CheckNull(reader, "ORDER_ID", 0); s.ADDITIONALINSTRUCTION = CheckNull(reader, "ADDITIONALINSTRUCTION", ""); s.Date = CheckNull(reader, "Date", DateTime.MinValue); s.USER_ID = CheckNull(reader, "USER_ID", 0); }
/// <summary> /// Executes a command and returns the selected data /// </summary> /// <returns>The data selected by the command</returns> public sp.DataTable ExecuteReader() { using (db.DbCommand cmd = ToDbCommand()) { using (db.DbDataReader dr = cmd.ExecuteReader()) { return(sp.DataTable.FromDataReader(dr)); } } }