public void inserirRaca(racaDTO dto)
{
SqlCommand cmd = new SqlCommand("pa_inserirRaca", con.conectarBD());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cod", SqlDbType.VarChar).Value = dto.codRaca;
cmd.Parameters.Add("@raca", SqlDbType.VarChar).Value = dto.raca;
cmd.ExecuteNonQuery();
con.desconectarBD();
}
public ActionResult confirma(FormCollection frm)
{
racaBLL bll = new racaBLL();
racaDTO dto = new racaDTO();
dto.codRaca = frm["txtCod"];
dto.raca = frm["txtRaca"];
bll.inserirRaca(dto);
return(View());
}
public DataTable buscaRaca(racaDTO dto)
{
SqlCommand cmd = new SqlCommand("pa_pesquisaRaca", con.conectarBD());
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@raca", SqlDbType.VarChar).Value = dto.raca;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable raca = new DataTable();
da.Fill(raca);
con.desconectarBD();
return(raca);
}
public ActionResult resultado(FormCollection frm)
{
racaBLL bll = new racaBLL();
racaDTO dto = new racaDTO();
GridView dgv = new GridView();
dto.raca = frm["txtRaca"];
dgv.DataSource = bll.buscaRaca(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());
}
