public void Agregar(UserViewModel pUserViewModel)
{
using (var scope = new TransactionScope())
{
users ousers = new users
{
id = 0,
user_name = pUserViewModel.user_name,
user_pass = pUserViewModel.user_pass,
user_email2 = pUserViewModel.user_email2,
user_email = pUserViewModel.user_email,
user_role_id = pUserViewModel.user_role_id,
user_status_id = pUserViewModel.user_status_id,
document_type_id = pUserViewModel.document_type_id,
doc_nro = pUserViewModel.doc_nro,
nationality_id = pUserViewModel.nationality_id,
contact_name = pUserViewModel.contact_name,
phone = pUserViewModel.phone,
address = pUserViewModel.address,
date_created = DateTime.Now,
user_id_created = pUserViewModel.user_id_created,
user_code_recover = pUserViewModel.user_code_recover,
address_municipality_id = pUserViewModel.address_municipality_id,
address_country_id = pUserViewModel.address_country_id,
};
oRepositorio.Add(ousers);
if (pUserViewModel.institution_ids != null && pUserViewModel.institution_ids.Count > 0)
{
foreach (int institution_id in pUserViewModel.institution_ids)
{
user_institutions ouser_institutions = new user_institutions
{
user_id = ousers.id,
institution_id = institution_id,
date_created = DateTime.Now,
user_id_created = pUserViewModel.user_id_created,
};
oRepositorioUserInstitution.Add(ouser_institutions);
}
}
oUnitOfWork.SaveChanges();
pUserViewModel.id = ousers.id;
scope.Complete();
}
}
public void Modificar(UserViewModel pUserViewModel)
{
using (var scope = new TransactionScope())
{
users ousers = oRepositorio.FindById(pUserViewModel.id);
ousers.user_name = pUserViewModel.user_name;
ousers.user_email = pUserViewModel.user_email;
ousers.user_role_id = pUserViewModel.user_role_id;
ousers.user_status_id = pUserViewModel.user_status_id;
ousers.document_type_id = pUserViewModel.document_type_id;
ousers.doc_nro = pUserViewModel.doc_nro;
ousers.nationality_id = pUserViewModel.nationality_id;
ousers.contact_name = pUserViewModel.contact_name;
ousers.phone = pUserViewModel.phone;
ousers.address = pUserViewModel.address;
ousers.user_email2 = pUserViewModel.user_email2;
ousers.address_country_id = pUserViewModel.address_country_id;
ousers.address_municipality_id = pUserViewModel.address_municipality_id;
ousers.user_id_modified = pUserViewModel.user_id_modified;
ousers.date_modified = DateTime.Now;
oRepositorio.Update(ousers);
oRepositorioUserInstitution.DeleleMultiple(pUserViewModel.id);
if (pUserViewModel.institution_ids != null && pUserViewModel.institution_ids.Count() > 0)
{
foreach (int institution_id in pUserViewModel.institution_ids)
{
user_institutions ouser_institutions = new user_institutions
{
user_id = ousers.id,
institution_id = institution_id,
date_created = DateTime.Now,
user_id_created = pUserViewModel.user_id_created,
};
oRepositorioUserInstitution.Add(ouser_institutions);
}
}
oUnitOfWork.SaveChanges();
scope.Complete();
}
}