public ActionResult Edit(RoomLookupModel model)
{
Room rooms = new Room();
rooms = model.roomsEdit;
if (ModelState.IsValid)
{
if (rooms != null)
{
try
{
//db.Rooms.Attach(rooms);
db.Entry(rooms).State = EntityState.Modified;
//db.SaveChanges();
db.SaveChanges();
return RedirectToAction("Index");
}
catch (DbEntityValidationException dbEx)
{
return RedirectToAction("Edit");
}
}
}
return View(rooms);
}
public ActionResult Edit(int id = 0)
{
RoomLookupModel model = new RoomLookupModel();
model.roomsEdit = db.Rooms.Find(id);
model.facilityEdit = (from f in db.Facilities select f).ToList();
// model.facilityIsChecked = true;
List<int> roomFac = (from i in db.RoomFacilities where i.RoomID == id select i.FacilityID).ToList();
ViewBag.roomFac = roomFac;
// model.facilityIsChecked = roomFac.Contains(ViewBag.roomfacs);
IEnumerable<SelectListItem> selectList = from b in db.Buildings
select new SelectListItem
{
Value = b.BuildingCode,
Text = b.BuildingCode + " - " + b.Name
};
ViewBag.EditDepartments = new SelectList(selectList, "Value", "Text");
Room rooms = db.Rooms.Find(id);
if (rooms == null)
{
return HttpNotFound();
}
return View(model);
}
//---------------------------------------------------------------------------------CREATE---------------
//
// GET: /Movies/Create
public ActionResult Create()
{
RoomLookupModel model = new RoomLookupModel();
Room rooms = new Room();
model.roomsCreate = rooms;
IEnumerable<SelectListItem> selectList = from b in db.Buildings
select new SelectListItem
{
Value = b.BuildingCode,
Text = b.BuildingCode + " - " + b.Name
};
ViewBag.EditDepartments = new SelectList(selectList, "Value", "Text");
//copied from edit page for checkboxes
model.facilityEdit = (from f in db.Facilities select f).ToList();
List<int> roomFac = (from i in db.RoomFacilities where i.RoomID == 0 select i.FacilityID).ToList();
//copied from edit page for checkboxes
return View(model);
}
public ActionResult Create(RoomLookupModel model)
{
IEnumerable<SelectListItem> selectList = from b in db.Buildings
select new SelectListItem
{
Value = b.BuildingCode,
Text = b.BuildingCode + " - " + b.Name
};
ViewBag.EditDepartments = new SelectList(selectList, "Value", "Text");
model.facilityEdit = (from f in db.Facilities select f).ToList();
List<int> roomFac = (from i in db.RoomFacilities where i.RoomID == 0 select i.FacilityID).ToList();
Room rooms = new Room();
rooms = model.roomsCreate;
if (ModelState.IsValid)
{
db.Entry(rooms).State = EntityState.Added;
db.SaveChanges();
List<int> fac = (from f in db.Facilities select f.FacilityID).ToList();
int facsNo = fac.Last();
for (int i = 1; i <= facsNo; i++)
{
if (Request["fac-" + i] == "1")
{
RoomFacility newRF = new RoomFacility();
newRF.RoomID = rooms.RoomID;
newRF.FacilityID = i;
db.Entry(newRF).State = EntityState.Added;
db.SaveChanges();
}
}
return RedirectToAction("Index");
}
TempData["notice"] = "Password is incorrect. Please try again.";
return View(model);
}
//-------------------------------------------------------------------------------------VIEW ROOM---------
public ActionResult ViewRoom(int id)
{
Room rooms = db.Rooms.Find(id);
RoomLookupModel model = new RoomLookupModel();
model.roomsDelete = rooms;
model.roomfacView = (from f in db.RoomFacilities
join r in db.Facilities on f.FacilityID equals r.FacilityID
where f.RoomID == id
select r).ToList();
return View(model);
}
//-------------------------------------------------------------------------------------VIEW BUILDINGS----
public ActionResult ViewBuildings()
{
RoomLookupModel model = new RoomLookupModel();
model.buildingsIndex = (from r in db.Buildings select r);
return View(model);
}
public ActionResult Index(String sortOrder, string searchString)
{
//RoomLookupModel model = new RoomLookupModel();
//model.building = new Building();
//return View(model);
//------------------
RoomLookupModel model = new RoomLookupModel();
model.roomsIndex = (from s in db.Rooms select s).ToList();
ViewBag.NameSortParm = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewBag.BCodeSortParm = sortOrder == "bcode" ? "bcode_desc" : "bcode";
ViewBag.RTypeSortParm = sortOrder == "rtype" ? "rtype_desc" : "rtype";
ViewBag.STypeSortParm = sortOrder == "stype" ? "stype_desc" : "stype";
if (!String.IsNullOrEmpty(searchString))
{
model.roomsIndex = model.roomsIndex.Where(o => o.Name.ToUpper().Contains(searchString.ToUpper())
|| o.BuildingCode.ToUpper().Contains(searchString.ToUpper())
);
}
switch (sortOrder)
{
case "name_desc":
model.roomsIndex = model.roomsIndex.OrderByDescending(o => o.Name);
break;
case "bcode":
model.roomsIndex = model.roomsIndex.OrderBy(o => o.BuildingCode);
break;
case "bcode_desc":
model.roomsIndex = model.roomsIndex.OrderByDescending(o => o.BuildingCode);
break;
case "rtype":
model.roomsIndex = model.roomsIndex.OrderBy(o => o.RoomType);
break;
case "rtype_desc":
model.roomsIndex = model.roomsIndex.OrderByDescending(o => o.RoomType);
break;
case "stype":
model.roomsIndex = model.roomsIndex.OrderBy(o => o.SeatingType);
break;
case "stype_desc":
model.roomsIndex = model.roomsIndex.OrderByDescending(o => o.SeatingType);
break;
default:
model.roomsIndex = model.roomsIndex.OrderBy(o => o.Name);
break;
}
return View(model);
}
public ActionResult Edit(RoomLookupModel model)
{
Room rooms = new Room();
rooms = model.roomsEdit;
// List<int> roomFac = (from i in db.RoomFacilities where i.RoomID == rooms.RoomID select i.FacilityID).ToList();
// model.checkedFacs = roomFac;
IEnumerable<SelectListItem> selectList = from b in db.Buildings
select new SelectListItem
{
Value = b.BuildingCode,
Text = b.BuildingCode + " - " + b.Name
};
ViewBag.EditDepartments = new SelectList(selectList, "Value", "Text");
if (ModelState.IsValid)
{
if (rooms != null)
{
db.Entry(rooms).State = EntityState.Modified;
db.SaveChanges();
}
List<RoomFacility> rFac = new List<RoomFacility>();
rFac = (from r in db.RoomFacilities where r.RoomID == rooms.RoomID select r).ToList();
foreach (RoomFacility r in rFac)
{
db.Entry(r).State = EntityState.Deleted;
db.SaveChanges();
}
List<int> fac = (from f in db.Facilities select f.FacilityID).ToList();
int facsNo = fac.Last();
for (int i = 1; i <= facsNo; i++)
{
if (Request["fac-" + i] == "1")
{
RoomFacility newRF = new RoomFacility();
newRF.RoomID = rooms.RoomID;
newRF.FacilityID = i;
db.Entry(newRF).State = EntityState.Added;
db.SaveChanges();
}
}
return RedirectToAction("Index");
}
return View(rooms);
}
public ActionResult Delete(RoomLookupModel model)
{
Room room = new Room();
room = model.roomsDelete;
if (ModelState.IsValid)
{
db.Entry(model.roomsDelete).State = EntityState.Deleted;
db.SaveChanges();
return RedirectToAction("Index");
}
return View("Delete");
}
public ActionResult CreateBuilding(RoomLookupModel model)
{
Building buildings = new Building();
buildings = model.buildingCreate;
List<string> buildingCodes = (from b in db.Buildings select b.BuildingCode).ToList();
if (buildingCodes.Contains((buildings.BuildingCode).ToUpper()))
{
TempData["notice"] = "This building code already exists. Please choose another.";
return RedirectToAction("CreateBuilding", "RoomLookup");
}
if (ModelState.IsValid)
{
db.Entry(buildings).State = EntityState.Added;
db.SaveChanges();
return RedirectToAction("Index");
}
//Room room = new Room();
//room = model.roomsCreated;
//if (ModelState.IsValid)
//{
// db.Entry(model.roomsCreate).State = EntityState.Added;
// db.SaveChanges();
// return RedirectToAction("Index");
//}
return View("Index");
}
public ActionResult Index()
{
RoomLookupModel model = new RoomLookupModel();
model.roomsIndex = (from s in db.Rooms select s).ToList();
model.building = new Building();
return View(model);
}