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");
}
//
// GET: /ViewRequest/
public ViewRequestModel getRequests(Request request)
{
string department = User.Identity.Name;
ViewRequestModel model = new ViewRequestModel();
model.moduleCode = request.ModuleCode;
model.numberOfRooms = request.NoOfRooms;
model.priority = request.Priority;
model.requestID = request.RequestID;
model.moduleTitle = db.Modules.Where(m => m.ModuleCode == request.ModuleCode).First().Title;
string requestStatus = request.Status;
string status = "";
switch(requestStatus){
case "P":
status = "Pending";
break;
case "A":
status = "Approved";
break;
case "R":
status = "Pending";
break;
default:
status = "";
break;
}
model.status = status;
model.statusCode = requestStatus;
string weekDay = "";
int days = int.Parse(request.Day.ToString());
switch (days)
{
case 1:
weekDay = "Mon";
break;
case 2:
weekDay = "Tues";
break;
case 3:
weekDay = "Wed";
break;
case 4:
weekDay = "Thur";
break;
case 5:
weekDay = "Fri";
break;
case 6:
weekDay = "Sat";
break;
case 7:
weekDay = "Sun";
break;
default:
weekDay = "Unknown";
break;
}
model.days = weekDay;
model.daysint = days;
string startTime = "";
int startint = int.Parse(request.Period.ToString());
switch (startint)
{
case 1:
startTime = "9:00";
break;
case 2:
startTime = "10:00";
break;
case 3:
startTime = "11:00";
break;
case 4:
startTime = "12:00";
break;
case 5:
startTime = "13:00";
break;
case 6:
startTime = "14:00";
break;
case 7:
startTime = "15:00";
break;
case 8:
startTime = "16:00";
break;
case 9:
startTime = "17:00";
break;
default:
startTime = "Unknown";
break;
}
model.startTime = startTime;
model.startint = startint;
string endTime = "";
int time = Convert.ToInt32(request.Period);
int length = Convert.ToInt32(request.Length);
int timelength = time + length;
switch (timelength)
{
case 2:
endTime = "9:50";
break;
case 3:
endTime = "10:50";
break;
case 4:
endTime = "11:50";
break;
case 5:
endTime = "12:50";
break;
case 6:
endTime = "13:50";
break;
case 7:
endTime = "14:50";
break;
case 8:
endTime = "15:50";
break;
case 9:
endTime = "16:50";
break;
case 10:
endTime = "17:50";
break;
default:
endTime = "Unknown";
break;
}
model.endTime = endTime;
model.endint = timelength;
string weeks = "";
List<RequestWeek> reqweeks = new List<RequestWeek>();
reqweeks = (from w in db.RequestWeeks where w.RequestID == request.RequestID select w).ToList();
foreach (RequestWeek r in reqweeks) {
weeks += r.Week.ToString() + ", ";
}
model.weeks = weeks;
return model;
}