public ActionResult Index()
{
string department = Session["department"] as string;
IEnumerable<SelectListItem> selectList = from s in db.Modules
where s.DepartmentCode == department
select new SelectListItem
{
Text = s.ModuleCode + " - " + s.Title,
Value = s.ModuleCode
};
AddRequestModel model = new AddRequestModel();
ViewBag.modules = new SelectList(selectList, "Value", "Text");
return View();
}
public ActionResult Index()
{
AddRequestModel model = new AddRequestModel();
string department = User.Identity.Name;
IEnumerable<SelectListItem> selectList = from s in db.Modules
where s.DepartmentCode == department
select new SelectListItem
{
Text = s.ModuleCode + " - " + s.Title,
Value = s.ModuleCode
};
ViewBag.modules = new SelectList(selectList, "Value", "Text");
IEnumerable<SelectListItem> selectActiveRoundList = from r in db.Rounds join s in db.Semesters on r.SemesterID equals s.SemesterID
where r.EndDate == null
select new SelectListItem {
Text = (s.StartYear).ToString() + " - " + (s.StartYear+1).ToString() +
" Semester " + (s.SemesterNo).ToString() ,
Value = (r.RoundID).ToString()
};
ViewBag.activeSemesters = new SelectList(selectActiveRoundList, "Value", "Text");
IEnumerable<SelectListItem> daysList = new List<SelectListItem>()
{
new SelectListItem() {Text="Monday", Value="1"},
new SelectListItem() {Text="Tuesday", Value="2"},
new SelectListItem() {Text="Wednesday", Value="3"},
new SelectListItem() {Text="Thursday", Value="4"},
new SelectListItem() {Text="Friday", Value="5"},
};
ViewBag.days = new SelectList(daysList, "Value", "Text");
IEnumerable<SelectListItem> Periods = new List<SelectListItem>()
{
new SelectListItem() {Text="Period 1 - 9:00", Value="1"},
new SelectListItem() {Text="Period 2 - 10:00", Value="2"},
new SelectListItem() {Text="Period 3 - 11:00", Value="3"},
new SelectListItem() {Text="Period 4 - 12:00", Value="4"},
new SelectListItem() {Text="Period 5 - 13:00", Value="5"},
new SelectListItem() {Text="Period 6 - 14:00", Value="6"},
new SelectListItem() {Text="Period 7 - 15:00", Value="7"},
new SelectListItem() {Text="Period 8 - 16:00", Value="8"},
new SelectListItem() {Text="Period 9 - 17:00", Value="9"}
};
ViewBag.periods = new SelectList(Periods, "Value", "Text");
IEnumerable<SelectListItem> roomsList = new List<SelectListItem>()
{
new SelectListItem() {Text="1", Value="1"},
new SelectListItem() {Text="2", Value="2"},
new SelectListItem() {Text="3", Value="3"},
new SelectListItem() {Text="4", Value="4"},
new SelectListItem() {Text="5", Value="5"},
};
ViewBag.noOfRooms = new SelectList(roomsList, "Value", "Text");
IEnumerable<SelectListItem> parkCodesList = new List<SelectListItem>()
{
new SelectListItem() {Text="W - West", Value="W"},
new SelectListItem() {Text="C - Central", Value="C"},
new SelectListItem() {Text="E - East", Value="E"},
};
ViewBag.parkCodes = new SelectList(parkCodesList, "Value", "Text");
model.facilities = (from f in db.Facilities select f).ToList();
ViewBag.noOfFacs = (from f in db.Facilities select f.FacilityID).Count();
return View(model);
}
public ActionResult Index(AddRequestModel model, HttpPostedFileBase LogoFile)
{
string department = User.Identity.Name;
IEnumerable<SelectListItem> selectList = from s in db.Modules
where s.DepartmentCode == department
select new SelectListItem
{
Text = s.ModuleCode + " - " + s.Title,
Value = s.ModuleCode
};
ViewBag.modules = new SelectList(selectList, "Value", "Text");
IEnumerable<SelectListItem> selectActiveRoundList = from r in db.Rounds
join s in db.Semesters on r.SemesterID equals s.SemesterID
where r.EndDate == null
select new SelectListItem
{
Text = (s.StartYear).ToString() + " - " + (s.StartYear + 1).ToString() +
" Semester " + (s.SemesterNo).ToString(),
Value = (r.RoundID).ToString()
};
ViewBag.activeSemesters = new SelectList(selectActiveRoundList, "Value", "Text");
IEnumerable<SelectListItem> daysList = new List<SelectListItem>()
{
new SelectListItem() {Text="Monday", Value="1"},
new SelectListItem() {Text="Tuesday", Value="2"},
new SelectListItem() {Text="Wednesday", Value="3"},
new SelectListItem() {Text="Thursday", Value="4"},
new SelectListItem() {Text="Friday", Value="5"},
};
ViewBag.days = new SelectList(daysList, "Value", "Text");
IEnumerable<SelectListItem> Periods = new List<SelectListItem>()
{
new SelectListItem() {Text="Period 1 - 9:00", Value="1"},
new SelectListItem() {Text="Period 2 - 10:00", Value="2"},
new SelectListItem() {Text="Period 3 - 11:00", Value="3"},
new SelectListItem() {Text="Period 4 - 12:00", Value="4"},
new SelectListItem() {Text="Period 5 - 13:00", Value="5"},
new SelectListItem() {Text="Period 6 - 14:00", Value="6"},
new SelectListItem() {Text="Period 7 - 15:00", Value="7"},
new SelectListItem() {Text="Period 8 - 16:00", Value="8"},
new SelectListItem() {Text="Period 9 - 17:00", Value="9"}
};
ViewBag.periods = new SelectList(Periods, "Value", "Text");
IEnumerable<SelectListItem> roomsList = new List<SelectListItem>()
{
new SelectListItem() {Text="1", Value="1"},
new SelectListItem() {Text="2", Value="2"},
new SelectListItem() {Text="3", Value="3"},
new SelectListItem() {Text="4", Value="4"},
new SelectListItem() {Text="5", Value="5"},
};
ViewBag.noOfRooms = new SelectList(roomsList, "Value", "Text");
IEnumerable<SelectListItem> parkCodesList = new List<SelectListItem>()
{
new SelectListItem() {Text="W - West", Value="W"},
new SelectListItem() {Text="C - Central", Value="C"},
new SelectListItem() {Text="E - East", Value="E"},
};
ViewBag.parkCodes = new SelectList(parkCodesList, "Value", "Text");
ViewBag.noOfFacs = (from f in db.Facilities select f.FacilityID).Count();
model.facilities = (from f in db.Facilities select f).ToList();
if (ModelState.IsValid)
if(model.requestsIndex != null){
{
int prefrooms = Convert.ToInt32(Request["roomSelect"]);
Request requests = new Request();
model.requestsIndex.RoundID = Convert.ToInt32(Request["roundSelect"]);
model.requestsIndex.ModuleCode = Request["moduleSelect"];
model.requestsIndex.Day = Convert.ToByte(Request["daySelect"]);
model.requestsIndex.Period = Convert.ToByte(Request["periodSelect"]);
model.requestsIndex.Length = Convert.ToByte(Request["lengthData"]);
model.requestsIndex.NoOfRooms = Convert.ToByte(Request["roomSelect"]);
model.requestsIndex.NoOfStudents = Convert.ToInt32(Request["noOfStudents"]);
model.requestsIndex.RoomType = Request["roomType"];
model.requestsIndex.SeatingType = Request["seatingType"];
model.requestsIndex.ParkCode = Request["parkSelect"];
model.requestsIndex.Status = "P";
if (Request["priorityCheck"] == "1")
{
model.requestsIndex.Priority = 1;
}
else { model.requestsIndex.Priority = 0; }
requests = model.requestsIndex;
db.Entry(requests).State = EntityState.Added;
db.SaveChanges();
for (int i = 1; i < 16; i++)
{
if (Request["week-" + i] == "1" )
{
RequestWeek requestweeks = new RequestWeek();
requestweeks.RequestID = requests.RequestID;
requestweeks.Week = i;
db.Entry(requestweeks).State = EntityState.Added;
db.SaveChanges();
}
}
for (int i = 1; i <= prefrooms; i++)
{
PreferenceRoom preferenceRooms = new PreferenceRoom();
preferenceRooms.RequestID = requests.RequestID;
preferenceRooms.RoomID = Convert.ToInt32(Request["roomPref-" + i]);
db.Entry(preferenceRooms).State = EntityState.Added;
db.SaveChanges();
}
for (int i = 1; i <= ViewBag.noOfFacs; i++) {
RequiredFacility requiredFacilities = new RequiredFacility();
requiredFacilities.RequestID = requests.RequestID;
string fac = Request["fac-"+i];
if ( fac == "1") {
requiredFacilities.FacilityID = i;
db.Entry(requiredFacilities).State = EntityState.Added;
db.SaveChanges();
}
}
return RedirectToAction("Index", "ViewRequest");
}
}
return View("Index");
}
