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 static CrossSectionSurveyDTO CreatePhonySurvey(int index)
{
CrossSectionSurveyDTO dto = new CrossSectionSurveyDTO();
dto.SurveyId = string.Format("SurveyId {0}", index);
dto.SiteId = string.Format("SiteId {0}", index);
dto.InstrumentId = string.Format("InstrumentId {0}", index);
dto.DateTime = Parsing.ParseDate(string.Format("{0}/01/2017", index));
dto.OriginX = Parsing.ParseDouble("");
dto.OriginY = Parsing.ParseDouble("");
dto.DestinationX = Parsing.ParseDouble("");
dto.DestinationY = Parsing.ParseDouble("");
dto.Comments = string.Format("Comments {0}", index);
return(dto);
}
private DataTab SurveysDataTab()
{
return(new DataTab("DET_Surveys", XlColor.White, CrossSectionSurveyDTO.GetSchema(), generalDet.Surveys.Values));
}
