const DbConfig = require('../Config/DatabaseConfig.js');
const sql = require('mssql');

async function Login(Username,Password) {
	await sql.connect(DbConfig.config);
	const request = new sql.Request();
	request.input('Username', sql.VarChar, Username);
	request.input('Password', sql.VarChar, Password);
	request.output('Totale', sql.Int);
	const recordset = await request.query('select count(*)  as Totale from Utente where Username=@Username and Password=@Password');
	const ret = parseInt(recordset.recordset[0].Totale);
	console.log("Valore di ret dentro model: ", ret);
	await sql.close();
	return ret;
}


module.exports.Login = Login;