public void ImportFromExcelFile(string path)
{
var excelRepository = new ExcelRepository();
var data = excelRepository.GetAllDataFrom(path, "ESPECIALIDADES.xls", "Plan1");
var list = new List<Specialty>();
foreach (DataRow row in data.Rows)
{
var specialty = new Specialty();
foreach (DataColumn column in data.Columns)
{
switch (column.Caption)
{
case "Código do Termo":
specialty.CodeTerm = row[column].ToString();
break;
case "Termo":
specialty.Description = row[column].ToString();
break;
}
}
list.Add(specialty);
}
var specialties = new Specialties();
specialties.SaveList(list);
}
public static SpecialtyModel MapSpecialtyModelFrom(Specialty specialty)
{
Mapper.CreateMap<Specialty, SpecialtyModel>();
var specialtyModel = Mapper.Map<Specialty, SpecialtyModel>(specialty);
specialtyModel.Code = specialty.Id;
return specialtyModel;
}
public virtual void CreateMedicalReview(int termMedicalReviewAt, Specialty specialty)
{
Assertion.GreaterThan(termMedicalReviewAt, 0, "Periodo não informado.").Validate();
Assertion.NotNull(specialty, "Especialidade não informada").Validate();
var medicalReview = new MedicalReview
{
TermMedicalReviewAt = termMedicalReviewAt,
Specialty = specialty
};
MedicalReviews.Add(medicalReview);
Assertion.IsTrue(MedicalReviews.Contains(medicalReview), "Revisão médica não inserida.").Validate();
}
