public void ModificarInvestigator(InvestigatorViewModel pInvestigatorViewModel) { using (var scope = new TransactionScope()) { investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id); users ousers = oRepositorio.FindById(oinvestigators.user_id); ousers.user_name = pInvestigatorViewModel.user_name; // ousers.user_email = pInvestigatorViewModel.user_email; // ousers.user_pass = pInvestigatorViewModel.user_pass; ousers.contact_name = pInvestigatorViewModel.contact_name; ousers.document_type_id = pInvestigatorViewModel.document_type_id; ousers.doc_nro = pInvestigatorViewModel.doc_nro; ousers.nationality_id = pInvestigatorViewModel.nationality_id; // contract_name = pInvestigatorViewModel.contract_name, ousers.phone = pInvestigatorViewModel.phone; ousers.address = pInvestigatorViewModel.address; ousers.address_municipality_id = pInvestigatorViewModel.address_municipality_id; ousers.address_country_id = pInvestigatorViewModel.address_country_id; ousers.user_id_modified = pInvestigatorViewModel.user_id_modified; ousers.date_modified = DateTime.Now; if (pInvestigatorViewModel.avatar != null) { ousers.avatar = pInvestigatorViewModel.avatar; } oRepositorio.Update(ousers); //investigators oinvestigators = oRepositorioInvestigator.FindById(pInvestigatorViewModel.investigator_id); oinvestigators.user_id = ousers.id; oinvestigators.first_name = pInvestigatorViewModel.first_name; oinvestigators.second_name = pInvestigatorViewModel.second_name; oinvestigators.last_name = pInvestigatorViewModel.last_name; oinvestigators.second_last_name = pInvestigatorViewModel.second_last_name; oinvestigators.gender_id = pInvestigatorViewModel.gender_id; oinvestigators.mobile_phone = pInvestigatorViewModel.mobile_phone; oinvestigators.birthdate = pInvestigatorViewModel.birthdate; oinvestigators.institution_id = pInvestigatorViewModel.institution_id; oinvestigators.investigation_group_id = pInvestigatorViewModel.investigation_group_id; oinvestigators.program_id = pInvestigatorViewModel.program_id; oinvestigators.educational_institution_id = pInvestigatorViewModel.educational_institution_id; oinvestigators.education_level_id = pInvestigatorViewModel.education_level_id; oinvestigators.CVLAC = pInvestigatorViewModel.CVLAC; oRepositorioInvestigatorCommission.DeleteMultiple(pInvestigatorViewModel.investigator_id); oRepositorioInvestigatorInterestArea.DeleteMultiple(pInvestigatorViewModel.investigator_id); foreach (int interest_area_id in pInvestigatorViewModel.interest_areas) { oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas { interest_area_id = interest_area_id, investigator_id = pInvestigatorViewModel.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } foreach (int commission_id in pInvestigatorViewModel.commissions) { oRepositorioInvestigatorCommission.Add(new investigators_commissions { commission_id = commission_id, investigator_id = pInvestigatorViewModel.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } oRepositorioInvestigator.Update(oinvestigators); oUnitOfWork.SaveChanges(); scope.Complete(); } }
public int?AgregarInvestigador(InvestigatorViewModel pInvestigatorViewModel) { users ousers = new users { id = 0, user_name = pInvestigatorViewModel.user_name, user_email = pInvestigatorViewModel.user_email, user_pass = pInvestigatorViewModel.user_pass, contact_name = pInvestigatorViewModel.contact_name, user_role_id = 11, user_status_id = 2, document_type_id = pInvestigatorViewModel.document_type_id, doc_nro = pInvestigatorViewModel.doc_nro, nationality_id = pInvestigatorViewModel.nationality_id, // contract_name = pInvestigatorViewModel.contract_name, phone = pInvestigatorViewModel.phone, address = pInvestigatorViewModel.address, address_municipality_id = pInvestigatorViewModel.address_municipality_id, address_country_id = pInvestigatorViewModel.address_country_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, user_code_activate = pInvestigatorViewModel.user_code_activate, user_code_recover = pInvestigatorViewModel.user_code_recover, }; ousers = oRepositorio.Add(ousers); investigators oinvestigators = new investigators { investigator_id = 0, user_id = ousers.id, first_name = pInvestigatorViewModel.first_name, second_name = pInvestigatorViewModel.second_name, last_name = pInvestigatorViewModel.last_name, second_last_name = pInvestigatorViewModel.second_last_name, gender_id = pInvestigatorViewModel.gender_id, mobile_phone = pInvestigatorViewModel.mobile_phone, birthdate = pInvestigatorViewModel.birthdate, institution_id = pInvestigatorViewModel.institution_id, investigation_group_id = pInvestigatorViewModel.investigation_group_id, program_id = pInvestigatorViewModel.program_id, educational_institution_id = pInvestigatorViewModel.educational_institution_id, education_level_id = pInvestigatorViewModel.education_level_id, CVLAC = pInvestigatorViewModel.CVLAC, }; foreach (int interest_area_id in pInvestigatorViewModel.interest_areas) { oRepositorioInvestigatorInterestArea.Add(new investigators_interest_areas { interest_area_id = interest_area_id, investigator_id = oinvestigators.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } foreach (int commission_id in pInvestigatorViewModel.commissions) { oRepositorioInvestigatorCommission.Add(new investigators_commissions { commission_id = commission_id, investigator_id = oinvestigators.investigator_id, date_created = DateTime.Now, user_id_created = pInvestigatorViewModel.user_id_created, date_modified = DateTime.Now, user_id_modified = pInvestigatorViewModel.user_id_created, }); } oinvestigators = oRepositorioInvestigator.Add(oinvestigators); oUnitOfWork.SaveChanges(); return(oinvestigators.user_id); }