private void CarregarAssociado(int codigo)
{
try
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
SqlCommand cmd = new SqlCommand(preparasql.ConsultaAssociado(codigo), con);
con.Open();
using (SqlDataReader leitor = cmd.ExecuteReader())
{
while (leitor.Read())
{
txtNome.Text = leitor["nomeASS"].ToString();
mskCPF.Text = leitor["cpfASS"].ToString();
mskRG.Text = leitor["rgASS"].ToString();
lblFoto.Text = leitor["imgASS"].ToString();
if (lblFoto.Text != "Foto")
{
pictureFoto.Image = Image.FromFile(lblFoto.Text);
}
}
leitor.Close();
}
con.Close();
}
catch
{
MessageBox.Show("Erro ao carregar o associado", "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CarregarPerfil()
{
try
{
cmbLogin.Items.Clear();
RecuperaConexao conexao = new RecuperaConexao();
PreparaSQL usuario = new PreparaSQL();
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
SqlCommand cmd = new SqlCommand(usuario.ConsultaUsuFUNC(), con);
con.Open();
using (SqlDataReader leitor = cmd.ExecuteReader())
{
while (leitor.Read())
{
cmbLogin.Items.Add(leitor["PerfilUsu"].ToString());
}
leitor.Close();
}
con.Close();
}
catch
{
MessageBox.Show("Erro ao carregar os usuários", "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void cmbLogin_MouseClick(object sender, MouseEventArgs e)
{
try
{
cmbLogin.Items.Clear();
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
SqlCommand cmd = new SqlCommand(usuario.ConsultaUsuario(), con);
con.Open();
using (SqlDataReader leitor = cmd.ExecuteReader())
{
while (leitor.Read())
{
cmbLogin.Items.Add(leitor["loginUSU"].ToString());
}
leitor.Close();
}
con.Close();
}
catch
{
MessageBox.Show("Erro ao conectar à base de dados", "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private bool RecarregaINFO()
{
try
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
SqlCommand cmd = new SqlCommand(preparasql.ConsultaINFOR(ID, perfil), con);
con.Open();
using (SqlDataReader leitor = cmd.ExecuteReader())
{
while (leitor.Read())
{
txtOBS.Text = leitor["infoSER"].ToString();
tem = true;
}
leitor.Close();
}
con.Close();
return(tem);
}
catch
{
MessageBox.Show("Erro ao conectar à base de dados", "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(tem);
}
}
public void CarregarReservas(int IDReserva)
{
try
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
SqlCommand cmd = new SqlCommand(preparasql.ConsultaInfoRESERVAS(IDReserva), con);
con.Open();
using (SqlDataReader leitor = cmd.ExecuteReader())
{
while (leitor.Read())
{
// cliRES,veicRES,funcRES,imgVEIC
// dataRES,datadevolucaoRES,valordiariaRES,protocoloRES
intReserva = int.Parse(leitor["codRES"].ToString());
intCli = int.Parse(leitor["cliRES"].ToString());
intVeic = int.Parse(leitor["veicRES"].ToString());
intFunc = int.Parse(leitor["funcRES"].ToString());
lblFoto.Text = leitor["imgVEIC"].ToString();
mskDataReserva.Text = leitor["dataRES"].ToString();
mskDataDevolu.Text = leitor["datadevolucaoRES"].ToString();
txtValorDiaria.Text = leitor["valordiariaRES"].ToString();
txtProtoloco.Text = leitor["protocoloRES"].ToString();
txtFuncionario.Text = "admin";
if (lblFoto.Text != "Foto")
{
pictureFoto.Image = Image.FromFile(lblFoto.Text);
}
}
leitor.Close();
}
con.Close();
}
catch
{
MessageBox.Show("Erro ao carregar a reserva", "ERRO", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CarregarCliente(int ID)
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
try
{
SqlCommand cmd = new SqlCommand(preparasql.ConsultaCliente(ID), con);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
txtNome.Text = reader["nomeCLI"].ToString();
mskRG.Text = reader["rgCLI"].ToString();
mskCPF.Text = reader["cpfCLI"].ToString();
mskCNH.Text = reader["CNHCLI"].ToString();
mskDataNas.Text = reader["datanascCLI"].ToString();
mskTelComer.Text = reader["telefonefixoCLI"].ToString();
mskCelular.Text = reader["telefonecelularCLI"].ToString();
txtEmail.Text = reader["emailCLI"].ToString();
mskCEP.Text = reader["cepCLI"].ToString();
txtLogradouro.Text = reader["enderCLI"].ToString();
txtCidade.Text = reader["cidadeCLI"].ToString();
txtUF.Text = reader["estadoCLI"].ToString();
txtBairro.Text = reader["bairroCLI"].ToString();
txtnum.Text = reader["numcasaCLI"].ToString();
}
}
/*nomeCLI,rgCLI,cpfCLI,CNHCLI,
* datanascCLI,telefonefixoCLI,telefonecelularCLI,emailCLI,
* cepCLI,enderCLI,cidadeCLI,estadoCLI,
* bairroCLI,numcasaCLI
*/
}
catch (Exception ex)
{
string err = ex.Message;
}
finally
{
con.Close();
con.Dispose();
}
}
private void CarregarVeiculo(int ID)
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
try
{
SqlCommand cmd = new SqlCommand(preparasql.ConsultaVeiculo(ID), con);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
txtChassis.Text = reader["chasVEIC"].ToString();
txtFabricante.Text = reader["fabricanteVEIC"].ToString();
txtPlaca.Text = reader["placaVEIC"].ToString();
txtMarca.Text = reader["marcaVEIC"].ToString();
txtCor.Text = reader["corVEIC"].ToString();
txtKM.Text = reader["kmVEIC"].ToString();
mskDataFabr.Text = reader["datafabrVEIC"].ToString();
mskDataCompr.Text = reader["datacompraVEIC"].ToString();
mskDataUltimaRev.Text = reader["ultimarevisaoVEIC"].ToString();
lblFoto.Text = reader["imgVEIC"].ToString();
txtObs.Text = reader["descVEIC"].ToString();
if (lblFoto.Text != "Foto")
{
pictureFoto.Image = Image.FromFile(lblFoto.Text);
}
}
}
}
catch (Exception ex)
{
string err = ex.Message;
}
finally
{
con.Close();
con.Dispose();
}
}
public void CarregarFunc(int ID)
{
SqlConnection con = new SqlConnection(conexao.RecuperaCNN());
try
{
SqlCommand cmd = new SqlCommand(preparasql.ConsultaFunc(ID), con);
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
txtNome.Text = reader["nomeFUNC"].ToString();
mskRG.Text = reader["rgFUNC"].ToString();
mskCPF.Text = reader["cpfFUNC"].ToString();
mskDataAd.Text = reader["dataadmiss"].ToString();
mskDataNasc.Text = reader["datanascFUNC"].ToString();
mskDataDemi.Text = reader["datademiss"].ToString();
mskTelefone.Text = reader["telefoneFUNC"].ToString();
mskCEP.Text = reader["cepFUNC"].ToString();
txtLogradouro.Text = reader["enderFUNC"].ToString();
txtCidade.Text = reader["cidadeFUNC"].ToString();
txtUF.Text = reader["estadoFUNC"].ToString();
txtBairro.Text = reader["bairroFUNC"].ToString();
txtnum.Text = reader["numcasaFUNC"].ToString();
cmbLogin.Text = reader["perfilusuFUNC"].ToString();
}
}
}
catch (Exception ex)
{
string err = ex.Message;
}
finally
{
con.Close();
con.Dispose();
}
}
