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();
}