using System;

using System.Collections.Generic;

using System.Text;

using System.Data.SqlClient;

using Dapper;

using System.Linq;

using SkuptiGigantenOpgave;

​

namespace skuptiGiganten

{

    public class DatabaseSQL

    {

​

        public static void Opretny(SqlConnection conn, string navn, decimal pris, int antal)

        {

​

​

            SqlCommand com = new SqlCommand();

            com.CommandText = $"insert into vare (navn, pris, antal) values ('{navn}', '{pris}', '{antal}')";

            Console.WriteLine(com.CommandText);

            com.Connection = conn;

            com.ExecuteNonQuery();

​

        }

​

        public static void Sletvare(SqlConnection conn, int varenr)

        {

​

            SqlCommand com = new SqlCommand();

            com.CommandText = $"delete from vare where varenr = {varenr}";

            Console.WriteLine(com.CommandText);

            com.Connection = conn;

            com.ExecuteNonQuery();

​

​

        }

​

        public static void Ændrevare(SqlConnection conn, int varenr, string navn, decimal pris, int antal)

        {

​

            SqlCommand comupdate = new SqlCommand();

            comupdate.CommandText = $"update vare set navn = '{navn}', pris = {pris}, mængde = {antal} where varenr = {varenr}";

            comupdate.Connection = conn;

            Console.WriteLine(comupdate.CommandText);

            comupdate.ExecuteNonQuery();

​

​

        }

​

        public static vare HentVare(SqlConnection conn, int varenr)

        {

​

            return conn.Query<vare>("select * from vare where varenr = @varenr", new {varenr}).SingleOrDefault();

​

        }

​

        public static List<vare> HentVarene(SqlConnection conn)

        {

​

            return conn.Query<vare>("select * from vare").ToList();

​

        }

    }

​

}