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 void Update(BusinessObjects.Model entity)
{
using (_ModelRepository = new GenericRepository<DAL.DataEntities.Model>())
{
entity.LastModifiedDate = DateTime.Now;
//
_ModelRepository.Attach((DAL.DataEntities.Model)entity.InnerEntity);
_ModelRepository.SaveChanges();
}
}
public void Update(BusinessObjects.Attribute entity)
{
using (_AttributeRepository = new GenericRepository<DAL.DataEntities.Attribute>())
{
//Update the Attribute
_AttributeRepository.Attach((DAL.DataEntities.Attribute)entity.InnerEntity);
_AttributeRepository.SaveChanges();
}
}
public void Update(BusinessObjects.CustomRule entity)
{
using (_CustomRuleRepository = new GenericRepository<DAL.DataEntities.CustomRule>())
{
//
_CustomRuleRepository.Attach((DAL.DataEntities.CustomRule)entity.InnerEntity);
_CustomRuleRepository.SaveChanges();
}
}
public void Update(BusinessObjects.Relation entity)
{
using (_RelationRepository = new GenericRepository<DAL.DataEntities.Relation>())
{
//
_RelationRepository.Attach((DAL.DataEntities.Relation)entity.InnerEntity);
_RelationRepository.SaveChanges();
}
}
public void Update(BusinessObjects.Feature entity)
{
using (_FeatureRepository = new GenericRepository<DAL.DataEntities.Feature>())
{
//Update the Feature
_FeatureRepository.Attach((DAL.DataEntities.Feature)entity.InnerEntity);
_FeatureRepository.SaveChanges();
}
}
public void Update(BusinessObjects.Configuration entity)
{
using (_ConfigurationRepository = new GenericRepository<DAL.DataEntities.Configuration>())
{
entity.LastModifiedDate = DateTime.Now;
//
_ConfigurationRepository.Attach((DAL.DataEntities.Configuration)entity.InnerEntity);
_ConfigurationRepository.SaveChanges();
}
}
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 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);
}
}
public void Update(BusinessObjects.Constraint entity)
{
using (_ConstraintRepository = new GenericRepository<DAL.DataEntities.Constraint>())
{
//
_ConstraintRepository.Attach((DAL.DataEntities.Constraint)entity.InnerEntity);
_ConstraintRepository.SaveChanges();
}
}
public void Update(BLL.BusinessObjects.UITemplate entity)
{
using (_UITemplateRepository = new GenericRepository<DAL.DataEntities.UITemplate>())
{
entity.LastModifiedDate = DateTime.Now;
//
_UITemplateRepository.Attach((DAL.DataEntities.UITemplate)entity.InnerEntity);
_UITemplateRepository.SaveChanges();
}
}
public void Update(BusinessObjects.FeatureSelection entity)
{
using (_FeatureSelectionRepository = new GenericRepository<DAL.DataEntities.FeatureSelection>())
{
//Update the FeatureSelection
_FeatureSelectionRepository.Attach((DAL.DataEntities.FeatureSelection)entity.InnerEntity);
_FeatureSelectionRepository.SaveChanges();
//Update AttributeValues
using (_AttributeValuesRepository = new GenericRepository<DAL.DataEntities.AttributeValue>())
{
for (int i = entity.AttributeValues.Count - 1; i >= 0; i--)
{
BLL.BusinessObjects.AttributeValue BLLAttributeValue = entity.AttributeValues[i];
BLLAttributeValue.FeatureSelectionID = entity.ID;
//Add
if (BLLAttributeValue.ToBeDeleted == false && BLLAttributeValue.ID == 0)
{
_AttributeValuesRepository.Add((DAL.DataEntities.AttributeValue)BLLAttributeValue.InnerEntity);
}
//Update
else if (BLLAttributeValue.ToBeDeleted == false && BLLAttributeValue.ID != 0)
{
_AttributeValuesRepository.Attach((DAL.DataEntities.AttributeValue)BLLAttributeValue.InnerEntity);
}
}
_AttributeValuesRepository.SaveChanges();
}
}
}
