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