public ActionResult DeleteConfirmed(int id)
{
CarreraProfesional carreraProfesional = db.CarreraProfesionals.Find(id);
db.CarreraProfesionals.Remove(carreraProfesional);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "CarreraProfesionalID,NombreCarrera,DescripcionCarrera")] CarreraProfesional carreraProfesional)
{
if (ModelState.IsValid)
{
db.Entry(carreraProfesional).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carreraProfesional));
}
public ActionResult Create([Bind(Include = "CarreraProfesionalID,NombreCarrera,DescripcionCarrera")] CarreraProfesional carreraProfesional)
{
if (ModelState.IsValid)
{
db.CarreraProfesionals.Add(carreraProfesional);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(carreraProfesional));
}
// GET: CarreraProfesionals/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
CarreraProfesional carreraProfesional = db.CarreraProfesionals.Find(id);
if (carreraProfesional == null)
{
return(HttpNotFound());
}
return(View(carreraProfesional));
}
public static List <CarreraProfesional> SeleccionarTodos()
{
SqlConnection conexion = new SqlConnection(Conexion.Cadena);
List <CarreraProfesional> listaCarreras = new List <CarreraProfesional>();
try
{
conexion.Open();
string sql = "Carrera_Profesional_PA_SeleccionarTodos";
SqlCommand comando = new SqlCommand(sql, conexion);
comando.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = comando.ExecuteReader();
while (reader.Read())
{
CarreraProfesional c = new CarreraProfesional();
c.Grado = reader["Grado"].ToString();
c.ID = Convert.ToInt32(reader["ID"]);
c.Puntos = Convert.ToInt32(reader["Puntos"]);
listaCarreras.Add(c);
}
return(listaCarreras);
}
catch (Exception)
{
throw;
}
finally
{
conexion.Close();
}
}
public static CarreraProfesional SeleccionarPorID(string carreraID)
{
SqlConnection conexion = new SqlConnection(Conexion.Cadena);
try
{
conexion.Open();
string sql = "Carrera_Profesional_PA_SeleccionarPorID";
SqlCommand comando = new SqlCommand(sql, conexion);
comando.Parameters.AddWithValue("@ID", carreraID);
comando.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader reader = comando.ExecuteReader();
if (reader.Read())
{
CarreraProfesional c = new CarreraProfesional();
c.Grado = reader["Grado"].ToString();
c.ID = Convert.ToInt32(reader["ID"]);
c.Puntos = Convert.ToInt32(reader["Puntos"]);
return(c);
}
}
catch (Exception)
{
throw;
}
finally
{
conexion.Close();
}
return(null);
}
