public void UpdateInstagramAccountFollowerSecond(Domain.Socioboard.Domain.InstagramUserDetails insert) { //Domain.Socioboard.Domain.InstagramUserDetails insert = (Domain.Socioboard.Domain.InstagramUserDetails)new JavaScriptSerializer().Deserialize(_Insta, typeof(Domain.Socioboard.Domain.InstagramUserDetails)); //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //Begin session trasaction and opens up. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { string str = "Update InstagramUserDetails set Follower=:FollowingsCount, Following=:FollowersCount,Media_Count=:MediaCount where Profile_Id=:ProfileId and Created_Time>=:EntryDate1 and Created_Time<=:EntryDate2"; int i = session.CreateQuery(str) .SetParameter("FollowingsCount", insert.Follower) .SetParameter("FollowersCount", insert.Following) .SetParameter("MediaCount", insert.Media_Count) .SetParameter("ProfileId", insert.Profile_Id) .SetParameter("EntryDate1", DateTime.Now.Date.AddHours(12).AddSeconds(1)) .SetParameter("EntryDate2", DateTime.Now.AddDays(1).Date.AddSeconds(-1)) .ExecuteUpdate(); transaction.Commit(); } } }
public string GetInstagramUserDetails(string profile_id, string access_token) { string code_status = "false"; Domain.Socioboard.Domain.InstagramUserDetails insert = new Domain.Socioboard.Domain.InstagramUserDetails(); JObject post_data = new JObject(); string url = "https://api.instagram.com/v1/users/" + profile_id + "?access_token=" + access_token; try { post_data = JObject.Parse(ApiInstagramHttp(url)); } catch (Exception) { } try { dynamic item = post_data["data"]; //foreach (var item in items) //{ try { Guid Id = Guid.NewGuid(); string insta_name = item["username"].ToString(); string full_name = item["full_name"].ToString(); string imageUrl = item["profile_picture"].ToString(); string media_count = item["counts"]["media"].ToString(); DateTime Created_Time = DateTime.Now; string follower = item["counts"]["followed_by"].ToString(); string following = item["counts"]["follows"].ToString(); insert.Id = Id; insert.Profile_Id = profile_id; insert.Insta_Name = insta_name; insert.Full_Name = full_name; insert.Media_Count = media_count; insert.Created_Time = Created_Time; insert.Follower = follower; insert.Following = following; try { objInstagramAccountRepository.updateInstagramAccount(media_count, follower, following, insta_name, imageUrl, profile_id); } catch { } string i = new JavaScriptSerializer().Serialize(insert); DateTime t1 = DateTime.Now.Date; DateTime t2 = DateTime.Now.Date.AddHours(12); DateTime t3 = DateTime.Now.AddDays(1).Date.AddSeconds(-1); if (DateTime.Now.TimeOfDay >= t1.TimeOfDay && DateTime.Now.TimeOfDay < t2.TimeOfDay) { if (objInstagramAccountRepository.IsInstagramAccountExistsFirst(profile_id)) { objInstagramAccountRepository.UpdateInstagramAccountFollowerFirst(insert); } else { insertuserdetails(insert); } } if (DateTime.Now.TimeOfDay >= t2.TimeOfDay && DateTime.Now.TimeOfDay < t3.TimeOfDay) { if (objInstagramAccountRepository.IsInstagramAccountExistsSecond(profile_id)) { objInstagramAccountRepository.UpdateInstagramAccountFollowerSecond(insert); } else { insertuserdetails(insert); } } //insertuserdetails(insert); code_status = "true"; } catch (Exception ex) { } //} } catch (Exception ex) { logger.Error(ex.Message); } return code_status; }
private static void instagramreport() { Api.InstagramReports.InstagramReports ApiInstaReportObj = new Api.InstagramReports.InstagramReports(); Api.Instagram.Instagram ApiInstaObj = new Api.Instagram.Instagram(); Domain.Socioboard.Domain.InstagramReport insert = new Domain.Socioboard.Domain.InstagramReport(); List <Domain.Socioboard.Domain.InstagramAccount> accounts = (List <Domain.Socioboard.Domain.InstagramAccount>) new JavaScriptSerializer().Deserialize(ApiInstaObj.getInstaAccounts(), typeof(List <Domain.Socioboard.Domain.InstagramAccount>)); foreach (Domain.Socioboard.Domain.InstagramAccount account in accounts) { try { Guid Id = Guid.NewGuid(); string Profile_Id = account.InstagramId; Domain.Socioboard.Domain.InstagramUserDetails user_details = (Domain.Socioboard.Domain.InstagramUserDetails) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.InstagramUserDetail(account.InstagramId), typeof(Domain.Socioboard.Domain.InstagramUserDetails)); string Insta_Name = user_details.Insta_Name; string Full_Name = user_details.Full_Name; string Media_count = user_details.Media_Count; string Follower = user_details.Follower; string Following = user_details.Following; ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.GetVideoPosts(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("1"); ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r1 = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.GetImagePosts(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("2"); ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r2 = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.InstagramFollowerGained(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("3"); ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r3 = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.InstagramFollowingGained(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("4"); ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r4 = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.InstagramPostCommentGained(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("4"); ApiInstaReportObj.Timeout = -1; Domain.Socioboard.Domain.ReturnData r5 = (Domain.Socioboard.Domain.ReturnData) new JavaScriptSerializer().Deserialize(ApiInstaReportObj.InstagramPostLikesGained(account.InstagramId), typeof(Domain.Socioboard.Domain.ReturnData)); Console.WriteLine("4"); insert.Id = Id; insert.Profile_Id = Profile_Id; insert.Insta_Name = Insta_Name; insert.Full_Name = Full_Name; insert.Media_Count = Media_count; insert.Follower = Follower; insert.Following = Following; insert.follow_15 = r2._15; insert.perday_follow_15 = r2.perday_15; insert.follow_30 = r1._30; insert.perday_follow_30 = r2.perday_30; insert.follow_60 = r2._60; insert.perday_follow_60 = r2.perday_60; insert.follow_90 = r2._90; insert.perday_follow_90 = r2.perday_90; insert.following_15 = r3._15; insert.perday_following_15 = r3.perday_15; insert.following_30 = r3._30; insert.perday_following_30 = r3.perday_30; insert.following_60 = r3._60; insert.perday_following_60 = r3.perday_60; insert.following_90 = r3._90; insert.perday_following_90 = r3.perday_90; insert.postcomment_15 = r4._15; insert.perday_postcomment_15 = r4.perday_15; insert.postcomment_30 = r4._30; insert.perday_postcomment_30 = r4.perday_30; insert.postcomment_60 = r4._60; insert.perday_postcomment_60 = r4.perday_60; insert.postcomment_90 = r4._90; insert.perday_postcomment_90 = r4.perday_90; insert.postlike_15 = r5._15; insert.perday_postlike_15 = r5.perday_15; insert.postlike_30 = r5._30; insert.perday_postlike_30 = r5.perday_30; insert.postlike_60 = r5._60; insert.perday_postlike_60 = r5.perday_60; insert.postlike_90 = r5._90; insert.perday_postlike_90 = r5.perday_90; insert.videopost_15 = r._15; insert.perday_videopost_15 = r.perday_15; insert.videopost_30 = r._30; insert.perday_videopost_30 = r.perday_30; insert.videopost_60 = r._60; insert.perday_videopost_60 = r.perday_60; insert.videopost_90 = r._90; insert.perday_videopost_90 = r.perday_90; insert.imagepost_15 = r1._15; insert.perday_imagepost_15 = r1.perday_15; insert.imagepost_30 = r1._30; insert.perday_imagepost_30 = r1.perday_30; insert.imagepost_60 = r1._60; insert.perday_imagepost_60 = r1.perday_60; insert.imagepost_90 = r1._90; insert.perday_imagepost_90 = r1.perday_90; string i = new JavaScriptSerializer().Serialize(insert); ApiInstaReportObj.insertdata(i); } catch (Exception ex) { } } }