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));
        }//loadPendingRequests
 public RequisitionControllerTests()
 {
     context = new ApplicationDbContext();
     requisitionController = new RequisitionController();
     disbursementService   = new DisbursementService(context);
     retrievalService      = new RetrievalService(context);
 }
        public static string loadRejectedRequests()
        {
            User user = (User)HttpContext.Current.Session["user"];

            if (user == null)
            {
                return(null);
            }
            int empId = user.id;

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


            JavaScriptSerializer  js = new JavaScriptSerializer();
            RequisitionController requisitionController = new RequisitionController();
            // hard coded user id = 6
            // List<Requisition> requisition_entities =requisitionController.actionGetPendingRequisitionsByUserID(6);
            List <Requisition>        requisition_entities = requisitionController.actionGetRejectedRequisitionsByUserID(empId);
            List <RequisitionModel>   model = new List <RequisitionModel>();
            StationeryController      stationeryController = new StationeryController();
            List <StationaryRequests> stationeryRequests   = new List <StationaryRequests>();

            foreach (Requisition r in requisition_entities)
            {
                StationaryRequests stationaryRequests = new StationaryRequests();
                stationaryRequests.Quantity        = r.quantity;
                stationaryRequests.StrationeryName = stationeryController.actionGetStationeryByID(r.stationery).stationery_name;
                stationaryRequests.RequestedDate   = r.datetime_requested.ToString("MMMM dd, yyyy");
                stationaryRequests.RejectReason    = r.reject_remark;
                stationeryRequests.Add(stationaryRequests);
            }
            // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ Rejected:" + js.Serialize(stationeryRequests));
            return(js.Serialize(stationeryRequests));
        } //loadDistributedRequests
Example #5
0
        public void setdgvDetailData(string reqID)
        {
            lblRequisition.Visible = true;
            lblReq.Visible         = true;
            lblReq.Text            = reqID;
            detailPanel.Visible    = true;
            Requisition req = RequisitionController.getReqByID(reqID);

            txtReason.Text = req.Remark;
            if (req.Status == "Rejected")
            {
                dgvDetail.Visible = true;

                List <RequisitionViewModel> reqVMList = RequisitionController.getRequisitionVM(reqID);
                lblReq.Text          = reqID;
                dgvDetail.DataSource = reqVMList;
                dgvDetail.DataBind();
                for (int i = 0; i < dgvDetail.Rows.Count; i++)
                {
                    TextBox txtQty = (TextBox)dgvDetail.Rows[i].Cells[3].FindControl("txtQty");
                    //dgvDetail.Rows[i].Cells[0].Text = reqVMList[i].categoryID;
                    //dgvDetail.Rows[i].Cells[1].Text = reqVMList[i].ItemName;
                    //dgvDetail.Rows[i].Cells[2].Text = reqVMList[i].RequiredQty.ToString();
                    txtQty.Text = reqVMList[i].RequiredQty.ToString();
                }
                btnResubmit.Visible = true;
            }
            else
            {
                dgvfix.Visible = true;
                List <RequisitionViewModel> reqVMList = RequisitionController.getRequisitionVM(reqID);
                dgvfix.DataSource = reqVMList;
                dgvfix.DataBind();
            }
        }
Example #6
0
        }//getStationaryId()

        public string makeRequisition(int userId, string stationeryName, int quantity)
        {
            StationeryController stController = new StationeryController();
            Requisition          requisition  = new Requisition();


            // System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + name);
            string newstationeryName = stationeryName.Replace('_', ' ');
            //  System.Diagnostics.Debug.WriteLine("inside actionGetStationeryIdByName::" + newstationeryName);


            int stationeryId = Convert.ToInt32(stController.actionGetStationeryIdByName(newstationeryName));

            requisition.stationery = stationeryId;
            requisition.quantity   = quantity;
            requisition.user_obj   = userId;
            //hardcoded department id
            requisition.department       = 8;
            requisition.user_approved_by = null;
            RequisitionController requisitionController = new RequisitionController();
            Message msg = requisitionController.actionCreateRequisition(requisition);

            if (msg.condition)
            {
                System.Diagnostics.Debug.WriteLine("success");
                return("success");
            }
            else
            {
                System.Diagnostics.Debug.WriteLine("fail");
                return("fail");
            }
        }//makeRequisition
        public static void approveRequisitions(List <RequisitionID> jsonParam)
        {
            User sUser = (User)HttpContext.Current.Session["user"];

            if (sUser == null)
            {
                return;
            }

            UserController userController = new UserController();
            User           dUser          = userController.actionGetUserByID(sUser.id);

            JavaScriptSerializer js = new JavaScriptSerializer();

            // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + js.Serialize(jsonParam));
            System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + jsonParam.Count());

            //actionRequisitionStatusChangeToApproved(int requisition_id)
            RequisitionController requisitionController = new RequisitionController();

            foreach (RequisitionID requisitionId in jsonParam)
            {
                System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ param:" + requisitionId.Id);
                requisitionController.actionRequisitionStatusChangeToApproved(Convert.ToInt32(requisitionId.Id), dUser.id);
            }
        }//approveRequisitions
Example #8
0
        public void DetailsTest()
        {
            RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService);
            ActionResult          result = requisitionController.Details("r-1");

            //ASSERT
            Assert.IsInstanceOfType(result, typeof(ViewResult));
            ViewResult viewResult = (ViewResult)result;
        }
Example #9
0
        public void RejectTest()
        {
            RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService);
            Requisition           requisition           = new Requisition()
            {
                Id     = "1",
                Status = 0
            };

            requisitionController.Approve(requisition.Id);
            Assert.AreEqual(CustomStatus.Rejected, requisition.Status);
        }
Example #10
0
        public void SaveTest()
        {
            Requisition requisition = new Requisition()
            {
                Id           = "1",
                DepartmentId = "2"
            };
            RequisitionController requisitionController = new RequisitionController(departmentService, itemService, requisitionService, itemRequisitionService, disbursementService, itemDisbursementService, inventoryService);

            ActionResult result = requisitionController.Save(requisition);

            Assert.IsNotNull(result);
        }
Example #11
0
        protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "viewdetail")
            {
                Panel1.Visible = true;
                int    index = Convert.ToInt32(e.CommandArgument);
                string ReqId = GridView1.Rows[index].Cells[0].Text;
                lblRequisitionID.Text = ReqId;
                List <SubmitItemDetailsModel> sids = ARC.GetReqItemByReqID(ReqId);
                txtRejectReason.Text            = RequisitionController.getReqByID(ReqId).Remark;
                Session["SubmittedItemDetails"] = sids;
                GridView2.DataSource            = ARC.GetReqItemByReqID(ReqId);

                GridView2.DataBind();
            }
        }
 public string approveRequisition(string accessToken, int reqId)
 {
     try
     {
         OAuthController oAuth = new OAuthController();
         User            user  = oAuth.actionGetUserByToken(accessToken);
         //get userId
         RequisitionController requisitionController = new RequisitionController();
         requisitionController.actionRequisitionStatusChangeToApproved(reqId, user.id);
         return("success");
     }
     catch (Exception e)
     {
         return("fail");
     }
 }//approveRequisition
Example #13
0
        protected void BtnCreate_Click(object sender, EventArgs e)
        {
            List <RequisitionItem> reqItemList = new List <RequisitionItem>();
            string type = ddlRequisitiontype.SelectedValue;

            for (int i = 0; i < GridViewCreateRequisition.Rows.Count; i++)
            {
                RequisitionItem reqItem = new RequisitionItem();
                ddlCategory = (DropDownList)GridViewCreateRequisition.Rows[i].Cells[1].FindControl("DropDownListDesc");
                TextBox tbQty = (TextBox)GridViewCreateRequisition.Rows[i].Cells[3].FindControl("TextboxQty");

                reqItem.Item_ID      = ddlCategory.SelectedValue;
                reqItem.Required_Qty = Convert.ToInt32(tbQty.Text);
                if (reqItem.Required_Qty > 0)
                {
                    reqItemList.Add(reqItem);
                }

                reqItemList = reqItemList.GroupBy(x => x.Item_ID)
                              .Select(y => new RequisitionItem {
                    Item_ID = y.Key, Required_Qty = y.Sum(t => t.Required_Qty)
                })
                              .ToList();
            }

            if (reqItemList.Count > 0)
            {
                try
                {
                    Staff loginstaff = (Staff)Session["LoginStaff"];


                    RequisitionController.createRequisition(reqItemList, loginstaff.Staff_ID, type, "Submitted");
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Successfully')", true);

                    initData();
                }
                catch (Exception ex)
                {
                    ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('OOPS! Requisition Submit Failed')", true);
                }
            }
            else
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('You have Item which Item Quantiy is 0, Pls check!!')", true);
            }
        }
Example #14
0
        protected void btnSearch_Click(object sender, EventArgs e)
        {
            Staff loginStaff = (Staff)Session["loginStaff"];

            lblReqResult.Text = "";
            string reqID = txtID.Text;

            if (reqID != "")
            {
                if (RequisitionController.checkReqByStaffID(reqID, loginStaff.Staff_ID))
                {
                    setdgvDetailData(reqID);
                }
                else
                {
                    lblReqResult.Text = "Requisition invalid, Please check!";
                }
            }
            else
            {
                string fromDate = txtFromDate.Text;
                string toDate   = txtToDate.Text;
                if (fromDate == "" || toDate == "")
                {
                    LBStatus.Text = "Please select both From date and To date.";
                }
                else if (DateTime.Compare(TC.DateConvert(fromDate), TC.DateConvert(toDate)) > 0)
                {
                    LBStatus.Text = "From date should be later than To date";
                }
                else
                {
                    Staff stf = (Staff)Session["LoginStaff"];
                    LBStatus.Text = "";
                    string             status  = dplStatus.SelectedValue;
                    List <Requisition> reqList = RequisitionController.getReqByDate_Status(stf.Staff_ID, fromDate, toDate, status);
                    Session["reqList"] = reqList;

                    initPage();
                    dgvList.Visible    = true;
                    dgvList.DataSource = reqList;
                    dgvList.DataBind();
                }
            }
        }
Example #15
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            User sUser = (User)Session["user"];

            if (sUser == null || sUser.user_type != 1)
            {
                Response.Redirect("~/m/Login.aspx");
            }

            User dUser = new UserController().actionGetUserByID(sUser.id);

            RequisitionController requisitionController = new RequisitionController();

            ApplicationLayer.Requisition requisition = new ApplicationLayer.Requisition();
            requisition.user_obj   = dUser.id;
            requisition.stationery = Convert.ToInt32(ui_id_hidden.Value);
            requisition.quantity   = Convert.ToInt32(ui_quantity.Text);
            requisition.department = Convert.ToInt32(dUser.department);
            Message message = requisitionController.actionCreateRequisition(requisition);

            if (message.condition)
            {
                Response.Cookies.Add(new HttpCookie("flash_message", "Successfully Requested.")
                {
                    Path = "/"
                });
                Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-success")
                {
                    Path = "/"
                });
                Response.Redirect("~/m/DepartmentEmployee/Stationeries.aspx");
            }
            else
            {
                Response.Cookies.Add(new HttpCookie("flash_message", "Requisition Fail. <br />" + message.message)
                {
                    Path = "/"
                });
                Response.Cookies.Add(new HttpCookie("flash_css", "alert alert-error")
                {
                    Path = "/"
                });
                return;
            }
        }
        }//approveRequisition

        public string rejectRequisition(string accessToken, int reqId, string reason)
        {
            System.Diagnostics.Debug.WriteLine("inside rejectRequisition: accessToken" + accessToken + " ,reqId:" + reqId + "  ,reason:" + reason);
            try
            {
                OAuthController oAuth = new OAuthController();
                User            user  = oAuth.actionGetUserByToken(accessToken);
                //get userId
                RequisitionController requisitionController = new RequisitionController();
                //  requisitionController.actionRequisitionStatusChangeToRejected(reqId);
                requisitionController.actionRequisitionStatusChangeToRejectedWithRemarkAndRejectedBy(reqId, reason, user.id);
                return("success");
            }
            catch (Exception e)
            {
                System.Diagnostics.Debug.WriteLine("Exception occured in rejectRequisition.." + e.Message);
                return("fail");
            }
        }//rejectRequisition
        public static string MakeRequisition(object jsonParam)
        {
            User user = (User)HttpContext.Current.Session["user"];

            if (user == null)
            {
                return(null);
            }
            int empId = user.id;

            String valueString = jsonParam.ToString();

            string[] values = valueString.Split('.');
            int      stId   = Convert.ToInt16(values[0]);
            int      qty    = Convert.ToInt16(values[1]);

            int         depId       = Convert.ToInt32(user.department);
            Requisition requisition = new Requisition();

            requisition.stationery       = stId;
            requisition.quantity         = qty;
            requisition.user_obj         = empId;
            requisition.department       = depId;
            requisition.user_approved_by = null;
            RequisitionController requisitionController = new RequisitionController();
            Message msg = requisitionController.actionCreateRequisition(requisition);

            if (msg.condition)
            {
                //return msg.message;
                return("success");
            }
            else
            {
                //return msg.message;
                return("fail");
            }


            // System.Diagnostics.Debug.WriteLine(" inside MakeRequisition " + msg);
            // return "Hi this is response from MakeRequisition";
        }//
        public string approveAllRequisitions(string accessToken, List <RequisitionId> requisitionsIds)
        {
            OAuthController       oAuth = new OAuthController();
            User                  user  = oAuth.actionGetUserByToken(accessToken);
            RequisitionController requisitionController = new RequisitionController();

            try
            {
                for (int i = 0; i < requisitionsIds.Count(); i++)
                {
                    RequisitionId requisitionId = requisitionsIds[i];
                    requisitionController.actionRequisitionStatusChangeToApproved(requisitionId.reqId, user.id);
                }
                return("success");
            }
            catch (Exception e)
            {
                return("fail");
            }
        }
        public string showAllApprovedRequisitions(string accessToken)
        {
            OAuthController        oAuth = new OAuthController();
            User                   user  = oAuth.actionGetUserByToken(accessToken);
            RequisitionController  requisitionController     = new RequisitionController();
            List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetApprovedRequisitionViewsByDepartmentID(Convert.ToInt32(user.department));
            List <Requisition>     requisitions = new List <Requisition>();

            foreach (RequisitionView rView in requisitionDepartmentWise)
            {
                Requisition requisition = new Requisition();
                requisition.EmployeeName    = rView.firstname + " " + rView.lastname;
                requisition.Quantity        = rView.quantity;
                requisition.RequisitionDate = rView.datetime_requested;
                requisition.ReqDate         = rView.datetime_requested.ToString("MMMM dd, yyyy");
                requisition.StationaryName  = rView.stationery_name;
                requisitions.Add(requisition);
            }
            return(JsonConvert.SerializeObject(requisitions));
        }//showAllApprovedRequisitions
Example #20
0
        protected void btnResubmit_Click(object sender, EventArgs e)
        {
            List <RequisitionItem> reqList = new List <RequisitionItem>();
            string reqid  = lblReq.Text;
            string status = "Submitted";

            for (int i = 0; i < dgvDetail.Rows.Count; i++)
            {
                TextBox txtQty = (TextBox)dgvDetail.Rows[i].Cells[3].FindControl("txtQty");


                string category = dgvDetail.Rows[i].Cells[0].Text;
                string ItemID   = dgvDetail.Rows[i].Cells[1].Text;
                string ItemName = dgvDetail.Rows[i].Cells[2].Text;
                string UOM      = dgvDetail.Rows[i].Cells[3].Text;
                int    Qty      = Convert.ToInt32(txtQty.Text);



                RequisitionItem reqitem = new RequisitionItem();
                reqitem.Item_ID        = ItemID;
                reqitem.Required_Qty   = Qty;
                reqitem.Requisition_ID = reqid;

                reqList.Add(reqitem);
            }
            try
            {
                RequisitionController.updateRequisition(reqList, reqid, status);
                clearPage();
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Successfully')", true);
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Requisition Submit Failed')", true);
            }
        }
        protected void btnCreate_Click(object sender, EventArgs e)
        {
            List <ReceivedItemModel> restItemList = (List <ReceivedItemModel>)Session["restItemList"];
            List <RequisitionItem>   reqItemList  = new List <RequisitionItem>();

            if (restItemList.Count > 0)
            {
                foreach (ReceivedItemModel restItem in restItemList)
                {
                    RequisitionItem reqItem = new RequisitionItem();
                    reqItem.Item_ID      = restItem.itemCode;
                    reqItem.Required_Qty = restItem.restQty;
                    reqItemList.Add(reqItem);
                }

                Staff  stf    = (Staff)Session["LoginStaff"];
                string type   = "Special";
                string status = "Approved";
                RequisitionController.createRequisition(reqItemList, stf.Staff_ID, type, status);
                Session["restItemList"] = "";
            }
            ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Create success!')", true);
            initPage();
        }
        public static void rejectRequisitions(List <RequisitionID> jsonParam, string reason)
        {
            System.Diagnostics.Debug.WriteLine("REASON FOR REJECTION:" + reason);
            User sUser = (User)HttpContext.Current.Session["user"];

            if (sUser == null)
            {
                return;
            }

            JavaScriptSerializer js = new JavaScriptSerializer();
            // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + js.Serialize(jsonParam));
            //  System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ approveRequisitions:" + jsonParam.Count());

            //actionRequisitionStatusChangeToApproved(int requisition_id)
            RequisitionController requisitionController = new RequisitionController();

            foreach (RequisitionID requisitionId in jsonParam)
            {
                // System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ param:" + requisitionId.Id);
                // requisitionController.actionRequisitionStatusChangeToRejected(Convert.ToInt32(requisitionId.Id));
                requisitionController.actionRequisitionStatusChangeToRejectedWithRemarkAndRejectedBy(Convert.ToInt32(requisitionId.Id), reason, sUser.id);
            }
        }//rejectRequisitions
        public string showAllPendingRequisition(string accessToken)
        {
            RequisitionController requisitionController = new RequisitionController();
            JavaScriptSerializer  js    = new JavaScriptSerializer();
            OAuthController       oAuth = new OAuthController();
            User user = oAuth.actionGetUserByToken(accessToken);
            // int userId = user.id;
            List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetPendingRequisitionViewsByDepartmentID(Convert.ToInt32(user.department));
            List <UserRequisition> userRequisitionsList      = new List <UserRequisition>();

            foreach (RequisitionView r in requisitionDepartmentWise)
            {
                if (userRequisitionsList.Count == 0)
                {
                    UserRequisition userRequisition = new UserRequisition();
                    userRequisition.EmployeeName = r.firstname + " " + r.lastname;
                    userRequisition.UserId       = r.user_obj;
                    Requisition requisition = new Requisition();
                    requisition.ReqId          = r.requisition_id;
                    requisition.Quantity       = r.quantity;
                    requisition.StationaryName = r.stationery_name;
                    userRequisition.UserRequisitions.Add(requisition);
                    userRequisitionsList.Add(userRequisition);
                }
                else
                {
                    bool found = false;
                    //check if requisition from the same user is pending, if yes group the requisition based on that user id
                    foreach (UserRequisition uR in userRequisitionsList)
                    {
                        if (r.user_obj == uR.UserId)
                        {
                            found = true;
                            Requisition requisition = new Requisition();
                            requisition.ReqId           = r.requisition_id;
                            requisition.Quantity        = r.quantity;
                            requisition.StationaryName  = r.stationery_name;
                            requisition.RequisitionDate = r.datetime_requested;
                            uR.UserRequisitions.Add(requisition);
                            break;
                        }
                    }//foreach
                    //else simply add the userrequisition to the list, grouping not required
                    if (!found)
                    {
                        UserRequisition userRequisition = new UserRequisition();
                        userRequisition.EmployeeName = r.firstname + " " + r.lastname;
                        userRequisition.UserId       = r.user_obj;
                        Requisition requisition = new Requisition();
                        requisition.ReqId          = r.requisition_id;
                        requisition.Quantity       = r.quantity;
                        requisition.StationaryName = r.stationery_name;
                        userRequisition.UserRequisitions.Add(requisition);
                        userRequisitionsList.Add(userRequisition);
                    } //if
                }     //else
            }         //forEach

            System.Diagnostics.Debug.WriteLine("json serialized:" + JsonConvert.SerializeObject(userRequisitionsList));
            return(JsonConvert.SerializeObject(userRequisitionsList));
            /// return js.Serialize(userRequisitionsList);
        }//showAllPendingRequisition
        public static string LoadAllPendingRequests()
        {
            User sUser = (User)HttpContext.Current.Session["user"];

            if (sUser == null)
            {
                return(null);
            }

            UserController userController = new UserController();
            User           dUser          = userController.actionGetUserByID(sUser.id);


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



            List <RequisitionView> requisitionDepartmentWise = requisitionController.actionGetPendingRequisitionViewsByDepartmentID(Convert.ToInt32(dUser.department));

            System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ requisitions by department wise:" + requisitionDepartmentWise.Count());

            List <UserRequisition> userRequisitionsList = new List <UserRequisition>();

            foreach (RequisitionView r in requisitionDepartmentWise)
            {
                //System.Diagnostics.Debug.WriteLine(" Dept:" + r.department + "User id:" + r.user_id + " Name" + r.firstname + " Req Id:" + r.requisition_id + " Stationary Name" + r.stationery_name + " Quantity " + r.quantity);


                if (userRequisitionsList.Count == 0)
                {
                    UserRequisition userRequisition = new UserRequisition();
                    //Since there are no requisitions made so no question of grouping based on user id
                    userRequisition.EmployeeName = r.firstname + " " + r.lastname;
                    userRequisition.UserId       = r.user_obj;
                    Requisition requisition = new Requisition();
                    requisition.ReqId          = r.requisition_id;
                    requisition.Quantity       = r.quantity;
                    requisition.StationaryName = r.stationery_name;
                    // requisition.RequisitionDate = r.r
                    userRequisition.UserRequisitions.Add(requisition);
                    userRequisitionsList.Add(userRequisition);
                }
                else
                {
                    bool found = false;
                    //check if requisition from the same user is pending, if yes group the requisition based on that user id
                    foreach (UserRequisition uR in userRequisitionsList)
                    {
                        if (r.user_obj == uR.UserId)
                        {
                            found = true;
                            Requisition requisition = new Requisition();
                            requisition.ReqId          = r.requisition_id;
                            requisition.Quantity       = r.quantity;
                            requisition.StationaryName = r.stationery_name;
                            // requisition.RequisitionDate = r.r
                            uR.UserRequisitions.Add(requisition);
                            break;
                        }
                    }//foreach
                    //else simply add the userrequisition to the list, grouping not required
                    if (!found)
                    {
                        UserRequisition userRequisition = new UserRequisition();
                        userRequisition.EmployeeName = r.firstname + " " + r.lastname;
                        userRequisition.UserId       = r.user_obj;

                        Requisition requisition = new Requisition();
                        requisition.ReqId          = r.requisition_id;
                        requisition.Quantity       = r.quantity;
                        requisition.StationaryName = r.stationery_name;
                        userRequisition.UserRequisitions.Add(requisition);
                        userRequisitionsList.Add(userRequisition);
                    }
                }
            }


            System.Diagnostics.Debug.WriteLine("check @@@@@@@@@@@@ loadAllPendingRequests:" + js.Serialize(userRequisitionsList));
            return(js.Serialize(userRequisitionsList));
        }//loadAllPendingRequests