public ContactModel[] LookupContactList(string firstname, string lastname, string phone, string email, int _logIncidentId = 0, int _logContactId = 0)
{
string request, response, logMessage, logNote;
CONTACTSVC.WC_Contacts_BSClient client = new CONTACTSVC.WC_Contacts_BSClient(binding, addr);
MyEndpointBehavior eBehavior = new MyEndpointBehavior();
client.Endpoint.Behaviors.Add(eBehavior);
if (ContactServiceTimeout > 0)
client.InnerChannel.OperationTimeout = TimeSpan.FromMilliseconds(ContactServiceTimeout );
ContactModel[] retvals = null;
if (String.IsNullOrWhiteSpace(ContactURL) || String.IsNullOrWhiteSpace(ContactServiceUsername) || String.IsNullOrWhiteSpace(ContactServicePassword))
{
throw new Exception("Provider's InitForContact not run.");
}
//WC_Contacts_BS client = SiebelProxyFactory.GetContactInstance(ContactListLookupURL, ContactServiceUsername, ContactServicePassword, ContactServiceTimeout);
CONTACTSVC.WC_Contacts_BSQueryPage_Input ip = new CONTACTSVC.WC_Contacts_BSQueryPage_Input();
ip.ListOfWc_Contacts_Io = new CONTACTSVC.ListOfWc_Contacts_IoQuery();
ip.ListOfWc_Contacts_Io.Contact = new CONTACTSVC.ContactQuery();
ip.ListOfWc_Contacts_Io.Contact.EmailAddress = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.EmailAddress.Value = String.Empty;
ip.ListOfWc_Contacts_Io.Contact.WorkPhone = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.WorkPhone.Value = String.Empty;
ip.ListOfWc_Contacts_Io.Contact.FirstName = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.FirstName.Value = String.Empty;
ip.ListOfWc_Contacts_Io.Contact.LastName = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.LastName.Value = String.Empty;
string searchSpec = "";
string firstNameSearchSpec = "";
if (!String.IsNullOrEmpty(firstname))
{
firstNameSearchSpec = "[FirstName]~LIKE '" + firstname + "'";
searchSpec = firstNameSearchSpec;
}
string lastNameSearchSpec = "";
if (!String.IsNullOrEmpty(lastname))
{
lastNameSearchSpec = "[LastName]~LIKE '" + lastname + "'";
searchSpec = lastNameSearchSpec;
}
string nameSearchSpec = "";
if (firstNameSearchSpec != "" && lastNameSearchSpec != "")
{
nameSearchSpec = "(" + firstNameSearchSpec + " AND " + lastNameSearchSpec + ")";
searchSpec = nameSearchSpec;
}
if (!String.IsNullOrEmpty(email))
{
if (searchSpec != "")
{
searchSpec = searchSpec + " OR [EmailAddress]~LIKE '" + email + "'";
}
else
{
searchSpec = searchSpec + "[EmailAddress]~LIKE '" + email + "'";
}
}
if (!String.IsNullOrEmpty(phone))
{
if (searchSpec != "")
{
searchSpec = searchSpec + " OR [WorkPhone]~LIKE '" + phone + "'";
}
else
{
searchSpec = searchSpec + "[WorkPhone]~LIKE '" + phone + "'";
}
}
ip.ListOfWc_Contacts_Io.Contact.searchspec = searchSpec;
ip.ListOfWc_Contacts_Io.pagesize = "20";
ip.ListOfWc_Contacts_Io.Contact.Id = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.Id.Value = String.Empty;
ip.ListOfWc_Contacts_Io.Contact.PrimaryOrganizationId = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.PrimaryOrganizationId.Value = String.Empty;
ip.LOVLanguageMode = "LIC";
ip.ViewMode = "All";
Stopwatch stopwatch = new Stopwatch();
try
{
CONTACTSVC.WC_Contacts_BSQueryPage_Output opList;
using (new OperationContextScope(client.InnerChannel))
{
MessageHeader usrMsgHdr = MessageHeader.CreateHeader("UsernameToken", "http://siebel.com/webservices", ContactServiceUsername);
OperationContext.Current.OutgoingMessageHeaders.Add(usrMsgHdr);
MessageHeader pwdMsgHdr = MessageHeader.CreateHeader("PasswordText", "http://siebel.com/webservices", ContactServicePassword);
OperationContext.Current.OutgoingMessageHeaders.Add(pwdMsgHdr);
stopwatch.Start();
opList = client.WC_Contacts_BSQueryPage(ip);
stopwatch.Stop();
request = eBehavior.msgInspector.reqPayload;
response = eBehavior.msgInspector.resPayload;
}
if (opList.ListOfWc_Contacts_Io.Contact == null)
return retvals;
List<ContactModel> contacts = new List<ContactModel>();
foreach (CONTACTSVC.ContactData op in opList.ListOfWc_Contacts_Io.Contact)
{
ContactModel contact = new ContactModel();
contact.ContactPartyID = op.Id;
contact.FirstName = op.FirstName;
contact.LastName = op.LastName;
contact.Email = op.EmailAddress;
contact.PhoneNumber = op.WorkPhone;
contact.ContactOrgID = op.PrimaryOrganizationId;
contacts.Add(contact);
}
if (contacts.Count > 0)
retvals = contacts.ToArray();
logMessage = "Request of search Contact (Success). FirstName = " + firstname + "; LastName = " + lastname + "Email = " + email + "; Phone = " + phone;
logNote = "Request Payload: " + request;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
logMessage = "Response of search Contact (Success). FirstName = " + firstname + "; LastName = " + lastname + "Email = " + email + "; Phone = " + phone;
logNote = "Response Payload: " + response;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote, (int)stopwatch.ElapsedMilliseconds);
}
catch (Exception ex)
{
request = eBehavior.msgInspector.reqPayload;
response = eBehavior.msgInspector.resPayload;
List<ContactModel> contacts = new List<ContactModel>();
ContactModel contact = new ContactModel();
contact.ErrorMessage = "There has been an error communicating with Siebel. Please check log for detail.";
contacts.Add(contact);
retvals = contacts.ToArray();
logMessage = "Request of search Contact (Failure). Email = " + email + "; Phone = " + phone + ". Error: " + ex.Message;
logNote = "Request Payload: " + request;
log.ErrorLog(_logIncidentId, _logContactId, logMessage, logNote);
logMessage = "Response of search Contact (Failure). Email = " + email + "; Phone = " + phone + ". Error: " + ex.Message;
logNote = "Response Payload: " + response;
log.ErrorLog(_logIncidentId, _logContactId, logMessage, logNote);
handleSiebelException(ex, "Search Contact", _logIncidentId, _logContactId);
}
return retvals;
}
/* This method calls
* WC_Contacts_BSClient : WC_Contacts_BSQueryPage
* Called by SRlistVirtualTable GetRows() to display Service Requests for a contact
*/
public ServiceRequest[] LookupSRbyContactPartyID(IList<string> columns, string contact_id, int _logIncidentId = 0, int _logContactId = 0)
{
if (String.IsNullOrWhiteSpace(SRURL) || String.IsNullOrWhiteSpace(SRServiceUsername) || String.IsNullOrWhiteSpace(SRServicePassword))
{
throw new Exception("Provider's InitForSR is not run.");
}
string request, response, logMessage, logNote;
binding.MaxReceivedMessageSize = 2147483647;
CONTACTSVC.WC_Contacts_BSClient client = new CONTACTSVC.WC_Contacts_BSClient(binding, addr);
MyEndpointBehavior eBehavior = new MyEndpointBehavior();
client.Endpoint.Behaviors.Add(eBehavior);
if(SRServiceTimeout > 0)
client.InnerChannel.OperationTimeout = TimeSpan.FromMilliseconds(SRServiceTimeout );
CONTACTSVC.WC_Contacts_BSQueryPage_Input ip = new CONTACTSVC.WC_Contacts_BSQueryPage_Input();
ip.ListOfWc_Contacts_Io = new CONTACTSVC.ListOfWc_Contacts_IoQuery();
ip.ListOfWc_Contacts_Io.Contact = new CONTACTSVC.ContactQuery();
ip.ListOfWc_Contacts_Io.Contact.Id = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.Id.Value = "='" + contact_id + "'";
ip.ListOfWc_Contacts_Io.Contact.ListOfServiceRequest = new CONTACTSVC.ListOfServiceRequestQuery();
ip.ListOfWc_Contacts_Io.Contact.ListOfServiceRequest.ServiceRequest = new CONTACTSVC.ServiceRequestQuery();
ip.ListOfWc_Contacts_Io.Contact.ListOfServiceRequest.ServiceRequest.SRNumber = new CONTACTSVC.queryType();
foreach (PropertyInfo propertyInfo in ip.ListOfWc_Contacts_Io.Contact.ListOfServiceRequest.ServiceRequest.GetType().GetProperties())
{
/* bc Incident/SR report tab is a special case, the columns are hard coded and fixed
* to show the combined rnow and siebel rows, IntegratrionId, summary, Id
* are diffent name
*/
foreach (string column in columns)
{
if (propertyInfo.Name == column.Split('.')[1] ||
propertyInfo.Name == "IntegrationId" ||
propertyInfo.Name == "Id" ||
propertyInfo.Name == "Abstract"
)
{
if (propertyInfo.PropertyType == typeof(CONTACTSVC.queryType))
{
CONTACTSVC.queryType queryType = new CONTACTSVC.queryType();
propertyInfo.SetValue(ip.ListOfWc_Contacts_Io.Contact.ListOfServiceRequest.ServiceRequest, queryType, null);
}
break;
}
}
}
ip.LOVLanguageMode = "LIC";
ip.ViewMode = "All";
Stopwatch stopwatch = new Stopwatch();
CONTACTSVC.WC_Contacts_BSQueryPage_Output opList;
try
{
using (new OperationContextScope(client.InnerChannel))
{
MessageHeader usrMsgHdr = MessageHeader.CreateHeader("UsernameToken", "http://siebel.com/webservices", SRServiceUsername);
OperationContext.Current.OutgoingMessageHeaders.Add(usrMsgHdr);
MessageHeader pwdMsgHdr = MessageHeader.CreateHeader("PasswordText", "http://siebel.com/webservices", SRServicePassword);
OperationContext.Current.OutgoingMessageHeaders.Add(pwdMsgHdr);
stopwatch.Start();
opList = client.WC_Contacts_BSQueryPage(ip);
stopwatch.Stop();
request = eBehavior.msgInspector.reqPayload;
logMessage = "Request of SRs by contactID (Success). Siebel Contact ID = " + contact_id;
logNote = "Request Payload: " + request;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
response = eBehavior.msgInspector.resPayload;
logMessage = "Response of SRs by contactID (Success). Siebel Contact ID = " + contact_id;
logNote = "Response Payload: " + response;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote, (int)stopwatch.ElapsedMilliseconds);
}
}
catch (Exception ex)
{
request = eBehavior.msgInspector.reqPayload;
logMessage = "Request of SRs by contactID (Failure). Siebel Contact ID = " + contact_id;
logNote = "Request Payload: " + request;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
response = eBehavior.msgInspector.resPayload;
logMessage = "Response of SRs by contactID (Failure). Siebel Contact ID = " + contact_id;
logNote = "Response Payload: " + response;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
handleSiebelException(ex, "LookupSRbyContactPartyID");
throw ex;
}
CONTACTSVC.ContactData contactData = opList.ListOfWc_Contacts_Io.Contact[0];
if (contactData.ListOfServiceRequest.ServiceRequest == null)
return null;
ServiceRequest[] retvals = new ServiceRequest[contactData.ListOfServiceRequest.ServiceRequest.Length];
int i = 0;
foreach (CONTACTSVC.ServiceRequestData sr in contactData.ListOfServiceRequest.ServiceRequest)
{
if (sr.IntegrationId == null || sr.IntegrationId == "")
{
ServiceRequest req = new ServiceRequest();
req.RequestID = sr.Id;
req.RequestNumber = sr.SRNumber;
req.Status = sr.Status;
req.Summary = sr.Abstract;
req.RequestDate = (DateTime)sr.Created;
retvals[i] = req;
i++;
}
}
return retvals;
}
/* This method calls
* WC_Contacts_BSClient.WC_Contacts_BSQueryPage(ip)
* Its output is a table, foreach loop is used
* (even though only one row is returned by setting record limit = 1)
* ContactData is generated and need to be updated
* if proxy is regenerated
* call dictAddProperty() to add the individual property name, type, and value
* for dynamic columns feature
*/
public Dictionary<string, string> LookupContactDetail(IList<string> columns, string party_id, int _logIncidentId = 0, int _logContactId = 0)
{
// can reuse SRURL, service username and password, is all the same
if (String.IsNullOrWhiteSpace(ContactURL) || String.IsNullOrWhiteSpace(ContactServiceUsername) || String.IsNullOrWhiteSpace(ContactServicePassword))
{
throw new Exception("Provider's InitForContact not run.");
}
string request, response, logMessage, logNote;
CONTACTSVC.WC_Contacts_BSClient client = new CONTACTSVC.WC_Contacts_BSClient(binding, addr);
CONTACTSVC.WC_Contacts_BSQueryPage_Input ip = new CONTACTSVC.WC_Contacts_BSQueryPage_Input();
MyEndpointBehavior eBehavior = new MyEndpointBehavior();
client.Endpoint.Behaviors.Add(eBehavior);
if(ContactServiceTimeout > 0)
client.InnerChannel.OperationTimeout = TimeSpan.FromMilliseconds(ContactServiceTimeout);
ip.ListOfWc_Contacts_Io = new CONTACTSVC.ListOfWc_Contacts_IoQuery();
ip.ListOfWc_Contacts_Io.Contact = new CONTACTSVC.ContactQuery();
foreach (PropertyInfo propertyInfo in ip.ListOfWc_Contacts_Io.Contact.GetType().GetProperties())
{
foreach (string column in columns)
{
if (propertyInfo.Name == column.Split('.')[1])
{
if (propertyInfo.PropertyType == typeof(CONTACTSVC.queryType))
{
CONTACTSVC.queryType queryType = new CONTACTSVC.queryType();
propertyInfo.SetValue(ip.ListOfWc_Contacts_Io.Contact, queryType, null);
}
break;
}
}
}
if (ip.ListOfWc_Contacts_Io.Contact.Id == null)
ip.ListOfWc_Contacts_Io.Contact.Id = new CONTACTSVC.queryType();
ip.ListOfWc_Contacts_Io.Contact.Id.Value = "='" + party_id + "'";
ip.LOVLanguageMode = "LIC";
ip.ViewMode = "All";
CONTACTSVC.WC_Contacts_BSQueryPage_Output opList;
Stopwatch stopwatch = new Stopwatch();
try
{
using (new OperationContextScope(client.InnerChannel))
{
MessageHeader usrMsgHdr = MessageHeader.CreateHeader("UsernameToken", "http://siebel.com/webservices", ContactServiceUsername);
OperationContext.Current.OutgoingMessageHeaders.Add(usrMsgHdr);
MessageHeader pwdMsgHdr = MessageHeader.CreateHeader("PasswordText", "http://siebel.com/webservices", ContactServicePassword);
OperationContext.Current.OutgoingMessageHeaders.Add(pwdMsgHdr);
stopwatch.Start();
opList = client.WC_Contacts_BSQueryPage(ip);
stopwatch.Stop();
request = eBehavior.msgInspector.reqPayload;
logMessage = "Request of contact detail (Success). Siebel Contact ID = " + party_id;
logNote = "Request Payload: " + request;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
response = eBehavior.msgInspector.resPayload;
logMessage = "Response of contact detail (Success). Siebel Contact ID = " + party_id;
logNote = "Response Payload: " + response;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
}
}
catch (Exception ex)
{
request = eBehavior.msgInspector.reqPayload;
logMessage = "Request of contact detail (Failure). Siebel Contact ID = " + party_id;
logNote = "Request Payload: " + request;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote);
response = eBehavior.msgInspector.resPayload;
logMessage = "Response of contact detail (Failure). Siebel Contact ID = " + party_id;
logNote = "Response Payload: " + response;
log.DebugLog(_logIncidentId, _logContactId, logMessage, logNote, (int)stopwatch.ElapsedMilliseconds);
handleSiebelException(ex, "client.WC_Contacts_BSQueryPage(ip)");
throw ex;
}
Dictionary<string, string> dictDetail = new Dictionary<string, string>();
CONTACTSVC.ContactData contactData = opList.ListOfWc_Contacts_Io.Contact[0];
foreach (PropertyInfo propertyInfo in contactData.GetType().GetProperties())
{
Object propVal = contactData.GetType().GetProperty(propertyInfo.Name).GetValue(contactData, null);
dictAddProperty(propertyInfo, propVal, ref dictDetail);
}
return dictDetail;
}