private void removePessoa(int nif) { if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.REMOVER_COMPRADOR @nif "; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@nif", nif); cmd.Connection = Connect.cn; try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Failed to delete vaca in database. \n ERROR MESSAGE: \n" + ex.Message); } finally { Connect.cn.Close(); } }
private void removeVaca(String nr_vacina, String nr_animal) { if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.REMOVER_VACINACAO @nr_vacina, @nr_animal "; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@nr_vacina", nr_vacina); cmd.Parameters.AddWithValue("@nr_animal", nr_animal); cmd.Connection = Connect.cn; try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Failed to delete vaca in database. \n ERROR MESSAGE: \n" + ex.Message); } finally { Connect.cn.Close(); } }
public void addVaca(Animal animal) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.ADD_VACA @numeroAnimal, @nome, @produtor, @progenitorMasc, @progenitorFem, @preco, @raca, @dataNasc, @estadoVacina, @analises, @tipoVaca "; cmd.Parameters.Clear(); if (preco.Text != String.Empty) { cmd.Parameters.AddWithValue("@preco", Convert.ToDecimal(animal.Preco)); } else { cmd.Parameters.AddWithValue("@preco", DBNull.Value); } cmd.Parameters.AddWithValue("@produtor", Convert.ToInt16(animal.produtor)); cmd.Parameters.AddWithValue("@nome", animal.nome); cmd.Parameters.AddWithValue("@progenitorMasc", Convert.ToInt16(animal.progenitorMasc)); cmd.Parameters.AddWithValue("@progenitorFem", Convert.ToInt16(animal.progenitorFem)); cmd.Parameters.AddWithValue("@raca", animal.Raca); cmd.Parameters.AddWithValue("@dataNasc", animal.dataNasc); cmd.Parameters.AddWithValue("@tipoVaca", animal.TipoVaca); cmd.Parameters.AddWithValue("@estadoVacina", animal.estadoVacinacao); cmd.Parameters.AddWithValue("@analises", animal.estadoAnalises); cmd.Parameters.AddWithValue("@numeroAnimal", Convert.ToInt16(animal.nrAnimal)); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show("404 NOT FOUND"); addSucess = false; //throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 2) { MessageBox.Show("Add OK"); addSucess = true; } else { MessageBox.Show("Add NOT OK"); addSucess = false; } Connect.cn.Close(); } }
private void initialize() { Connect.verifySGBDConnection(); SqlCommand cmd = new SqlCommand("EXEC VACAS.VER_PRODUCAO_LEITE", Connect.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { producaoLeite prod = new producaoLeite(); prod.Produtor = reader["PRODUTOR"].ToString(); prod.ProducaoManha = reader["PRODUCAO_MANHA"].ToString(); prod.ProducaoTarde = reader["PRODUCAO_TARDE"].ToString(); prod.Data = reader["DATA_PRODUCAO"].ToString(); prod.Preco = reader["PRECO"].ToString(); prod.Fabrica = reader["NOME"].ToString(); fabrica.Text = prod.Fabrica; precoLeite.Text = prod.Preco; listBox1.Items.Add(prod); } reader.Close(); Connect.verifySGBDConnection(); cmd = new SqlCommand("SELECT VACAS.RENDIMENTO_LEITE()", Connect.cn); rendimentoLeite.Text = cmd.ExecuteScalar().ToString(); Connect.cn.Close(); }
private void add_vacinacao(RegistoVacinacao registo) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.ADD_VACINACAO @nr_animal, @nr_veterinario, @nome, @data,@local"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@nr_veterinario", Convert.ToInt16(registo.NrVeterinario)); cmd.Parameters.AddWithValue("@nr_animal", Convert.ToInt16(registo.NrAnimal)); cmd.Parameters.AddWithValue("@nome", registo.Nome); cmd.Parameters.AddWithValue("@data", registo.Data); cmd.Parameters.AddWithValue("@local", registo.Local); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show("404 NOT FOUND"); addSucess = false; throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 2) { MessageBox.Show("Add OK"); addSucess = true; } else { MessageBox.Show("Add NOT OK"); addSucess = false; } Connect.cn.Close(); } }
private void initialize() { Connect.verifySGBDConnection(); SqlCommand cmd = new SqlCommand("EXEC VACAS.VERBOIS", Connect.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { tipoAnimal.SelectedIndex = 0; Animal A = new Animal(); A.produtor = reader["PRODUTOR"].ToString(); A.nrAnimal = reader["NR_ANIMAL"].ToString(); A.progenitorMasc = reader["PROGENITOR_MASC"].ToString(); A.progenitorFem = reader["PROGENITOR_FEM"].ToString(); A.estadoVacinacao = reader["ESTADO_VACINA"].ToString(); A.estadoAnalises = reader["ESTADO_ANÁLISES"].ToString(); A.nome = reader["NOME"].ToString(); A.dataNasc = reader["DATA_NASCIMENTO"].ToString(); A.Raca = reader["RACA"].ToString(); A.Preco = reader["PRECO"].ToString(); A.Vaca = false; listBox1.Items.Add(A); } Connect.cn.Close(); Connect.cn.Open(); cmd = new SqlCommand("EXEC VACAS.VERVACAS", Connect.cn); reader = cmd.ExecuteReader(); while (reader.Read()) { Animal A = new Animal(); A.produtor = reader["PRODUTOR"].ToString(); A.nrAnimal = reader["NR_ANIMAL"].ToString(); A.progenitorMasc = reader["PROGENITOR_MASC"].ToString(); A.progenitorFem = reader["PROGENITOR_FEM"].ToString(); A.estadoVacinacao = reader["ESTADO_VACINA"].ToString(); A.estadoAnalises = reader["ESTADO_ANÁLISES"].ToString(); A.nome = reader["NOME"].ToString(); A.dataNasc = reader["DATA_NASCIMENTO"].ToString(); A.Raca = reader["RACA"].ToString(); A.TipoVaca = reader["TIPO_VACA"].ToString(); A.Preco = reader["PRECO"].ToString(); A.Vaca = true; listBox1.Items.Add(A); } currentAnimal = 0; listBox1.SelectedIndex = currentAnimal; showAnimal(); Connect.cn.Close(); }
private void addPessoa(Pessoa pessoa) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.ADD_COMPRADOR @nif, @nome,@sexo, @localidade, @data,@telefone, @email"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@nome", pessoa.Name); cmd.Parameters.AddWithValue("@nif", Convert.ToInt32(pessoa.Nif)); cmd.Parameters.AddWithValue("@localidade", pessoa.Localidade); cmd.Parameters.AddWithValue("@data", Convert.ToDateTime(pessoa.Data_nasc)); cmd.Parameters.AddWithValue("@email", pessoa.Email); cmd.Parameters.AddWithValue("@telefone", Convert.ToInt32(pessoa.Tel)); cmd.Parameters.AddWithValue("@sexo", Convert.ToChar(pessoa.Sexo)); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { addSucess = false; throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 2) { MessageBox.Show("Add OK"); addSucess = true; } else { MessageBox.Show("Add NOT OK"); addSucess = false; } Connect.cn.Close(); } }
private void addProducaoLeite(producaoLeite prod) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.ADD_PRODUCAO_LEITE @numeroProdutor, @producaoManha, @producaoTarde, @data"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@producaoManha", prod.ProducaoManha); cmd.Parameters.AddWithValue("@producaoTarde", prod.ProducaoTarde); cmd.Parameters.AddWithValue("@data", prod.Data); cmd.Parameters.AddWithValue("@numeroProdutor", 1); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { //MessageBox.Show("404 NOT FOUND"); addSucess = false; throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 1) { MessageBox.Show("Add OK"); addSucess = true; } else { MessageBox.Show("Add NOT OK"); addSucess = false; } Connect.cn.Close(); } }
private void edit_venda(Venda venda) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.EDITAR_VENDA @nr_venda, @nr_animal, @vendedor, @montante , @data , @destino "; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@nr_venda", Convert.ToInt16(venda.Nr_venda)); cmd.Parameters.AddWithValue("@nr_animal", Convert.ToInt16(venda.NrAnimal)); cmd.Parameters.AddWithValue("@vendedor", Convert.ToInt64(venda.Nif)); cmd.Parameters.AddWithValue("@montante", Convert.ToDecimal(venda.Montante)); cmd.Parameters.AddWithValue("@data", Convert.ToDateTime(venda.Data)); cmd.Parameters.AddWithValue("@destino", venda.Destino); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 1) { MessageBox.Show("Update OK"); } else { MessageBox.Show("Update NOT OK"); } Connect.cn.Close(); } }
private void addCompra(Compra compra) { int rows = 0; if (!Connect.verifySGBDConnection()) { return; } SqlCommand cmd = new SqlCommand(); cmd.CommandText = "EXEC VACAS.ADD_COMPRA_VACA @numeroAnimal, @vendedor, @montante, @data, @destino"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@numeroAnimal", compra.NrAnimal); cmd.Parameters.AddWithValue("@vendedor", compra.Nif); cmd.Parameters.AddWithValue("@montante", compra.Montante); cmd.Parameters.AddWithValue("@data", compra.Data); cmd.Parameters.AddWithValue("@destino", compra.Destino); cmd.Connection = Connect.cn; try { rows = cmd.ExecuteNonQuery(); } catch (Exception ex) { throw new Exception("Failed to update database. \n ERROR MESSAGE: \n" + ex.Message); } finally { if (rows == 3) { MessageBox.Show("Update OK"); } else { MessageBox.Show("Update NOT OK"); } Connect.cn.Close(); } }
private void initialize() { Connect.verifySGBDConnection(); SqlCommand cmd = new SqlCommand("EXEC VACAS.VER_COMPRADOR", Connect.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine("reading..."); Pessoa pessoa = new Pessoa(); pessoa.Nif = (int)reader["NIF"]; pessoa.Name = reader["NOME"].ToString(); pessoa.Sexo = Convert.ToChar(reader["SEXO"]); pessoa.Localidade = reader["LOCALIDADE"].ToString(); pessoa.Data_nasc = reader["DATA_NASCIMENTO"].ToString(); pessoa.Tel = (int)reader["TELEFONE"]; pessoa.Email = reader["EMAIL"].ToString(); listBox1.Items.Add(pessoa); } Connect.cn.Close(); currentPerson = 0; listBox1.SelectedIndex = currentPerson; showPerson(); }
private void initialize() { Connect.verifySGBDConnection(); SqlCommand cmd = new SqlCommand("EXEC VACAS.VER_VENDAS", Connect.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Venda c = new Venda(); c.Nr_venda = reader["NR_VENDA"].ToString(); c.Nif = reader["COMPRADOR"].ToString(); c.NrAnimal = reader["NR_ANIMAL"].ToString(); c.Montante = reader["MONTANTE"].ToString(); c.Data = reader["DATA"].ToString(); c.Destino = reader["DESTINO"].ToString(); listBox1.Items.Add(c); } currentVenda = 0; listBox1.SelectedIndex = currentVenda; showVenda(); Connect.cn.Close(); okButton.Visible = false; cancelButton.Visible = false; }
private void initialize() { Connect.verifySGBDConnection(); SqlCommand cmd = new SqlCommand("EXEC VACAS.VER_VACINACAO", Connect.cn); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { RegistoVacinacao R = new RegistoVacinacao(); //A.produtor = reader["PRODUTOR"].ToString(); R.NrVacina = reader["NR_VACINA"].ToString(); R.NrAnimal = reader["NR_ANIMAL"].ToString(); R.NrVeterinario = reader["NR_VETERINARIO"].ToString(); R.Nome = reader["NOME"].ToString(); R.Data = reader["DATA"].ToString(); R.Local = reader["LOCAL"].ToString(); listBox1.Items.Add(R); } currentVacinacao = 0; listBox1.SelectedIndex = currentVacinacao; showVacinacao(); lockFields(); Connect.cn.Close(); }