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 PreySurveyDTO CreatePhonySurvey(int index) { PreySurveyDTO dto = new PreySurveyDTO(); dto.SampleId = string.Format("SampleId {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.SampleType = string.Format("SampleType {0}", index); dto.Comments = string.Format("Comments {0}", index); return(dto); }
private DataTab PreySurveysDataTab() { return(new DataTab("DET_PreySurveys", XlColor.White, PreySurveyDTO.GetSchema(), generalDet.PreySurveys.Values)); }