public DataTable buscaAnimal(animalDTO dto)
{
SqlCommand cmd = new SqlCommand("pa_pesquisaAnimal", con.conectarBD());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@nomea", SqlDbType.VarChar).Value = dto.nomeAnimal;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable animal = new DataTable();
da.Fill(animal);
con.desconectarBD();
return(animal);
}
public ActionResult confirma(FormCollection frm)
{
animalBLL bll = new animalBLL();
animalDTO dto = new animalDTO();
dto.codAnimal = frm["txtCod"];
dto.nomeAnimal = frm["txtNome"];
dto.codTipo = frm["txtCodTP"];
dto.codRaca = frm["txtCodRA"];
dto.codResp = frm["txtCodR"];
dto.dataCadastro = frm["txtData"];
bll.inserirAnimal(dto);
return(View());
}
public void inserirAnimal(animalDTO dto)
{
SqlCommand cmd = new SqlCommand("pa_inserirAnimal", con.conectarBD());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@coda", SqlDbType.VarChar).Value = dto.codAnimal;
cmd.Parameters.Add("@nomepet", SqlDbType.VarChar).Value = dto.nomeAnimal;
cmd.Parameters.Add("@codtipo", SqlDbType.VarChar).Value = dto.codTipo;
cmd.Parameters.Add("@codraca", SqlDbType.VarChar).Value = dto.codRaca;
cmd.Parameters.Add("@codresp", SqlDbType.VarChar).Value = dto.codResp;
cmd.Parameters.Add("@data", SqlDbType.VarChar).Value = dto.dataCadastro;
cmd.ExecuteNonQuery();
con.desconectarBD();
}
public ActionResult resultado(FormCollection frm)
{
animalBLL bll = new animalBLL();
animalDTO dto = new animalDTO();
GridView dgv = new GridView();
dto.nomeAnimal = frm["txtNome"];
dgv.DataSource = bll.buscaAnimal(dto); //puxa o metodo de pesquisa e usa o termo inserido pelo usuario
dgv.DataBind();
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
dgv.RenderControl(htw);
ViewBag.GridViewString = sw.ToString();
return(View());
}
