private void Reporte1()
{
string NameFile = "Empleados_lista";
int n = 1;
string filePath = @"C:/Users/mfhernandezl/Downloads/" + NameFile + ".pdf";
ReportDocument crystalReport = new ReportDocument();
crystalReport.Load(Server.MapPath("/Reports/PersonInfo.rpt"));
bdPersonal dsPersona = ReadAll();
crystalReport.SetDataSource(dsPersona);
CrystalReportViewer1.ReportSource = crystalReport;
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.RefreshReport();
if (!File.Exists(filePath))
{
crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, filePath);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(filePath);
}
else
{
NameFile += "(" + n++ + ")";
filePath = @"C:/Users/mfhernandezl/Downloads/" + NameFile + ".pdf";
crystalReport.ExportToDisk(ExportFormatType.PortableDocFormat, filePath);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.WriteFile(filePath);
}
}
public bdPersonal ReadAll()
{
string conString = ConfigurationManager.ConnectionStrings["EmpleadosEntities2"].ConnectionString;
SqlCommand cmd = new SqlCommand("sp_CRUD");
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", "READ");
sda.SelectCommand = cmd;
using (bdPersonal dsCustomers = new bdPersonal())
{
sda.Fill(dsCustomers, "Personal");
return(dsCustomers);
}
}
}
}