internal static SSBIConversationCollection GetConversationCollection(Database db, BrokerService bServ, Guid handle) { SqlConnection conn = null; int servid; conn = CreateNewConnection(db); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sqlConversation; if (bServ != null) { servid = bServ.ID; cmd.CommandText += " and se.service_id = @id"; cmd.Parameters.Add("@id", SqlDbType.Int, 4); cmd.Parameters["@id"].Value = servid; } if (handle != Guid.Empty) { cmd.CommandText += " and se.conversation_handle = @h"; cmd.Parameters.Add("@h", SqlDbType.UniqueIdentifier); cmd.Parameters["@h"].Value = handle; } if (conn.Database != db.Name) { conn.ChangeDatabase(db.Name); } SqlDataReader dr = cmd.ExecuteReader(); SSBIConversationCollection scColl = new SSBIConversationCollection(); while (dr.Read()) { string srvName = dr["service"].ToString(); if (bServ == null) { bServ = CreateSMOService(db, srvName); } SSBIConversation sc = new SSBIConversation(bServ, dr); scColl.Add(sc); } conn.Close(); return(scColl); }
internal static SSBIConversationCollection GetConversationCollection(Database db, BrokerService bServ, Guid handle) { SqlConnection conn = null; int servid; conn = CreateNewConnection(db); SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = sqlConversation; if (bServ != null) { servid = bServ.ID; cmd.CommandText += " and se.service_id = @id"; cmd.Parameters.Add("@id", SqlDbType.Int, 4); cmd.Parameters["@id"].Value = servid; } if (handle != Guid.Empty) { cmd.CommandText += " and se.conversation_handle = @h"; cmd.Parameters.Add("@h", SqlDbType.UniqueIdentifier); cmd.Parameters["@h"].Value = handle; } if (conn.Database != db.Name) conn.ChangeDatabase(db.Name); SqlDataReader dr = cmd.ExecuteReader(); SSBIConversationCollection scColl = new SSBIConversationCollection(); while (dr.Read()) { string srvName = dr["service"].ToString(); if(bServ == null) bServ = CreateSMOService(db, srvName); SSBIConversation sc = new SSBIConversation(bServ, dr); scColl.Add(sc); } conn.Close(); return scColl; }