//This should be kept in sync with CollarInfo.cs in the SqlServer_Files project private LookupCollarFileFormat GetFormat() { try { char code = '?'; //get the first line of the file var fileHeader = ReadHeader(Contents, Encoding.UTF8, 500).Trim().Normalize(); //database for header is only 450 char var db = new SettingsDataContext(); foreach (var format in db.LookupCollarFileHeaders) { var header = format.Header.Normalize(); var regex = format.Regex; if (fileHeader.StartsWith(header, StringComparison.OrdinalIgnoreCase) || (regex != null && new Regex(regex).IsMatch(fileHeader))) { code = format.FileFormat; break; } } if (code == '?' && new ArgosEmailFile(Contents).GetPrograms().Any()) { // We already checked for ArgosAwsFile with the header code = 'E'; } return(Database.LookupCollarFileFormats.FirstOrDefault(f => f.Code == code)); } catch (Exception) { return(null); } }
private void LoadDatabaseList() { var db = new SettingsDataContext(); DatabaseComboBox.DataSource = db.LookupQueryLayerServers; DatabaseComboBox.DisplayMember = "Location"; //DatabaseComboBox.ValueMember = "Connection"; }
private string GetArgosFromFormatB() { //the first column is the Argos ID, if more than one, then return none try { var checkForHeader = true; var db = new SettingsDataContext(); string argosId = null; var header = db.LookupCollarFileHeaders.First(h => h.FileFormat == 'B').Header; foreach (var line in ReadLines(Contents, Encoding.UTF8)) { //skip the first line if it looks like the header if (checkForHeader && line.Normalize().StartsWith(header, StringComparison.OrdinalIgnoreCase)) { checkForHeader = false; continue; } //skip empty/blank lines if (string.IsNullOrEmpty(line.Replace(',', ' ').Trim())) { continue; } var newArgosId = line.Substring(0, line.IndexOf(",", StringComparison.OrdinalIgnoreCase)); if (argosId == null) { argosId = newArgosId; checkForHeader = false; } if (newArgosId != argosId) { return(null); } } return(argosId); } catch (Exception) { return(null); } }
private void Settings_Load(object sender, EventArgs e) { radioButton1.Checked = true; SQLiteDatabaseWorker worker = new SQLiteDatabaseWorker(); worker.SetConnect(Program.DBName); SettingsDataContext sdc = worker.GetSettings(); // настройки worker.CloseConnect(); regionid = FindRegionIdByCityId(sdc.cityID); yacityId = sdc.cityID; getYandex(FindRegionIdByCityId(sdc.cityID)); tempid = sdc.cityID; FillComboBox2(FindRegionIdByCityId(sdc.cityID), tempid); if (sdc.sourceID == 2) { radioButton1.Checked = true; } if (sdc.sourceID == 1) { radioButton2.Checked = true; } }
public SettingsView() { DataContext = new SettingsDataContext(); InitializeComponent(); }
public static string GetSystemDefault(string key) { var db = new SettingsDataContext(); Setting setting = db.Settings.FirstOrDefault(s => s.Username == SystemUsername && s.Key == key); return setting == null ? null : setting.Value; }
private static void SetUsersDefault(string key, string value) { var db = new SettingsDataContext(); try { db.Settings_Update(key, value); } catch (Exception ex) { Debug.Print("Unable to save settings (u:{0},k:{1},v:{2}, exception:{3}", GetUserName(), key, value, ex.Message); } }
private static string GetUsersDefault(string key) { var db = new SettingsDataContext(); var user = GetUserName(); Setting setting = db.Settings.FirstOrDefault(s => s.Username == user && s.Key == key); return setting == null ? null : setting.Value; }
public static bool PiWantsEmails(string address) { var database = new AnimalMovementDataContext(); var pi = database.ProjectInvestigators.FirstOrDefault(p => p.Email == address); if (pi == null) return false; var db = new SettingsDataContext(); var setting = db.Settings.FirstOrDefault(s => s.Username == pi.Login && s.Key == WantsEmailKey); //default is to get email, unless explicitly and correctly denied return setting == null || setting.Value != false.ToString(CultureInfo.InvariantCulture); }