Exemplo n.º 1
0
        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"])
                }
            });
        }
Exemplo n.º 2
0
        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"];
            }
        }
Exemplo n.º 3
0
 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);
 }
Exemplo n.º 6
0
        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", "");
        }
Exemplo n.º 7
0
 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"];
 }
Exemplo n.º 8
0
        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);
 }
Exemplo n.º 11
0
 public SqlReaderStream(
     DbDataReader reader,
     int columnIndex)
 {
     this.reader = reader;
     this.columnIndex = columnIndex;
 }
Exemplo n.º 12
0
 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);
 }
Exemplo n.º 13
0
        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();
            }
        }
Exemplo n.º 14
0
        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();
            }
        }
Exemplo n.º 15
0
 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);
 }
Exemplo n.º 16
0
 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");
 }
Exemplo n.º 17
0
 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;
 }
Exemplo n.º 18
0
        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);
        }
Exemplo n.º 19
0
    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);
        }
Exemplo n.º 21
0
        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);
        }
Exemplo n.º 22
0
        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;
        }
Exemplo n.º 23
0
 public DynamicEntityValue(DbDataReader reader)
 {
     for(int i = 0; i < reader.FieldCount; i++)
     {
         this._nameValues.Add(reader.GetName(i), reader.GetValue(i));
     }
 }
Exemplo n.º 24
0
 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);
     }
 }
Exemplo n.º 25
0
 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));
 }
Exemplo n.º 28
0
        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;
        }
Exemplo n.º 29
0
        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);
		}
Exemplo n.º 32
0
        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;
        }
Exemplo n.º 33
0
        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);
        }
Exemplo n.º 37
0
        /// <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");
            }
        }
Exemplo n.º 38
0
 /// <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");
 }
Exemplo n.º 40
0
 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"];
 }
Exemplo n.º 41
0
 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);
     }
 }
Exemplo n.º 42
0
 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"];
 }
Exemplo n.º 43
0
 public GlimpseDbDataReader(DbDataReader dataReader, DbCommand command, Guid connectionId, Guid commandId)
 {
     InnerDataReader = dataReader;
     InnerCommand = command;        
     ConnectionId = connectionId;
     CommandId = commandId; 
 }
Exemplo n.º 44
0
 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"]);
 }
Exemplo n.º 45
0
 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());
 }
Exemplo n.º 46
0
 public Department(DbDataReader reader)
 {
     DepartmentId = (Int16) reader["DepartmentID"];
     Name = (string) reader["Name"];
     GroupName = (string) reader["GroupName"];
     ModifiedDate = (DateTime) reader["ModifiedDate"];
 }
Exemplo n.º 47
0
 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");
 }
Exemplo n.º 49
0
 /// <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));
     }
 }
Exemplo n.º 50
0
 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"];
 }
Exemplo n.º 51
0
        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", "");
        }
Exemplo n.º 52
0
 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"];
 }
Exemplo n.º 53
0
 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"];
 }
Exemplo n.º 54
0
        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);
        }
Exemplo n.º 55
0
 public override void PrepareData(System.Data.Common.DbDataReader dr)
 {
     dt = (DateTime)dr[5];
     total_maquinas++;
     if ((long)dr[4] != 0)
     {
         total_en_uso++;
     }
 }
Exemplo n.º 56
0
 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"];
 }
Exemplo n.º 57
0
        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);
            }
        }
Exemplo n.º 58
0
        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);
        }
Exemplo n.º 59
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);
        }
Exemplo n.º 60
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));
         }
     }
 }