/// <summary> /// Gets the queue that has the given name from the database /// </summary> /// <param name="name">The name of the queue you want</param> /// <returns>The queue</returns> public INamedQueue GetQueue(string name) { INamedQueue retqueue = null; using (var conn = SqlHelper.CreateSqlConnection(NameOrConnectionString)) { conn.Open(); using (var command = new SqlCommand()) { command.Connection = conn; command.Parameters.Add("@name", SqlDbType.NVarChar, 63).Value = name; command.CommandText = GetSelectQueueSql(); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); retqueue = new SqlNamedQueue(reader.GetString(1), reader.GetInt32(0), this); } } } } return(retqueue); }
/// <summary> /// Creates a new queue with the given name /// </summary> /// <param name="name">The name you want for the queue</param> /// <returns>The queue you have just created</returns> public INamedQueue CreateQueue(string name) { INamedQueue queue; using (var conn = SqlHelper.CreateSqlConnection(NameOrConnectionString)) { conn.Open(); using (var commandInsert = new SqlCommand()) { commandInsert.Parameters.Add("@queuename", SqlDbType.NVarChar).Value = name; commandInsert.CommandText = GetInsertQueueSql(); commandInsert.Connection = conn; using (var reader = commandInsert.ExecuteReader()) { reader.Read(); queue = new SqlNamedQueue(name, (int)reader.GetDecimal(0), this); } } } return(queue); }
/// <summary> /// Gets the queue that has the given name from the database /// </summary> /// <param name="name">The name of the queue you want</param> /// <returns>The queue</returns> public INamedQueue GetQueue(string name) { INamedQueue retqueue = null; using (var conn = SqlHelper.CreateSqlConnection(NameOrConnectionString)) { conn.Open(); using (var command = new SqlCommand()) { command.Connection = conn; command.Parameters.Add("@name", SqlDbType.NVarChar, 63).Value = name; command.CommandText = GetSelectQueueSql(); using (var reader = command.ExecuteReader()) { if (reader.HasRows) { reader.Read(); retqueue = new SqlNamedQueue(reader.GetString(1), reader.GetInt32(0), this); } } } } return retqueue; }
/// <summary> /// Creates a new queue with the given name /// </summary> /// <param name="name">The name you want for the queue</param> /// <returns>The queue you have just created</returns> public INamedQueue CreateQueue(string name) { INamedQueue queue; using (var conn = SqlHelper.CreateSqlConnection(NameOrConnectionString)) { conn.Open(); using (var commandInsert = new SqlCommand()) { commandInsert.Parameters.Add("@queuename", SqlDbType.NVarChar).Value = name; commandInsert.CommandText = GetInsertQueueSql(); commandInsert.Connection = conn; using (var reader = commandInsert.ExecuteReader()) { reader.Read(); queue = new SqlNamedQueue(name, (int)reader.GetDecimal(0), this); } } } return queue; }