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