public ActionResult EmployeeDetails()
        {
            string           ViewEmployeeID = Request.Cookies["ViewEmployeeID"].Value;
            Emp_BasicInfoBal EmpDashBal     = new Emp_BasicInfoBal();

            List <Emp_BasicInfoModel> empview = new List <Emp_BasicInfoModel>();
            var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext);

            using (var clientContext = spContext.CreateUserClientContextForSPHost())
            {
                empview = EmpDashBal.GetEmployeeById(clientContext, ViewEmployeeID);
            }
            ViewBag.name = empview;

            return(View());
        }
        public ActionResult EmployeeEdit()
        {
            // string items = "":
            string           EditEmployeeID = Request.Cookies["EditEmployeeID"].Value;
            Emp_BasicInfoBal EmpDashBal     = new Emp_BasicInfoBal();

            List <Emp_BasicInfoModel> empEdit = new List <Emp_BasicInfoModel>();
            var spContext = SharePointContextProvider.Current.GetSharePointContext(HttpContext);

            using (var clientContext = spContext.CreateUserClientContextForSPHost())
            {
                empEdit         = EmpDashBal.GetEmployeeById(clientContext, EditEmployeeID);
                empBasicinfo    = emp.GetAllEmployee(clientContext);
                emp_Company     = company.GetAllCompany(clientContext);
                emp_designation = designation.GetDesignation(clientContext);
                emp_department  = department.GetAllDepartment(clientContext);
                emp_division    = division.GetDivision(clientContext);
                emp_Branch      = Branch.GetBranch(clientContext);
                emp_Region      = Region.GetRegion(clientContext);
                user            = username.Getusergroup(clientContext);
                emp_manager     = empmanager.GetManager(clientContext);

                /*  emp_Company = company.GetAllCompany(clientContext);
                 * IEnumerable<Emp_CompanyMasterModel> companymodel = company.GetAllCompany(clientContext);
                 * var listToClient = companymodel.Select(p => new { p.CompanyName, p.ID }).ToList();
                 * var items = listToClient.Select(i => new SelectListItem { Text = i.CompanyName, Value = i.ID.ToString() });
                 * ViewBag.companyedit = items;*/
            }
            ViewBag.company     = emp_Company;
            ViewBag.designation = emp_designation;
            ViewBag.department  = emp_department;
            ViewBag.division    = emp_division;
            ViewBag.Branch      = emp_Branch;
            ViewBag.Region      = emp_Region;
            ViewBag.emp         = empBasicinfo;
            Session["manager"]  = empBasicinfo;
            ViewBag.Empdata     = empEdit;
            ViewBag.username    = user;
            ViewBag.empmanager  = emp_manager;

            return(View());
        }
        public List <GEN_ApproverRoleNameModel> getApproverData(ClientContext clientContext, string empcode, string module, string approvertype)
        {
            // approver details model
            List <GEN_ApproverRoleNameModel> approverRoleNameModel = new List <GEN_ApproverRoleNameModel>();

            // create object for gen_approver master
            GEN_ApproverMasterModel approverMasterModel = new GEN_ApproverMasterModel();

            string filter = "Module eq '" + module + "' and Approver_Type eq '" + approvertype + "'";

            JArray jArray = RestGetApproverLevels(clientContext, filter);

            //List<GEN_ApproverRoleListModel> approverRoleListModels = new List<GEN_ApproverRoleListModel>();

            //GEN_ApproverRoleListBal approverRoleListBal = new GEN_ApproverRoleListBal();

            //approverRoleListModels = approverRoleListBal.GetApproverRoleListBals(clientContext);

            Emp_BasicInfoBal basicInfoBal = new Emp_BasicInfoBal();

            approverMasterModel = new GEN_ApproverMasterModel
            {
                ID                       = Convert.ToInt32(jArray[0]["ID"]),
                Module                   = jArray[0]["Module"] == null ? "" : Convert.ToString(jArray[0]["Module"]),
                Approver_Type            = jArray[0]["Approver_Type"] == null ? "" : Convert.ToString(jArray[0]["Approver_Type"]),
                Rule_For_Filter_Type     = jArray[0]["Rule_For_Filter_Type"] == null ? "" : Convert.ToString(jArray[0]["Rule_For_Filter_Type"]),
                Rule_For_Filter_Data     = jArray[0]["Rule_For_Filter_Data"] == null ? "" : Convert.ToString(jArray[0]["Rule_For_Filter_Data"]),
                ApproverRoleName         = jArray[0]["ApproverRoleName"] == null ? "" : Convert.ToString(jArray[0]["ApproverRoleName"]),
                ApproverRoleInternalName = jArray[0]["ApproverRoleInternalName"] == null ? "" : Convert.ToString(jArray[0]["ApproverRoleInternalName"])
            };

            List <string> rolenamearr = new List <string>();

            rolenamearr = approverMasterModel.ApproverRoleInternalName.Split(',').ToList();

            // call Emp-basicinfimodel class
            Emp_BasicInfoBal emp_BasicInfo = new Emp_BasicInfoBal();

            Emp_BasicInfoModel basicInfoManager = new Emp_BasicInfoModel();

            basicInfoManager = emp_BasicInfo.GetEmpManager(clientContext, empcode);

            for (int i = 0; i < rolenamearr.Count; i++)
            {
                if (rolenamearr[i] == "Manager")
                {
                    if (basicInfoManager.ManagerCode != null)
                    {
                        approverRoleNameModel.Add(new GEN_ApproverRoleNameModel
                        {
                            Sequence = i,
                            Role     = rolenamearr[i],
                            Empcode  = basicInfoManager.ManagerCode,
                            Email    = basicInfoManager.OfficeEmail,
                            FullName = basicInfoManager.Manager + " " + basicInfoManager.LastName,
                            ID       = basicInfoManager.ManagerId,
                        });
                    }
                }
                else if (rolenamearr[i] == "ManagersManager")
                {
                    if (basicInfoManager.Manager_Code != null)
                    {
                        approverRoleNameModel.Add(new GEN_ApproverRoleNameModel
                        {
                            Sequence = i,
                            Role     = rolenamearr[i],
                            Empcode  = basicInfoManager.Manager_Code
                        });
                    }
                }
                else if (rolenamearr[i] == "DepartmentHead")
                {
                    if (basicInfoManager.Department != null)
                    {
                        Emp_DepartmentModel departmentModel = new Emp_DepartmentModel();
                        Emp_DepartmentBal   departmentBal   = new Emp_DepartmentBal();
                        departmentModel = departmentBal.GetDepartmentHead(clientContext, basicInfoManager.Department);

                        approverRoleNameModel.Add(new GEN_ApproverRoleNameModel
                        {
                            Sequence = i,
                            Role     = rolenamearr[i],
                            Empcode  = departmentModel.HeadOfDepartment
                        });
                    }
                }
                else if (rolenamearr[i] == "AssetAllocateDepartment")
                {
                    GEN_ApproverRoleListModel _ApproverRoleListModel = new GEN_ApproverRoleListModel();
                    GEN_ApproverRoleListBal   _ApproverRoleListBal   = new GEN_ApproverRoleListBal();
                    _ApproverRoleListModel = _ApproverRoleListBal.GetEmpByRole(clientContext, rolenamearr[i]);

                    approverRoleNameModel.Add(new GEN_ApproverRoleNameModel
                    {
                        Sequence = i,
                        Role     = rolenamearr[i],
                        Empcode  = _ApproverRoleListModel.Empcode
                    });
                }
            }


            return(approverRoleNameModel);
        }