//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 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);
}
private void LoadDatabaseList()
{
var db = new SettingsDataContext();
DatabaseComboBox.DataSource = db.LookupQueryLayerServers;
DatabaseComboBox.DisplayMember = "Location";
//DatabaseComboBox.ValueMember = "Connection";
}
