public InsiderDashboardDTO_OS GetDashboardDetails_OS(string i_sConnectionString, int nLoggedInUserId)
        {
            InsiderDashboardDTO_OS objInsiderDashboardDTO = new InsiderDashboardDTO_OS();

            try
            {
                using (var InsiderDashboardDAL_OS = new InsiderDashboardDAL_OS())
                {
                    objInsiderDashboardDTO = InsiderDashboardDAL_OS.GetDashboardDetails_OS(i_sConnectionString, nLoggedInUserId);
                }
            }
            catch (Exception exp)
            {
                throw exp;
            }
            return(objInsiderDashboardDTO);
        }
        private InsiderDashboardOtherModel BindDashboardForOtherSecurities()
        {
            LoginUserDetails          objLoginUserDetails       = null;
            InsiderDashboardDTO_OS    objInsiderDashboardDTO_OS = null;
            UserInfoDTO               objUserInfoDTO            = null;
            ApprovedPCLDTO            objApprovedPCLDTO         = null;
            PasswordExpiryReminderDTO objPassExpiryReminderDTO  = null;
            DateTime  CurrentDate;
            ArrayList lst = new ArrayList();
            UserPolicyDocumentEventLogDTO objChangePasswordEventLogDTO = null;
            CompanyConfigurationDTO       objCompanyConfigurationDTO   = null;
            int noOfDays;

            objLoginUserDetails = (LoginUserDetails)Common.Common.GetSessionValue(ConstEnum.SessionValue.UserDetails);
            using (InsiderDashboardSL_OS objInsiderDashboardSL_OS = new InsiderDashboardSL_OS())
            {
                objInsiderDashboardDTO_OS = objInsiderDashboardSL_OS.GetDashboardDetails_OS(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);

                Common.Common.CopyObjectPropertyByName(objInsiderDashboardDTO_OS, objInsiderDashboardModel.objInsiderDashboardOtherModel);
                CurrentDate = Convert.ToDateTime(DateTime.Now.Date.ToString("dd/MM/yyyy"), System.Globalization.CultureInfo.GetCultureInfo("hi-IN").DateTimeFormat);
                objPassExpiryReminderDTO = objInsiderDashboardSL_OS.GetPasswordExpiryReminder(objLoginUserDetails.CompanyDBConnectionString, objLoginUserDetails.LoggedInUserID);
                if (objLoginUserDetails.LoggedInUserID == objPassExpiryReminderDTO.UserID &&
                    objPassExpiryReminderDTO.ValidityDate.Date >= CurrentDate &&
                    objPassExpiryReminderDTO.ExpiryReminderDate.Date <= CurrentDate)
                {
                    if ((objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days == 1)
                    {
                        noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days;
                    }
                    else
                    {
                        noOfDays = (objPassExpiryReminderDTO.ValidityDate.Date - CurrentDate.Date).Days + 1;
                    }
                    lst.Add(noOfDays);
                    lst.Add(objPassExpiryReminderDTO.ValidityDate.Date.ToString("dd/MM/yyyy"));
                    ViewBag.PasswordReminderMsg = Common.Common.getResource("pc_msg_50569", lst);
                }
                else if (objPassExpiryReminderDTO.ValidityDate.Date < CurrentDate)
                {
                    objInsiderDashboardModel.objInsiderDashboardOtherModel.IsChangePassword = true;
                }
            }

            return(objInsiderDashboardModel.objInsiderDashboardOtherModel);
        }