private static CrossSectionElevationDTO CreatePhonyElevation(int index)
{
CrossSectionElevationDTO dto = new CrossSectionElevationDTO();
dto.SurveyId = string.Format("SurveyId {0}", index);
dto.DistanceFromOrigin = Parsing.ParseDouble("");
dto.Elevation = Parsing.ParseDouble("");
dto.Comments = string.Format("Comments {0}", index);
return(dto);
}
private void LoadRow(string sheetName, Dictionary <string, string> values)
{
ValidationIssues issues = generalDet.ValidationIssues;
if (sheetName == "DET_Surveys")
{
CrossSectionSurveyDTO newDto = new CrossSectionSurveyDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Surveys.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The survey with code {0} is not unique.", newDto.LookupKey));
}
}
else if (sheetName == "DET_Elevations")
{
CrossSectionElevationDTO newDto = new CrossSectionElevationDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Elevations.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The elevation with code {0} is not unique.", newDto.LookupKey));
}
}
else if (sheetName == "LIST_Instruments")
{
InstrumentDTO newDto = new InstrumentDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Instruments.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The instrument with code {0} is not unique.", newDto.LookupKey));
}
}
else if (sheetName == "LIST_Sites")
{
SiteDTO newDto = new SiteDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Sites.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The site with code {0} is not unique.", newDto.LookupKey));
}
}
}
private DataTab ElevationsDataTab()
{
return(new DataTab("DET_Elevations", XlColor.White, CrossSectionElevationDTO.GetSchema(), generalDet.Elevations.Values));
}
