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