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