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