public List <ViewRequestModel> GetViewRequests()
{
List <ViewRequestModel> viewRequests = new List <ViewRequestModel>();
using (SqlConnection conn = new SqlConnection(_connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand("dbo.GetViewRequests", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ViewRequestModel viewRequest = new ViewRequestModel();
viewRequest.Id = reader["Id"] != DBNull.Value ? Convert.ToInt32(reader["Id"]) : 0;
viewRequest.Name = reader["Name"] != DBNull.Value ? Convert.ToString(reader["Name"]) : string.Empty;
viewRequests.Add(viewRequest);
}
}
return(viewRequests);
}
public ViewRequestModel getRequestData(string RequestID)
{
int reqid = Convert.ToInt32(RequestID);
Request viewRequest = new Request();
viewRequest = db.Requests.Find(reqid);
List <Room> prefRoom = (from f in db.PreferenceRooms
join r in db.Rooms on f.RoomID equals r.RoomID
where f.RequestID == reqid
select r).ToList();
List <Facility> prefFac = (from f in db.RequiredFacilities
join fa in db.Facilities on f.FacilityID equals fa.FacilityID
where f.FacilityID == reqid
select fa).ToList();
ViewRequestModel model = new ViewRequestModel();
foreach (var item in prefRoom)
{
model.prefRooms += item.Name + ", ";
}
foreach (var item in prefFac)
{
model.prefFacs = item.Name + ", ";
}
model.specialRequirements = viewRequest.SpecialRequirements;
model.priority = viewRequest.Priority;
model.period = (viewRequest.Period).ToString();
model.length = (viewRequest.Length).ToString();
model.status = viewRequest.Status;
return(model);
}
public ViewRequestModel getRequestData()
{
ViewRequestModel model = new ViewRequestModel();
return(model);
}
//
// 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);
}
