private static structCountFour[] TechnologyOS(DataTable _DataTable) { int i = 0; // Set MetricsCount Size structCountFour[] _MetricsCount = new structCountFour[(_DataTable.Rows.Count < DefaultRowLimit ? _DataTable.Rows.Count : DefaultRowLimit)]; foreach (DataRow dr in _DataTable.Rows) { _MetricsCount[i].c1 = Convert.ToString(dr["OS"]) == "" ? "Other" : Convert.ToString(dr["OS"]); _MetricsCount[i].c2 = Convert.ToInt32(dr["OSCount"]); _MetricsCount[i].c4 = Convert.ToInt32(dr["OSUniqueCount"]); _MetricsCount[i].c3 = Math.Round((decimal)_MetricsCount[i].c4 / TotalUsers * 100, 2); i++; } return(_MetricsCount); }
private static structCountFour[] AudienceTotalUsers(DataTable _DataTable) { int i = 0; // Set MetricsCount Size structCountFour[] _MetricsCount = new structCountFour[_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].c2 = Convert.ToInt32(dr["TotalUsers"]); _MetricsCount[i].c3 = Convert.ToInt32(dr["UniqueUsers"]); _MetricsCount[i].c4 = Convert.ToInt32(dr["NewVisitors"]); i++; } return(_MetricsCount); }