public UpdateProvider ( long AtulServiceProviderID, string ServiceProviderName, string ServiceProviderDescription, int AtulServiceProviderClassID, string queue, int ModifiedBy, string ServiceProviderXML ) : bool | ||
AtulServiceProviderID | long | The atul service provider ID. |
ServiceProviderName | string | Name of the service provider. |
ServiceProviderDescription | string | The service provider description. |
AtulServiceProviderClassID | int | The atul service provider class ID. |
queue | string | The queue. |
ModifiedBy | int | The modified by. |
ServiceProviderXML | string | The service provider XML. |
return | bool |
/// <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; }
/// <summary> /// Updates the provider. /// </summary> /// <param name="AtulServiceProviderID">The atul service provider ID.</param> /// <param name="ServiceProviderName">Name of the service provider.</param> /// <param name="ServiceProviderDescription">The service provider description.</param> /// <param name="AtulServiceProviderClassID">The atul service provider class ID.</param> /// <param name="WSDL">The WSDL.</param> /// <param name="DSN">The DSN.</param> /// <param name="verb">The verb.</param> /// <param name="ModifiedBy">The modified by.</param> /// <param name="ServiceProviderXML">The service provider XML.</param> /// <returns></returns> public bool UpdateProvider(long AtulServiceProviderID, string ServiceProviderName, string ServiceProviderDescription, int AtulServiceProviderClassID, string queue, int ModifiedBy, string ServiceProviderXML) { bool success = false; Atul_v1Data adb = new Atul_v1Data(); success = adb.UpdateProvider(AtulServiceProviderID, ServiceProviderName, ServiceProviderDescription, AtulServiceProviderClassID, queue, ModifiedBy, ServiceProviderXML); return success; }