//public bool checkFbIPageImprStatsExists(string FbUserId, Guid Userid, string countdate) //{ // using (NHibernate.ISession session = SessionFactory.GetNewSession()) // { // using (NHibernate.ITransaction transaction = session.BeginTransaction()) // { // try // { // NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where UserId = :userid and FbUserId = :fbuserid and CountDate=:countdate"); // query.SetParameter("userid", Userid); // query.SetParameter("fbuserid", FbUserId); // query.SetParameter("countdate", countdate); // var result = query.UniqueResult(); // if (result == null) // return false; // else // return true; // } // catch (Exception ex) // { // Console.WriteLine(ex.StackTrace); // return true; // } // } // } //} //public bool checkFbILocationStatsExists(string FbUserId, Guid Userid, string countdate, string location) //{ // using (NHibernate.ISession session = SessionFactory.GetNewSession()) // { // using (NHibernate.ITransaction transaction = session.BeginTransaction()) // { // try // { // NHibernate.IQuery query = session.CreateQuery("from FacebookInsightStats where UserId = :userid and FbUserId = :fbuserid and CountDate=:countdate and Location=:location"); // query.SetParameter("userid", Userid); // query.SetParameter("fbuserid", FbUserId); // query.SetParameter("countdate", countdate); // query.SetParameter("location", location); // var result = query.UniqueResult(); // if (result == null) // return false; // else // return true; // } // catch (Exception ex) // { // Console.WriteLine(ex.StackTrace); // return true; // } // } // } //} /// <getGoogleAnalyticsStatsDetails> /// Get google analytics stats detail of account. /// </summary> /// <param name="gaAccountId">Id of Google analytics account .(string)</param> /// <returns>Return object of GoogleAnalyticsStats class.(Domein.GoogleAnalyticsStats)</returns> public GoogleAnalyticsStats getGoogleAnalyticsStatsDetails(string gaAccountId) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { try { //Proceed action, to get details of google stats. NHibernate.IQuery query = session.CreateQuery("from GoogleAnalyticsStats where GaAccountId = :gaAccountId"); query.SetParameter("gaAccountId", gaAccountId); List <GoogleAnalyticsStats> lst = new List <GoogleAnalyticsStats>(); foreach (GoogleAnalyticsStats item in query.Enumerable()) { lst.Add(item); break; } GoogleAnalyticsStats fbacc = lst[0]; return(fbacc); } catch (Exception ex) { Console.WriteLine(ex.StackTrace); return(null); } } //End Transaction } //End Session }
public DataTable getDayWiseAnalyticsApi(string profileId, Guid user) { DataTable dtAnalytics = new DataTable(); try { Analytics objAlyt = new Analytics(); oAuthTokenGa obj = new oAuthTokenGa(); GoogleAnalyticsAccountRepository objGaAccRepo = new GoogleAnalyticsAccountRepository(); GoogleAnalyticsStats objGaStats = new GoogleAnalyticsStats(); GoogleAnalyticsStatsRepository objGaStatsRepo = new GoogleAnalyticsStatsRepository(); GoogleAnalyticsAccount objGaAcc = objGaAccRepo.getGoogelAnalyticsAccountDetailsById(profileId, user); string strRefresh = obj.GetAccessToken(objGaAcc.RefreshToken); if (!strRefresh.StartsWith("[")) { strRefresh = "[" + strRefresh + "]"; } JArray objArray = JArray.Parse(strRefresh); foreach (var itemRefresh in objArray) { objGaAcc.AccessToken = itemRefresh["access_token"].ToString(); } XmlDocument xDoc = new XmlDocument(); DateTime startdt = DateTime.Now.AddMonths(-3); DateTime enddt = DateTime.Now; xDoc.LoadXml(objAlyt.getAnalyticsData(objGaAcc.GaProfileId, "metrics=ga:visits&dimensions=ga:day", startdt.ToShortDateString().Replace("/", "-"), "2013-07-25", objGaAcc.AccessToken)); dtAnalytics = getdatafromXml(xDoc); for (int i = 0; i < dtAnalytics.Rows.Count; i++) { objGaStats.EntryDate = DateTime.Now; objGaStats.GaAccountId = objGaAcc.GaAccountId; if (dtAnalytics.Rows[i]["title"].ToString().Contains("ga:day")) { objGaStats.gaDate = dtAnalytics.Rows[i]["title"].ToString().Substring(8); } objGaStats.gaVisits = dtAnalytics.Rows[i]["ga:visitors"].ToString(); objGaStats.Id = Guid.NewGuid(); objGaStats.UserId = user; objGaStats.GaProfileId = objGaAcc.GaProfileId; if (!objGaStatsRepo.checkGoogleAnalyticsDateStatsExists(objGaAcc.GaProfileId, "day", dtAnalytics.Rows[i]["title"].ToString(), user)) { objGaStatsRepo.addGoogleAnalyticsStats(objGaStats); } else { objGaStatsRepo.updateGoogleAnalyticsStats(objGaStats); } } } catch (Exception Err) { Console.Write(Err.StackTrace); } return(dtAnalytics); }
public DataTable getRegionWiseAnalyticsApi(string profileId) { DataTable dtAnalytics = new DataTable(); try { User user = (User)HttpContext.Current.Session["LoggedUser"]; Analytics objAlyt = new Analytics(); oAuthTokenGa obj = new oAuthTokenGa(); GoogleAnalyticsAccountRepository objGaAccRepo = new GoogleAnalyticsAccountRepository(); GoogleAnalyticsStats objGaStats = new GoogleAnalyticsStats(); GoogleAnalyticsStatsRepository objGaStatsRepo = new GoogleAnalyticsStatsRepository(); GoogleAnalyticsAccount objGaAcc = objGaAccRepo.getGoogelAnalyticsAccountDetailsById(profileId, user.Id); string strRefresh = obj.GetAccessToken(objGaAcc.RefreshToken); if (!strRefresh.StartsWith("[")) { strRefresh = "[" + strRefresh + "]"; } JArray objArray = JArray.Parse(strRefresh); foreach (var itemRefresh in objArray) { objGaAcc.AccessToken = itemRefresh["access_token"].ToString(); } XmlDocument xDoc = new XmlDocument(); xDoc.LoadXml(objAlyt.getAnalyticsData(objGaAcc.GaProfileId, "metrics=ga:visits&dimensions=ga:year", "2013-01-01", "2013-07-15", objGaAcc.AccessToken)); dtAnalytics = getdatafromXml(xDoc); for (int i = 0; i < dtAnalytics.Rows.Count; i++) { objGaStats.EntryDate = DateTime.Now; objGaStats.GaAccountId = objGaAcc.GaAccountId; if (dtAnalytics.Rows[i]["title"].ToString().Contains("ga:year")) { objGaStats.gaYear = dtAnalytics.Rows[i]["title"].ToString().Substring(8); } objGaStats.gaVisits = dtAnalytics.Rows[i]["ga:visitors"].ToString(); objGaStats.Id = Guid.NewGuid(); objGaStats.UserId = user.Id; objGaStats.GaProfileId = objGaAcc.GaProfileId; if (!objGaStatsRepo.checkGoogleAnalyticsDateStatsExists(objGaAcc.GaProfileId, "year", dtAnalytics.Rows[i]["title"].ToString(), user.Id)) { objGaStatsRepo.addGoogleAnalyticsStats(objGaStats); } else { objGaStatsRepo.updateGoogleAnalyticsStats(objGaStats); } } } catch (Exception Err) { Console.Write(Err.StackTrace); } return(dtAnalytics); }
/// <addGoogleAnalyticsStats> /// Add a new Google Analytics Stats /// </summary> /// <param name="gastats">Set Values in a GoogleAnalyticsStats Class Property and Pass the same Object of GoogleAnalyticsStats Class.(Domain.GoogleAnalyticsStats)</param> public void addGoogleAnalyticsStats(GoogleAnalyticsStats gastats) { //Creates a database connection and opens up a session using (NHibernate.ISession session = SessionFactory.GetNewSession()) { //After Session creation, start Transaction. using (NHibernate.ITransaction transaction = session.BeginTransaction()) { //Proceed action, to save data. session.Save(gastats); transaction.Commit(); } //End Transaction } //End Session }
public string getDayWiseAnalytics(string gaAccountId) { string strYearVal = string.Empty; try { User user = (User)HttpContext.Current.Session["LoggedUser"]; GoogleAnalyticsStats objGaStats = new GoogleAnalyticsStats(); GoogleAnalyticsStatsRepository objGaStatsRepo = new GoogleAnalyticsStatsRepository(); ArrayList arrCountry = objGaStatsRepo.getGoogleAnalyticsStatsYearById(gaAccountId, user.Id, 7, "day"); string strYear = string.Empty; string strVal = string.Empty; int cnt = 0; foreach (var item in arrCountry) { cnt++; Array temp = (Array)item; strYear = strYear + temp.GetValue(3).ToString() + ","; strVal = strVal + temp.GetValue(8).ToString() + ","; } if (cnt < 7) { for (int j = 0; j < 7 - cnt; j++) { strYear = strYear + "0,"; strVal = strVal + "0,"; } } strYearVal = strYear.Substring(0, strYear.Length - 1) + "@" + strVal.Substring(0, strVal.Length - 1); } catch (Exception Err) { Console.Write(Err.StackTrace); } return(strYearVal); }
public void updateGoogleAnalyticsStats(GoogleAnalyticsStats fbaccount) { throw new NotImplementedException(); }