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
{
}
}
