router.post('/updatepassword', validator(validatePasswordUpdate), async (req, res, next) => {


    sql.connect(serverconfig).then(() => {
        // connect();
        var request = new sql.Request();

        request.input('Name', sql.VarChar(50), req.body.name)
            .input('Password', sql.VarChar(50), req.body.password)

            .query(`select * from dbo.Aims_Users where loginName=@Name and password=@Password`, function (err, data) {
                if (err) console.log(err)
                if (data == undefined) {
                    return res.status(400).send({ 'error': "An error occured" });
                }
                var resultLength = Object.values(data.recordset).length;
                if (resultLength == 0) {

                    return res.status(400).json({ 'error': 'Incorrect name or password' })
                }
                // res.send(data.recordset);
                if (data.recordset[0]["PassWord"] == req.body.password)
                    request
                        .input('NewPassword', sql.VarChar(50), req.body.new_password)
                        .query(`update dbo.Aims_Users set password=@NewPassword where loginName=@Name`, function (err, data) {
                            if (err) console.log(err)
                            if (data == undefined) {
                                return res.status(400).send({ 'error': "An error occured" });
                            }
                            var resultLength = Object.values(data.rowsAffected).length;
                            if (resultLength == 0)
                                return res.status(404).json({ 'error': 'An error occured' })

                            res.json({
                                'message': 'Login with updated password',
                                'data': data.rowsAffected,
                            });
                        })
                // if(data.recordset)

            });
    }).catch((err) => {
        next(err);
    });


});


function validate(req) {
    const schema = Joi.object({
        name: Joi.string().min(3).max(30).required(),
        password: Joi.string().min(5).max(255).required(),
    });

    return schema.validate(req);
}
function validatePasswordUpdate(req) {
    const schema = Joi.object({
        name: Joi.string().min(3).max(30).required(),
        password: Joi.string().min(5).max(255).required(),
        new_password: Joi.string().min(5).max(255).required(),
    });

    return schema.validate(req);
}
module.exports = router;