public void updateUserPassword(tbUserPassword upPassword)
{
try
{
using (dbConsorcioEntities consorcio = new dbConsorcioEntities())
{
tbUserPassword password = consorcio.tbUserPassword.Where(p => p.id_user == upPassword.id_user).FirstOrDefault();
if (password == null)
{
throw new Exception("Usuário sem Password definido");
}
password.de_password = returnSHA512String(upPassword.de_password);
password.dt_create = upPassword.dt_create;
password.dt_update = DateTime.Now;
password.bt_bloqueio = password.bt_bloqueio;
consorcio.SaveChanges();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public bool validateUserPassword(tbUserPassword validatePassword)
{
try
{
using (dbConsorcioEntities consorcio = new dbConsorcioEntities())
{
validatePassword.de_password = returnSHA512String(validatePassword.de_password);
tbUserPassword password = consorcio.tbUserPassword.Where(p => p.id_user == validatePassword.id_user &
p.de_password == validatePassword.de_password).FirstOrDefault();
if (password == null)
{
return(false);
}
if (password.bt_bloqueio == true)
{
return(false);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
return(true);
}
public void insertUserPassword(tbUserPassword newPassword)
{
tbUserPassword passCheck;
try
{
using (dbConsorcioEntities consorcio = new dbConsorcioEntities())
{
passCheck = consorcio.tbUserPassword.Where(p => p.id_user == newPassword.id_user).FirstOrDefault();
}
if (passCheck == null)
{
using (dbConsorcioEntities consorcio = new dbConsorcioEntities())
{
tbUserPassword password = new tbUserPassword();
password.id_user = newPassword.id_user;
password.de_password = returnSHA512String(newPassword.de_password);
password.dt_create = DateTime.Now;
password.bt_bloqueio = false;
consorcio.tbUserPassword.Add(password);
consorcio.SaveChanges();
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}