require('./db');
const express = require('express');
const app = new express();
const bodyParser = require('body-parser');
const path = require("path");
const mssql = require('mssql');
app.use(bodyParser.urlencoded({
    extended: true
}));
app.use(bodyParser.json())


app.listen(3000);

app.use(express.static(path.join(__dirname, 'app')));


app.get("/getAllNotes", async (req, res) => {
    res.json(await getDataNotesDB())
});
// TILFØJ ID TIL HTML ELEMENTET
async function getDataNotesDB() {
    try {
        const result = (await mssql.query `select * from dbo.note`).recordset
        return result
    } catch (err) {
        console.log(err);
    }
}

app.post("/savenote", async (req, res) => {
    let title = req.body.title;
    let text = req.body.text;
    saveNoteDB(title, text)

    res.json(
        {"WhatTheFuck": "I am the reponse of the savenote request"}
    )
});

// update
app.post("/updateNote", async (req, res) => {
    let title = req.body.title;
    let text = req.body.text;
    let id = req.body.id;
    //console.log(title);
   // console.log(text);
   // console.log(id);
   // updateNoteDB(id,title,text);

    res.json(
        {"Updated note":"This note has been updated"}
        )

})

// update function
async function updateNoteDB(id, title, text) {
    try {
        const result = (await mssql.query `update dbo.note
        set note_text = ${text}, note_title = ${title}
        where id = ${id};`).recordset
        console.log("vi er nået her til ");
    } catch (err) {
        console.log(err);
    }
}

// delete
// `delete from note
//where id = ${htmlelement.id}`
app.delete("/deleteNote", async (req, res) => {
    let id = req.body.id;
    deleteNoteDB(id);

    res.json(
        {"Delete": "Note deleted"}
    )
})

//Delete function
async function deleteNoteDB(id){
    try {
        const result = (await mssql.query `DELETE FROM dbo.note where id = ${id};`).recordset
    } catch(err){
        console.log(err);
    }

}

//Save function
async function saveNoteDB(title, text) {
    try {
        const result = (await mssql.query `INSERT INTO dbo.note (note_title, note_text)
        VALUES (${title}, ${text});`).recordset
    } catch (err) {
        console.log(err);
    }
}