public string SetNewPassword(PasswordCredentials request)
{
using (var dbContext = new TtcDbContext())
{
var player = dbContext.Players.SingleOrDefault(x => x.Id == request.PlayerId);
if (player != null)
{
dbContext.Database.ExecuteSqlCommand(
$"UPDATE {PlayerEntity.TableName} SET paswoord=MD5({{1}}) WHERE id={{0}}",
request.PlayerId,
request.NewPassword);
return player.Email;
}
return null;
}
}
public User ChangePassword(PasswordCredentials userNewCredentials)
{
using (var dbContext = new TtcDbContext())
{
var pwdCheck = dbContext.Database.SqlQuery<int>(
$"SELECT COUNT(0) FROM {PlayerEntity.TableName} WHERE id={{0}} AND paswoord=MD5({{1}})",
userNewCredentials.PlayerId,
userNewCredentials.OldPassword).FirstOrDefault();
if (pwdCheck != 1)
{
return null;
}
else
{
dbContext.Database.ExecuteSqlCommand(
$"UPDATE {PlayerEntity.TableName} SET paswoord=MD5({{1}}) WHERE id={{0}}",
userNewCredentials.PlayerId,
userNewCredentials.NewPassword);
return GetUser(userNewCredentials.PlayerId);
}
}
}
