//StopProcedure
public void Insert(Calculo c)
{
SqlCommand com = new SqlCommand("InsertCalculo", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Respuesta", c.Respuesta);
com.Parameters.AddWithValue("@FechaHora", c.FechaHora);
com.Parameters.AddWithValue("@UsuarioId", c.UsuarioId);
con.Open();
com.ExecuteNonQuery();
}
public Calculo SelectId(int id)
{
Calculo calculo = new Calculo();
SqlCommand com = new SqlCommand("GetIdCalculo", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Id", id);
SqlDataAdapter da = new SqlDataAdapter(com);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count == 1)
{
calculo.Id = Convert.ToInt32(dt.Rows[0][0].ToString());
calculo.Respuesta = Convert.ToInt32(dt.Rows[0][1].ToString());
calculo.FechaHora = Convert.ToDateTime(dt.Rows[0][2].ToString());
calculo.UsuarioId = Convert.ToInt32(dt.Rows[0][3].ToString());
return(calculo);
}
return(calculo);
}
