public OBAPIResponse CheckDatabaseConnectivity(string OBAuthCode)
{
OBAPIResponse Response = new OBAPIResponse();
try
{
var list = new List <KeyValuePair <string, bool> >()
{
new KeyValuePair <string, bool>(obDb.Database.Connection.Database, obDb.Database.Exists()),
new KeyValuePair <string, bool>(ambDb.Database.Connection.Database, ambDb.Database.Exists())
};
IPHostEntry ipHostInfo = Dns.GetHostEntry(Dns.GetHostName()); // `Dns.Resolve()` method is deprecated.
IPAddress ipAddress = ipHostInfo.AddressList[0];
Response.success = obDb.Database.Exists() && ambDb.Database.Exists();
Response.data = list;
Response.message = "Calling MySQL databases from:" + ipAddress.ToString();
OBSyncDB.OBAPIResponses.Add(Response);
OBSyncDB.SaveChanges();
return(Response);
}
catch (Exception e)
{
ErrorSignal.FromCurrentContext().Raise(e);
return(Response);
throw;
}
}
public OBAPIResponse SyncWeAppsToCRM()
{
OBAPIResponse Response = new OBAPIResponse();
List <OBAPIResponse> amblst = OBSync.Models.Helpers.SuiteCRM.UpdateAllMyBioUsersBasicInformation();
List <OBAPIResponse> oblst = OBSync.Models.Helpers.SuiteCRM.UpdateOrgBubbleUsersBasicInformation();
return(Response);
////string sugarCrmUrl = "https://crm.orgbubble.com/service/v4_1/rest.php";
////string sugarCrmUsername = "******";
////string sugarCrmPassword = "******";
////string user_name = "obapiuser"; string password = "******";
////var paramss = new
////{
//// user_auth = new
//// {
//// user_name = user_name,
//// password = password,
//// encryption = "PLAIN"
//// },
//// application = "SugarCRM RestAPI Example"
////};
////var JsonLoginString = JsonConvert.SerializeObject(paramss);
////var rsClient = new RestClient("https://crm.orgbubble.com/service/v4_1/rest.php");
////var rRequest = new RestRequest();
////rRequest.AddParameter("method", "login");
////rRequest.AddParameter("input_type", "JSON");
////rRequest.AddParameter("response_type", "JSON");
////rRequest.AddParameter("rest_data", JsonLoginString);
////var rResponse = rsClient.Execute(rRequest);
////var responseData = rResponse.Content;
////var session = responseData.id;
//OBAPIResponse Response = new OBAPIResponse();
//var client = OBSync.Models.Helpers.SuiteCRM.GetSuiteCRMClient();
//try
//{
// List<OrgBubble.general_users> obLst = new List<OrgBubble.general_users>();
// obLst = obDb.general_users.ToList();
// foreach (var oOBUser in obLst)
// {
// //https://github.com/mattkol/SugarRestSharp/
// var request = new SugarRestRequest(RequestType.BulkRead);
// request.Options.MaxResult = 3;
// request.Options.QueryPredicates = new List<QueryPredicate>();
// //request.Options.QueryPredicates.Add(new QueryPredicate(nameof(Contact.em), QueryOperator.Equal, "Test"));
// //request.Options.QueryPredicates.Add(new QueryPredicate("email1", QueryOperator.Equal, "*****@*****.**"));
// //request.Options.QueryPredicates.Add(new QueryPredicate(nameof(Case.Status), QueryOperator.Equal, "Assigned"));
// //DateTime date = DateTime.Parse("07/02/2016");
// //request.Options.QueryPredicates.Add(new QueryPredicate(nameof(Case.DateEntered),
// // QueryOperator.Between, null, date.AddDays(-1),
// // DateTime.Now));
// //request.Options.QueryPredicates.Add(new QueryPredicate(nameof(Contact.Email), QueryOperator.Equal, "*****@*****.**"));
// //request.Options.QueryPredicates.Add(new QueryPredicate("email1", QueryOperator.Equal, oOBUser.email));
// //request.Options.QueryPredicates.Add(new QueryPredicate("orgbubbleid_c", QueryOperator.Equal, oOBUser.id));
// //request.Options.Query = String.Concat("contacts.email1='", oOBUser.email, "' or contacts.orgbubbleid_c ='", oOBUser.id,"'");
// request.Options.Query = String.Concat("contacts.id IN (SELECT bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (eabr.email_address_id = ea.id) WHERE bean_module = 'Contacts' AND ea.email_address_caps = '", oOBUser.email, "' AND eabr.deleted=0)");
// //request.Options.QueryPredicates = new List<QueryPredicate>();
// SugarRestResponse response = client.Execute<Contact>(request);
// //
// if (response.Data.GetType() == typeof(List<Contact>) &&
// ((List<Contact>)response.Data).Count > 0)
// {
// //Update
// List<Contact> oContacsReturned = (List<Contact>)response.Data;
// Contact oContactTuUpdate = oContacsReturned.FirstOrDefault();
// }
// else
// {
// Account oNewAccount = new Account()
// {
// Name = oOBUser.email.ToUpper(),
// AssignedUserId = "6fa5fc21-77d4-ca8d-9e83-5de1a1d5f2ba"
// };
// var oNewAccountrRequest = new SugarRestRequest("Accounts", RequestType.Create);
// oNewAccountrRequest.Parameter = oNewAccount;
// List<string> selectNewAccountFields = new List<string>();
// selectNewAccountFields.Add(nameof(Account.Name));
// selectNewAccountFields.Add(nameof(Account.AssignedUserId));
// oNewAccountrRequest.Options.SelectFields = selectNewAccountFields;
// SugarRestResponse oNewAccountrRequestResponse = client.Execute(oNewAccountrRequest);
// string striCreatedAccountID = (string)oNewAccountrRequestResponse.Data;
// //Create Contact
// Contact oContactToCreate = new Contact(){
// FirstName = Models.Helpers.Utilities.NameObject(oOBUser.fullname).First ,
// LastName = Models.Helpers.Utilities.NameObject(oOBUser.fullname).Last
// };
// var oNewConntactRequest = new SugarRestRequest("Contacts", RequestType.Create);
// oNewConntactRequest.Parameter = oContactToCreate;
// List<string> selectNewContactFields = new List<string>();
// selectNewContactFields.Add(nameof(Contact.FirstName));
// selectNewContactFields.Add(nameof(Contact.LastName));
// oNewConntactRequest.Options.SelectFields = selectNewContactFields;
// SugarRestResponse oNewConntactResponse = client.Execute(oNewConntactRequest);
// string strCreatedContact = (string)oNewConntactResponse.Data;
// var oLinkAccountToContact = new SugarRestRequest(RequestType.LinkedBulkRead);
// }
// }
// Response.success = obDb.Database.Exists() && ambDb.Database.Exists();
// Response.data = obLst;
// Response.message = "OB User found :" + obLst.Count();
// return Response;
//}
//catch (Exception e)
//{
// ErrorSignal.FromCurrentContext().Raise(e);
// return Response;
// throw;
//}
}
public OBAPIResponse Tests()
{
OBAPIResponse Response = new OBAPIResponse();
var client = OBSync.Models.Helpers.SuiteCRM.GetSuiteCRMClient();
Response = OBSync.Models.Helpers.SuiteCRM.UpdateOrgBubbleUsersBasicInformation(obDb.general_users.Find(94));
Response = OBSync.Models.Helpers.SuiteCRM.UpdateOrgBubbleUsersActivities(obDb.general_users.Find(94));
return(Response);
//Account info
// Option 1 - Read by known type typeof(Account).
//var accountRequest = new SugarRestRequest(RequestType.ReadById);
//accountRequest.Parameter = "1d30bf4d-0f91-b46b-a389-5dd5c91680d1"; //5D Investments
//SugarRestResponse accountResponse = client.Execute<Account>(accountRequest);
//Account account = (Account)accountResponse.Data;
// Option 2 - Read by known SugarCRM module name - "Contacts".
//var contactRequest = new SugarRestRequest("Contacts", RequestType.ReadById);
//contactRequest.Parameter = "16a50e00-8aba-c748-71a1-5dd5c947ec6a";
//SugarRestResponse contactRresponse = client.Execute(contactRequest);
//Contact contact = (Contact)contactRresponse.Data;
//var createAccountRequest = new SugarRestRequest("Accounts", RequestType.Create);
//SugarRestSharp.Models.Account actTest = new SugarRestSharp.Models.Account {
// Name = "Test from API",
// Website = "www.OrgBubble.com"
//};
//createAccountRequest.Parameter = actTest;
//List<string> selectFields = new List<string>();
//selectFields.Add(nameof(SugarRestSharp.Models.Account.Name));
//selectFields.Add(nameof(SugarRestSharp.Models.Account.Website));
//createAccountRequest.Options.SelectFields = selectFields;
//SugarRestResponse response = client.Execute(createAccountRequest);
//string accountId = "1ea2d1c7-4ac3-3b4b-9c67-5dd5c944178a";
//var request = new SugarRestRequest("Accounts",RequestType.LinkedReadById);
//request.Parameter = accountId;
//List<string> selectedFields = new List<string>();
//selectedFields.Add(nameof(Account.Id));
//selectedFields.Add(nameof(Account.Name));
//selectedFields.Add(nameof(Account.Industry));
//selectedFields.Add(nameof(Account.Website));
//selectedFields.Add(nameof(Account.ShippingAddressCity));
//request.Options.SelectFields = selectedFields;
//Dictionary<object, List<string>> linkedListInfo = new Dictionary<object, List<string>>();
//List<string> selectContactFields = new List<string>();
//selectContactFields.Add(nameof(Contact.FirstName));
//selectContactFields.Add(nameof(Contact.LastName));
//selectContactFields.Add(nameof(Contact.Title));
//selectContactFields.Add(nameof(Contact.Description));
//selectContactFields.Add(nameof(Contact.PrimaryAddressPostalcode));
//linkedListInfo[typeof(Contact)] = selectContactFields;
//request.Options.LinkedModules = linkedListInfo;
//SugarRestResponse response = client.Execute<Account>(request);
//string strOBAccountID = "78c00489-0f96-e09f-c5ed-5e129ab36850";
//Note oNote = new Note()
//{
// ContactId = "",
// CreatedBy= "6fa5fc21-77d4-ca8d-9e83-5de1a1d5f2ba",
// AssignedUserId = "6fa5fc21-77d4-ca8d-9e83-5de1a1d5f2ba",
// ParentType= "Accounts",
// ParentId= strOBAccountID,
// Deleted =0,
// DateEntered=DateTime.Now,
// DateModified = DateTime.Now,
// Name="added from api",
// Description = "description added from api",
//};
//var oNewNote = new SugarRestRequest("Notes", RequestType.Create);
//oNewNote.Parameter = oNote;
//List<string> selectNewNoteFields = new List<string>();
//selectNewNoteFields.Add(nameof(Note.ContactId));
//selectNewNoteFields.Add(nameof(Note.CreatedBy));
//selectNewNoteFields.Add(nameof(Note.AssignedUserId));
//selectNewNoteFields.Add(nameof(Note.ParentType));
//selectNewNoteFields.Add(nameof(Note.ParentId));
//selectNewNoteFields.Add(nameof(Note.Deleted));
//selectNewNoteFields.Add(nameof(Note.DateEntered));
//selectNewNoteFields.Add(nameof(Note.DateModified));
//selectNewNoteFields.Add(nameof(Note.Name));
//selectNewNoteFields.Add(nameof(Note.Description));
//oNewNote.Options.SelectFields = selectNewNoteFields;
//SugarRestResponse oNewAccountrRequestResponse = client.Execute(oNewNote);
//string strNoteID = (string)oNewAccountrRequestResponse.Data;
//SugarRestResponse response = client.Execute<Note>(oNewNote);
//Response.data = response;
//Response.success = true;
//Response.message = DateTime.Now.ToString();
//return Response;
}