public DataTable pesquTagImp(CadIPsImp cadIPsImp)
{
try
{
Abrirconexao();
DataTable dataTable = new DataTable();
SQLiteDataAdapter sQLiteDataAdapter = new SQLiteDataAdapter();
//PARAMETROS QUE POSSIBILITA O SELECT COM LIKE NO BANCO
comando = new SQLiteCommand("select * from cadIPsImp WHERE tag LIKE @tag", conexao);
comando.Parameters.AddWithValue("@pc", "%" + cadIPsImp.tag + "%");
sQLiteDataAdapter = new SQLiteDataAdapter(comando);
dataTable = new DataTable();
sQLiteDataAdapter.Fill(dataTable);
return(dataTable);
}
catch (Exception erro)
{
throw erro;
}
finally
{
FecharConexao();
}
}
public void fkIpsImp(CadIPsImp cadIPsImp)
{
try
{
Abrirconexao();
comando = new SQLiteCommand("select * from cadIPsImp where ip_impressora = @ip_impressora and modelo = @modelo and tag = @tag", conexao);
comando.Parameters.AddWithValue("@ip_impressora", cadIPsImp.ip_impressora);
comando.Parameters.AddWithValue("@modelo", cadIPsImp.modelo);
comando.Parameters.AddWithValue("@tag", cadIPsImp.tag);
SQLiteDataReader fkIpsImp;
fkIpsImp = comando.ExecuteReader();
if (fkIpsImp.Read())
{
cadIPsImp.id_impressora = fkIpsImp.GetInt32(0);
fkIpsImp.Close();
//System.Windows.Forms.MessageBox.Show("fkIps GERADO" + cadIPsImp.id_impressora);
}
}
catch (Exception erro)
{
throw erro;
}
finally
{
FecharConexao();
}
}
private void alterarIPsImp(CadIPsImp cadIPsImp)
{
cadIPsImp.ip_impressora = textBoxIpImp.Text;
cadIPsImp.modelo = textBoxMoImp.Text;
cadIPsImp.tag = Convert.ToInt32(textBoxTagImp.Text);
ipsBll.alterarIPsImp(cadIPsImp);
}
public void alterarIPsImp(CadIPsImp cadIPsImp)
{
try
{
ipsDao.fkIpsImp(cadIPsImp);
}
catch (Exception erro)
{
System.Windows.Forms.MessageBox.Show("ERRO de conexao com a base de dados: " + erro, "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
throw erro;
}
}
public DataTable pesquTagImp(CadIPsImp cadIPsImp)
{
try
{
DataTable dataTable = new DataTable();
dataTable = ipsDao.pesquTagImp(cadIPsImp);
return(dataTable);
}
catch (Exception erro)
{
throw erro;
}
}
public void deletarIPsImp(CadIPsImp cadIPsImp)
{
try
{
ipsDao.deletarIPsImp(cadIPsImp);
System.Windows.Forms.MessageBox.Show("Dados deletar com sucesso : ", "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
catch (Exception erro)
{
System.Windows.Forms.MessageBox.Show("ERRO de conexao com a base de dados:" + erro, "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
throw erro;
}
}
public void salvarIPsImp(CadIPsImp cadIPsImp)
{
try
{
ipsDao.salvarIPsImp(cadIPsImp);
if (cadIPsImp.id_impressora != 0)
{
System.Windows.Forms.MessageBox.Show("Dados alterados com sucesso : ", "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
else
{
System.Windows.Forms.MessageBox.Show("Dados salvos com sucesso : ", "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
}
}
catch (Exception erro)
{
System.Windows.Forms.MessageBox.Show("ERRO de conexao com a base de dados: " + erro, "Alerta", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Stop);
throw erro;
}
}
public void deletarIPsImp(CadIPsImp cadIPsImp)
{
try
{
Abrirconexao();
comando = new SQLiteCommand("delete from CadIPsImp where id_impressora = @id_impressora", conexao);
comando.Parameters.AddWithValue("@id_impressora", cadIPsImp.id_impressora);
comando.ExecuteNonQuery();
limparVariaves(cadIPs);
}
catch (Exception erro)
{
throw erro;
}
finally
{
FecharConexao();
}
}
public void salvarIPsImp(CadIPsImp cadIPsImp)
{
try
{
Abrirconexao();
if (cadIPsImp.id_impressora != 0)
{
comando = new SQLiteCommand("update cadIPsImp set ip_impressora = @ip_impressora, modelo = @modelo, tag = @tag where id_impressora = @id_impressora", conexao);
comando.Parameters.AddWithValue("@ip_impressora", cadIPsImp.ip_impressora);
comando.Parameters.AddWithValue("@modelo", cadIPsImp.modelo);
comando.Parameters.AddWithValue("@tag", cadIPsImp.tag);
comando.Parameters.AddWithValue("@id_impressora", cadIPsImp.id_impressora);
}
else if (cadIPsImp.id_impressora == 0)
{
comando = new SQLiteCommand("insert into cadIPsImp values( null, @ip_impressora, @modelo, @tag)", conexao);
comando.Parameters.AddWithValue("@ip_impressora", cadIPsImp.ip_impressora);
comando.Parameters.AddWithValue("@modelo", cadIPsImp.modelo);
comando.Parameters.AddWithValue("@tag", cadIPsImp.tag);
}
comando.ExecuteNonQuery();
limparVariaves(cadIPs);
}
catch (Exception erro)
{
throw erro;
}
finally
{
FecharConexao();
}
}
private void deletarIPsImp(CadIPsImp cadIPsImp)
{
ipsBll.deletarIPsImp(cadIPsImp);
listarIPsImpr();
}
