private static SedimentAccretionSurvey CreatePhonySurvey(int index)
{
SedimentAccretionSurvey dto = new SedimentAccretionSurvey();
dto.SurveyId = string.Format("SurveyId {0}", index);
dto.SiteId = string.Format("SiteId {0}", index);
dto.DateTime = Parsing.ParseDate(string.Format("{0}/01/2017", index));
dto.ElevTopA = Parsing.ParseDouble("");
dto.ElevTopB = 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")
{
SedimentAccretionSurvey newDto = new SedimentAccretionSurvey(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")
{
SedimentAccretionElevation newDto = new SedimentAccretionElevation(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_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 SurveysDataTab()
{
return(new DataTab("DET_Surveys", XlColor.White, SedimentAccretionSurvey.GetSchema(), generalDet.Surveys.Values));
}
