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