private void button4_Click(object sender, EventArgs e)
{
GUI.Bodega.TelasControl guitelas = new TelasControl();
guitelas.ShowDialog();
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
dataGridView1.DataSource = telasdao.tablatelas();
}
private void Tela_Seleccion_Load(object sender, EventArgs e)
{
//DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
//telasdao.tipo = int.Parse(label2.Text);
//telasdao.cliente = int.Parse(label1.Text);
//dataGridView1.DataSource = telasdao.bodegastipo();
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
dataGridView1.DataSource = telasdao.tablatelas();
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex != -1)
{
if (comboBox1.SelectedIndex == 0)
{
string campo = "Nombre";
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
DataView dv;
dv = new DataView(telasdao.tablatelas());
dv.RowFilter = campo + " like '%" + textBox5.Text + "%'";
dataGridView1.DataSource = dv;
}
if (comboBox1.SelectedIndex == 1)
{
string campo = "Cliente";
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
DataView dv;
dv = new DataView(telasdao.tablatelas());
dv.RowFilter = campo + " like '%" + textBox5.Text + "%'";
dataGridView1.DataSource = dv;
}
if (comboBox1.SelectedIndex == 2)
{
string campo = "Proveedor";
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
DataView dv;
dv = new DataView(telasdao.tablatelas());
dv.RowFilter = campo + " like '%" + textBox5.Text + "%'";
dataGridView1.DataSource = dv;
}
}
else
{
MessageBox.Show("Escoja una opcion de filtro primero");
}
}
private void textBox5_TextChanged(object sender, EventArgs e)
{
string campo = "Nombre";
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
DataView dv;
dv = new DataView(telasdao.tablatelas());
dv.RowFilter = campo + " like '%" + textBox5.Text + "%'";
dataGridView1.DataSource = dv;
}
private void button2_Click(object sender, EventArgs e)
{
try
{
DialogResult result = MessageBox.Show("¿Desea eliminar la tela seleccionada?",
"Mensaje",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
telasdao.idtela_bodega = Convert.ToInt16(dataGridView1.CurrentRow.Cells[0].Value);
MessageBox.Show(telasdao.borra_telasbodega());
DAO.TelasDAO telasdao1 = new GrupoSM_Recepcion.DAO.TelasDAO();
dataGridView1.DataSource = telasdao1.tablatelas();
}
}
catch
{
MessageBox.Show("Elija una tela para eliminar");
}
}
public void actualizagrid()
{
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
dataGridView1.DataSource = telasdao.tablatelas();
}
private void Telas_Load(object sender, EventArgs e)
{
DAO.TelasDAO telasdao = new GrupoSM_Recepcion.DAO.TelasDAO();
dataGridView1.DataSource = telasdao.tablatelas();
}