private static void SyncBrokers(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncBrokers()", LogSeverity.Information, LogCategory.DataAccess);
var response = httpClient.GetAsync("rest/api/broker").Result;
if (response.IsSuccessStatusCode)
{
var serviceBrokers = response.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.Broker>>().Result;
foreach (var serviceBroker in serviceBrokers)
{
if (!consoleRepository.Query<Broker>().Any(cb => cb.BrokerSequenceId == serviceBroker.Id))
{
consoleRepository.Add(new Broker
{
BrokerSequenceId = serviceBroker.Id,
Name = serviceBroker.Name,
Code = serviceBroker.Code,
Psu = serviceBroker.Psu,
GroupCode = serviceBroker.GrpCd
});
}
else
{
var consoleBroker = consoleRepository.Query<Broker>()
.FirstOrDefault(cb => cb.BrokerSequenceId == serviceBroker.Id);
if (consoleBroker != null)
{
consoleBroker.Code = serviceBroker.Code;
consoleBroker.GroupCode = serviceBroker.GrpCd;
consoleBroker.Name = serviceBroker.Name;
consoleBroker.Psu = serviceBroker.Psu;
consoleRepository.Attach(consoleBroker);
}
}
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/broker failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
public HomeModule(IRepository repository)
{
Get["/"] = p =>
{
var feeds = repository.Query(new GetFeedsQuery()).ToArray();
return Negotiate
.WithModel(feeds)
.WithView("home.cshtml");
};
}
private static void UpdateSipAddresses(IRepository consoleRepository)
{
Dictionary<String, String> userSipAddresses = DatabaseInit.GetUserSipAddresses();
foreach (User u in consoleRepository.Query<User>(u => u.IsActive))
{
String shortName = WebSiteModuleManager.ExtractUserName(u.DomainLogon);
if (userSipAddresses.ContainsKey(shortName))
{
String sipAddress = userSipAddresses[shortName];
if (String.IsNullOrEmpty(u.SipAddress))
{
if (!String.IsNullOrEmpty(sipAddress))
u.SipAddress = sipAddress;
}
else
{
if (!u.SipAddress.Equals(sipAddress, StringComparison.InvariantCultureIgnoreCase))
u.SipAddress = sipAddress;
}
}
}
}
private static void UpdateUserPictures(IRepository consoleRepository)
{
Dictionary<String, byte[]> userPictures = DatabaseInit.GetUserPictures();
foreach (User u in consoleRepository.Query<User>(u => u.IsActive))
{
String shortName = WebSiteModuleManager.ExtractUserName(u.DomainLogon);
if (userPictures.ContainsKey(shortName))
{
byte[] userPic = userPictures[shortName];
if ((userPic != null) && (userPic.Length > 0))
{
if ((u.UserThumbnail == null) || (u.UserThumbnail.Length <= 0))
{
u.UserThumbnail = userPic;
}
else
{
if (!u.UserThumbnail.Equals(userPic))
u.UserThumbnail = userPic;
}
}
}
}
}
/// <summary>
/// The create new tags.
/// </summary>
/// <param name="tags">
/// The tags.
/// </param>
/// <param name="tagRepository">
/// The tag repository.
/// </param>
/// <returns>
/// The <see cref="IList"/>.
/// </returns>
/// <exception cref="ArgumentNullException">
/// </exception>
private IList<Tag> CreateNewTags(IList<Tag> tags, IRepository<Tag, int> tagRepository)
{
if (tags == null)
{
throw new ArgumentNullException("tags");
}
IList<Tag> result = new List<Tag>(tags.Count);
for (int i = 0; i < tags.Count; ++i)
{
string content = tags[i].Content;
Tag temp =
tagRepository.Query()
.Filter(p => p.Content.Equals(content, StringComparison.Ordinal))
.Get()
.FirstOrDefault();
if (temp == null)
{
tagRepository.Insert(tags[i]);
result.Add(tags[i]);
}
else
{
result.Add(temp);
}
}
return result;
}
private void GetCategoryData(IRepository _repository)
{
Categories = _repository.Query<Category>(x => x == x);
}
public HomeViewModel(ILog log, IAccount account, ILocalize localize, IApplication application, IHistory history,
INavigationService navigationService, IUser user, IRepository repository,
IList<IExerciseType> exerciseTypes, ISettings settings)
{
_log = log;
_localize = localize;
_application = application;
Account = account;
_history = history;
_history.OnHistoryItemsChanged += _history_OnHistoryItemsChanged;
_NavigationService = navigationService;
User = user;
ExerciseTypes = exerciseTypes;
_repository = repository;
_settings = settings;
_settings.OnSettingsChanged += _settings_OnSettingsChanged;
_settings.Load();
_history.Load();
_repository.Single<User>(1).ContinueWith(t =>
{
var foundUser = t.Result;
if (foundUser == null)
{
//this is first load of the app, set it up
_repository.Insert<User>(this.User).ContinueWith(task =>
{
this.User = this.User;
Account.AccessToken = this.User.RunkeeperToken;
});
}
else
{
User = foundUser;
Account.AccessToken = foundUser.RunkeeperToken;
}
});
if (_exerciseTypes == null || _exerciseTypes.Count == 0 ||
(_exerciseTypes.Count == 1 && _exerciseTypes[0].Id == 0))
{
if (HomeViewModel.cachedTypes != null)
{
this.ExerciseTypes = HomeViewModel.cachedTypes;
_log.Info("cache hit");
}
else
{
_log.Info("cache miss");
this.ExerciseTypes = DefaultTypes;
_log.Info("default types set, querying");
_repository.Query<ExerciseType>("select * from ExerciseType").ContinueWith(t =>
{
_log.Info("query complete");
var types = t.Result;
if (types == null || types.Count == 0)
{
_log.Info("db does not have Exercise types, loading default items");
foreach (var e in from tt in this.ExerciseTypes orderby tt.Id select tt)
{
_repository.Insert<ExerciseType>(e);
}
}
else
{
_log.Info("all excecise types retreived from the db, update local data store");
this.ExerciseTypes = (from tt in types select tt).ToArray();
}
_log.Info("cache extypes to static var");
HomeViewModel.cachedTypes = ExerciseTypes;
});
}
}
}
private static void SyncRiskCodes(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncRiskCodes()", LogSeverity.Information, LogCategory.DataAccess);
var response = httpClient.GetAsync("rest/api/riskcode").Result;
if (response.IsSuccessStatusCode)
{
var serviceRisks = response.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.RiskCode>>().Result;
foreach (var serviceRisk in serviceRisks)
{
if (!consoleRepository.Query<RiskCode>()
.Any(crc => crc.Code == serviceRisk.Code))
{
consoleRepository.Add(new RiskCode
{
Code = serviceRisk.Code,
Name = serviceRisk.Name
});
}
else
{
var consoleRisk = consoleRepository.Query<RiskCode>()
.FirstOrDefault(crc => crc.Code == serviceRisk.Code);
if (consoleRisk != null)
{
consoleRisk.Code = serviceRisk.Code;
consoleRisk.Name = serviceRisk.Name;
consoleRepository.Attach(consoleRisk);
}
}
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/riskcode failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
private static void SyncUnderwriters(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncUnderwriters()", LogSeverity.Information, LogCategory.DataAccess);
var response = httpClient.GetAsync("rest/api/underwriter").Result;
if (response.IsSuccessStatusCode)
{
var serviceUnderwriters = response.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.Underwriter>>().Result;
foreach (var serviceUnderwriter in serviceUnderwriters)
{
if (!consoleRepository.Query<Underwriter>().Any(cu => cu.Code == serviceUnderwriter.Code))
{
consoleRepository.Add(new Underwriter
{
Code = serviceUnderwriter.Code,
Name = serviceUnderwriter.Name
});
}
else
{
var consoleUnderwriter = consoleRepository.Query<Underwriter>()
.FirstOrDefault(b => b.Code == serviceUnderwriter.Code);
if (consoleUnderwriter != null)
{
consoleUnderwriter.Code = serviceUnderwriter.Code;
consoleUnderwriter.Name = serviceUnderwriter.Name;
consoleRepository.Attach(consoleUnderwriter);
}
}
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/underwriter failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
private static void SyncOffices(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncOffices()", LogSeverity.Information, LogCategory.DataAccess);
var response = httpClient.GetAsync("rest/api/office").Result;
if (response.IsSuccessStatusCode)
{
var serviceOffices = response.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.Office>>().Result;
foreach (var serviceOffice in serviceOffices.Where(so => !consoleRepository.Query<Office>()
.Any(co => co.Id == so.Code)))
{
consoleRepository.Add(new Office
{
Id = serviceOffice.Code,
Name = serviceOffice.Name,
Title = serviceOffice.Name
});
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/office failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
private static void SyncCOBs(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncCOBs()", LogSeverity.Information, LogCategory.DataAccess);
var response = httpClient.GetAsync("rest/api/cob").Result;
if (response.IsSuccessStatusCode)
{
var serviceCOBs = response.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.COB>>().Result;
foreach (var serviceCOB in serviceCOBs.Where(sc => !consoleRepository.Query<COB>()
.Any(cc => cc.Id == sc.Code)))
{
consoleRepository.Add(new COB
{
Id = serviceCOB.Code,
Narrative = serviceCOB.Name
});
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/cob failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
private static void SyncNonLondonBrokers(HttpClient httpClient, IRepository consoleRepository)
{
DatabaseInit._LogHandler.WriteLog("SyncNonLondonBrokers()", LogSeverity.Information, LogCategory.DataAccess);
var responseOffices = httpClient.GetAsync("rest/api/office").Result;
if (responseOffices.IsSuccessStatusCode)
{
var serviceOffices = responseOffices.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.Office>>().Result;
foreach (var serviceOffice in serviceOffices)
{
DatabaseInit._LogHandler.WriteLog("SyncNonLondonBrokers()_" + serviceOffice.Code, LogSeverity.Information, LogCategory.DataAccess);
var responseNonLondonBroker = httpClient.GetAsync("rest/api/NonLondonBroker?office=" + serviceOffice.Code).Result;
if (responseNonLondonBroker.IsSuccessStatusCode)
{
var serviceNonLondonBrokers = responseNonLondonBroker.Content.ReadAsAsync<IEnumerable<Validus.Services.Models.NonLondonBroker>>().Result;
foreach (var serviceNonLondonBroker in serviceNonLondonBrokers)
{
if (serviceNonLondonBroker.Code == "NA") continue;
if (!consoleRepository.Query<NonLondonBroker>().Any(cb => cb.Code == serviceNonLondonBroker.Code))
{
consoleRepository.Add(new NonLondonBroker
{
Name = serviceNonLondonBroker.Name,
Code = serviceNonLondonBroker.Code,
});
}
else
{
var consoleNonLondonBroker = consoleRepository.Query<NonLondonBroker>()
.FirstOrDefault(cb => cb.Code == serviceNonLondonBroker.Code);
if (consoleNonLondonBroker != null)
{
consoleNonLondonBroker.Code = serviceNonLondonBroker.Code;
consoleNonLondonBroker.Name = serviceNonLondonBroker.Name;
consoleRepository.Attach(consoleNonLondonBroker);
}
}
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/NonLondonBroker failed_" + serviceOffice.Code, LogSeverity.Warning, LogCategory.DataAccess);
}
}
if (!consoleRepository.Query<NonLondonBroker>().Any(cb => cb.Code == "NA"))
{
consoleRepository.Add(new NonLondonBroker
{
Name = "Not Applicable",
Code = "NA",
});
}
}
else
{
DatabaseInit._LogHandler.WriteLog("Get rest/api/NonLondonBroker failed", LogSeverity.Warning, LogCategory.DataAccess);
}
}
private void SetupSubstitutions()
{
uow = Substitute.For<IUnitOfWork>();
tokenService = Substitute.For<IRepository<ApiToken>>();
tokenService.Query().Returns(FakeTokens);
uow.GetRepository<ApiToken>().Returns(tokenService);
}
