public ActionResult Edit(SEdefaulters sEdefaulters) { try { if (ModelState.IsValid) { db.Entry(sEdefaulters).State = EntityState.Modified; db.SaveChanges(); var extra = new List <extratotal>(); int semt = Convert.ToInt32(Session["sem"]); int stdrollnot = Convert.ToInt32(sEdefaulters.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(sEdefaulters)); } catch { return(View()); } }
public ActionResult DeleteConfirmed(int id) { SEdefaulters sEdefaulters = db.SEdefaulters.Find(id); db.SEdefaulters.Remove(sEdefaulters); 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")] SEdefaulters sEdefaulters) { if (ModelState.IsValid) { db.SEdefaulters.Add(sEdefaulters); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(sEdefaulters)); }
// GET: SEdefaulters/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } SEdefaulters sEdefaulters = db.SEdefaulters.Find(id); if (sEdefaulters == null) { return(HttpNotFound()); } return(View(sEdefaulters)); }