private void getPreviousForms() { using (var rep = new Lib.Repositories.BaseFormRepository(this.ActiveUser)) { var listForms = rep.getAll().Select(f=> new { IdCrypt = Commons.SecurityUtils.criptografar( f.Id.ToString()), Name = f.Name }).OrderBy(f=>f.Name).ToList(); if (listForms != null && listForms.Count > 0) { ddlPreviousForms.DataSource = listForms; ddlPreviousForms.DataBind(); } else { btnDesireCopyForm.Visible = false; } } }
protected void btnDownload_Click(object sender, EventArgs e) { Lib.Entities.BaseForm baseForm = null; string excelname = "file.xlsx"; using (Lib.Repositories.BaseFormRepository repo = new Lib.Repositories.BaseFormRepository(this.ActiveUser)) { baseForm = repo.getInstanceByPeriodDate(DateTime.Now); } if (baseForm != null) { excelname = Commons.StringUtils.removeAccents(baseForm.Name) + ".xlsx"; filePath = Server.MapPath("/App_Data/" + excelname); Lib.Utils.ExcelUtils utils = new Lib.Utils.ExcelUtils(); bool save = utils.createExcel(filePath, true); if (save) { System.IO.FileInfo file = new System.IO.FileInfo(filePath); Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=" + excelname); Response.ContentEncoding = Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.Private); Response.ContentType = "application/vnd.ms-excel"; Response.WriteFile(file.FullName); Response.Flush(); Response.End(); } } }