public void EliminarAulas(EAulas e)
{
try
{
DAulas d = new DAulas();
d.EliminarAula(e);
}
catch (Exception ex)
{
throw ex;
}
}
public void ModificarAulas(EAulas e)
{
try
{
if (e.Aula == "")
{
throw new ArgumentException("Ingrese una Aula");
}
DAulas d = new DAulas();
d.ModificarAula(e);
}
catch (Exception ex)
{
throw ex;
}
}
public void IngresaAulas(EAulas e)
{
try
{
List <EAulas> Lista = ListaAulas().Where(x => x.Aula == e.Aula && x.GradoId == e.GradoId && e.Turno == x.Turno).ToList();
if (Lista.Count > 0)
{
throw new ArgumentException("La Aula " + e.Aula + " ya existe");
}
DAulas d = new DAulas();
d.IngresarAula(e);
}
catch (Exception ex)
{
throw ex;
}
}
public void EliminarAula(EAulas A)
{
try
{
comando = new SqlCommand("EliminarAulas");
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@AulaId", A.AulaId);
comando.Connection = conexion;
conexion.Open();
comando.ExecuteNonQuery();
conexion.Close();
conexion.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
public void IngresarAula(EAulas A)
{
try
{
comando = new SqlCommand("IngresarAula", conexion);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Aula", A.Aula);
comando.Parameters.AddWithValue("@capacidad", A.Capacidad);
comando.Parameters.AddWithValue("@Vacantes", A.Vacantes);
comando.Parameters.AddWithValue("@GradoId", A.GradoId);
comando.Parameters.AddWithValue("@Turno", A.Turno);
conexion.Open();
comando.ExecuteNonQuery();
conexion.Close();
conexion.Dispose();
}
catch (Exception ex)
{
throw ex;
}
}
public List <EAulas> MostrarVacantesAulas(int turnoid, int id)
{
comando = new SqlCommand("mostrarVacantesAula", conexion);
comando.CommandType = CommandType.StoredProcedure;
comando.Parameters.AddWithValue("@Gradoid", id);
comando.Parameters.AddWithValue("@Turno", turnoid);
conexion.Open();
SqlDataReader leer = comando.ExecuteReader();
List <EAulas> lista = new List <EAulas>();
while (leer.Read())
{
EAulas a = new EAulas();
a.Aula = leer[0].ToString();
a.Capacidad = (int)leer[1];
lista.Add(a);
}
leer.Close();
conexion.Close();
conexion.Dispose();
return(lista);
}
public List <EAulas> ListaAulas()
{
try
{
string sql = "select AulaId,Aula,Capacidad,Vacantes,A.GradoId,Grado,A.activo,A.TurnoId, Turno \n" +
"from dba.Aulas A \n" +
"inner join dba.Grados G ON A.GradoId = G.GradoId \n" +
"inner join dba.Turnos T on A.TurnoId = T.TurnoId";
comando = new SqlCommand(sql, conexion);
comando.CommandType = CommandType.Text;
comando.Connection = conexion;
conexion.Open();
List <EAulas> lista = new List <EAulas>();
SqlDataReader leer = comando.ExecuteReader();
while (leer.Read())
{
EAulas a = new EAulas();
a.AulaId = (int)leer[0];
a.Aula = leer[1].ToString();
a.Capacidad = (int)leer[2];
a.Vacantes = (int)leer[3];
a.GradoId = (int)leer[4];
a.Grado = leer[5].ToString();
a.Activo = (bool)leer[6];
a.Turno = Convert.ToInt32(leer[7].ToString());
a.TurnoName = leer[8].ToString();
lista.Add(a);
}
leer.Close();
conexion.Close();
conexion.Dispose();
return(lista);
}
catch (Exception ex)
{
throw ex;
}
}
private void eliminarToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
EAulas A = new EAulas();
NAulas n = new NAulas();
A.AulaId = Convert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "AulaId").ToString());
var Aula = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "Aula").ToString();
DialogResult o = MessageBox.Show("¿Realmente deseas eliminar la Aula " + Aula + " ?", "SGA", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (o == DialogResult.OK)
{
n.EliminarAulas(A);
MessageBox.Show("Aula Eliminada con exito", "SGA", MessageBoxButtons.OK, MessageBoxIcon.Information);
Limpiar();
CargarGrados();
CargarLista();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SGA", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
