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