public ActionResult Edit(TEdefaulters xyz) { try { if (ModelState.IsValid) { db.Entry(xyz).State = EntityState.Modified; db.SaveChanges(); var extra = new List <extratotal>(); int semt = Convert.ToInt32(Session["sem"]); int stdrollnot = Convert.ToInt32(xyz.stdrollno); using (var adv = new AttendanceContext()) { var sem = new SqlParameter("@sem", SqlDbType.Int) { Direction = System.Data.ParameterDirection.Input, Value = semt }; var stdrollno = new SqlParameter("@stdrollno", SqlDbType.Int) { Direction = System.Data.ParameterDirection.Input, Value = stdrollnot }; extra = adv.Database.SqlQuery <extratotal>("exec extraattendance @stdrollno, @sem ", stdrollno, sem).ToList(); } return(RedirectToAction("Index")); } return(View(xyz)); } catch { return(View()); } }
public ActionResult DeleteConfirmed(int id) { TEdefaulters tEdefaulters = db.TEdefaulters.Find(id); db.TEdefaulters.Remove(tEdefaulters); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "id,stdrollno,stdname,total_theory,theory_percentage,total_practical,practical_percentage,extra_attendance,total_attendance,attendance_percentage")] TEdefaulters tEdefaulters) { if (ModelState.IsValid) { db.TEdefaulters.Add(tEdefaulters); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tEdefaulters)); }
// GET: TEdefaulters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TEdefaulters tEdefaulters = db.TEdefaulters.Find(id); if (tEdefaulters == null) { return(HttpNotFound()); } return(View(tEdefaulters)); }