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