public void txtBuscar_KeyUp_1(object sender, KeyEventArgs e)
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
if (chkDisponivel.Checked)
{
if (rdbNome.Checked)
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVeicDispon WHERE MARCA LIKE '%" + txtBuscar.Text + "%'", "ConsultaVEIC").Tables[0];
}
else
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVeicDispon WHERE FABRICANTE LIKE '%" + txtBuscar.Text + "%'", "FABRICANTE").Tables[0];
}
}
else
{
if (rdbNome.Checked)
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVeicDispon WHERE MARCA LIKE '%" + txtBuscar.Text + "%'", "ConsultaVEIC").Tables[0];
}
else
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVeicDispon WHERE FABRICANTE LIKE '%" + txtBuscar.Text + "%'", "FABRICANTE").Tables[0];
}
}
dgvVeic.AutoResizeColumns();
dgvVeic.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
private void FiltroSelecionado()
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
if (chkDisponivel.Checked == true)
{
if (rdbNome.Checked)
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE NOME LIKE '%" + txtBuscar.Text + "%' AND CONCLUIDO = 0 ", "ConsultaAgendamentosAsso").Tables[0];
}
else
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE CPF LIKE '%" + txtBuscar.Text + "%' AND concluidoAGE = 0 ", "ConsultaAgendamentosAsso").Tables[0];
}
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
else
{
if (rdbNome.Checked)
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE NOME LIKE '%" + txtBuscar.Text + "%' AND CONCLUIDO = 1", "ConsultaAgendamentosAsso").Tables[0];
}
else
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE CPF LIKE '%" + txtBuscar.Text + "%' AND CONCLUIDO = 1 ", "ConsultaAgendamentosAsso").Tables[0];
}
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
}
private void GerenciarLocacoes_Load(object sender, EventArgs e)
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
dgvReservas.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaReservados", "ConsultaReservados").Tables[0];
dgvReservas.AutoResizeColumns();
dgvReservas.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblInfo.Text = "";
}
private void frmConsultaFunc_Load(object sender, EventArgs e)
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
dgvFunc.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaFUNC", "ConsultaFUNC").Tables[0];
dgvFunc.AutoResizeColumns();
dgvFunc.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblInfo.Text = "";
}
public void frmConsultaClientes_Load(object sender, EventArgs e)
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaCLI", "ConsultaCLI").Tables[0];
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblInfo.Text = "";
}
private void txtBuscar_KeyUp(object sender, KeyEventArgs e)
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
if (rdbNome.Checked)
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaASS WHERE NOME LIKE '%" + txtBuscar.Text + "%'", "ConsultaASS").Tables[0];
}
else
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaASS WHERE CPF LIKE '%" + txtBuscar.Text + "%'", "ConsultaASS").Tables[0];
}
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
private void SemFiltroSelecionado()
{
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
if (chkDisponivel.Checked == true)
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE CONCLUIDO = 1", "ConsultaAgendamentosAsso").Tables[0];
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
else
{
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaAgendamentosAsso WHERE CONCLUIDO = 0", "ConsultaAgendamentosAsso").Tables[0];
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
lblInfo.Text = "";
}
private void frmConsultaVeic_Load(object sender, EventArgs e)
{
if (verFiltroDisp == 0)
{
chkDisponivel.Visible = false;
}
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
if (chkDisponivel.Checked)
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVeicDispon", "ConsultaVeicDispon").Tables[0];
}
else
{
dgvVeic.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaVEIC", "ConsultaVEIC").Tables[0];
}
dgvVeic.AutoResizeColumns();
dgvVeic.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblInfo.Text = "";
}
private void FrmConsultaAsso_Load(object sender, EventArgs e)
{
/*
* AD
* AT
* AD
* PS
* AS
*/
perfil = User.getID();
switch (perfil)
{
case "AT":
btnOBS.Visible = false;
break;
case "AM":
btnOBS.Visible = true;
break;
default:
//btnOBS.Visible = true;
btnEditar.Visible = true;
btnOBS.Location = new Point(652, 323);
btnOBS.Size = new Size(69, 51);
break;
}
PreencheDataGridView PreencheGrid = new PreencheDataGridView();
dgvClientes.DataSource = PreencheGrid.PrencherDados("SELECT * FROM ConsultaASS", "ConsultaASS").Tables[0];
dgvClientes.AutoResizeColumns();
dgvClientes.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
lblInfo.Text = "";
}
