public void Agregar(ConsultationViewModel pConsultationViewModel)
{
consultations oconsultations = new consultations
{
consultation_id = 0,
title = pConsultationViewModel.title,
message = pConsultationViewModel.message,
consultation_type_id = pConsultationViewModel.consultation_type_id,
date_created = DateTime.Now,
user_id_created = pConsultationViewModel.user_id_created
};
oRepositorio.Add(oconsultations);
foreach (int interest_area_id in pConsultationViewModel.interest_areas)
{
oRepositorioConsultationInterestArea.Add(new consultations_interest_areas
{
interest_area_id = interest_area_id,
consultation_id = pConsultationViewModel.consultation_id,
date_created = DateTime.Now,
user_id_created = pConsultationViewModel.user_id_created,
date_modified = DateTime.Now,
user_id_modified = pConsultationViewModel.user_id_created,
});
}
oUnitOfWork.SaveChanges();
pConsultationViewModel.consultation_id = oconsultations.consultation_id;
}
public void Eliminar(int id)
{
using (var scope = new TransactionScope())
{
consultations oConsultation = new consultations
{
consultation_id = id,
};
oRepositorio.Delete(oConsultation);
oRepositorioConsultationInterestArea.DeleteByConsultation(id);
oUnitOfWork.SaveChanges();
scope.Complete();
}
}
