public ActionResult Create(Room room)
        {
            if (ModelState.IsValid)
            {

                db.Rooms.InsertOnSubmit(room);
                db.SubmitChanges();
                return RedirectToAction("Index");
            }

            return View(room);
        }
        public ActionResult Edit(Room room)
        {
            if (ModelState.IsValid)
            {
                var projectRoom = from r in db.Rooms where r.ID == room.ID select r;
                foreach (var rooms in projectRoom)
                {
                    rooms.Name = room.Name;
                    rooms.info = room.info;
                    rooms.Capacity = room.Capacity;

                }

                db.SubmitChanges();
                return RedirectToAction("Index");
            }
            return View(room);
        }
 partial void UpdateRoom(Room instance);
 partial void DeleteRoom(Room instance);
 partial void InsertRoom(Room instance);