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(); } }