public static string Read(SettingHeader setting) { StringBuilder sb = new StringBuilder(2048); GetPrivateProfileString(GetHeader(setting), "VALUE", "", sb, 2048, Setting.SettingPath); return(sb.ToString()); }
private static string GetHeader(SettingHeader setting) { string settingHeader = ""; switch (setting) { case SettingHeader.ConcurrentCount: settingHeader = "COUNCURRENT_COUNT"; break; case SettingHeader.DomainSaveSetting: settingHeader = "DOMAIN_SAVE_SETTING"; break; case SettingHeader.SavePath: settingHeader = "DOMAIN_SAVE_PATH"; break; } return(settingHeader); }
public TenantSetting GetTenantSetting(Guid tenantSettingId, bool readOnly = true) { TenantSetting tenantSetting; if (readOnly) { tenantSetting = PanacheLegalFoundationContext.TenantSettings .Where(t => t.Id == tenantSettingId) .AsNoTracking() .SingleOrDefault(); } else { tenantSetting = PanacheLegalFoundationContext.TenantSettings .Where(t => t.Id == tenantSettingId) .SingleOrDefault(); } if (tenantSetting == null) { SettingHeader settingHeader = PanacheLegalFoundationContext.SettingHeaders .Where(h => h.Id == tenantSettingId) .Where(h => h.SettingType == SettingTypes.SYSTEM) .AsNoTracking() .SingleOrDefault(); if (settingHeader != null) { return(new TenantSetting() { SettingHeaderId = settingHeader.Id, Status = StatusTypes.Open, Value = settingHeader.DefaultValue, Name = settingHeader.Name, Description = settingHeader.Description }); } } return(tenantSetting); }
public UserSetting GetUserSetting(Guid userSettingId, Guid userId, bool readOnly = true) { UserSetting userSetting; if (readOnly) { userSetting = PanacheLegalFoundationContext.UserSettings .Where(u => u.Id == userSettingId) .Where(u => u.UserId == userId) .AsNoTracking() .SingleOrDefault(); } else { userSetting = PanacheLegalFoundationContext.UserSettings .Where(u => u.Id == userSettingId) .Where(u => u.UserId == userId) .SingleOrDefault(); } if (userSetting == null) { SettingHeader settingHeader = PanacheLegalFoundationContext.SettingHeaders .Where(h => h.Id == userSettingId) .Where(h => h.SettingType == SettingTypes.USER) .AsNoTracking() .SingleOrDefault(); if (settingHeader != null) { return(new UserSetting() { SettingHeaderId = settingHeader.Id, Status = StatusTypes.Open, Value = settingHeader.Value }); } } return(userSetting); }
public TenantSetting GetTenantSetting(string tenantSettingName, bool readOnly = true) { TenantSetting tenantSetting = null; SettingHeader settingHeader = PanacheLegalFoundationContext.SettingHeaders .Where(h => h.Name == tenantSettingName) .Where(h => h.SettingType == SettingTypes.SYSTEM) .Include(t => t.TenantSettings) .FirstOrDefault(); if (settingHeader != null) { tenantSetting = settingHeader.TenantSettings.FirstOrDefault(); if (tenantSetting == null) { tenantSetting = new TenantSetting() { SettingHeaderId = settingHeader.Id, Status = StatusTypes.Open, Value = settingHeader.DefaultValue, Name = settingHeader.Name, Description = settingHeader.Description }; } else { if (readOnly) { return(PanacheLegalFoundationContext.TenantSettings.Where(t => t.Id == tenantSetting.Id).AsNoTracking().FirstOrDefault()); } return(PanacheLegalFoundationContext.TenantSettings.Where(t => t.Id == tenantSetting.Id).FirstOrDefault()); } } return(tenantSetting); }
public UserSetting GetUserSetting(string userSettingName, Guid userId, bool readOnly = true) { UserSetting userSetting = null; SettingHeader settingHeader = PanacheLegalFoundationContext.SettingHeaders .Where(h => h.Name == userSettingName) .Where(h => h.SettingType == SettingTypes.USER) .Include(h => h.UserSettings) .FirstOrDefault(); if (settingHeader != null) { userSetting = settingHeader.UserSettings.Where(u => u.UserId == userId).FirstOrDefault(); if (userSetting == null) { userSetting = new UserSetting() { SettingHeaderId = settingHeader.Id, Status = StatusTypes.Open, Value = settingHeader.Value }; } else { if (readOnly) { return(PanacheLegalFoundationContext.UserSettings.Where(u => u.Id == userSetting.Id).AsNoTracking().FirstOrDefault()); } return(PanacheLegalFoundationContext.UserSettings.Where(u => u.Id == userSetting.Id).FirstOrDefault()); } } return(userSetting); }
public static void Write(SettingHeader setting, string value) { WritePrivateProfileString(GetHeader(setting), "VALUE", value, Setting.SettingPath); }
public bool SaveDbSettings(int settingId, string serverName, bool integratedSecurity, string username, string password, string settingName, List <DatabaseViewModel> selectedDbs) { using (var db = new ScriptRunnerDbEntities()) { try { if (settingId == 0) { var settingHeading = new SettingHeader() { IntegratedSecurity = integratedSecurity, Name = settingName, Password = password, Username = username, Server = serverName, }; db.SettingHeaders.Add(settingHeading); db.SaveChanges(); selectedDbs.ForEach(d => { var setting = new Setting() { DbName = d.Name, HeaderId = settingHeading.Id }; db.Settings.Add(setting); db.SaveChanges(); }); } else { var settingHeader = db.SettingHeaders.FirstOrDefault(t => t.Id == settingId); settingHeader.IntegratedSecurity = integratedSecurity; settingHeader.Name = settingName; settingHeader.Password = password; settingHeader.Username = username; settingHeader.Server = serverName; db.SaveChanges(); var savedSettings = db.Settings.Where(t => t.HeaderId == settingId).ToList(); //newly added Settings var newItems = selectedDbs.Where(t => t.Id == 0).ToList(); newItems.ForEach(d => { var setting = new Setting() { DbName = d.Name, HeaderId = settingHeader.Id }; db.Settings.Add(setting); db.SaveChanges(); }); //DeletedDbs var deletedDbs = (from e in savedSettings where !selectedDbs.Any(t => t.Id == e.Id) select e).ToList(); foreach (var item in deletedDbs) { db.Settings.Remove(item); db.SaveChanges(); } } return(true); } catch (Exception ex) { return(false); } } }