static void Main() { var folder = @"C:\VS\VoiceServicesAnalysis\VoiceServicesAnalysisUX\src\assets\json\"; // var start = new DateTime(2017, 10, 1, 0, 0, 0); var start = new DateTime(2018, 9, 28, 0, 0, 0); var end = new DateTime(2018, 9, 28, 23, 59, 59); Console.WriteLine("Starting @ " + DateTime.Now.ToString()); var alloffices = GenerateOffices(); var programs = alloffices.GroupBy(x => x.Program); foreach (var p in programs) { var pr = new ProgramReport(); Console.WriteLine("Starting program " + p.Key + " @ " + DateTime.Now.ToString()); var offices = alloffices.Where(x => x.Program == p.Key); var summaries = new List <ConcurrentSummary>(); foreach (var o in offices) { var or = new OfficeReport(); Console.WriteLine("Starting office " + o.Name + " @ " + DateTime.Now.ToString()); summaries.Add(GenerateSummary(o.Program, o.Name, start, end, GetIntervals(start, end, 60), GetCalls(o.Wildcards, start, end))); Console.WriteLine("Finished office " + o.Name + " @ " + DateTime.Now.ToString()); } var ms = new MemoryStream(); var ser = new DataContractJsonSerializer(typeof(List <ConcurrentSummary>)); ser.WriteObject(ms, summaries); var json = ms.ToArray(); ms.Close(); var filename = folder + p.Key.ToLower() .Replace(" ", "") .Replace(".", "") + ".json"; var contents = Encoding.UTF8.GetString(json, 0, json.Length); if (!File.Exists(filename)) { File.WriteAllLines(filename, new string[] { "{" }); File.AppendAllLines(filename, new string[] { "\"program\": \"" + p.Key + "\"," }); File.AppendAllLines(filename, new string[] { "\"start\": \"" + start.ToString() + "\"," }); File.AppendAllLines(filename, new string[] { "\"end\": \"" + end.ToString() + "\"," }); File.AppendAllLines(filename, new string[] { "\"summaries\": " }); File.AppendAllLines(filename, new string[] { contents }); File.AppendAllLines(filename, new string[] { "}" }); } Console.WriteLine("Finished program " + p.Key + " @ " + DateTime.Now.ToString()); } Console.WriteLine("Finished @ " + DateTime.Now.ToString()); }
protected void Page_Load(object sender, EventArgs e) { string id = string.Format("Id: {0} Uri: {1}", Guid.NewGuid(), HttpContext.Current.Request.Url); using (Utils utility = new Utils()) { utility.MethodStart(id, System.Reflection.MethodBase.GetCurrentMethod()); } try { OfficeReport report = new OfficeReport(); DatabaseConfig.ConnectionString = ConfigurationManager.AppSettings["Connection_String"].ToString();// "Data Source=SERVER\\SQLEXPRESS2008;Initial Catalog=BillingSystemGreenBillsPrepod;User ID=tusharb;password=tusharb"; //collect parameters report.OfficeId = Request.QueryString["ofcid"]; report.CompanyId = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; report.User = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME; report.StartDate = DateTime.Parse("Jan 1, " + DateTime.Now.Year); report.EndDate = DateTime.Now; byte[] PdfReport = report.RenderReport(); if (report.Rendering == true) { Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.AddHeader("Content-length", PdfReport.Length.ToString()); Response.AppendHeader("Content-Disposition", "inline;filename=" + report.Status); Response.OutputStream.Write(PdfReport, 0, PdfReport.Length); Response.OutputStream.Flush(); Response.OutputStream.Close(); //Response.End(); PdfReport = null; report = null; } else { throw new Exception(report.Status); } } catch (Exception ex) { Elmah.ErrorSignal.FromCurrentContext().Raise(ex); using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } string str2 = "Error Request=" + id + ".Please share with Technical support."; base.Response.Redirect("../Bill_Sys_ErrorPage.aspx?ErrMsg=" + str2); } //Method End using (Utils utility = new Utils()) { utility.MethodEnd(id, System.Reflection.MethodBase.GetCurrentMethod()); } }
protected void Page_Load(object sender, EventArgs e) { try { OfficeReport report = new OfficeReport(); DatabaseConfig.ConnectionString = ConfigurationManager.AppSettings["Connection_String"].ToString();// "Data Source=SERVER\\SQLEXPRESS2008;Initial Catalog=BillingSystemGreenBillsPrepod;User ID=tusharb;password=tusharb"; //collect parameters report.OfficeId = Request.QueryString["ofcid"]; report.CompanyId = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; report.User = ((Bill_Sys_UserObject)Session["USER_OBJECT"]).SZ_USER_NAME; report.StartDate = DateTime.Parse(Session["ReportFromDate"].ToString()); report.EndDate = DateTime.Parse(Session["ReportToDate"].ToString()); byte[] PdfReport = report.RenderReport(); if (report.Rendering == true) { Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; Response.AddHeader("Content-length", PdfReport.Length.ToString()); Response.AppendHeader("Content-Disposition", "inline;filename=" + report.Status); Response.OutputStream.Write(PdfReport, 0, PdfReport.Length); Response.OutputStream.Flush(); Response.OutputStream.Close(); Response.End(); PdfReport = null; report = null; } else { throw new Exception(report.Status); } } catch (Exception ex) { Response.Write(ex.Message); } }