public bool UpdateProvider(long AtulServiceProviderID, string ServiceProviderName, string ServiceProviderDescription, int AtulServiceProviderClassID, string queue, int ModifiedBy, string ServiceProviderXML)
{
SqlCommand cmd = new SqlCommand("exec dbo.Atul_ServiceProviderUpdate_sp @ServiceProviderName, @ServiceProviderDescription, @AtulServiceProviderClassID, @CreatedBy, @ServiceProviderXML, @ESBQueue", this._connection);
cmd.Parameters.Add(new SqlParameter("@AtulServiceProviderID", AtulServiceProviderID));
cmd.Parameters.Add(new SqlParameter("@ServiceProviderName", ServiceProviderName.Trim()));
cmd.Parameters.Add(new SqlParameter("@ServiceProviderDescription", ServiceProviderDescription.Trim()));
cmd.Parameters.Add(new SqlParameter("@AtulServiceProviderClassID", AtulServiceProviderClassID));
cmd.Parameters.Add(new SqlParameter("@ModifiedBy", ModifiedBy));
cmd.Parameters.Add(new SqlParameter("@ServiceProviderXML",ServiceProviderXML.Trim()));
cmd.Parameters.Add(new SqlParameter("@ESBQueue", queue));
bool success = Convert.ToBoolean(cmd.ExecuteNonQuery());
return success;
}