public string loadAllPendingRequisitions(String accessToken)
        {
            OAuthController oAuth = new OAuthController();
            User user = oAuth.actionGetUserByToken(accessToken);

            RequisitionController requisitionController = new RequisitionController();

            List<Requisition> requisition_entities = requisitionController.actionGetPendingRequisitionsByUserID(user.id);
            List<RequisitionModel> model = new List<RequisitionModel>();
            StationeryController stationeryController = new StationeryController();
            List<StationaryRequests> stationeryRequests = new List<StationaryRequests>();
            int counter = 1;
            foreach (Requisition r in requisition_entities)
            {

                StationaryRequests stationaryRequests = new StationaryRequests();
                stationaryRequests.Quantity = r.quantity;
                stationaryRequests.SNo = counter;
                stationaryRequests.StationaryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name;
                stationaryRequests.RequestedDate = r.datetime_requested.ToString();
                stationeryRequests.Add(stationaryRequests);
                counter++;

            }

            return JsonConvert.SerializeObject(stationeryRequests);
        }
        public static string loadPendingRequests()
        {
            User user = (User)HttpContext.Current.Session["user"];
            if (user == null) {
                return null;
            }
            int empId = user.id;

            //--------------------------------------------------------------

            JavaScriptSerializer js = new JavaScriptSerializer();
            RequisitionController requisitionController = new RequisitionController();

            List<Requisition> requisition_entities = requisitionController.actionGetPendingRequisitionsByUserID(empId);
            List<RequisitionModel> model = new List<RequisitionModel>();
            StationeryController stationeryController = new StationeryController();
            List<StationaryRequests> stationeryRequests = new List<StationaryRequests>();
            int counter = 1;
            foreach (Requisition r in requisition_entities)
            {

                StationaryRequests stationaryRequests = new StationaryRequests();
                stationaryRequests.Quantity = r.quantity;
                stationaryRequests.SNo = counter;
                stationaryRequests.StrationeryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name;
                stationaryRequests.RequestedDate = r.datetime_requested.ToString("MMMM dd, yyyy");
                stationeryRequests.Add(stationaryRequests);
                counter++;

            }

            return js.Serialize(stationeryRequests);
        }