private string GetUploadPermission()
        {
            List <ITILServiceDesk_Setting> objITILServiceDesk_Settings = GetSettings();
            ITILServiceDesk_Setting        objITILServiceDesk_Setting  = objITILServiceDesk_Settings.Where(x => x.SettingName == "UploadPermission").FirstOrDefault();

            string strUploadPermission = "All";

            if (objITILServiceDesk_Setting != null)
            {
                strUploadPermission = objITILServiceDesk_Setting.SettingValue;
            }

            return(strUploadPermission);
        }
        private string GetAdminRole()
        {
            List <ITILServiceDesk_Setting> objITILServiceDesk_Settings = GetSettings();
            ITILServiceDesk_Setting        objITILServiceDesk_Setting  = objITILServiceDesk_Settings.Where(x => x.SettingName == "AdminRole").FirstOrDefault();

            string strAdminRoleID = PortalSettings.AdministratorRoleName;

            if (objITILServiceDesk_Setting != null)
            {
                strAdminRoleID = objITILServiceDesk_Setting.SettingValue;
            }

            return(strAdminRoleID);
        }
        protected void btnUpdateAdminRole_Click(object sender, EventArgs e)
        {
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            ITILServiceDesk_Setting objITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                  where ITILServiceDesk_Settings.PortalID == PortalId
                                                                  where ITILServiceDesk_Settings.SettingName == "AdminRole"
                                                                  select ITILServiceDesk_Settings).FirstOrDefault();


            objITILServiceDesk_Setting.SettingValue = ddlAdminRole.SelectedValue;
            objServiceDeskDALDataContext.SubmitChanges();

            lblAdminRole.Text = Localization.GetString("Updated.Text", LocalResourceFile);
        }
        private string GetAdminRole()
        {
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            List <ITILServiceDesk_Setting> colITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                         where ITILServiceDesk_Settings.PortalID == PortalId
                                                                         select ITILServiceDesk_Settings).ToList();

            ITILServiceDesk_Setting objITILServiceDesk_Setting = colITILServiceDesk_Setting.Where(x => x.SettingName == "AdminRole").FirstOrDefault();

            string strAdminRoleID = "Administrators";

            if (objITILServiceDesk_Setting != null)
            {
                strAdminRoleID = objITILServiceDesk_Setting.SettingValue;
            }

            return(strAdminRoleID);
        }
        private void DisplayUploadedFilesPath()
        {
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            // Uploaded Files Path
            ITILServiceDesk_Setting objITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                  where ITILServiceDesk_Settings.PortalID == PortalId
                                                                  where ITILServiceDesk_Settings.SettingName == "UploadefFilesPath"
                                                                  select ITILServiceDesk_Settings).FirstOrDefault();

            txtUploadedFilesPath.Text = objITILServiceDesk_Setting.SettingValue;

            // Upload Permissions
            ITILServiceDesk_Setting UploadPermissionITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                               where ITILServiceDesk_Settings.PortalID == PortalId
                                                                               where ITILServiceDesk_Settings.SettingName == "UploadPermission"
                                                                               select ITILServiceDesk_Settings).FirstOrDefault();

            ddlUploadPermission.SelectedValue = UploadPermissionITILServiceDesk_Setting.SettingValue;
        }
        protected void btnUploadedFiles_Click(object sender, EventArgs e)
        {
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            ITILServiceDesk_Setting UploadefFilesITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                            where ITILServiceDesk_Settings.PortalID == PortalId
                                                                            where ITILServiceDesk_Settings.SettingName == "UploadefFilesPath"
                                                                            select ITILServiceDesk_Settings).FirstOrDefault();

            UploadefFilesITILServiceDesk_Setting.SettingValue = txtUploadedFilesPath.Text.Trim();
            objServiceDeskDALDataContext.SubmitChanges();

            ITILServiceDesk_Setting UploadPermissionITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                               where ITILServiceDesk_Settings.PortalID == PortalId
                                                                               where ITILServiceDesk_Settings.SettingName == "UploadPermission"
                                                                               select ITILServiceDesk_Settings).FirstOrDefault();

            UploadPermissionITILServiceDesk_Setting.SettingValue = ddlUploadPermission.SelectedValue;
            objServiceDeskDALDataContext.SubmitChanges();

            lblUploadedFilesPath.Text = Localization.GetString("Updated.Text", LocalResourceFile);
        }
        private List <ITILServiceDesk_Setting> GetSettings()
        {
            // Get Settings
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            List <ITILServiceDesk_Setting> colITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                         where ITILServiceDesk_Settings.PortalID == PortalId
                                                                         select ITILServiceDesk_Settings).ToList();

            if (colITILServiceDesk_Setting.Count == 0)
            {
                // Create Default vaules
                ITILServiceDesk_Setting objITILServiceDesk_Setting1 = new ITILServiceDesk_Setting();

                objITILServiceDesk_Setting1.PortalID     = PortalId;
                objITILServiceDesk_Setting1.SettingName  = "AdminRole";
                objITILServiceDesk_Setting1.SettingValue = PortalSettings.AdministratorRoleName;

                objServiceDeskDALDataContext.ITILServiceDesk_Settings.InsertOnSubmit(objITILServiceDesk_Setting1);
                objServiceDeskDALDataContext.SubmitChanges();

                ITILServiceDesk_Setting objITILServiceDesk_Setting2 = new ITILServiceDesk_Setting();

                objITILServiceDesk_Setting2.PortalID     = PortalId;
                objITILServiceDesk_Setting2.SettingName  = "UploadefFilesPath";
                objITILServiceDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/ITILServiceDesk/Upload");

                objServiceDeskDALDataContext.ITILServiceDesk_Settings.InsertOnSubmit(objITILServiceDesk_Setting2);
                objServiceDeskDALDataContext.SubmitChanges();

                colITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                              where ITILServiceDesk_Settings.PortalID == PortalId
                                              select ITILServiceDesk_Settings).ToList();
            }

            return(colITILServiceDesk_Setting);
        }
        private List <ITILServiceDesk_Setting> GetSettings()
        {
            // Get Settings
            ServiceDeskDALDataContext objServiceDeskDALDataContext = new ServiceDeskDALDataContext();

            List <ITILServiceDesk_Setting> colITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                         where ITILServiceDesk_Settings.PortalID == PortalId
                                                                         select ITILServiceDesk_Settings).ToList();

            if (colITILServiceDesk_Setting.Count == 0)
            {
                // Create Default vaules
                ITILServiceDesk_Setting objITILServiceDesk_Setting1 = new ITILServiceDesk_Setting();

                objITILServiceDesk_Setting1.PortalID     = PortalId;
                objITILServiceDesk_Setting1.SettingName  = "AdminRole";
                objITILServiceDesk_Setting1.SettingValue = "Administrators";

                objServiceDeskDALDataContext.ITILServiceDesk_Settings.InsertOnSubmit(objITILServiceDesk_Setting1);
                objServiceDeskDALDataContext.SubmitChanges();

                ITILServiceDesk_Setting objITILServiceDesk_Setting2 = new ITILServiceDesk_Setting();

                objITILServiceDesk_Setting2.PortalID     = PortalId;
                objITILServiceDesk_Setting2.SettingName  = "UploadefFilesPath";
                objITILServiceDesk_Setting2.SettingValue = Server.MapPath("~/DesktopModules/ITILServiceDesk/Upload");

                objServiceDeskDALDataContext.ITILServiceDesk_Settings.InsertOnSubmit(objITILServiceDesk_Setting2);
                objServiceDeskDALDataContext.SubmitChanges();

                colITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                              where ITILServiceDesk_Settings.PortalID == PortalId
                                              select ITILServiceDesk_Settings).ToList();
            }

            // Upload Permission
            ITILServiceDesk_Setting UploadPermissionITILServiceDesk_Setting = (from ITILServiceDesk_Settings in objServiceDeskDALDataContext.ITILServiceDesk_Settings
                                                                               where ITILServiceDesk_Settings.PortalID == PortalId
                                                                               where ITILServiceDesk_Settings.SettingName == "UploadPermission"
                                                                               select ITILServiceDesk_Settings).FirstOrDefault();

            if (UploadPermissionITILServiceDesk_Setting != null)
            {
                // Add to collection
                colITILServiceDesk_Setting.Add(UploadPermissionITILServiceDesk_Setting);
            }
            else
            {
                // Add Default value
                ITILServiceDesk_Setting objITILServiceDesk_Setting = new ITILServiceDesk_Setting();
                objITILServiceDesk_Setting.SettingName  = "UploadPermission";
                objITILServiceDesk_Setting.SettingValue = "All";
                objITILServiceDesk_Setting.PortalID     = PortalId;
                objServiceDeskDALDataContext.ITILServiceDesk_Settings.InsertOnSubmit(objITILServiceDesk_Setting);
                objServiceDeskDALDataContext.SubmitChanges();

                // Add to collection
                colITILServiceDesk_Setting.Add(objITILServiceDesk_Setting);
            }

            return(colITILServiceDesk_Setting);
        }