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