/*
     *  Struct Functions
     */
    private static structCountSeven[] MonetizeGameIncomesTotal(DataTable _DataTable)
    {
        int i = 0;

        // Set MetricsCount Size
        structCountSeven[] _MetricsCount = new structCountSeven[(_DataTable.Rows.Count < DefaultRowLimit ? _DataTable.Rows.Count : DefaultRowLimit)];
        foreach (DataRow dr in _DataTable.Rows)
        {
            _MetricsCount[i].c1 = Convert.ToInt32(dr["SumBannerView"]);
            _MetricsCount[i].c2 = Convert.ToInt32(dr["SumBannerClick"]);
            _MetricsCount[i].c3 = Math.Round(Convert.ToDecimal(dr["AvgBannerClickThroughRate"]), 2);
            _MetricsCount[i].c4 = Math.Round(Convert.ToDecimal(dr["AvgBannerCostPerClick"]), 2);
            _MetricsCount[i].c5 = Math.Round(Convert.ToDecimal(dr["AvgBannerRatePerImp"]), 2);
            _MetricsCount[i].c6 = Convert.ToString(dr["Currency"]);
            _MetricsCount[i].c7 = Math.Round(Convert.ToDecimal(dr["SumEarnings"]), 2);
            i++;
        }
        return(_MetricsCount);
    }
Esempio n. 2
0
    private static structCountSeven[] AudienceSummary(DataTable _DataTable)
    {
        int i = 0;

        // Set MetricsCount Size
        structCountSeven[] _MetricsCount = new structCountSeven[_DataTable.Rows.Count];
        foreach (DataRow dr in _DataTable.Rows)
        {
            //_MetricsCount[i].c1 = String.Format("{0:dd.MM.yyyy}", dr["ReportDate"]);
            //_MetricsCount[i].c1 = Convert.ToString(Utils.DateTimeToUnixTime((DateTime)dr["ReportDate"]));
            _MetricsCount[i].c1 = Convert.ToString(dr["Title"]);
            _MetricsCount[i].c2 = Convert.ToInt32(dr["TotalUsers"]);
            _MetricsCount[i].c3 = Convert.ToInt32(dr["UniqueUsers"]);
            _MetricsCount[i].c4 = Convert.ToInt32(dr["WebSitePlayedCount"]);
            _MetricsCount[i].c5 = Convert.ToInt32(dr["AvgTimePlayed"]);
            _MetricsCount[i].c6 = Convert.ToSingle(dr["Bounce"]);
            _MetricsCount[i].c7 = Convert.ToString(dr["GameId"]);
            _MetricsCount[i].c8 = Convert.ToString(dr["FirstSeenDate"]);
            i++;
        }
        return(_MetricsCount);
    }