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