public List<DetailedVisit> getVisitSourceData(DateTime fromDate, DateTime toDate, Site site) { List<DetailedVisit> visits = new List<DetailedVisit>(); int startIndex = 1; Boolean isMore; DataFeed feed = null; do { isMore = false; try { feed = getGADataFeed(site, fromDate, toDate, "ga:medium,ga:date", "ga:visitors,ga:visits,ga:transactions", "", "", startIndex); if (feed != null) { foreach (DataEntry singleEntry in feed.Entries) { DetailedVisit visit = new DetailedVisit(singleEntry, site); visits.Add(visit); isMore = true; } } } catch (Exception rEx) { log.Error("Error in getVisitData", rEx); } if (isMore) startIndex += numberOfGARecordsToRetrievePerRequest; } while (isMore); return visits; }
public void recordAnalyticsVisitSource(DetailedVisit visit) { SqlConnection conn = new SqlConnection(connectionAnalytics); try { conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = @"IF NOT EXISTS(SELECT (1) FROM analytics_source_visits_site (nolock) WHERE Analytics_Date = @Date AND Site = @Account AND Medium = @Medium) INSERT INTO analytics_source_visits_site (Analytics_Date, Site, Medium, UniqueVisitors, Visits, Transactions) VALUES (@Date, @Account, @Medium, @UniqueVisitors, @Visits, @Transactions) ELSE UPDATE analytics_source_visits_site SET UniqueVisitors = @UniqueVisitors, Visits = @Visits, Transactions = @Transactions WHERE Analytics_Date = @Date AND Site = @Account AND Medium = @Medium"; cmd.Parameters.Add("@Date", SqlDbType.DateTime); cmd.Parameters["@Date"].Value = visit.gaDate; cmd.Parameters.Add("@Account", SqlDbType.NVarChar); cmd.Parameters["@Account"].Value = truncate(visit.gaAccount, 15); cmd.Parameters.Add("@Medium", SqlDbType.NVarChar); cmd.Parameters["@Medium"].Value = truncate(visit.medium, 50); cmd.Parameters.Add("@UniqueVisitors", SqlDbType.Int); cmd.Parameters["@UniqueVisitors"].Value = visit.uniqueVisitors; cmd.Parameters.Add("@Visits", SqlDbType.Int); cmd.Parameters["@Visits"].Value = visit.visits; cmd.Parameters.Add("@Transactions", SqlDbType.Int); cmd.Parameters["@Transactions"].Value = visit.transactions; cmd.ExecuteNonQuery(); cmd.Dispose(); } catch (SqlException sqle) { log.Error("Error in recordAnalyticsVisitSource", sqle); } finally { if (conn != null) { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } } }