protected void ButtonListaEspera_Click(object sender, EventArgs e)
{
int IndexGridViewTurma = Convert.ToInt32(GridViewTurma.SelectedRow.RowIndex);
int IndexGridViewAluno = Convert.ToInt32(GridViewAlunos.SelectedRow.RowIndex);
DataKey keysTurmaID = GridViewTurma.DataKeys[IndexGridViewTurma];
DataKey keysAlunoID = GridViewAlunos.DataKeys[IndexGridViewAluno];
int IdTurma = Convert.ToInt32(keysTurmaID.Value);
int IdAluno = Convert.ToInt32(keysAlunoID.Value);
Modelo.ListaEspera listaEspera = new Modelo.ListaEspera(IdTurma, IdAluno, DateTime.Now);
new DAL.DALListaEspera().Insert(listaEspera);
Response.Redirect("~/Matricula/WebFormMatricular.aspx");
}
public void Insert(Modelo.ListaEspera L)
{
SqlConnection conn = new SqlConnection(connectioString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO ListaEspera (IdTurma,IdAluno,DataInscricao) VALUES (@IdTurma,@IdAluno,@DataInscricao)";
cmd.Parameters.AddWithValue("@IdTurma", L.idTurma);
cmd.Parameters.AddWithValue("@IdAluno", L.IdAluno);
cmd.Parameters.AddWithValue("@DataInscricao", L.dataInscricao);
cmd.ExecuteNonQuery();
conn.Close();
}
public Modelo.ListaEspera Select(string IdAluno, string IdTurma)
{
Modelo.ListaEspera listaEspera = new Modelo.ListaEspera();
SqlConnection conn = new SqlConnection(connectioString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * FROM ListaEspera WHERE IdTurma = @IdTurma AND IdAluno = @IdAluno";
cmd.Parameters.AddWithValue("@IdTurma", IdTurma);
cmd.Parameters.AddWithValue("@IdAluno", IdAluno);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
listaEspera.IdAluno = int.Parse(dr["IdAluno"].ToString());
listaEspera.idTurma = int.Parse(dr["IdTurma"].ToString());
listaEspera.dataInscricao = DateTime.Parse(dr["DataInscricao"].ToString());
}
conn.Close();
return(listaEspera);
}
