public ActionResult ExportarExcel()
{
int? SiteId = GetCurrentSite();
HttpContext.Response.Clear();
HttpContext.Response.AddHeader("content-disposition", string.Format("attachment;filename=Mailing_{0}.xls", DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss")));
HttpContext.Response.ContentType = "application/ms-excel";
HttpContext.Response.ContentEncoding = System.Text.Encoding.Default;
//Mailing
MailingDAL mailingDAL = new MailingDAL();
List<MailingDTO> lista = mailingDAL.ListarMailing(null, SiteId);
var tabela = new StringBuilder();
CriarTagDeEstilo(tabela);
CriarCabecalho(tabela);
lista.ForEach(item => { CriarConteudo(tabela, item); });
CriarTagDeRodape(tabela);
HttpContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
HttpContext.Response.Write(tabela.ToString());
HttpContext.Response.End();
return null;
}
public ActionResult ListarMailing()
{
int? SiteId = GetCurrentSite();
int UsuarioId = 1;
int IdiomaId = 1;
//Mailing
MailingDAL mailingDAL = new MailingDAL();
List<MailingDTO> listaMailing = mailingDAL.ListarMailing(null, SiteId);
return Json(listaMailing, JsonRequestBehavior.AllowGet);
}