public int UpdateDatasyncJob(int?id, string token, DateTime?startDateTime, DateTime?endDateTime)
{
return(SQLAdapter.UpdateDataSync("Marathon", id, token, startDateTime, endDateTime));
//List<SqlParameter> sqlParamters = new List<SqlParameter>() {
// new SqlParameter("@Id",id),
// new SqlParameter("@Token",token),
// new SqlParameter("@StartDate", startDateTime),
// new SqlParameter("@EndDate", endDateTime)
// };
//SQLAdapter.ExecuteSPWithReturnValue("Marathon", "rsa.UpdateDatasyncJob", sqlParamters);
}
public void syncUserContacts(string token, List <UserRootObject> userList)
{
_client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Archer", "session-id=" + token);
HttpResponseMessage response = _client.GetAsync("core/system/usercontact").Result;
response.EnsureSuccessStatusCode();
var resultStr = response.Content.ReadAsStringAsync().Result;
var result = response.Content.ReadAsAsync <List <UserContactRootObject> >().Result;
string Password = "******";
string salt = "afsdafshtyyukuiyergrsgsasfgh";
string PassHash = "";
MD5 md5Hash = MD5.Create();
PassHash = GetMd5Hash(md5Hash, salt + Password);
//Get only updated users list from SyncUsers and update only those contacts
HashSet <int> commonUsers = new HashSet <int>(userList.Select(s => s.RequestedObject.Id));
var results = result.Where(m => commonUsers.Contains(m.RequestedObject.UserId)).ToList();
foreach (UserContactRootObject user in results)
{
string email = null, phone = null;
if (user.RequestedObject.Contacts != null && user.RequestedObject.Contacts.Count > 0)
{
foreach (var contact in user.RequestedObject.Contacts)
{
if (contact.ContactType == 7 && contact.ContactSubType == 2)
{
email = contact.Value;
}
else if (contact.ContactType == 9 && contact.ContactSubType == 9)
{
phone = contact.Value;
}
}
}
List <SqlParameter> sqlParamters = new List <SqlParameter>()
{
new SqlParameter("@Id", user.RequestedObject.UserId),
new SqlParameter("@Email", email),
new SqlParameter("@Phone", phone)
};
SQLAdapter.ExecuteSPWithoutReturnValue("Marathon", "rsa.SyncResourceContacts", sqlParamters);
}
}
public void SyncProjects(string token)
{
//var authClient = new ArcherGeneral.generalSoapClient();
//token = authClient.CreateUserSessionFromInstance("sysadmin", "AuditProdigy", "Password123!");
var client = new searchSoapClient("searchSoap");
//var response = client.ExecuteQuickSearchWithModuleIds(token, "271", "EMEA", 1, 50);
var searchOptions = @"<SearchReport><PageSize>100</PageSize>
<DisplayFields>
<DisplayField>5686</DisplayField>
<DisplayField>5689</DisplayField>
<DisplayField>9908</DisplayField>
<DisplayField>15498</DisplayField>
<DisplayField>15520</DisplayField>
</DisplayFields>
<Criteria>
<ModuleCriteria><Module>271</Module>
<IsKeywordModule>False</IsKeywordModule>
</ModuleCriteria>
</Criteria></SearchReport>";
var searchResponse = client.ExecuteSearch(token, searchOptions, 1);
XmlDocument doc = new XmlDocument();
doc.LoadXml(searchResponse);
XmlNodeList nodes = doc.DocumentElement.SelectNodes("/Records/Record");
foreach (XmlNode node in nodes)
{
List <SqlParameter> sqlParamters = new List <SqlParameter>()
{
new SqlParameter("@Engagement_ID", node.ChildNodes[0].InnerText),
new SqlParameter("@Engagement_Name", node.ChildNodes[1].InnerText),
new SqlParameter("@Audit_Scope__Objectives", node.ChildNodes[2].InnerText),
new SqlParameter("@Projected_Hours", node.ChildNodes[3].InnerText == "" || node.ChildNodes[3].InnerText == "0" ? node.ChildNodes[4].InnerText: node.ChildNodes[3].InnerText)
};
SQLAdapter.ExecuteSPWithoutReturnValue("Marathon", "rsa.SyncProject", sqlParamters);
}
}
