public IActionResult AssignedRoomList()
{
int serialno = 1;
var studentinfo = dbc.Student.ToList();
var roominfo = dbc.AssignedRoom.ToList();
var query = from student in studentinfo
join room in roominfo on student.StudentHallID equals room.StudentHallID
select new
{
roomid = room.RoomID,
roomname = room.RoomName,
studenthallid = student.StudentHallID,
studentname = student.StudentName,
department = student.Department,
date = room.Date
};
var detailslist = new List <AssignedRoomViewModel>();
foreach (var item in query)
{
AssignedRoomViewModel assignedroominfo = new AssignedRoomViewModel();
assignedroominfo.serialnoVM = serialno;
serialno++;
assignedroominfo.roomidVM = item.roomid;
assignedroominfo.roomnameVM = item.roomname;
assignedroominfo.studenthallidVM = item.studenthallid;
assignedroominfo.studentnameVM = item.studentname;
assignedroominfo.departmentVM = item.department;
assignedroominfo.adVM = item.date.ToShortDateString();
detailslist.Add(assignedroominfo);
}
return(View(detailslist));
}
public IActionResult MyRoomInfo()
{
var student = HttpContext.Session.GetString("UserID");
var id = Convert.ToInt32(student);
var c = dbc.AssignedRoom.Where(q => q.StudentHallID == id).FirstOrDefault();
AssignedRoomViewModel assignedinfo = new AssignedRoomViewModel();
assignedinfo.studenthallidVM = c.StudentHallID;
assignedinfo.studentnameVM = c.StudentName;
assignedinfo.roomnameVM = c.RoomName;
assignedinfo.adVM = c.Date.ToShortDateString();
return(View(assignedinfo));
}
public IActionResult RoomAssignForm(AssignedRoomViewModel assignforminfo)
{
var check1 = dbc.AvailableRoom.Where(q => q.Available > 0).ToList();
check1.Insert(0, new AvailableRoom {
RoomID = 0, RoomName = "Choose Room"
});
ViewBag.chooseroom = check1;
if (assignforminfo.roomidVM == 0)
{
ViewBag.message3 = "Please choose a room!";
return(View());
}
var matchstudent = dbc.Student.Where(q => q.StudentHallID == assignforminfo.studenthallidVM).FirstOrDefault();
if (matchstudent == null)
{
ViewBag.message1 = "Invalid ID";
return(View());
}
var checkifassigned = dbc.AssignedRoom.Where(q => q.StudentHallID == assignforminfo.studenthallidVM).FirstOrDefault();
if (checkifassigned != null)
{
ViewBag.message2 = "Already Assigned!";
return(View());
}
var getroomname = dbc.AvailableRoom.Where(q => q.RoomID == assignforminfo.roomidVM).FirstOrDefault();
AssignedRoom assign = new AssignedRoom();
assign.StudentHallID = assignforminfo.studenthallidVM;
assign.StudentName = matchstudent.StudentName;
assign.RoomID = assignforminfo.roomidVM;
assign.RoomName = getroomname.RoomName;
assign.Department = matchstudent.Department;
assign.Date = DateTime.Now;
dbc.AssignedRoom.Add(assign);
dbc.SaveChanges();
ModelState.Clear();
var getroomname2 = dbc.AvailableRoom.Where(q => q.RoomID == assign.RoomID).FirstOrDefault();
getroomname2.Available = getroomname2.Available - 1;
dbc.AvailableRoom.Update(getroomname2);
dbc.SaveChanges();
return(View());
}
