[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)); }