private void LoadRow(string sheetName, Dictionary <string, string> values)
{
ValidationIssues issues = generalDet.ValidationIssues;
if (sheetName == "DET_PreySurveys")
{
PreySurveyDTO newDto = new PreySurveyDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.PreySurveys.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The prey survey with code {0} is not unique.", newDto.LookupKey));
}
}
else if (sheetName == "DET_Prey")
{
PreyDTO newDto = new PreyDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Prey.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The prey 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));
}
}
else if (sheetName == "LIST_Species")
{
SpeciesDTO newDto = new SpeciesDTO(values);
newDto.Validate();
issues.Merge(newDto.ValidationIssues);
bool success = generalDet.Species.Add(newDto);
if (!success)
{
issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The species with code {0} is not unique.", newDto.LookupKey));
}
}
//else if (sheetName == "LIST_LifeStages")
//{
// LifeStageDTO newDto = new LifeStageDTO(values);
// newDto.Validate();
// issues.Merge(newDto.ValidationIssues);
// bool success = generalDet.LifeStages.Add(newDto);
// if (!success)
// {
// issues.Add(ValidationIssue.Code.NonUniqueKeyCode, string.Format("The life stage with code {0} is not unique.", newDto.LookupKey));
// }
//}
}
private static PreyDTO CreatePhonyPrey(int index)
{
PreyDTO dto = new PreyDTO();
dto.SampleId = string.Format("SampleId {0}", index);
dto.SpeciesId = string.Format("SpeciesId {0}", index);
dto.LifeStage = string.Format("LifeStage {0}", index);
dto.Count = index;
return(dto);
}
private DataTab PreyDataTab()
{
return(new DataTab("DET_Prey", XlColor.White, PreyDTO.GetSchema(), generalDet.Prey.Values));
}
