public class DynamicsCRM
{
OrganizationServiceProxy orgService;
public void RegisterFacebookPost(string User, string Text, string Term, string OriginalFacebookPostDate, DateTime FacebookPostDate, string ProfileURL)
{
try
{
ClientCredentials credentials = new ClientCredentials();
credentials.UserName.UserName = ConfigurationManager.AppSettings["UserName"];
credentials.UserName.Password = ConfigurationManager.AppSettings["Password"];
ClientCredentials deviceCredentials = new ClientCredentials();
deviceCredentials.UserName.UserName = ConfigurationManager.AppSettings["DeviceUserName"];
deviceCredentials.UserName.Password = ConfigurationManager.AppSettings["DevicePassword"];
Uri organizationUri = new Uri(ConfigurationManager.AppSettings["OrganizationURL"]);
Uri homeRealmUri = null;
orgService = new OrganizationServiceProxy(organizationUri, homeRealmUri, credentials, deviceCredentials);
Entity FacebookPost = new Entity("new_facebookpost");
FacebookPost["new_user"] = User;
FacebookPost["new_text"] = Text;
FacebookPost["new_term"] = Term;
FacebookPost["new_originalfacebookpostdate"] = OriginalFacebookPostDate;
FacebookPost["new_facebookpostdate"] = FacebookPostDate;
FacebookPost["new_profileurl"] = ProfileURL;
//FacebookPost["new_facebookpostid"] = FacebookPostId;
orgService.Create(FacebookPost);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
public string CheckLastfacebookPost(string Term)
{
try
{
ClientCredentials credentials = new ClientCredentials();
credentials.UserName.UserName = ConfigurationManager.AppSettings["UserName"];
credentials.UserName.Password = ConfigurationManager.AppSettings["Password"];
ClientCredentials deviceCredentials = new ClientCredentials();
deviceCredentials.UserName.UserName = ConfigurationManager.AppSettings["DeviceUserName"];
deviceCredentials.UserName.Password = ConfigurationManager.AppSettings["DevicePassword"];
Uri organizationUri = new Uri(ConfigurationManager.AppSettings["OrganizationURL"]);
Uri homeRealmUri = null;
orgService = new OrganizationServiceProxy(organizationUri, homeRealmUri, credentials, deviceCredentials);
QueryExpression query = new QueryExpression("new_facebookpost");
query.ColumnSet.AddColumns("new_facebookpostdate", "new_term", "new_originalfacebookpostdate");
query.Criteria = new FilterExpression();
query.Criteria.AddCondition("new_term", ConditionOperator.Equal, Term);
EntityCollection results = orgService.RetrieveMultiple(query);
return results.Entities.Max(g => g.Attributes["new_originalfacebookpostdate"].ToString());
}
catch (Exception ex)
{
return "0";
}
}
}
{
OrganizationServiceProxy orgService;
public void RegisterFacebookPost(string User, string Text, string Term, string OriginalFacebookPostDate, DateTime FacebookPostDate, string ProfileURL)
{
try
{
ClientCredentials credentials = new ClientCredentials();
credentials.UserName.UserName = ConfigurationManager.AppSettings["UserName"];
credentials.UserName.Password = ConfigurationManager.AppSettings["Password"];
ClientCredentials deviceCredentials = new ClientCredentials();
deviceCredentials.UserName.UserName = ConfigurationManager.AppSettings["DeviceUserName"];
deviceCredentials.UserName.Password = ConfigurationManager.AppSettings["DevicePassword"];
Uri organizationUri = new Uri(ConfigurationManager.AppSettings["OrganizationURL"]);
Uri homeRealmUri = null;
orgService = new OrganizationServiceProxy(organizationUri, homeRealmUri, credentials, deviceCredentials);
Entity FacebookPost = new Entity("new_facebookpost");
FacebookPost["new_user"] = User;
FacebookPost["new_text"] = Text;
FacebookPost["new_term"] = Term;
FacebookPost["new_originalfacebookpostdate"] = OriginalFacebookPostDate;
FacebookPost["new_facebookpostdate"] = FacebookPostDate;
FacebookPost["new_profileurl"] = ProfileURL;
//FacebookPost["new_facebookpostid"] = FacebookPostId;
orgService.Create(FacebookPost);
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message);
}
}
public string CheckLastfacebookPost(string Term)
{
try
{
ClientCredentials credentials = new ClientCredentials();
credentials.UserName.UserName = ConfigurationManager.AppSettings["UserName"];
credentials.UserName.Password = ConfigurationManager.AppSettings["Password"];
ClientCredentials deviceCredentials = new ClientCredentials();
deviceCredentials.UserName.UserName = ConfigurationManager.AppSettings["DeviceUserName"];
deviceCredentials.UserName.Password = ConfigurationManager.AppSettings["DevicePassword"];
Uri organizationUri = new Uri(ConfigurationManager.AppSettings["OrganizationURL"]);
Uri homeRealmUri = null;
orgService = new OrganizationServiceProxy(organizationUri, homeRealmUri, credentials, deviceCredentials);
QueryExpression query = new QueryExpression("new_facebookpost");
query.ColumnSet.AddColumns("new_facebookpostdate", "new_term", "new_originalfacebookpostdate");
query.Criteria = new FilterExpression();
query.Criteria.AddCondition("new_term", ConditionOperator.Equal, Term);
EntityCollection results = orgService.RetrieveMultiple(query);
return results.Entities.Max(g => g.Attributes["new_originalfacebookpostdate"].ToString());
}
catch (Exception ex)
{
return "0";
}
}
}
No comments:
Post a Comment