private void InitializeForCountyAdmin()
{
DialogCredentialMessage.InnerHtml = "Your sign-in credentials allow only " +
Counties.GetFullName(_SecureAdminPage.StateCode,
_SecureAdminPage.CountyCode) + " local districts to be selected.";
StateName.InnerHtml = States.GetName(_SecureAdminPage.StateCode);
StateDropDownList.AddCssClasses("hidden");
StateRadioButton.AddCssClasses("invisible");
CountyName.InnerHtml = Counties.GetName(_SecureAdminPage.StateCode,
_SecureAdminPage.CountyCode);
CountyDropDownList.AddCssClasses("hidden");
LocalName.AddCssClasses("hidden");
switch (_SecureAdminPage.AdminPageLevel)
{
case AdminPageLevel.County:
CountyRadioButton.Checked = true;
PopulateLocalDropDown(true);
break;
case AdminPageLevel.Local:
LocalRadioButton.Checked = true;
PopulateLocalDropDown();
break;
}
}
static async Task SaveCountiesToDbAsync(Counties counties)
{
using (FloridaCountiesDbContext dbContext = InitDb()) {
Console.WriteLine("Cleaning Counties table...");
await dbContext.Database.ExecuteSqlRawAsync(@"DELETE FROM tblCounties");
//Cascade deletion ensures cities are deleted as well
Console.Write("Saving data to the DB...");
dbContext.Counties.AddRange(counties.features.Select(feature => new FloridaCounty()
{
Id = int.Parse(feature.attributes.COUNTY),
DepCode = feature.attributes.DEPCODE,
EsriId = feature.attributes.OBJECTID,
Name = feature.attributes.COUNTYNAME != "DADE" ? feature.attributes.COUNTYNAME : "MIAMI-DADE",
Shape = feature.geometry
}));
await dbContext.SaveChangesAsync();
Console.WriteLine("COMPLETE.");
Console.Write("Parsing cities....");
IEnumerable <FloridaCity> cities = PopulateCitiesFromJsonFile(dbContext);
dbContext.AddRange(cities);
Console.WriteLine("COMPLETE.");
Console.Write("Saving cities to DB....");
await dbContext.SaveChangesAsync();
Console.WriteLine("COMPLETE.");
Console.WriteLine(" DONE!");
}
}
private void AnalyzeDeletions(string address)
{
var found = false;
found |= AnalyzeCount(States.CountByEmail(address), address, "States.Email");
found |= AnalyzeCount(States.CountByAltEmail(address), address, "States.AltEmail");
found |= AnalyzeCount(Counties.CountByEmail(address), address, "Counties.Email");
found |= AnalyzeCount(Counties.CountByAltEmail(address), address, "Counties.AltEmail");
found |= AnalyzeCount(LocalDistricts.CountByEmail(address), address, "LocalDistricts.Email");
found |= AnalyzeCount(LocalDistricts.CountByAltEmail(address), address,
"LocalDistricts.AltEmail");
found |= AnalyzeCount(Politicians.CountByEmail(address), address, "Politicians.Email");
found |= AnalyzeCount(Politicians.CountByCampaignEmail(address), address,
"Politicians.CampaignEmail");
found |= AnalyzeCount(Politicians.CountByEmailVoteUSA(address), address,
"Politicians.EmailVoteUSA");
found |= AnalyzeCount(Politicians.CountByStateEmail(address), address,
"Politicians.StateEmail");
//found |= AnalyzeCount(Politicians.CountByLDSEmail(address), address, "Politicians.LDSEmail");
found |= AnalyzeCount(Addresses.EmailExists(address) ? 1 : 0, address, "Addresses.Email");
found |= AnalyzeCount(PartiesEmails.PartyEmailExists(address) ? 1 : 0, address,
"PartiesEmails.PartyEmail");
if (!found)
{
_Messages.Add($"<p class=\"error\">{address} not found</p>");
}
}
static Counties PopulateCountiesFromJsonFile()
{
Counties fileContent = null;
using (StreamReader jsonStreamReader = File.OpenText(COUNTIES_JSON_DATAFILE)) {
using (JsonTextReader jsonTextReader = new JsonTextReader(jsonStreamReader)) {
jsonTextReader.SupportMultipleContent = false;
JsonSerializer jsonSerializer = new JsonSerializer();
while (jsonTextReader.Read())
{
if (jsonTextReader.TokenType == JsonToken.StartObject)
{
fileContent = jsonSerializer.Deserialize <Counties>(jsonTextReader);
}
}
}
}
if (fileContent is null)
{
DisplayError($"Unable to parse json file: {COUNTIES_JSON_DATAFILE}");
}
else
{
Console.WriteLine($"Counties data has been parsed and loaded from {COUNTIES_JSON_DATAFILE}...");
}
return(fileContent);
}
private void SetSubHeading()
{
switch (AdminPageLevel)
{
case AdminPageLevel.President:
case AdminPageLevel.PresidentTemplate:
case AdminPageLevel.Federal:
H2.InnerHtml = States.GetName(StateCode) + ", All States";
break;
case AdminPageLevel.State:
H2.InnerHtml = "State Elections for " + States.GetName(StateCode);
break;
case AdminPageLevel.County:
H2.InnerHtml = "County Elections for " +
Counties.GetFullName(StateCode, CountyCode);
break;
case AdminPageLevel.Local:
H2.InnerHtml = "Local Elections for " +
LocalDistricts.GetFullName(StateCode, CountyCode, LocalKey);
int countyCount;
if ((countyCount = FormatOtherCountiesMessage(MultiCountyMessage)) > 1)
{
MultiCountyMessage.InnerText +=
$". Changes you make to elections will appear in {(countyCount == 2 ? "both" : "all")} counties.";
}
break;
case AdminPageLevel.Unknown:
H2.InnerHtml = "No Jurisdiction Selected";
break;
}
}
private void SetSubHeading()
{
switch (AdminPageLevel)
{
//case AdminPageLevel.President:
//case AdminPageLevel.PresidentTemplate:
//case AdminPageLevel.Federal:
// H2.InnerHtml = States.GetName(StateCode) + ", All States";
// break;
case AdminPageLevel.AllStates:
H2.InnerHtml = "Bulk Email for All States";
break;
case AdminPageLevel.State:
H2.InnerHtml = "Bulk Email for " + States.GetName(StateCode);
break;
case AdminPageLevel.County:
H2.InnerHtml = "Bulk Email for " +
Counties.GetFullName(StateCode, CountyCode);
break;
case AdminPageLevel.Local:
H2.InnerHtml = "Bulk Email for " +
LocalDistricts.GetFullName(StateCode, CountyCode, LocalCode);
break;
case AdminPageLevel.Unknown:
H2.InnerHtml = "No Jurisdiction Selected";
break;
}
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in Counties.ToList())
{
x.DeleteFull(dbContext);
}
}
// ReSharper restore UnassignedField.Global
// ReSharper restore UnusedAutoPropertyAccessor.Global
// ReSharper restore UnusedMethodReturnValue.Global
// ReSharper restore UnusedMember.Global
// ReSharper restore MemberCanBeProtected.Global
// ReSharper restore MemberCanBePrivate.Global
#endregion ReSharper restore
#endregion Public
#region Private
private void SetCredentialMessage()
{
switch (UserSecurityClass)
{
case MasterSecurityClass:
CredentialMessage.InnerHtml =
"Your sign-in credentials allow access to all bulk mail capabilities.";
break;
case StateAdminSecurityClass:
CredentialMessage.InnerHtml =
"Your sign-in credentials permit bulk mailing to any " +
States.GetName(StateCode) + " recipients.";
break;
case CountyAdminSecurityClass:
CredentialMessage.InnerHtml =
"Your sign-in credentials permit bulk mailing only to " +
Counties.GetFullName(StateCode, CountyCode) + " recipients.";
break;
case LocalAdminSecurityClass:
CredentialMessage.InnerHtml =
"Your sign-in credentials permit bulk mailing only to " +
LocalDistricts.GetFullName(StateCode, CountyCode, LocalCode) +
" recipients.";
break;
default:
throw new VoteException("Unexpected UserSecurityClass: " +
UserSecurityClass);
}
}
//private string GetOfficeKey()
//{
// return SelectedOfficeKey.Value;
//}
private void SetCredentialMessage()
{
switch (UserSecurityClass)
{
case MasterSecurityClass:
CredentialMessage.InnerHtml = IsSuperUser
? "Your sign-in credentials allow any election to be updated."
: "Your sign-in credentials allow any federal, state, county or local election to be updated.";
break;
case StateAdminSecurityClass:
CredentialMessage.InnerHtml = "Your sign-in credentials permit any " +
States.GetName(StateCode) + " election to be updated.";
break;
case CountyAdminSecurityClass:
CredentialMessage.InnerHtml = "Your sign-in credentials permit only " +
Counties.GetFullName(StateCode, CountyCode) +
" elections to be updated.";
break;
case LocalAdminSecurityClass:
CredentialMessage.InnerHtml = "Your sign-in credentials permit only " +
LocalDistricts.GetFullName(StateCode, CountyCode, LocalKey) +
" elections to be updated.";
SelectJurisdictionButton.Visible = false;
break;
default:
throw new VoteException("Unexpected UserSecurityClass: " +
UserSecurityClass);
}
}
private void SetSubHeading()
{
switch (AdminPageLevel)
{
//case AdminPageLevel.President:
//case AdminPageLevel.PresidentTemplate:
//case AdminPageLevel.Federal:
// H2.InnerHtml = States.GetName(StateCode) + ", All States";
// break;
case AdminPageLevel.State:
H2.InnerHtml = "State Offices for " + States.GetName(StateCode);
break;
case AdminPageLevel.County:
H2.InnerHtml = "County Offices for " +
Counties.GetFullName(StateCode, CountyCode);
break;
case AdminPageLevel.Local:
H2.InnerHtml = "Local Offices for " +
LocalDistricts.GetFullName(StateCode, CountyCode, LocalKey);
FormatOtherCountiesMessage(MuliCountyMessage);
break;
case AdminPageLevel.Unknown:
H2.InnerHtml = "No Jurisdiction Selected";
break;
}
}
private Control GenerateReportByJurisdiction(string stateCode, string countyCode, string localKey)
{
ReportContainer.ID = "new-accordions";
ReportContainer.ClientIDMode = ClientIDMode.Static;
stateCode = stateCode.ToUpperInvariant();
_DataManager.GetDataByJurisdiction(stateCode, countyCode, localKey);
var issueLevelGroups = _DataManager.GetDataSubset()
.GroupBy(row => new
{
IssueGroupId = row.IssueGroupId(),
IssueId = row.IssueId()
})
.ToList()
.GroupBy(g => g.Key.IssueGroupId)
.ToList()
.GroupBy(g => g.First().First()
.IssueLevel())
.OrderBy(g => g.Key)
.ToList();
foreach (var issueLevelGroup in issueLevelGroups)
{
switch (issueLevelGroup.Key)
{
case Issues.IssueLevelAll:
OneReportSection(issueLevelGroup,
"Questions Available to All Candidates");
break;
case Issues.IssueLevelNational:
OneReportSection(issueLevelGroup,
"Questions Available to U.S. President, U.S. House and U.S. Senate Candidates");
break;
case Issues.IssueLevelState:
OneReportSection(issueLevelGroup,
$"Questions Available to {StateCache.GetStateName(stateCode)}" +
" Statewide, House and Senate Candidates");
break;
case Issues.IssueLevelCounty:
OneReportSection(issueLevelGroup,
$"Questions Available to {Counties.GetName(stateCode, countyCode)}" +
$" ({stateCode}) Candidates");
break;
case Issues.IssueLevelLocal:
OneReportSection(issueLevelGroup,
$"Questions Available to {LocalDistricts.GetName(stateCode, localKey)}" +
$" ({stateCode}) Candidates");
break;
}
}
return(ReportContainer.AddCssClasses("issue-list-report accordion-container"));
}
static async Task Main(string[] args)
{
//await PopulateFromAPI();
Counties counties = PopulateCountiesFromJsonFile();
await SaveCountiesToDbAsync(counties);
}
private static void CheckForFatalCredentialingProblems(string usernameEntered)
{
switch (UserSecurityClass)
{
case MasterSecurityClass:
// no additional info needed
break;
case StateAdminSecurityClass:
if (!StateCache.IsValidStateCode(UserStateCode))
{
HandleCredentialingInconsistency(usernameEntered, "Invalid StateCode");
}
break;
case CountyAdminSecurityClass:
if (!Counties.StateCodeCountyCodeExists(UserStateCode, UserCountyCode))
{
HandleCredentialingInconsistency(usernameEntered, "Invalid CountyCode");
}
break;
case LocalAdminSecurityClass:
//if (!LocalDistricts.StateCodeCountyCodeLocalCodeExists(
// UserStateCode, UserCountyCode, UserLocalCode))
// HandleCredentialingInconsistency(usernameEntered, "Invalid LocalCode");
break;
case PartySecurityClass:
if (!Parties.PartyKeyExists(UserPartyKey))
{
HandleCredentialingInconsistency(usernameEntered, "Invalid PartyKey");
}
break;
case PoliticianSecurityClass:
// no additional info needed --
// they couldn't get this far without a valid politician key
break;
case DesignSecurityClass:
if (!DomainDesigns.DomainDesignCodeExists(UserDesignCode))
{
HandleCredentialingInconsistency(usernameEntered, "Invalid DesignCode");
}
break;
case OrganizationSecurityClass:
if (!Organizations.OrganizationCodeExists(UserOrganizationCode))
{
HandleCredentialingInconsistency(
usernameEntered, "Invalid OrganizationCode");
}
break;
}
}
/// <summary>
/// Active Dependent type names of this object
/// </summary>
public List <string> DependentObjectNames()
{
var dependentObjects = new List <string>();
if (Counties.Any())
{
dependentObjects.Add(typeof(County).Name);
}
return(dependentObjects.Distinct().ToList());
}
public async Task <ActionResult> SaveLibraryUser(LibraryUserViewModel viewModel)
{
if (viewModel.CountyIds != null && viewModel.CountyIds.Length > 0)
{
viewModel.County = viewModel.CountyIds[0];
}
if (viewModel.CountryIds != null && viewModel.CountryIds.Length > 0)
{
viewModel.Country = viewModel.CountryIds[0];
}
if (!ModelState.IsValid)
{
viewModel.Counties = Counties.PopulateCountySelectList(viewModel.County);
viewModel.Countries = Countries.PopulateCountrySelectList(viewModel.Country);
return(View("LibraryUser", viewModel));
}
string currentCode = string.Empty;
if (string.IsNullOrEmpty(viewModel.LibraryUserCode))
{
var insertResponse = await _libraryUserClient.Insert(viewModel.GetApiModel());
if (!insertResponse.StatusIsSuccessful)
{
AddResponseErrorsToModelState(insertResponse);
}
else
{
//viewModel.Id = insertResponse.ResponseResult;
currentCode = insertResponse.ResponseResult;
TempData["SuccessMessage"] = "Record Inserted";
}
}
else
{
currentCode = viewModel.LibraryUserCode;
var response = await _libraryUserClient.Update(viewModel.GetApiModel());
if (!response.StatusIsSuccessful)
{
AddResponseErrorsToModelState(response);
}
else
{
TempData["SuccessMessage"] = "Record Updated";
}
}
viewModel.Counties = Counties.PopulateCountySelectList(viewModel.County);
viewModel.Countries = Countries.PopulateCountrySelectList(viewModel.Country);
return(View("LibraryUser", viewModel));
}
public override void Start()
{
base.Start();
try
{
SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0);
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0);
SelectedWard = Wards.FirstOrDefault(x => x.Id == 0);
}
catch { }
}
/// <summary>
/// Dependent type names of this entity
/// </summary>
public void DeleteChildren(DatabaseEntities dbContext)
{
foreach (var x in Counties.ToList())
{
x.DeleteFull(dbContext);
}
foreach (var x in StormwaterJurisdictions.ToList())
{
x.DeleteFull(dbContext);
}
}
static CountyCache()
{
var table = Counties.GetAllCacheData();
CountyNameDictionary =
table.ToDictionary(row => MakeKey(row.StateCode, row.CountyCode),
row => row.County, StringComparer.OrdinalIgnoreCase);
CountiesByStateDictionary = table.GroupBy(row => row.StateCode)
.ToDictionary(g => g.Key,
g => g.OrderBy(row => row.County, StringComparer.OrdinalIgnoreCase)
.Select(row => row.CountyCode)
.ToList()
.AsReadOnly());
}
/**
* Read all county files
*/
private void ReadCounties()
{
var selectedCounties = ReadSelectedCounties();
//Read county files
foreach (string filePath in Directory.EnumerateFiles(Configuration.GetSetting(Configuration.INPUT_DIRECTORY)))
{
County county = ReadCounty(filePath, selectedCounties);
if (county != null)
{
Counties.Add(county);
}
}
CountiesRead?.Invoke();
}
/// <summary>
/// Lookups the county by fips.
/// </summary>
/// <param name="countyFIPS">The county fips.</param>
/// <param name="stateFIPS">The state fips.</param>
/// <returns></returns>
private static County LookupCountyByFIPS(string countyFIPS, string stateFIPS)
{
int cFips;
if (int.TryParse(countyFIPS, out cFips))
{
int sFips;
if (int.TryParse(stateFIPS, out sFips))
{
string countyCode = String.Format("{0:D2}{1:D3}", sFips, cFips);
return(Counties.FirstOrDefault(c => c.CountyFIPS.Equals(countyCode)));
}
}
return(null);
}
public static string GetSpreadsheetListHtml(bool all = false, int?id = null)
{
var table = all
? ElectionSpreadsheets.GetAllListData()
: ElectionSpreadsheets.GetListDataByCompleted(false);
if (table.Count == 0)
{
return("<div>No spreadsheets found</div>");
}
// get a dictionary of election descriptions
var dictionary =
Elections.GetElectionDescriptions(table.Select(recordStates =>
recordStates.ElectionKey));
// append jurisdictions
var mods = new List <KeyValuePair <string, string> >();
foreach (var kvp in dictionary)
{
if (!Elections.IsStateElection(kvp.Key))
{
var stateCode = Elections.GetStateCodeFromKey(kvp.Key);
var jurisdiction = Elections.IsCountyElection(kvp.Key)
? Counties.GetCounty(stateCode, Elections.GetCountyCodeFromKey(kvp.Key))
: LocalDistricts.GetLocalDistrict(stateCode, Elections.GetLocalKeyFromKey(kvp.Key));
mods.Add(new KeyValuePair <string, string>(kvp.Key, jurisdiction));
}
}
foreach (var kvp in mods)
{
dictionary[kvp.Key] += ", " + kvp.Value;
}
return(Join(Empty,
table.OrderByDescending(r => r.UploadTime).Select(r =>
$"<div data-completed=\"{r.Completed.ToString().ToLower()}\"" +
$" data-id=\"{r.Id}\" data-rows=\"{r.Rows}\"" +
$"{(r.Id == id ? " class=\"selected\"" : Empty)}>" +
$"{r.Filename} ({r.UploadTime:d}: {dictionary[r.ElectionKey]}" +
$"{(r.ElectionScope == "A" ? " et. al." : Empty)}" +
$"{(r.JurisdictionScope == "S" ? ", state level only" : Empty)})</div>")));
}
private void initCommonData()
{
if (doOnce)
{
return;
}
doOnce = true;
Stopwatch sw = new Stopwatch();
sw.Start();
Counties.GetAllCounties();
Debug.WriteLine(" -GetAllCounties time in millisec:" + sw.ElapsedMilliseconds);
sw.Restart();
Master.Lists.Clients.GetAllClients();
Master.Lists.Users.GetAllUsers();
Debug.WriteLine(" -GetAllClients & GetAllUsers time in millisec:" + sw.ElapsedMilliseconds);
}
protected override bool Update(object newValue)
{
switch (Page.AdminPageLevel)
{
case AdminPageLevel.State:
States.UpdateColumn(StatesColumn, newValue, Page.StateCode);
break;
case AdminPageLevel.County:
Counties.UpdateColumn(CountiesColumn, newValue, Page.StateCode, Page.CountyCode);
break;
case AdminPageLevel.Local:
LocalDistricts.UpdateColumnByStateCodeLocalKey(LocalDistrictsColumn, newValue,
Page.StateCode, Page.LocalKey);
break;
}
return(true);
}
/// <summary>
/// Check that data is valid.
/// </summary>
public override void CheckData()
{
base.CheckData();
LocationSearchString = LocationSearchString.CheckSqlInjection();
if (Counties.IsNotEmpty())
{
foreach (WebCounty county in Counties)
{
county.CheckData();
}
}
if (Provinces.IsNotEmpty())
{
foreach (WebProvince province in Provinces)
{
province.CheckData();
}
}
}
private void DoDeletions(string address)
{
var found = false;
found |= DeletionCount(States.UpdateEmailByEmail(Empty, address), address,
"States.Email");
found |= DeletionCount(States.UpdateAltEmailByAltEmail(Empty, address),
address, "States.AltEmail");
found |= DeletionCount(Counties.UpdateEmailByEmail(Empty, address), address,
"Counties.Email");
found |= DeletionCount(Counties.UpdateAltEmailByAltEmail(Empty, address),
address, "Counties.AltEmail");
found |= DeletionCount(LocalDistricts.UpdateEmailByEmail(Empty, address),
address, "LocalDistricts.Email");
found |= DeletionCount(LocalDistricts.UpdateAltEmailByAltEmail(Empty, address),
address, "LocalDistricts.AltEmail");
found |= DeletionCount(Politicians.UpdateEmailByEmail(null, address), address,
"Politicians.Email");
found |= DeletionCount(
Politicians.UpdateCampaignEmailByCampaignEmail(Empty, address), address,
"Politicians.CampaignEmail");
found |= DeletionCount(
Politicians.UpdateEmailVoteUSAByEmailVoteUSA(Empty, address), address,
"Politicians.EmailVoteUSA");
found |= DeletionCount(
Politicians.UpdateStateEmailByStateEmail(Empty, address), address,
"Politicians.StateEmail");
if (Addresses.EmailExists(address))
{
Addresses.DeleteByEmail(address);
found |= DeletionCount(1, address, "Addresses");
}
found |= DeletionCount(PartiesEmails.DeleteByPartyEmail(address), address,
"PartiesEmails.PartyEmail");
found |= DeletionCount(
OrganizationContacts.UpdateEmailByEmail(Empty, address), address,
"OrganizationContacts.Email");
if (!found)
{
_Messages.Add($"<p class=\"error\">{address} not found</p>");
}
}
/// <summary>
/// Get counties from web service.
/// </summary>
private static void LoadCounties()
{
CountyList counties;
if (Counties.IsNull())
{
// Get data from web service.
counties = new CountyList();
foreach (WebCounty webCounty in WebServiceClient.GetCounties())
{
counties.Add(new County(webCounty.Id,
webCounty.Name,
webCounty.Identifier,
webCounty.IsNumberSpecified,
webCounty.Number,
webCounty.IsCountyPart,
webCounty.PartOfCountyId));
}
Counties = counties;
}
}
private void AddLocalsMenu(Control ul)
{
// County Admins always see a local menu
// Masters and State Admins see it if they are on a County or Local Admin page
string stateCode = null;
string countyCode = null;
if (SecurePage.IsCountyAdminUser ||
((SecurePage.IsMasterUser || SecurePage.IsStateAdminUser) &&
(SecurePage.IsCountyAdminPage || SecurePage.IsLocalAdminPage)))
{
stateCode = SecurePage.GetViewStateStateCode();
countyCode = SecurePage.GetViewStateCountyCode();
}
if ((stateCode != null) && (countyCode != null))
{
AddMenuItem(ul, Counties.GetCounty(stateCode, countyCode),
GetLocalsMenu(
"/admin?state={StateCode}&county={CountyCode}&local={LocalCode}",
stateCode, countyCode));
}
}
protected override string GetCurrentValue()
{
switch (Page.AdminPageLevel)
{
case AdminPageLevel.State:
return
((States.GetColumn(StatesColumn, Page.StateCode) ?? Empty).ToString());
case AdminPageLevel.County:
return
((Counties.GetColumn(CountiesColumn, Page.StateCode, Page.CountyCode) ??
Empty).ToString());
case AdminPageLevel.Local:
return
((LocalDistricts.GetColumnByStateCodeLocalKey(LocalDistrictsColumn,
Page.StateCode, Page.LocalKey) ?? Empty).ToString());
default:
return(null);
}
}
public override void LoadFromStore(VMStore modelStore)
{
try
{
ContactAddress = JsonConvert.DeserializeObject <ClientContactAddressDTO>(modelStore.Store);
PersonId = ContactAddress.PersonId;
Downloaded = ContactAddress.Downloaded;
Telephone = ContactAddress.Phone;
Landmark = ContactAddress.Landmark;
ContactId = ContactAddress.ContactId;
AddressId = ContactAddress.AddressId;
SelectedCounty = Counties.FirstOrDefault(x => x.Id == 0);
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == 0);
SelectedWard = Wards.FirstOrDefault(x => x.Id == 0);
if (ContactAddress.CountyId.HasValue && ContactAddress.CountyId.Value > 0)
{
SelectedCounty = Counties.FirstOrDefault(x => x.Id == ContactAddress.CountyId);
GetSubCounties();
}
if (ContactAddress.SubCountyId.HasValue && ContactAddress.SubCountyId.Value > 0)
{
SelectedSubCounty = SubCounties.FirstOrDefault(x => x.Id == ContactAddress.SubCountyId);
GetWards();
}
if (ContactAddress.WardId.HasValue && ContactAddress.WardId.Value > 0)
{
SelectedWard = Wards.FirstOrDefault(x => x.Id == ContactAddress.WardId);
}
}
catch (Exception e)
{
Mvx.Error(e.Message);
}
}
public void DataTable_ContainsRkiColumns()
{
var sut = CreateExportDefinition();
var county = Counties.First();
Sending.SamplingLocation = SamplingLocation.Other;
Sending.OtherSamplingLocation = "Other Location";
Sending.Patient.BirthDate = new DateTime(2005, 8, 31);
Sending.Patient.County = county.Name;
Sending.Patient.State = State.BB;
Sending.Patient.Gender = Gender.Female;
Sending.Patient.HibVaccination = VaccinationStatus.Yes;
Sending.Isolate.Evaluation = Evaluation.HaemophilusTypeA;
Sending.Isolate.BetaLactamase = TestResult.Negative;
var export = sut.ToDataTable(Sendings);
export.Rows[0]["klhi_nr"].Should().Be(Sending.Isolate.StemNumber);
export.Rows[0]["eing"].ToString().Should().Match("??.??.????");
export.Rows[0]["ent"].ToString().Should().Match("??.??.????");
export.Rows[0]["mat"].Should().Be("Other Location");
export.Rows[0]["geb_monat"].Should().Be(8);
export.Rows[0]["geb_jahr"].Should().Be(2005);
export.Rows[0]["geschlecht"].Should().Be("w");
export.Rows[0]["hib_impf"].Should().Be("Ja");
export.Rows[0]["styp"].Should().Be("Hia");
export.Rows[0]["b_lac"].Should().Be("negativ");
export.Rows[0]["kreis_nr"].Should().Be(county.CountyNumber);
export.Rows[0]["bundesland"].Should().Be("12");
export.Rows[0]["einsender"].Should().Be(Sending.SenderId);
export.Rows[0]["landkreis"].Should().Be(Sending.Patient.County);
export.Rows[0]["bundeslandName"].Should().Be("Brandenburg");
export.Rows[0]["ampicillinMHK"].Should().Be(2.0);
export.Rows[0]["ampicillinBewertung"].Should().Be("resistent");
export.Rows[0]["amoxicillinClavulansaeureMHK"].Should().Be(0.75);
export.Rows[0]["bewertungAmoxicillinClavulansaeure"].Should().Be("sensibel");
}
