public ActionResult DeleteConfirmed(int id) { Roomadd roomadd = db.Roomadds.Find(id); db.Roomadds.Remove(roomadd); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "ID,RoomNo,Roomtype,Price,Status,StudentID,StudentID2")] Roomadd roomadd) { if (ModelState.IsValid) { db.Roomadds.Add(roomadd); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(roomadd)); }
// GET: Roomadds/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Roomadd roomadd = db.Roomadds.Find(id); if (roomadd == null) { return(HttpNotFound()); } return(View(roomadd)); }
public ActionResult Edit([Bind(Include = "ID,RoomNo,Roomtype,Price,Status,StudentID,StudentID2")] Roomadd roomadd) { //Roomadd roomadds = db.Roomadds.Find(); if (ModelState.IsValid) { db.Entry(roomadd).State = EntityState.Modified; db.SaveChanges(); var update = db.Students.Where(o => (o.StudentID == roomadd.StudentID)).FirstOrDefault(); if (update != null) { update.RoomNo = roomadd.RoomNo; db.SaveChanges(); } var update2 = db.Students.Where(o => (o.StudentID == roomadd.StudentID2)).FirstOrDefault(); if (update2 != null) { update2.RoomNo = roomadd.RoomNo; db.SaveChanges(); } var obj = db.Roomadds.Where(x => x.StudentID != null && x.StudentID2 != null && x.RoomNo == roomadd.RoomNo).FirstOrDefault();; if (obj != null) { obj.Status = roomadd.Status = "Busy"; db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(roomadd)); }