public Modelo.Turma Select(string ID)
{
Modelo.Turma Turma = new Modelo.Turma();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * FROM Turma WHERE IdTurma = @idTurma";
cmd.Parameters.AddWithValue("@idTurma", ID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Turma.idTurma = int.Parse(dr["IdTurma"].ToString());
Turma.nomeTurma = dr["Turma"].ToString();
Turma.ano = int.Parse(dr["Ano"].ToString());
Turma.horario = dr["Horario"].ToString();
Turma.dataInicio = DateTime.Parse(dr["DataInicio"].ToString());
Turma.dataFim = DateTime.Parse(dr["DataFim"].ToString());
Turma.qtdVagas = int.Parse(dr["QtdVagas"].ToString());
Turma.idDisciplina = int.Parse(dr["IdDisciplina"].ToString());
}
conn.Close();
return(Turma);
}
protected void InserirTurma_Click(object sender, EventArgs e)
{
DAL.DALTurma dALTurma = new DAL.DALTurma();
Modelo.Turma turma = new Modelo.Turma(0, TxtNomeTurma.Text,
int.Parse(TxtAno.Text), TxtHorário.Text, DateTime.Parse(CalendarDataInicio.Text), DateTime.Parse(CalendarDataFim.Text), int.Parse(TxtNumVagas.Text),
int.Parse(DropDownListDisciplina.SelectedItem.Value));
dALTurma.Insert(turma);
Response.Redirect("~/Admin/WebFormVisualizacaoTurma.aspx");
}
public bool VagaDisponivel(string IdTurma)
{
DALTurma dALTurma = new DALTurma();
Modelo.Turma turma = dALTurma.Select(IdTurma);
if (turma.qtdVagas >= (dALTurma.GetCountMatriculados(IdTurma) + 1))
{
return(true);
}
else
{
return(false);
}
}
public void CarregarItemEdicao()
{
DAL.DALTurma dALTurma = new DAL.DALTurma();
turma = dALTurma.Select(Session["IdTurma"].ToString());
if (!IsPostBack)
{
TxtNomeTurma.Text = turma.nomeTurma;
TxtAno.Text = turma.ano.ToString();
TxtHorário.Text = turma.horario;
CalendarDataInicio.Text = turma.dataInicio.ToShortDateString();
CalendarDataFim.Text = turma.dataFim.ToShortDateString();
TxtNumVagas.Text = turma.qtdVagas.ToString();
DropDownListDisciplina.SelectedValue = turma.idDisciplina.ToString();
}
}
public List <Modelo.Turma> Select(string filtro, string ano)
{
int iano;
Modelo.Turma Turma;
if (ano == "")
{
iano = 0;
}
else
{
iano = Convert.ToInt32(ano);
}
List <Modelo.Turma> ListTurma = new List <Modelo.Turma>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from Turma where ( (turma like '%" + filtro + "%') or (horario like '%" + filtro + "%') ) and ((ano = @ano) or (@ano = 0)) order by DataInicio";
cmd.Parameters.AddWithValue("@ano", iano);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Turma = new Modelo.Turma(
int.Parse(dr["IdTurma"].ToString()),
dr["Turma"].ToString(),
int.Parse(dr["Ano"].ToString()),
dr["Horario"].ToString(),
DateTime.Parse(dr["DataInicio"].ToString()),
DateTime.Parse(dr["DataFim"].ToString()),
int.Parse(dr["QtdVagas"].ToString()),
int.Parse(dr["IdDisciplina"].ToString()));
ListTurma.Add(Turma);
}
}
dr.Close();
conn.Close();
return(ListTurma);
}
public void Update(Modelo.Turma obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("UPDATE Turma SET IdTurma = IdTurma, Turma = @Turma, Ano = @Ano,Horario = @Horario,DataInicio = @DataInicio,DataFim = @DataFim,QtdVagas = @QtdVagas,IdDisciplina = @IdDisciplina WHERE IdTurma=@IdTurma", conn);
cmd.Parameters.AddWithValue("@IdTurma", obj.idTurma);
cmd.Parameters.AddWithValue("@Turma", obj.nomeTurma);
cmd.Parameters.AddWithValue("@Ano", obj.ano);
cmd.Parameters.AddWithValue("@Horario", obj.horario);
cmd.Parameters.AddWithValue("@DataInicio", obj.dataInicio);
cmd.Parameters.AddWithValue("@DataFim", obj.dataFim);
cmd.Parameters.AddWithValue("@QtdVagas", obj.qtdVagas);
cmd.Parameters.AddWithValue("@IdDisciplina", obj.idDisciplina);
cmd.ExecuteNonQuery();
conn.Close();
}
public List <Modelo.Turma> SelectAll()
{
Modelo.Turma Turma;
List <Modelo.Turma> ListTurma = new List <Modelo.Turma>();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "Select * from Turma order by DataInicio";
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Turma = new Modelo.Turma(
int.Parse(dr["IdTurma"].ToString()),
dr["Turma"].ToString(),
int.Parse(dr["Ano"].ToString()),
dr["Horario"].ToString(),
DateTime.Parse(dr["DataInicio"].ToString()),
DateTime.Parse(dr["DataFim"].ToString()),
int.Parse(dr["QtdVagas"].ToString()),
int.Parse(dr["IdDisciplina"].ToString()));
ListTurma.Add(Turma);
}
}
dr.Close();
conn.Close();
return(ListTurma);
}
public void Insert(Modelo.Turma obj)
{
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlCommand cmd = new SqlCommand("INSERT INTO Turma(IdTurma, Turma, Ano, Horario, DataInicio, DataFim, QtdVagas, IdDisciplina)VALUES(@IdTurma, @Turma, @Ano, @Horario, @DataInicio, @DataFim, @QtdVagas, @IdDisciplina)", conn);
cmd.Parameters.AddWithValue("@IdTurma", GetIdMax());
cmd.Parameters.AddWithValue("@Turma", obj.nomeTurma);
cmd.Parameters.AddWithValue("@Ano", obj.ano);
cmd.Parameters.AddWithValue("@Horario", obj.horario);
cmd.Parameters.AddWithValue("@DataInicio", obj.dataInicio);
cmd.Parameters.AddWithValue("@DataFim", obj.dataFim);
cmd.Parameters.AddWithValue("@QtdVagas", obj.qtdVagas);
cmd.Parameters.AddWithValue("@IdDisciplina", obj.idDisciplina);
cmd.ExecuteNonQuery();
conn.Close();
}
