public void actualizatabla()
{
if (label1.Text == "Catalogo avios")
{
if (comboBox1.SelectedIndex >= 0)
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
aviosdao.tipo = comboBox1.SelectedIndex;
dataGridView1.DataSource = aviosdao.busca_aviosportipobase();
}
else
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
dataGridView1.DataSource = aviosdao.devuelveaviostipobase();
}
}
else
{
if (comboBox1.SelectedIndex >= 0)
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
aviosdao.tipo = comboBox1.SelectedIndex;
dataGridView1.DataSource = aviosdao.buscatipobodega();
}
else
{
DAO.AviosDAO aviosdao = new GrupoSM_Recepcion.DAO.AviosDAO();
dataGridView1.DataSource = aviosdao.aviosbodega();
}
}
}
public void Generardatagrid()
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
BindingSource source = new BindingSource();
string nombre, tipo;
int clave, id;
foreach (DataGridViewRow row in dataGridView5.Rows)
{
aviosdao.nombre = row.Cells[0].Value.ToString();
dataGridView4.DataSource = aviosdao.datosalmacen();
nombre = row.Cells[0].Value.ToString();
tipo = dataGridView4.CurrentRow.Cells[0].Value.ToString();
id = Convert.ToInt16(dataGridView4.CurrentRow.Cells[1].Value.ToString());
clave = Convert.ToInt16(dataGridView4.CurrentRow.Cells[2].Value.ToString());
source.Add(new Services.Avios.Avio(nombre, tipo, clave, id));
}
dataGridView2.DataSource = source;
cargacombobox();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex == 0)
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
dataGridView2.DataSource = aviosdao.existenciascatalogoalmacenavios();
BindingSource source = new BindingSource();
string nombre, tipo;
int id;
decimal cantidad;
foreach (DataGridViewRow row in dataGridView2.Rows)
{
aviosdao.nombre = row.Cells[0].Value.ToString();
dataGridView3.DataSource = aviosdao.datoscatalogoalmacenavios();
nombre = row.Cells[0].Value.ToString();
cantidad = Convert.ToDecimal(row.Cells[1].Value.ToString());
foreach (DataGridViewRow row1 in dataGridView3.Rows)
{
tipo = row1.Cells[0].Value.ToString();
id = Convert.ToInt16(row1.Cells[0].Value);
source.Add(new Services.AviosAlmacen.AvioAlmacen(nombre, tipo, cantidad, id));
}
}
dataGridView1.DataSource = source;
}
}
private void ImpresionBodegaAvios_Faltantes_Load(object sender, EventArgs e)
{
//GUI.PLANTILLAS.VistaBodegaAvios_Faltantes report = new PLANTILLAS.VistaBodegaAvios_Faltantes();
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
//report.SetDataSource(aviosdao.devuelvefaltantesaviosbodega());
//report.Subreports["AviosSubRPT"].SetDataSource(aviosdao.sacar_avios());
// report.Subreports["PiezasSubRPT"].SetDataSource(piezasdao.devuelvepiezasfichas());
//crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
private void ImpresionBodegaAvios_PorTipo_Load(object sender, EventArgs e)
{
//GUI.PLANTILLAS.VistaBodegaAvios_PorTipo report = new PLANTILLAS.VistaBodegaAvios_PorTipo();
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
aviosdao.tipo = this.tipoavio;
//report.SetDataSource(aviosdao.vistaimpresionbodegaaviosportipo());
//report.Subreports["AviosSubRPT"].SetDataSource(aviosdao.sacar_avios());
// report.Subreports["PiezasSubRPT"].SetDataSource(piezasdao.devuelvepiezasfichas());
//crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
private void ImpresionBodegaDeavios_Load(object sender, EventArgs e)
{
DAO.AviosDAO daoavios = new DAO.AviosDAO();
//GUI.PLANTILLAS.Vistabodega_Avios report = new PLANTILLAS.Vistabodega_Avios();
//report.SetDataSource(daoavios.devuelvebodegaaviosparaimprimir());
//report.Subreports["CrystalReport1.rpt"].SetDataSource(produccion.tallas_preliminaresproduccion());
//report.Subreports["ModeloSubrpt"].SetDataSource(ordendao.devuelvepellones());
//crystalReportViewer1.ReportSource = report;
crystalReportViewer1.Refresh();
}
private void button3_Click_1(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Tenga en cuenta que la entrada del avio se eliminara de bodega y de catalogo", "Confirmacion", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
DAO.AviosDAO aviosdao = new DAO.AviosDAO();
aviosdao.IDAvioAlmacen = Convert.ToInt32(dataGridView2.CurrentRow.Cells["ID"].Value);
aviosdao.eliminadebodegaalmacen();
devuelvecampos();
Generardatagrid();
cargacombobox();
}
}
