public void cargarEmpresa()
{
txtnombreempresa.Text = Propiedades.getNombreEmpresa();
txtcif.Text = Propiedades.getCif();
txtdireccion.Text = Propiedades.getDireccion();
txttelefono.Text = Propiedades.getTelefono();
txtemail.Text = Propiedades.getEmail();
}
private void enviarPDF(int id, int tipo)
{
i.recoverInvoice(id);
DataRow dr = u.singleUser(i.Refuser);
u.recoverUser(i.Refuser);
DataTable user = new DataTable();
user.Columns.Add("iduser", Type.GetType("System.Int32"));
user.Columns.Add("nombre", Type.GetType("System.String"));
user.Columns.Add("apellidos", Type.GetType("System.String"));
user.Columns.Add("email", Type.GetType("System.String"));
user.Columns.Add("telefono", Type.GetType("System.Int32"));
DataRow drf = user.NewRow();
drf[0] = dr[0];
drf[1] = dr[1];
drf[2] = dr[2];
drf[3] = dr[3];
drf[4] = dr[4];
user.Rows.Add(drf);
dr = i.singleInvoice(i.Idinvoice);
DataTable invo = new DataTable();
invo.Columns.Add("idinvoice", Type.GetType("System.Int32"));
invo.Columns.Add("mes", Type.GetType("System.Int32"));
invo.Columns.Add("año", Type.GetType("System.Int32"));
drf = invo.NewRow();
drf[0] = dr[0];
drf[1] = dr[2];
drf[2] = dr[3];
invo.Rows.Add(drf);
InvoiceItem ii = new InvoiceItem();
DataTable items = ii.mostrarDatos(i.Idinvoice);
items.Columns[0].ColumnName = "idinvoiceitem";
items.Columns[1].ColumnName = "nombre";
items.Columns[2].ColumnName = "precio";
DataTable emp = new DataTable();
emp.Columns.Add("nombre", Type.GetType("System.String"));
emp.Columns.Add("direccion", Type.GetType("System.String"));
emp.Columns.Add("telefono", Type.GetType("System.String"));
emp.Columns.Add("email", Type.GetType("System.String"));
emp.Columns.Add("cif", Type.GetType("System.String"));
drf = emp.NewRow();
drf[0] = Propiedades.getNombreEmpresa();
drf[1] = Propiedades.getDireccion();
drf[2] = Propiedades.getTelefono();
drf[3] = Propiedades.getEmail();
drf[4] = Propiedades.getCif();
emp.Rows.Add(drf);
if (tipo == 0)
{
CrystalReport1 report = new CrystalReport1();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
Stream tmp = report.ExportToStream(ExportFormatType.PortableDocFormat);
enviarMensaje(tmp);
}
else
{
CrystalReport2 report = new CrystalReport2();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
Stream tmp = report.ExportToStream(ExportFormatType.PortableDocFormat);
enviarMensaje(tmp);
}
}
private void Grid_Loaded(object sender, RoutedEventArgs e)
{
User u = new User();
DataRow dr = u.singleUser(i.Refuser);
DataTable user = new DataTable();
user.Columns.Add("iduser", Type.GetType("System.Int32"));
user.Columns.Add("nombre", Type.GetType("System.String"));
user.Columns.Add("apellidos", Type.GetType("System.String"));
user.Columns.Add("email", Type.GetType("System.String"));
user.Columns.Add("telefono", Type.GetType("System.Int32"));
DataRow drf = user.NewRow();
drf[0] = dr[0];
drf[1] = dr[1];
drf[2] = dr[2];
drf[3] = dr[3];
drf[4] = dr[4];
user.Rows.Add(drf);
dr = i.singleInvoice(i.Idinvoice);
DataTable invo = new DataTable();
invo.Columns.Add("idinvoice", Type.GetType("System.Int32"));
invo.Columns.Add("mes", Type.GetType("System.Int32"));
invo.Columns.Add("año", Type.GetType("System.Int32"));
drf = invo.NewRow();
drf[0] = dr[0];
drf[1] = dr[2];
drf[2] = dr[3];
invo.Rows.Add(drf);
InvoiceItem ii = new InvoiceItem();
DataTable items = ii.mostrarDatos(i.Idinvoice);
items.Columns[0].ColumnName = "idinvoiceitem";
items.Columns[1].ColumnName = "nombre";
items.Columns[2].ColumnName = "precio";
DataTable emp = new DataTable();
emp.Columns.Add("nombre", Type.GetType("System.String"));
emp.Columns.Add("direccion", Type.GetType("System.String"));
emp.Columns.Add("telefono", Type.GetType("System.String"));
emp.Columns.Add("email", Type.GetType("System.String"));
emp.Columns.Add("cif", Type.GetType("System.String"));
drf = emp.NewRow();
drf[0] = Propiedades.getNombreEmpresa();
drf[1] = Propiedades.getDireccion();
drf[2] = Propiedades.getTelefono();
drf[3] = Propiedades.getEmail();
drf[4] = Propiedades.getCif();
emp.Rows.Add(drf);
if (tipo == 0)
{
CrystalReport1 report = new CrystalReport1();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
CReportViewer.ViewerCore.ReportSource = report;
}
else
{
CrystalReport2 report = new CrystalReport2();
report.Database.Tables["items"].SetDataSource(items);
report.Database.Tables["usuario"].SetDataSource(user);
report.Database.Tables["invoice"].SetDataSource(invo);
report.Database.Tables["empresa"].SetDataSource(emp);
CReportViewer.ViewerCore.ReportSource = report;
}
}
