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