public List <OnlineToolsQueues> GetOnlineToolsQueues(string connectionName)
        {
            Database  db        = DatabaseFactory.CreateDatabase(connectionName);
            DbCommand dbCommand = db.GetStoredProcCommand(Resources.OnlineToolsQueuesResources.SP_Get_ToolOnlineQueues);

            List <OnlineToolsQueues> listOnlineQueue = new List <OnlineToolsQueues>();

            using (IDataReader dr = db.ExecuteReader(dbCommand))
            {
                while (dr.Read())
                {
                    int _queue       = dr.GetOrdinal(Resources.OnlineToolsQueuesResources.PARAM_QUEUES);
                    int _pcc         = dr.GetOrdinal(Resources.OnlineToolsQueuesResources.PARAM_PCC);
                    int _piccode     = dr.GetOrdinal(Resources.OnlineToolsQueuesResources.PARAM_PICCODE);
                    int _description = dr.GetOrdinal(Resources.OnlineToolsQueuesResources.PARAM_DESCRIPTION);

                    OnlineToolsQueues item = new OnlineToolsQueues();

                    item.Queue       = (dr[_queue] == DBNull.Value) ? Types.IntegerNullValue : dr.GetInt32(_queue);
                    item.PCC         = (dr[_pcc] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_pcc);
                    item.PicCode     = (dr[_piccode] == DBNull.Value) ? Types.IntegerNullValue : dr.GetInt32(_piccode);
                    item.Description = (dr[_description] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_description);
                    listOnlineQueue.Add(item);
                }
            }
            return(listOnlineQueue);
        }
        //Asigna los valores a los campos correspondientes
        private void AsignarValoresQueues(OnlineToolsQueues queue, string nombretxtQueue, string nombrecmbPCC, string nombrecmbPicCode, string valorQueue, string valorPCC, string valorPicCode)
        {
            SmartTextBox txtQueueGenerico   = (SmartTextBox)this.Controls.Find(nombretxtQueue, true)[0];
            ComboBox     cmbPCCGenerico     = (ComboBox)this.Controls.Find(nombrecmbPCC, true)[0];
            ComboBox     cmbPicCodeGenerico = (ComboBox)this.Controls.Find(nombrecmbPicCode, true)[0];

            txtQueueGenerico.Text   = valorQueue;
            cmbPCCGenerico.Text     = valorPCC;
            cmbPicCodeGenerico.Text = valorPicCode;
        }