public ActionResult ExportTraslados()
{
var cp = new BLLTraslado();
var lista = cp.All();
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Reports"), "CrystalReport5.rpt"));
rd.SetDatabaseLogon("fretta", "Napoli10");
rd.SetDataSource(lista);
//rd.SetParameterValue("numero_traslado", lala);
//rd.SetDataSource(lista);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "lista.pdf"));
}
public ActionResult Create(Traslado traslado, string user)
{
try
{
var blltraslado = new BLLTraslado();
user = User.Identity.Name;
blltraslado.CreateTraslado(traslado, user);
TempData["msg"] = "Traslado cargado correctamente";
//this.AddMessage("success", "Un mensaje de prueba");
//TempData["OKNormal"] = "Andoo";
//this.TempData["Notification"] = "Traslado cargado correctamente";
//this.TempData["NotificationCSS"] = "notificationbox nb-success";
//TempData["msg"] = "<script>alert('Nuevo traslado ingresado');</script>";
//ViewBag.Message = "Nuevo Traslado Cargado";
return(RedirectToAction("Create"));
}
catch (Exception ex)
{
//this.TempData["Notification"] = "Error: " + ex.Message.ToString();
//this.TempData["NotificationCSS"] = "notificationbox nb-success";
TempData["msg"] = "Error Consulte el registro de eventos";
//TempData["msg"] = "<script>alert('"+ ex.Message.ToString()+"');</script>";
return(RedirectToAction("Create"));
}
}
public ActionResult Index(string search, int?page)
{
var cp = new BLLTraslado();
var lista = cp.All();
//var btc = new BLLTipoContribuyente();
//ViewData["TipoContribuyente"] = btc.All();
if (search == null)
{
search = "";
}
return(View(lista.Where(x => x.NumeroTraslado.ToString().StartsWith(search.ToUpper())).ToList().ToPagedList(page ?? 1, 10)));
}
public ActionResult PostTraslado(Traslado traslado, string user)
{
user = User.Identity.Name;
try
{
var blltraslado = new BLLTraslado();
blltraslado.CreateTraslado(traslado, user);
return(null);
}
catch (Exception ex)
{
throw;
}
}
public void ExportToXML()
{
var cp = new BLLTraslado();
var lista = cp.All();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename = listado.xls");
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
var serializer = new
System.Xml.Serialization.XmlSerializer(lista.GetType());
serializer.Serialize(Response.OutputStream, lista);
}
public void ExportToXLS()
{
var cp = new BLLTraslado();
var lista = cp.All();
ExcelPackage excel = new ExcelPackage();
var workSheet = excel.Workbook.Worksheets.Add("Hoja1");
workSheet.Cells[1, 1].LoadFromCollection(lista, true);
using (var memoryStream = new MemoryStream())
{
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment; filename=ListaTraslados.xlsx");
excel.SaveAs(memoryStream);
memoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
}