public int insEvaluacion(ObjResultado obj) { int valid = 0; if (this.AbreConexion()) { try { DataTable table = new DataTable(); SqlCommand cmd = new SqlCommand("SP_INS_EVALUACION", conectar); SqlDataReader read; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID_ALUMNO", obj.ID_ALUMNO); cmd.Parameters.AddWithValue("@ID_DOCENTE", obj.ID_DOCENTE); cmd.Parameters.AddWithValue("@A1", obj.A1); cmd.Parameters.AddWithValue("@B1", obj.B1); cmd.Parameters.AddWithValue("@C1", obj.C1); cmd.Parameters.AddWithValue("@D1", obj.D1); cmd.Parameters.AddWithValue("@E1", obj.E1); cmd.Parameters.AddWithValue("@F1", obj.F1); cmd.Parameters.AddWithValue("@G1", obj.G1); cmd.Parameters.AddWithValue("@H1", obj.H1); cmd.Parameters.AddWithValue("@H2", obj.H2); cmd.Parameters.AddWithValue("@COMENTARIO", obj.COMENTARIO); cmd.Parameters.AddWithValue("@COMENTARIOA", obj.COMENTARIOA); cmd.Parameters.AddWithValue("@COMENTARIOB", obj.COMENTARIOB); cmd.Parameters.AddWithValue("@COMENTARIOC", obj.COMENTARIOC); cmd.Parameters.AddWithValue("@COMENTARIOD", obj.COMENTARIOD); cmd.Parameters.AddWithValue("@COMENTARIOE", obj.COMENTARIOE); cmd.Parameters.AddWithValue("@COMENTARIOF", obj.COMENTARIOF); cmd.Parameters.AddWithValue("@COMENTARIOG", obj.COMENTARIOG); cmd.Parameters.AddWithValue("@IDPC", obj.IDPC); cmd.Parameters.AddWithValue("@SECCION", obj.SECCION); read = cmd.ExecuteReader(); while (read.Read()) { valid = read.GetInt32(0); } read.Close(); CerrarConexion(); return(valid); } catch (SqlException ex) { EventLog.WriteEntry("BDClass", "SP_INS_EVALUACION" + ex.Message); } catch (Exception ex) { EventLog.WriteEntry("BDClass", "SP_INS_EVALUACION" + ex.Message); } } return(0); }
protected void btnRegistrar_Click(object sender, EventArgs e) { ObjResultado obj = new ObjResultado(); string[] words = Session["valores"].ToString().Split('-'); lblMaestro.Text = words[0]; lblMateria.Text = words[1]; idpc = words[2]; seccion = words[3]; obj.A1 = Request["a1"]; obj.COMENTARIOA = Request["comentarioA"]; obj.B1 = Request["b1"]; obj.COMENTARIOB = Request["comentarioB"]; obj.C1 = Request["c1"]; obj.COMENTARIOC = Request["comentarioC"]; obj.D1 = Request["d1"]; obj.COMENTARIOD = Request["comentarioD"]; obj.E1 = Request["e1"]; obj.COMENTARIOE = Request["comentarioE"]; obj.F1 = Request["f1"]; obj.COMENTARIOF = Request["comentarioF"]; obj.G1 = Request["g1"]; obj.COMENTARIOG = Request["comentarioG"]; obj.H1 = Request["h1"]; obj.H2 = Request["h2"]; obj.COMENTARIO = Request["comentario"]; obj.ID_ALUMNO = Session["id_alumno"].ToString(); obj.ID_DOCENTE = words[4]; obj.IDPC = idpc; obj.SECCION = seccion; int valid = conn.insEvaluacion(obj); if (valid == 1) { Response.Redirect("Inicio"); } else { } }