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