[HttpPost] //Metodo Para Matricular un Estudiante
public async Task <IActionResult> Agregar(int OfertasId, int TurnoId, int SituacionMatriculaId, int EstudiantesId, int[] AsignaturasId)
{
//Verifica si no posee ya una matricula
var Verifica = _context.Matriculas.Where(x => x.EstudiantesId == EstudiantesId && x.Fecha.Year == DateTime.Today.Year).FirstOrDefault();
if (Verifica == null)
{
Matriculas matriculas = new Matriculas();
matriculas.EstudiantesId = EstudiantesId;
matriculas.Fecha = DateTime.Today;
matriculas.OfertasId = OfertasId;
matriculas.TurnoId = TurnoId;
matriculas.SituacionMatriculaId = SituacionMatriculaId;
_context.Add(matriculas);
await _context.SaveChangesAsync();
Detallematricula Detalle;
for (int i = 0; i < AsignaturasId.Length; i++)
{
Detalle = new Detallematricula();
Detalle.AsignaturasId = AsignaturasId[i];
Detalle.MatriculasId = matriculas.Id;
_context.Add(Detalle);
await _context.SaveChangesAsync();
}
return(Json(1));
}
else
{
return(Json(Verifica));
}
}
public ActionResult ValidarDigitosVerificadores()
{
string arquivoDownload = "";
string arquivoUpload = "";
try
{
IFormFile arquivo = Request.Form.Files[0];
arquivoUpload = SalvarArquivo(arquivo);
arquivoDownload = Matriculas.ValidarDigitosVerificadores(arquivoUpload);
return(BaixarArquivo(arquivoDownload));
}
catch (System.Exception ex)
{
return(Json("Upload Failed: " + ex.Message));
}
finally
{
RemoverArquivo(arquivoDownload);
RemoverArquivo(arquivoUpload);
}
}
public ActionResult DeleteConfirmed(int?curso, string grupo, string user, string nummatricula, DateTime fecha)
{
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo);
db.Matriculas.Remove(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string user, int?curso, int?grupo, string id)
{
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo, id);
db.Matriculas.Remove(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public static void guardaNuevaMatricula(string nombre, string apellido, string correo, string materia)
{
Matriculas.Add(
nombre + " " + apellido +
" Correo = " + correo +
" Materia = " + materia
);
}
public ActionResult DeleteConfirmed(int id)
{
Matriculas matriculas = db.Matriculas.Find(id);
db.Matriculas.Remove(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(matriculas));
}
public ActionResult Edit([Bind(Include = "Id,CursoId,GrupoClaseId,UserId")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CursoId = new SelectList(db.Cursos, "Id", "Curso", matriculas.CursoId);
return(View(matriculas));
}
public ActionResult Create([Bind(Include = "Id")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Matriculas.Add(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(matriculas));
}
public ActionResult Edit([Bind(Include = "Id,GrupoId,UsuarioId")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GrupoId = new SelectList(db.GrupoClases, "Id", "Grupo_Nombre", matriculas.GrupoId);
ViewBag.UsuarioId = new SelectList(db.Users, "Id", "Name", matriculas.UsuarioId);
return(View(matriculas));
}
public int CrearMatricula(Matriculas matricula)
{
try
{
entities.Matriculas.Add(matricula);
return(entities.SaveChanges());
}
catch (Exception ex)
{
throw ex;
}
}
public void EditMatricula(Matriculas matricula)
{
Matriculas novaMatricula = new Matriculas();
novaMatricula.IdMatricula = matricula.IdMatricula;
novaMatricula.IdAluno = matricula.IdAluno;
novaMatricula.ValorMatricula = matricula.ValorMatricula;
novaMatricula.IdTurma = novaMatricula.IdTurma;
DataModel.Entry(novaMatricula).State = novaMatricula.IdAluno == 0 ? EntityState.Added : EntityState.Modified;
dados.SaveChanges();
}
public void SaveMatricula(Matriculas matricula)
{
Matriculas novaMatricula = new Matriculas();
novaMatricula.IdMatricula = matricula.IdMatricula;
novaMatricula.IdAluno = matricula.IdAluno;
novaMatricula.ValorMatricula = matricula.ValorMatricula;
novaMatricula.IdTurma = novaMatricula.IdTurma;
dados.Matriculas.Add(novaMatricula);
dados.SaveChanges();
}
public ActionResult Edit([Bind(Include = "IdMatricula,codCurso,codGrupoClase,UserId")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.codCurso = new SelectList(db.Cursos, "codCurso", "nombre", matriculas.codCurso);
ViewBag.codGrupoClase = new SelectList(db.GrupoClases, "codGrupoClase", "nombre", matriculas.codGrupoClase);
ViewBag.UserId = new SelectList(db.Users, "Id", "Name", matriculas.UserId);
return(View(matriculas));
}
public ActionResult Create([Bind(Include = "Id,grupoClaseId,cursoId,userId,fechaMatricula")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Matriculas.Add(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cursoId = new SelectList(db.Cursos, "Id", "NombreCurso", matriculas.cursoId);
ViewBag.grupoClaseId = new SelectList(db.GrupoClases, "Id", "aula", matriculas.grupoClaseId);
return(View(matriculas));
}
public ActionResult Edit([Bind(Include = "Id,alumnoId,cursoId,grupoId,fecha")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.alumnoId = new SelectList(db.Users, "Id", "Name", matriculas.alumnoId);
ViewBag.cursoId = new SelectList(db.Cursos, "Id", "promocion", matriculas.cursoId);
ViewBag.grupoId = new SelectList(db.GrupoClases, "Id", "nombre", matriculas.grupoId);
return(View(matriculas));
}
public ActionResult Edit([Bind(Include = "Ano,Semestre,MatriculaAluno,CodigoDisciplina,Nota1,Nota2,Nota3,Faltas1,Faltas2,Faltas3")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Entry(matriculas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MatriculaAluno = new SelectList(db.Alunos, "MatriculaAluno", "NomeAluno", matriculas.MatriculaAluno);
ViewBag.CodigoDisciplina = new SelectList(db.Disciplinas, "CodigoDisciplina", "NomeDisciplina", matriculas.CodigoDisciplina);
ViewBag.Ano = new SelectList(db.PeriodosLetivos, "Ano", "Ano", matriculas.Ano);
return(View(matriculas));
}
public async Task RemoverDadosAlunoAsync(int alunoId)
{
var aluno = await Alunos.FindAsync(alunoId);
// Apagar aulas assistidas
var aulasAssistidas = await AulasAssistidas.Where(aa => aa.AlunoId == aluno.Id).ToListAsync();
if (aulasAssistidas != null)
{
AulasAssistidas.RemoveRange(aulasAssistidas);
}
// Apagar anotacoes
var anotacoes = await AnotacoesAulas.Where(aa => aa.AlunoId == aluno.Id).ToListAsync();
if (anotacoes != null)
{
AnotacoesAulas.RemoveRange(anotacoes);
}
// Apagar notas
var notas = await Notas.Where(n => n.AlunoId == aluno.Id).ToListAsync();
if (notas != null)
{
Notas.RemoveRange(notas);
}
// Apagar matriculas
var matriculas = await Matriculas.Where(m => m.AlunoId == aluno.Id).ToListAsync();
if (matriculas != null)
{
// Apagar Status Aulas
foreach (var matricula in matriculas)
{
var statusAulas = StatusAulas.Where(sa => sa.MatriculaId == matricula.Id).SingleOrDefault();
if (statusAulas != null)
{
StatusAulas.Remove(statusAulas);
}
var pagamento = await Pagamentos.Where(p => p.Id == matricula.PagamentoId).SingleOrDefaultAsync();
Pagamentos.Remove(pagamento);
Matriculas.Remove(matricula);
}
}
await SaveChangesAsync();
}
// GET: Matriculas/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(id);
if (matriculas == null)
{
return(HttpNotFound());
}
return(View(matriculas));
}
// GET: Matriculas/Details/5
public ActionResult Details(string user, int?curso, int?grupo, string id)
{
if (user == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo, id);
if (matriculas == null)
{
return(HttpNotFound());
}
return(View(matriculas));
}
public ActionResult Create([Bind(Include = "Id,CursoId,GrupoClaseId,UserId")] Matriculas matriculas)
{
if (ModelState.IsValid)
{
db.Matriculas.Add(matriculas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CursoId = new SelectList(db.Cursos, "Id", "descripcion", matriculas.CursoId);
ViewBag.GrupoClaseId = new SelectList(db.GrupoClases, "Id", "descripcion", matriculas.GrupoClaseId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Name", matriculas.UserId);
return(View(matriculas));
}
// GET: Matriculas/Details/5
public ActionResult Details(int?curso, string grupo, string user, string nummatricula, DateTime fecha)
{
if (curso == null || grupo == null || user == null || nummatricula == null || fecha == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo);
if (matriculas == null)
{
return(HttpNotFound());
}
return(View(matriculas));
}
public static void eliminaMatricula(string estudiante)
{
int cont = 0;
int posicion = 0;
foreach (string i in Matriculas)
{
if (i.Contains(estudiante))
{
posicion = cont;
}
cont++;
}
Matriculas.RemoveAt(posicion);
}
// GET: Matriculas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(id);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.CursoId = new SelectList(db.Cursos, "Id", "Curso", matriculas.CursoId);
return(View(matriculas));
}
protected void email_TextChanged(object sender, EventArgs e)
{
string em = email.Text;
Matriculas m = new Matriculas();
string res = m.comprobar(em);
if (res == "SI")
{
validaMail.Text = "Válido";
}
if (res == "NO")
{
validaMail.Text = "Inválido";
}
}
// GET: Matriculas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(id);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.GrupoId = new SelectList(db.GrupoClases, "Id", "Grupo_Nombre", matriculas.GrupoId);
ViewBag.UsuarioId = new SelectList(db.Users, "Id", "Name", matriculas.UsuarioId);
return(View(matriculas));
}
public ActionResult Edit(string user, int?curso, int?grupo, string id)
{
if (user == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo, id);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.CursoId = new SelectList(db.Cursos, "Id", "Curso", matriculas.CursoId);
ViewBag.GrupoId = new SelectList(db.Grupos, "Id", "Grupo", matriculas.GrupoId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Name", matriculas.UserId);
return(View(matriculas));
}
// GET: Matriculas/Edit/5
public ActionResult Edit(int?curso, string grupo, string user, string nummatricula, DateTime fecha)
{
if (curso == null || grupo == null || user == null || nummatricula == null || fecha == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(user, curso, grupo);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.CursoId = new SelectList(db.Cursos, "CursoId", "CursoId", matriculas.CursoId);
ViewBag.GrupoId = new SelectList(db.Grupos, "GrupoId", "GrupoId", matriculas.GrupoId);
ViewBag.UserId = new SelectList(db.Users, "Id", "Name", matriculas.UserId);
return(View(matriculas));
}
// GET: Matriculas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(id);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.alumnoId = new SelectList(db.Users, "Id", "Name", matriculas.alumnoId);
ViewBag.cursoId = new SelectList(db.Cursos, "Id", "promocion", matriculas.cursoId);
ViewBag.grupoId = new SelectList(db.GrupoClases, "Id", "nombre", matriculas.grupoId);
return(View(matriculas));
}
// GET: Matriculas/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Matriculas matriculas = db.Matriculas.Find(id);
if (matriculas == null)
{
return(HttpNotFound());
}
ViewBag.MatriculaAluno = new SelectList(db.Alunos, "MatriculaAluno", "NomeAluno", matriculas.MatriculaAluno);
ViewBag.CodigoDisciplina = new SelectList(db.Disciplinas, "CodigoDisciplina", "NomeDisciplina", matriculas.CodigoDisciplina);
ViewBag.Ano = new SelectList(db.PeriodosLetivos, "Ano", "Ano", matriculas.Ano);
return(View(matriculas));
}
