private void btOk_Click(object sender, EventArgs e)
{
//SqlConnection Conn = DB.Connection();
//SqlCommand Comm = Conn.CreateCommand();
DBApp db = new DBApp();
db.openConnection();
SqlCommand Comm = db.Conn.CreateCommand();
if (Terminal > 0)
{
Comm.CommandText = "UPDATE Terminais SET TRM_DESCRICAO = @DESCRICAO, TRM_IP = @IP, " +
"TRM_PORTA = @PORTA, TRM_GRUPO = @GRUPO, TRM_FABRICANTE = @FABRICANTE, " +
"TRM_RAZAOSOCIAL = @RAZAOSOCIAL, TRM_CNPJ = @CNPJ, TRM_CPF = @CPF, TRM_ENDERECO = @ENDERECO, TRM_NUMERO = @NUMERO, TRM_SERIAL = @SERIAL " +
"WHERE TRM_IND = " + Terminal.ToString();
}
else
{
Comm.CommandText = "INSERT INTO Terminais (TRM_DESCRICAO, TRM_IP, TRM_PORTA, TRM_GRUPO, " +
"TRM_FABRICANTE, TRM_RAZAOSOCIAL, TRM_CNPJ, TRM_CPF, TRM_ENDERECO, TRM_NUMERO, TRM_SERIAL) VALUES (@DESCRICAO, " +
"@IP, @PORTA, @GRUPO, @FABRICANTE, @RAZAOSOCIAL, @CNPJ, @CPF, @ENDERECO, @NUMERO, @SERIAL)";
}
Comm.Parameters.Add(new SqlParameter("@DESCRICAO", edDescricao.Text));
Comm.Parameters.Add(new SqlParameter("@IP", edIp.Text));
Comm.Parameters.Add(new SqlParameter("@PORTA", edPorta.Text));
Comm.Parameters.Add(new SqlParameter("@GRUPO", Grupo));
Comm.Parameters.Add(new SqlParameter("@FABRICANTE", "TRIX"));
Comm.Parameters.Add(new SqlParameter("@RAZAOSOCIAL", edRazaoSocial.Text));
Comm.Parameters.Add(new SqlParameter("@CNPJ", edCnpj.Text));
Comm.Parameters.Add(new SqlParameter("@CPF", edCpf.Text));
Comm.Parameters.Add(new SqlParameter("@ENDERECO", edEndereco.Text));
Comm.Parameters.Add(new SqlParameter("@NUMERO", edNumero.Text));
Comm.Parameters.Add(new SqlParameter("@SERIAL", edSerial.Text));
Comm.ExecuteNonQuery();
db.closeConnection();
//Conn.Close();
this.Close();
}
