ATUL_v1.Atul_v1Data.GetProviderBySearch C# (CSharp) Method

        public DataRow GetProviderBySearch(string name, int classID, string queue)
        {
            SqlCommand cmd = new SqlCommand("exec dbo.Atul_ServiceProviderGetBySearch_sp @ServiceProviderName, @AtulServiceProviderClassID, @ESBQueue", this._connection);
            cmd.Parameters.Add(new SqlParameter("@ServiceProviderName", name));
            cmd.Parameters.Add(new SqlParameter("@AtulServiceProviderClassID", classID));
            cmd.Parameters.Add(new SqlParameter("@ESBQueue", queue));
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable returnTable = new DataTable(); returnTable.TableName = "providers";
            da.Fill(returnTable);
            if (returnTable.Rows.Count > 0)
            {
                return returnTable.Rows[0];
            }
            return null;
        }

        /// <summary>
        /// Upsert provider.
        /// </summary>
        /// <param name="queue">The queue.</param>
        /// <param name="providerXML">The provider XML.</param>
        /// <returns></returns>
        public bool UpSertProvider(string queue, string providerXML)
        {
            StringWriter decodedXML = new StringWriter();
            // Decode the encoded string.
            HttpUtility.HtmlDecode(providerXML, decodedXML);

            bool success = false;
            DataTable pTable = new DataTable();
            Atul_v1Data adb = new Atul_v1Data();
            pTable = adb.GetProviders();

            XmlDocument pXML = new XmlDocument();
            pXML.LoadXml(decodedXML.ToString());

            XmlNodeList submittedProviders = pXML.SelectNodes(@"//endpoint/provider");
            foreach (XmlNode xn in submittedProviders)
            {
                int ModifiedBy = -1;
                string xmlproviderName = xn["name"].InnerText;
                string xmlclassid = xn["classid"].InnerText;

                string xmlDescription = xn["description"].InnerText;
                //To insert or update, that is the question. We'll add the queue check in when the db gets sorted.
                DataRow providerRow = adb.GetProviderBySearch(xmlproviderName, Convert.ToInt32(xmlclassid), queue);
                string ServiceProviderXML = xn.OuterXml;
                if (providerRow != null)
                {
                    long AtulServiceProviderID = Convert.ToInt64(providerRow["AtulServiceProviderID"]);
                    int AtulServiceProviderClassID = Convert.ToInt32(Convert.ToInt32(xmlclassid));
                    success = adb.UpdateProvider(AtulServiceProviderID, xmlproviderName, xmlDescription, AtulServiceProviderClassID, queue, ModifiedBy, ServiceProviderXML);
                }
                else
                {
                    //insert provider
                    success = adb.InsertProvider(xmlproviderName, xmlDescription, Convert.ToInt32(xmlclassid), queue, ModifiedBy, ServiceProviderXML);
                }
            }
            return success;
        }