public static List <AlumnoGrado> GetAll() { List <AlumnoGrado> alumnosGrados = new List <AlumnoGrado>(); using (SqlConnection connection = DBConfig.GetInstance().GetConnection()) { try { SqlCommand query = new SqlCommand("spAlumnoGradoGetAll", connection) { CommandType = CommandType.StoredProcedure }; SqlDataReader reader = query.ExecuteReader(); while (reader.Read()) { AlumnoGrado alumnoGrado = new AlumnoGrado { ID = Convert.ToInt32(reader["id"]), AlumnoID = Convert.ToInt32(reader["alumnoID"]), GradoID = Convert.ToInt32(reader["gradoID"]), Seccion = Convert.ToString(reader["seccion"]) }; alumnosGrados.Add(alumnoGrado); } } catch (Exception e) { Console.WriteLine(e.Message); } } return(alumnosGrados); }
public static bool Create(AlumnoGrado alumnoGrado) { using (SqlConnection connection = DBConfig.GetInstance().GetConnection()) { try { SqlCommand query = new SqlCommand("spAlumnoGradoCreate", connection) { CommandType = CommandType.StoredProcedure }; query.Parameters.AddWithValue("@alumnoID", alumnoGrado.AlumnoID); query.Parameters.AddWithValue("@gradoID", alumnoGrado.GradoID); query.Parameters.AddWithValue("@seccion", alumnoGrado.Seccion); int rowsAffected = query.ExecuteNonQuery(); if (rowsAffected == 1) { return(true); } } catch (Exception e) { Console.WriteLine(e.Message); } } return(false); }
public ActionResult DeleteConfirmed(int id) { AlumnoGrado alumnoGrado = db.AlumnosGrado.Find(id); db.AlumnosGrado.Remove(alumnoGrado); try { db.SaveChanges(); } catch (Exception ex) { if (ex.InnerException != null && ex.InnerException.InnerException != null && ex.InnerException.InnerException.Message.Contains("REFERENCE")) { ModelState.AddModelError(string.Empty, "El registro no se puede eliminar porque tiene datos relacionados."); } else { ModelState.AddModelError(string.Empty, ex.Message); } return(View(alumnoGrado)); } return(RedirectToAction("Index")); }
public static AlumnoGrado GetByID(int id) { AlumnoGrado alumnoGrado = null; using (SqlConnection connection = DBConfig.GetInstance().GetConnection()) { try { SqlCommand query = new SqlCommand("spAlumnoGradoGetByID", connection) { CommandType = CommandType.StoredProcedure }; query.Parameters.AddWithValue("@id", id); SqlDataReader reader = query.ExecuteReader(); while (reader.Read()) { alumnoGrado = new AlumnoGrado { ID = Convert.ToInt32(reader["id"]), AlumnoID = Convert.ToInt32(reader["alumnoID"]), GradoID = Convert.ToInt32(reader["gradoID"]), Seccion = Convert.ToString(reader["seccion"]) }; } } catch (Exception e) { Console.WriteLine(e.Message); } } return(alumnoGrado); }
public ActionResult DeleteConfirmed(int id) { AlumnoGrado alumnoGrado = db.AlumnosGrados.Find(id); db.AlumnosGrados.Remove(alumnoGrado); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "AlumnoGradoId,Seccion,AlumnoId,GradoId")] AlumnoGrado alumnoGrado) { if (ModelState.IsValid) { db.Entry(alumnoGrado).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } loadEditAlumnosyGrados(alumnoGrado.AlumnoId, alumnoGrado.GradoId); return(View(alumnoGrado)); }
public ActionResult Edit([Bind(Include = "Id,AlumnoId,GradoId,Seccion")] AlumnoGrado alumnoGrado) { if (ModelState.IsValid) { db.Entry(alumnoGrado).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AlumnoId = new SelectList(db.Alumnos, "Id", "NombreCompleto", alumnoGrado.AlumnoId); ViewBag.GradoId = new SelectList(db.GradosAlumnos, "Id", "Nombre", alumnoGrado.GradoId); return(View(alumnoGrado)); }
public ActionResult Create([Bind(Include = "AlumnoGradoId,Seccion,AlumnoId,GradoId")] AlumnoGrado alumnoGrado) { if (ModelState.IsValid) { db.AlumnosGrados.Add(alumnoGrado); db.SaveChanges(); return(RedirectToAction("Index")); } loadEditAlumnosyGrados(alumnoGrado.AlumnoId, alumnoGrado.GradoId); return(View(alumnoGrado)); }
// GET: AlumnosGrado/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AlumnoGrado alumnoGrado = db.AlumnosGrado.Find(id); if (alumnoGrado == null) { return(HttpNotFound()); } return(View(alumnoGrado)); }
// GET: Asignaciones/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AlumnoGrado alumnoGrado = db.AlumnosGrados.Find(id); if (alumnoGrado == null) { return(HttpNotFound()); } loadEditAlumnosyGrados(alumnoGrado.AlumnoId, alumnoGrado.GradoId); return(View(alumnoGrado)); }
// POST: api/alumnogrado public JObject Post([FromBody] AlumnoGrado alumnoGrado) { JObject response = new JObject { { "error", false }, { "msg", "AlumnoGrado created successfully." } }; if (!AlumnoGradoRepository.Create(alumnoGrado)) { response["error"] = true; response["msg"] = "AlumnoGrado not created."; } return(response); }
// GET: AlumnosGrado/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AlumnoGrado alumnoGrado = db.AlumnosGrado.Find(id); if (alumnoGrado == null) { return(HttpNotFound()); } ViewBag.AlumnoId = new SelectList(db.Alumnos, "Id", "NombreCompleto", alumnoGrado.AlumnoId); ViewBag.GradoId = new SelectList(db.GradosAlumnos, "Id", "Nombre", alumnoGrado.GradoId); return(View(alumnoGrado)); }
// PUT: api/alumnogrado/5 public JObject Put(int id, [FromBody] AlumnoGrado alumnoGrado) { alumnoGrado.ID = id; JObject response = new JObject { { "error", false }, { "msg", "AlumnoGrado updated successfully." } }; if (!AlumnoGradoRepository.Update(alumnoGrado)) { response["error"] = true; response["msg"] = "AlumnoGrado not updated."; } return(response); }