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