public void Add(Pecuarista obj)
{
using (SqlConnection con = new SqlConnection(Db.getconnectionString()))
{
string comandoSQL = "Insert into Pecuarista (Nome) Values(@Nome)";
SqlCommand cmd = new SqlCommand(comandoSQL, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Nome", obj.Nome);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public void Add(Animal obj)
{
using (SqlConnection con = new SqlConnection(Db.getconnectionString()))
{
string comandoSQL = "Insert into Animal (Descricao,Preco) Values(@Descricao, @Preco)";
SqlCommand cmd = new SqlCommand(comandoSQL, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Descricao", obj.Descricao);
cmd.Parameters.AddWithValue("@Preco", obj.Preco);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public void Add(CompraGado obj)
{
using (SqlConnection con = new SqlConnection(Db.getconnectionString()))
{
string comandoSQL = "Insert into CompraGado (ID, DataEntrega, PecuaristaId) Values(@ID, @DataEntrega, @PecuaristaId)";
SqlCommand cmd = new SqlCommand(comandoSQL, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ID", obj.ID);
cmd.Parameters.AddWithValue("@DataEntrega", obj.DataEntrega);
cmd.Parameters.AddWithValue("@PecuaristaId", obj.PecuaristaID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public void Add(CompraGadoItem obj)
{
using (SqlConnection con = new SqlConnection(Db.getconnectionString()))
{
string comandoSQL = "Insert into CompraGadoItem (Quantidade, CompraGadoId, AnimalId) Values(@Quantidade, @CompraGadoId, @AnimalId)";
SqlCommand cmd = new SqlCommand(comandoSQL, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Quantidade", obj.Quantidade);
cmd.Parameters.AddWithValue("@CompraGadoId", obj.CompraGadoID);
cmd.Parameters.AddWithValue("@AnimalId", obj.AnimalID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
