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