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);

        }