public JsonResult GetMeetingReq2(int?id)
        {
            mrReqFactory = new MeetingRoomReqFactorys();
            List <MeetingRoomRequisition> list = mrReqFactory.SearchMeetingRoomReq(id);
            var appointmentList = list.Select(x => new { x.RequiredDate, x.MeetingRoomID, x.RequisitionID, x.Remarks, x.FromTime, x.ToTime, Time = x.FromTime, x.Employee.EmpName, x.MeetingRoom.RoomNo }).OrderByDescending(x => x.RequiredDate);

            return(Json(appointmentList, JsonRequestBehavior.AllowGet));
        }
        public JsonResult SearchMeetingRoomParticipant(int?id)
        {
            mrReqFactory = new MeetingRoomReqFactorys();
            List <DAL.db.MeetingParticipant> list = mrReqFactory.SearchMeetingRoomParticipant(id);
            var participantList = list.Select(x => new { x.Employee.EmpName, x.Department.DepartmentName, x.EmployeeID, x.DesignationID, x.DepartmentID, x.ParticipantID, x.RequisitionID });

            return(Json(participantList, JsonRequestBehavior.AllowGet));
        }
        public JsonResult SaveMeetingReqRoom(DAL.db.MeetingRoomRequisition meetingRoomReq, List <DAL.db.MeetingParticipant> participantList, List <int> deleteStoreReqDtlsID)
        {
            int empID = Convert.ToInt32(dictionary[1].Id == "" ? 0 : Convert.ToInt32(dictionary[1].Id));

            mrReqFactory                 = new MeetingRoomReqFactorys();
            meetingRoomReq.CreatedBy     = empID;
            meetingRoomReq.CreatedDate   = todayTime;
            meetingRoomReq.RequisitionBy = empID;
            result = mrReqFactory.SaveMeetingReq(meetingRoomReq, participantList, deleteStoreReqDtlsID);
            return(Json(result));
        }