Exemplo n.º 1
0
        public ActionResult GetLocationStatisticsCsv(DateTime startDate, DateTime endDate, Guid regionId,
                                                     Guid ownerId, Guid codecTypeId)
        {
            var statistics = _statisticsManager.GetLocationStatistics(startDate.ToUniversalTime(),
                                                                      endDate.ToUniversalTime().AddDays(1.0), regionId, ownerId, codecTypeId);
            var csv = new StringBuilder();

            csv.AddCsvValue(Resources.Location)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Calls)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Time)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Simultaneous)
            .AppendLine();
            var svCulture = CultureInfo.CreateSpecificCulture("sv-SE");

            foreach (var stats in statistics)
            {
                csv.AddCsvValue(string.IsNullOrWhiteSpace(stats.LocationName) ? "-" : stats.LocationName)
                .AddCsvSeparator()
                .AddCsvValue(stats.NumberOfCalls)
                .AddCsvSeparator()
                .AddCsvValue(stats.TotaltTimeForCalls, 0, svCulture)
                .AddCsvSeparator()
                .AddCsvValue(stats.MaxSimultaneousCalls)
                .AppendLine();
            }
            var encoding = Encoding.GetEncoding(1252);

            return(File(encoding.GetBytes(csv.ToString()), "text/csv",
                        string.Format("Platser_{0:yyMMdd}_{1:yyMMdd}.csv", startDate, endDate)));
        }
Exemplo n.º 2
0
        public ActionResult GetDateBasedCsv(DateBasedFilterType filterType, DateTime startDate, DateTime endDate, Guid filterId)
        {
            IList <DateBasedStatistics> stats;

            switch (filterType)
            {
            case DateBasedFilterType.Regions:
                stats = _statisticsManager.GetRegionStatistics(startDate.ToUniversalTime(), endDate.ToUniversalTime().AddDays(1.0), filterId);
                break;

            case DateBasedFilterType.SipAccounts:
                stats = _statisticsManager.GetSipStatistics(startDate.ToUniversalTime(), endDate.ToUniversalTime().AddDays(1.0), filterId);
                break;

            default:
                stats = _statisticsManager.GetCodecTypeStatistics(startDate.ToUniversalTime(), endDate.ToUniversalTime().AddDays(1.0), filterId);
                break;
            }

            var csv = new StringBuilder();

            csv.AddCsvValue(Resources.Date)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Calls)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Time + "/" + Resources.Total)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Time + "/" + Resources.Average)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Time + "/" + Resources.Shortest)
            .AddCsvSeparator()
            .AddCsvValue(Resources.Call_Time + "/" + Resources.Longest)
            .AppendLine();
            var svCulture = CultureInfo.CreateSpecificCulture("sv-SE");

            foreach (var row in stats)
            {
                csv.AddCsvValue(row.Date.ToString("yyyy-MM-dd", svCulture))
                .AddCsvSeparator()
                .AddCsvValue(row.NumberOfCalls)
                .AddCsvSeparator()
                .AddCsvValue(row.TotaltTimeForCalls, 0, svCulture)
                .AddCsvSeparator()
                .AddCsvValue(row.AverageTime, 0, svCulture)
                .AddCsvSeparator()
                .AddCsvValue(row.MinCallTime, 0, svCulture)
                .AddCsvSeparator()
                .AddCsvValue(row.MaxCallTime, 0, svCulture)
                .AppendLine();
            }
            var encoding = Encoding.GetEncoding(1252);
            var prefix   = filterType == DateBasedFilterType.CodecTypes
                ? Resources.Codec_Type
                : filterType == DateBasedFilterType.SipAccounts ? Resources.Sip_Accounts : Resources.Region;

            return(File(encoding.GetBytes(csv.ToString()), "text/csv",
                        string.Format("{0}_{1:yyMMdd}_{2:yyMMdd}.csv", prefix, startDate, endDate)));
        }
Exemplo n.º 3
0
        public ActionResult GetLocationSim24HourCsv(DateTime startDate, DateTime endDate, Guid locationId)
        {
            var stats = _statisticsManager.GetHourStatisticsForLocation(startDate.ToUniversalTime(),
                                                                        endDate.ToUniversalTime().AddDays(1.0), locationId, true);

            var csv = new StringBuilder();

            csv.AddCsvValue(Resources.Statistics).AddCsvSeparator().AddCsvValue(Resources.Call_Sim24Hour).AppendLine();
            csv.AddCsvValue(Resources.Location).AddCsvSeparator().AddCsvValue(stats.LocationName).AppendLine();
            csv.AddCsvValue(Resources.From).AddCsvSeparator().AddCsvValue(string.Format(CultureInfo.InvariantCulture, "{0:yyyy-MM-dd}", startDate)).AppendLine();
            csv.AddCsvValue(Resources.To).AddCsvSeparator().AddCsvValue(string.Format(CultureInfo.InvariantCulture, "{0:yyyy-MM-dd}", endDate)).AppendLine();
            csv.AppendLine();
            csv.AddCsvValue(Resources.Hour).AddCsvSeparator().AddCsvValue(Resources.Stats_Number_Of_Simultaneous_Calls).AppendLine();
            foreach (var hour in stats.Statistics)
            {
                csv.AddCsvValue(string.Format(CultureInfo.InvariantCulture, "{0:yyyy-MM-dd HH:mm}", hour.Date.ToLocalTime()))
                .AddCsvSeparator()
                .AddCsvValue(hour.MaxSimultaneousCalls)
                .AppendLine();
            }
            var encoding     = Encoding.GetEncoding(1252);
            var locationName =
                Regex.Replace(stats.LocationName ?? "",
                              string.Join("|", Path.GetInvalidFileNameChars().Select(c => Regex.Escape(c.ToString()))), "")
                .Replace(" ", "_");

            return(File(encoding.GetBytes(csv.ToString()), "text/csv",
                        string.Format("{0}_{1:yyMMdd}_{2:yyMMdd}.csv", locationName, startDate, endDate)));
        }