public ActionResult DeleteConfirmed(int id) { MATRICULA mATRICULA = db.MATRICULA.Find(id); db.MATRICULA.Remove(mATRICULA); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "cod_mat,cod_alum,pro_mat,cod_gra")] MATRICULA mATRICULA) { if (ModelState.IsValid) { db.Entry(mATRICULA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(mATRICULA)); }
static clsNMatricula transformar(MATRICULA newMatricula) { clsNMatricula matricula = new clsNMatricula(); matricula.IDMATRICULA = newMatricula.IDMATRICULA; matricula.IDLINEADEACCION = newMatricula.IDLINEADEACCION; matricula.IDORIENTADOR = newMatricula.IDORIENTADOR; matricula.IDPROCESO = newMatricula.IDPROCESO; matricula.IDPERIODO = newMatricula.IDPERIODO; matricula.IDPERSONA = newMatricula.IDPERSONA; return(matricula); }
// GET: Matricula/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MATRICULA mATRICULA = db.MATRICULA.Find(id); if (mATRICULA == null) { return(HttpNotFound()); } return(View(mATRICULA)); }
public void eliminarMatricula(int idMatricula) { try { using (MERSembrarDataContext db = new MERSembrarDataContext()) { MATRICULA matricula = (from ma in db.MATRICULA where ma.IDMATRICULA == idMatricula select ma).First(); db.MATRICULA.DeleteOnSubmit(matricula); db.SubmitChanges(); } } catch { } }
//Ingreso de matriculas public bool ingresarMatricula(clsNMatricula nuevaMatricula) { try { using (MERSembrarDataContext db = new MERSembrarDataContext()) { MATRICULA matricula = new MATRICULA(); matricula.IDLINEADEACCION = nuevaMatricula.IDLINEADEACCION; matricula.IDORIENTADOR = nuevaMatricula.IDORIENTADOR; matricula.IDPROCESO = nuevaMatricula.IDPROCESO; matricula.IDPERIODO = nuevaMatricula.IDPERIODO; matricula.IDPERSONA = nuevaMatricula.IDPERSONA; db.MATRICULA.InsertOnSubmit(matricula); db.SubmitChanges(); } return(true); } catch { return(false); } }
public ActionResult Create([Bind(Include = "cod_mat,cod_alum,pro_mat,cod_gra")] MATRICULA mATRICULA) { List <SelectListItem> listItems = new List <SelectListItem>(); listItems.Add(new SelectListItem { Text = "Primaria", Value = "P" }); listItems.Add(new SelectListItem { Text = "Secundaria", Value = "S" }); if (ModelState.IsValid) { string niv; int gra; if (Request.Form["buscar"] != "") { ViewData["busqueda"] = Request.Form["buscar"].ToString(); ViewData["prom"] = Request.Form["pro_mat"].ToString(); var index = Request.Form["buscar"].IndexOf(','); string dni; if (index == -1 || index == 0) { dni = Request.Form["buscar"]; } else { dni = Request.Form["buscar"].Substring(0, index); } if (db.IsAllDigits(dni)) { if (dni.Length == 8) { if (db.ALUMNO.Any(a => a.dni_alum.Equals(dni))) { var codAlu = db.ALUMNO.Where(a => a.dni_alum.Equals(dni)).Select(a => a.cod_alum).First(); mATRICULA.cod_alum = codAlu; if (Request.Form["NIVEL"].ToString() != "") { niv = Request.Form["NIVEL"]; if (Request.Form["GRADO"].ToString() != "") { gra = int.Parse(Request.Form["GRADO"]); mATRICULA.cod_gra = gra; if (!(db.MATRICULA.Any(x => x.cod_alum == mATRICULA.cod_alum))) { var limite = (from g in db.GRADO join a in db.AULA on g.cod_aula equals a.cod_aula where g.cod_gra == gra select a.nca_aul).First(); var alumnos = (from a in db.ALUMNO join m in db.MATRICULA on a.cod_alum equals m.cod_alum where m.cod_gra == gra select a.cod_alum).Count(); if (alumnos < limite) { db.MATRICULA.Add(mATRICULA); db.SaveChanges(); return(RedirectToAction("Index")); } else { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", niv); ViewData["GRADO"] = new SelectList(db.GRADO.ToList().Where(g => g.niv_gra == niv), "cod_gra", "gradoSeccion"); TempData["msg"] = "<script>alert('No se pueden matricular más alumnos');</script>"; return(View(mATRICULA)); } } else { TempData["msg"] = "<script>alert('El alumno ya se encuentra matriculado');</script>"; ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", niv); ViewData["GRADO"] = new SelectList(db.GRADO.ToList().Where(g => g.niv_gra == niv), "cod_gra", "gradoSeccion"); return(View(mATRICULA)); } } else { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", niv); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); } } else { ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); } } else { TempData["msg"] = "<script>alert('El DNI no está registrado');</script>"; ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); } } else { if (Request.Form["NIVEL"].ToString() != "") { if (Request.Form["GRADO"].ToString() == "") { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(""); TempData["msg"] = "<script>alert('El DNI no tiene 8 dígitos');</script>"; return(View(mATRICULA)); } else { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(db.GRADO.ToList().Where(g => g.cod_gra == int.Parse(Request.Form["GRADO"])), "cod_gra", "gradoSeccion"); TempData["msg"] = "<script>alert('El DNI no tiene 8 dígitos');</script>"; return(View(mATRICULA)); } } else { ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); TempData["msg"] = "<script>alert('El DNI no tiene 8 dígitos');</script>"; return(View(mATRICULA)); } } } else { if (Request.Form["NIVEL"].ToString() != "") { if (Request.Form["GRADO"].ToString() == "") { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(""); TempData["msg"] = "<script>alert('DNI incorrecto');</script>"; return(View(mATRICULA)); } else { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(db.GRADO.ToList().Where(g => g.cod_gra == int.Parse(Request.Form["GRADO"])), "cod_gra", "gradoSeccion"); TempData["msg"] = "<script>alert('DNI incorrecto');</script>"; return(View(mATRICULA)); } } else { ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); TempData["msg"] = "<script>alert('DNI incorrecto');</script>"; return(View(mATRICULA)); } } } else { if (Request.Form["NIVEL"].ToString() != "") { if (Request.Form["GRADO"].ToString() == "") { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); } else { ViewData["NIVEL"] = new SelectList(listItems, "Value", "Text", Request.Form["NIVEL"].ToString()); ViewData["GRADO"] = new SelectList(db.GRADO.ToList().Where(g => g.cod_gra == int.Parse(Request.Form["GRADO"])), "cod_gra", "gradoSeccion"); return(View(mATRICULA)); } } else { ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); } } } ViewBag.nivel = new SelectList(listItems, "Value", "Text"); ViewData["GRADO"] = new SelectList(""); return(View(mATRICULA)); }