public void updateUser(tbUsers upUser) { try { using (dbConsorcioEntities consorcio = new dbConsorcioEntities()) { tbUsers user = consorcio.tbUsers.Where(u => u.id_user == upUser.id_user).FirstOrDefault(); if (user == null) { throw new Exception("Usuário não Encontrado!"); } user.nm_user = upUser.nm_user; user.nm_apelido = upUser.nm_apelido; user.cd_fisjur = upUser.cd_fisjur; user.cd_cnpj = upUser.cd_cnpj; user.cd_cpf = upUser.cd_cpf; user.cd_ie = upUser.cd_ie; user.bit_bloqueio = upUser.bit_bloqueio; user.de_username = upUser.de_username; user.de_telefone = upUser.de_telefone; consorcio.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public tbUsers insertUser(tbUsers newUser) { tbUsers user = new tbUsers(); try { using (dbConsorcioEntities consorcio = new dbConsorcioEntities()) { user.id_user = Guid.NewGuid().ToString(); user.de_username = newUser.de_username; user.nm_user = newUser.nm_user; user.nm_apelido = newUser.nm_apelido; user.cd_fisjur = newUser.cd_fisjur; user.cd_cnpj = newUser.cd_cnpj; user.cd_cpf = newUser.cd_cpf; user.cd_ie = newUser.cd_ie; user.de_telefone = newUser.de_telefone; user.bit_bloqueio = 0; consorcio.tbUsers.Add(user); consorcio.SaveChanges(); } return(user); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void deleteUser(tbUsers dUser) { try { using (dbConsorcioEntities consorcio = new dbConsorcioEntities()) { tbUsers user = consorcio.tbUsers.Where(u => u.id_user == dUser.id_user).FirstOrDefault(); consorcio.tbUsers.Remove(user); consorcio.SaveChanges(); } } catch (Exception ex) { throw new Exception(ex.Message); } }