public string admin_gid(string url, DateTime publishDate, string a_url)
        {
            get_admin_gid_Result res;

            using (var data = db.get_admin_gid(url))
            {
                res = data.FirstOrDefault <get_admin_gid_Result>();
            }
            Authorization auth   = new Authorization(res.Email);
            var           result = auth.service.Data.Ga.Get(("ga:" + res.ga_id), convertDate(publishDate), convertDate(System.DateTime.Now), "ga:sessions");

            result.Filters = "ga:medium=@referral;ga:landingPagePath=@" + convertUrl(a_url, url);
            try
            {
                var final = result.Execute();
                int count = (int)final.TotalResults;
                if (count != 0)
                {
                    IList <string> l = final.Rows[0];
                    return(l[0]);
                }
                return("" + 0);
            }catch (Exception E)
            {
                return("" + 0);
            }
        }
Esempio n. 2
0
        public List <CountryStats> countryGraph([FromBody] trafficInput input)
        {
            ArticleController    use = new ArticleController();
            get_admin_gid_Result res;
            List <CountryStats>  stats = new List <CountryStats>();

            using (var data = db.get_admin_gid(input.site_url))
            {
                res = data.FirstOrDefault <get_admin_gid_Result>();
            }
            Authorization auth   = new Authorization(res.Email);
            var           result = auth.service.Data.Ga.Get(("ga:" + res.ga_id), use.convertDate(input.fromDate), use.convertDate(input.toDate), "ga:sessions");

            result.Dimensions = "ga:country";
            result.MaxResults = 5;
            result.Sort       = "-ga:sessions";
            result.Filters    = "ga:landingPagePath=@" + use.convertUrl(input.url, input.site_url) + ";ga:campaign=@" + input.uid + ";ga:medium=@referral";
            try
            {
                var final = result.Execute();
                int count = (int)final.TotalResults;
                if (count != 0)
                {
                    foreach (var item in final.Rows)
                    {
                        CountryStats temp = new CountryStats()
                        {
                            country = item[0], sessions = item[1]
                        };
                        stats.Add(temp);
                    }
                }
            }catch (Exception e)
            {
            }
            return(stats);
        }