public void Insert(Modelo.Matricula M)
{
SqlConnection conn = new SqlConnection(connectioString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "INSERT INTO Matricula (IdTurma,IdAluno,Situacao,DataMatricula) VALUES (@IdTurma,@IdAluno,@Situacao,@DataMatricula)";
cmd.Parameters.AddWithValue("@IdTurma", M.idTurma);
cmd.Parameters.AddWithValue("@IdAluno", M.idAluno);
cmd.Parameters.AddWithValue("@Situacao", M.situacao);
cmd.Parameters.AddWithValue("@DataMatricula", M.dataMatricula);
try
{
cmd.ExecuteNonQuery();
}
catch (SqlException)
{
throw new Exception("Aluno já matriculado na turma selecionada");
}
finally
{
conn.Close();
}
}
protected void ButtonMatricular_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.Matricula matricula = new Modelo.Matricula(IdAluno, IdTurma, 1, DateTime.Now);
DAL.DALMatricula dalMatricula = new DAL.DALMatricula();
try
{
dalMatricula.Insert(matricula);
}
catch (Exception ex)
{
LiteralErro.Text = ex.Message;
LiteralErro.Visible = true;
}
DAL.DALAlunoDocumento dalAlunoDocumento = new DAL.DALAlunoDocumento();
foreach (ListItem I in CheckBoxListDocumentoDisciplina.Items)
{
if (I.Selected)
{
dalAlunoDocumento.insert(new Modelo.AlunoDocumento(Convert.ToInt32(IdAluno), Convert.ToInt32(I.Value)));
}
}
Session["matricula"] = matricula;
Response.Redirect("~/Matricula/WebFormImprimirFichaInscricao.aspx");
}
public void CarregarDadosAluno()
{
matricula = (Modelo.Matricula)Session["matricula"];
Modelo.Aluno aluno = new DAL.DALAluno().select(matricula.idAluno.ToString());
Modelo.Turma turma = new DAL.DALTurma().Select(matricula.idTurma.ToString());
LabelData.Text = matricula.dataMatricula.ToShortDateString();
}
public void Update(Modelo.Matricula M)
{
SqlConnection conn = new SqlConnection(connectioString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE Matricula SET Situacao = @Situacao WHERE IdTurma = @IdTurma AND IdAluno = @IdAluno";
cmd.Parameters.AddWithValue("@Situacao", M.situacao);
cmd.Parameters.AddWithValue("@IdTurma", M.idTurma);
cmd.Parameters.AddWithValue("@IdAluno", M.idAluno);
cmd.ExecuteNonQuery();
conn.Close();
}
public Modelo.Matricula Select(string IdAluno, string IdTurma)
{
Modelo.Matricula matricula = new Modelo.Matricula();
SqlConnection conn = new SqlConnection(connectioString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * FROM Matricula WHERE IdTurma = @IdTurma AND IdAluno = @IdAluno";
cmd.Parameters.AddWithValue("@IdTurma", IdTurma);
cmd.Parameters.AddWithValue("@IdAluno", IdAluno);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
matricula.idAluno = int.Parse(dr["IdAluno"].ToString());
matricula.idTurma = int.Parse(dr["IdTurma"].ToString());
matricula.situacao = int.Parse(dr["Situacao"].ToString());
matricula.dataMatricula = DateTime.Parse(dr["DataMatricula"].ToString());
}
conn.Close();
return(matricula);
}
