Exemplo n.º 1
0
        public ActionResult Reporte13(string fec_ini, string fec_fin)
        {
            try
            {
                var doctor = db.doctor.Where(d => d.doc_cedula == User.Identity.Name).First();

                var lista = db.getReporte13(fec_ini, fec_fin, doctor.doc_empresa);
                var grid  = new GridView();
                grid.DataSource = lista;
                grid.DataBind();

                Response.ClearContent();
                Response.Buffer = true;
                Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
                Response.ContentType = "application/ms-excel";

                Response.Charset = "";
                StringWriter   sw  = new StringWriter();
                HtmlTextWriter htw = new HtmlTextWriter(sw);

                grid.RenderControl(htw);
                Response.Output.Write(sw.ToString());
                Response.Flush();
                Response.End();

                return(View("Lista02", lista.ToList()));
            }
            catch (Exception ex)
            {
                return(RedirectToAction("Message", "Home", new { mensaje = ex.Message }));
            }
        }