// GET: api/Settings
public HttpResponseMessage Get(HttpRequestMessage request)
{
SettingsViewModel viewModel = new SettingsViewModel();
viewModel = _service.GetSettings();
return request.CreateResponse(HttpStatusCode.OK, viewModel);
}
public void SaveSettings(SettingsViewModel settings)
{
Settings formSettings = new Settings
{
AlertsEnabled = settings.AlertsEnabled,
ContactIntervalMinutes = settings.ContactInterval,
RefreshIntervalMinutes = settings.RefreshInterval
};
List<Email> emails = new List<Email>();
string[] emailList = settings.Emails.Split(',');
foreach (var email in emailList)
{
email.Trim();
emails.Add(new Email { EmailAddress = email.Trim() });
}
List<Phone> phones = new List<Phone>();
string[] phoneList = settings.Phones.Split(',');
foreach (var phone in phoneList)
{
phones.Add(new Phone { PhoneNumber = phone.Trim() });
}
try
{
_settingsRepo.SaveSettings(formSettings, emails, phones, settings.Deltas);
}
catch (Exception err)
{
return;
}
}
public SettingsViewModel GetSettings()
{
var dbFactory = new OrmLiteConnectionFactory(
_connectionString,
SqlServerOrmLiteDialectProvider.Instance);
using (IDbConnection dbConnection = dbFactory.OpenDbConnection())
{
Dictionary<string, int> deltas = dbConnection.Dictionary<string, int>("SELECT Name, Delta FROM source");
int refreshInterval = dbConnection.Scalar<int>("SELECT TOP 1 RefreshIntervalMinutes FROM settings");
int contactInterval = dbConnection.Scalar<int>("SELECT TOP 1 ContactIntervalMinutes FROM settings");
bool alertsEnabled = dbConnection.Scalar<bool>("SELECT TOP 1 AlertsEnabled FROM settings");
List<Email> emails = dbConnection.Select<Email>("SELECT EmailAddress FROM email");
List<Phone> phones = dbConnection.Select<Phone>("SELECT PhoneNumber FROM phone");
dbConnection.Close();
string emailString = string.Empty;
string phoneString = string.Empty;
for (int i = 0; i < emails.Count; i++)
{
if (i == emails.Count - 1)
{
emailString += emails[i].EmailAddress;
}
else
{
emailString += emails[i].EmailAddress + ", ";
}
}
for (int i = 0; i < phones.Count; i++)
{
if (i == phones.Count - 1)
{
phoneString += phones[i].PhoneNumber;
}
else
{
phoneString += phones[i].PhoneNumber + ", ";
}
}
SettingsViewModel settings = new SettingsViewModel
{
Deltas = deltas,
Emails = emailString,
Phones = phoneString,
RefreshInterval = refreshInterval,
ContactInterval = contactInterval,
AlertsEnabled = alertsEnabled
};
return settings;
}
}