public string InstagramFollowingGained(string profileid) { Domain.Socioboard.Domain.ReturnData r = new Domain.Socioboard.Domain.ReturnData(); DateTime present_date = DateTime.Now; string perday_15 = string.Empty; string perday_30 = string.Empty; string perday_60 = string.Empty; string perday_90 = string.Empty; string ret_string = string.Empty; List<Domain.Socioboard.Domain.InstagramUserDetails> following_15 = new List<Domain.Socioboard.Domain.InstagramUserDetails>(); List<Domain.Socioboard.Domain.InstagramUserDetails> following_30 = new List<Domain.Socioboard.Domain.InstagramUserDetails>(); List<Domain.Socioboard.Domain.InstagramUserDetails> following_60 = new List<Domain.Socioboard.Domain.InstagramUserDetails>(); List<Domain.Socioboard.Domain.InstagramUserDetails> following_90 = new List<Domain.Socioboard.Domain.InstagramUserDetails>(); Domain.Socioboard.Domain.InstagramUserDetails _15_first = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _15_last = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _30_first = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _30_last = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _60_first = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _60_last = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _90_first = new Domain.Socioboard.Domain.InstagramUserDetails(); Domain.Socioboard.Domain.InstagramUserDetails _90_last = new Domain.Socioboard.Domain.InstagramUserDetails(); using (NHibernate.ISession session = SessionFactory.GetNewSession()) { try { string follow_str = "from InstagramUserDetails i where i.Profile_Id = : ProfileId"; try { following_90 = session.CreateQuery(follow_str).SetParameter("ProfileId", profileid) .List<Domain.Socioboard.Domain.InstagramUserDetails>().ToList().Where(x => x.Created_Time <= DateTime.Now && x.Created_Time >= (DateTime.Now.AddDays(-90))).OrderByDescending(y => y.Created_Time).ToList(); following_60 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-60).Date).OrderByDescending(y => y.Created_Time).ToList(); following_30 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-30).Date).OrderByDescending(y => y.Created_Time).ToList(); following_15 = following_90.Where(x => x.Created_Time < DateTime.Now.AddDays(1).Date && x.Created_Time > DateTime.Now.AddDays(-15).Date).OrderByDescending(y => y.Created_Time).ToList(); } catch (Exception e) { logger.Error(e.Message); logger.Error(e.StackTrace); } present_date = DateTime.Now; while (present_date.Date != DateTime.Now.Date.AddDays(-90)) { try { //using (NHibernate.ISession session2 = SessionFactory.GetNewSession()) //{ //List<Domain.Socioboard.Domain.InstagramUserDetails> lstresult = session2.Query<Domain.Socioboard.Domain.InstagramUserDetails>().Where(t => t.Profile_Id == profileid && t.Created_Time >= present_date.Date.AddSeconds(1) && t.Created_Time <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Time).ToList(); List<Domain.Socioboard.Domain.InstagramUserDetails> lstresult = following_90.Where(t => t.Created_Time >= present_date.Date.AddSeconds(1) && t.Created_Time <= present_date.Date.AddDays(1).AddSeconds(-1)).OrderByDescending(t => t.Created_Time).ToList(); if (lstresult.Count > 0) { Domain.Socioboard.Domain.InstagramUserDetails _result = lstresult.First(); Domain.Socioboard.Domain.InstagramUserDetails _result1 = lstresult.Last(); long add_data = long.Parse(_result.Following); long add_data1 = long.Parse(_result1.Following); long newfollowerdata = add_data - add_data1; perday_90 = perday_90 + newfollowerdata.ToString() + ","; } else { perday_90 = perday_90 + "0,"; } present_date = present_date.AddDays(-1); // logger.Error("perdayfollowing >>" + perday_90); //} } catch (Exception e) { logger.Error(e.Message); } } try { string[] arr = perday_90.Split(','); for (int i = 0; i < 15; i++) { perday_15 = perday_15 + arr[i] + ","; } for (int i = 0; i < 30; i++) { perday_30 = perday_30 + arr[i] + ","; } for (int i = 0; i < 60; i++) { perday_60 = perday_60 + arr[i] + ","; } } catch (Exception) { } if (following_15.Count > 0) { _15_first = following_15.First(); _15_last = following_15.Last(); r._15 = long.Parse(_15_first.Following) - long.Parse(_15_last.Following); } else { r._15 = 0; } if (following_30.Count > 0) { _30_first = following_30.First(); _30_last = following_30.Last(); r._30 = long.Parse(_30_first.Following) - long.Parse(_30_last.Following); } else { r._30 = 0; } if (following_60.Count > 0) { _60_first = following_60.First(); _60_last = following_60.Last(); r._60 = long.Parse(_60_first.Following) - long.Parse(_60_last.Following); } else { r._60 = 0; } if (following_90.Count > 0) { _90_first = following_90.First(); _90_last = following_90.Last(); r._90 = long.Parse(_90_first.Following) - long.Parse(_90_last.Following); } else { r._90 = 0; } r.perday_15 = perday_15; r.perday_30 = perday_30; r.perday_60 = perday_60; r.perday_90 = perday_90; } catch (Exception e) { logger.Error(e.Message); logger.Error(e.StackTrace); } } string ret = new JavaScriptSerializer().Serialize(r); return ret; }
public string InstagramUserDetail(string profileid) { List<Domain.Socioboard.Domain.InstagramUserDetails> userdetails = new List<Domain.Socioboard.Domain.InstagramUserDetails>(); Domain.Socioboard.Domain.InstagramUserDetails userdetail = new Domain.Socioboard.Domain.InstagramUserDetails(); using (NHibernate.ISession session = SessionFactory.GetNewSession()) { try { userdetails = session.CreateQuery("from InstagramUserDetails i where i.Profile_Id = : Profileid order by Created_Time desc").SetParameter("Profileid", profileid).List<Domain.Socioboard.Domain.InstagramUserDetails>().ToList(); userdetail = userdetails.First(); } catch (Exception e) { try { List<Domain.Socioboard.Domain.InstagramAccount> lstAccount = new List<Domain.Socioboard.Domain.InstagramAccount>(); Domain.Socioboard.Domain.InstagramAccount _Account = new Domain.Socioboard.Domain.InstagramAccount(); lstAccount = session.CreateQuery("from InstagramAccount i where i.InstagramId = : Profileid").SetParameter("Profileid", profileid).List<Domain.Socioboard.Domain.InstagramAccount>().ToList(); _Account = lstAccount.First(); userdetail.Profile_Id = _Account.InstagramId; userdetail.Insta_Name = _Account.InsUserName; userdetail.Full_Name = _Account.InsUserName; userdetail.Follower = _Account.Followers.ToString(); userdetail.Following = _Account.FollowedBy.ToString(); userdetail.Created_Time = DateTime.Now; userdetail.Media_Count = _Account.TotalImages.ToString(); } catch { } logger.Error(e.Message); logger.Error(e.StackTrace); } } return new JavaScriptSerializer().Serialize(userdetail); }