Tuesday, 13 May 2014

FaceBookposts in MS CRM

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";
            }
        }
    }

No comments:

Post a Comment