public IEnumerable <TablaPrueba> ListarPorCodigo(int codigo) { List <TablaPrueba> oLista = new List <TablaPrueba>(); using (SqlConnection con = new SqlConnection(cadenaConexion)) { SqlCommand cmd = new SqlCommand("sp_ListarTablaPrueba", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("x_codprueba", SqlDbType.Int); cmd.Parameters["x_codprueba"].Value = codigo; SqlDataReader reader; con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { TablaPrueba oTablaPrueba = new TablaPrueba() { Codigo = reader.GetInt32(reader.GetOrdinal("x_codpru")), Descripcion = reader.GetString(reader.GetOrdinal("x_despru")), Estado = reader.GetBoolean(reader.GetOrdinal("x_estpru")) }; oLista.Add(oTablaPrueba); } con.Close(); } return(oLista); }
public ActionResult DeleteConfirmed(int id) { TablaPrueba tablaPrueba = db.Movies.Find(id); db.Movies.Remove(tablaPrueba); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,Correlative,goodAnswer,wrongAnswer,blankAnswer,Course,Level")] TablaPrueba tablaPrueba) { if (ModelState.IsValid) { db.Entry(tablaPrueba).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tablaPrueba)); }
// GET: TablaPruebas/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TablaPrueba tablaPrueba = db.Movies.Find(id); if (tablaPrueba == null) { return(HttpNotFound()); } return(View(tablaPrueba)); }
public ActionResult Create([Bind(Include = "ID,Correlative,goodAnswer,wrongAnswer,blankAnswer")] TablaPrueba tablaPrueba) { if (Session["courseList"] == null || Session["levelList"] == null) { return(RedirectToAction("", "Home")); } tablaPrueba.Course = int.Parse(Session["courseList"].ToString()); tablaPrueba.Level = int.Parse(Session["levelList"].ToString()); //Warning(string.Format("<b>{0}</b> already exists in the database. select * from TablaPruebas where Correlative like '{1}'", db.Database.SqlQuery<TablaPrueba>("select * from TablaPruebas where Correlative like '{0}'", tablaPrueba.Correlative).ToList<TablaPrueba>().Count, tablaPrueba.Correlative), true); //if (db.Database.SqlQuery<TablaPrueba>("select * from TablaPruebas where Correlative like '{0}'", tablaPrueba.Correlative).ToList<TablaPrueba>().Count >0) //{ //} foreach (TablaPrueba item in db.Movies.ToList <TablaPrueba>()) { if (item.Correlative.Contains(tablaPrueba.Correlative)) { Warning(string.Format("<b>{0}</b> already exists in the database.", tablaPrueba.Correlative), true); return(View(tablaPrueba)); } } if (ModelState.IsValid)// && (tablaPrueba.blankAnswer+tablaPrueba.goodAnswer + tablaPrueba.wrongAnswer)==10) { if ((tablaPrueba.blankAnswer + tablaPrueba.goodAnswer + tablaPrueba.wrongAnswer) != int.Parse(Session["ans"].ToString())) { ViewBag.c = Session["courseList"].ToString(); ViewBag.l = Session["levelList"].ToString(); ViewBag.m = Session["materia"].ToString(); Danger("La cantidad de respuestas <b>no es valida</b>", true); return(View(tablaPrueba)); } db.Movies.Add(tablaPrueba); db.SaveChanges(); Success(string.Format("<b>{0}</b> was successfully added to the database.", tablaPrueba.Correlative), true); //return RedirectToAction("Index"); return(RedirectToAction("Create")); } Danger("Looks like something went wrong. Please check your form."); return(View(tablaPrueba)); }