PageService

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Data;
using WebApplication3.classi;

namespace WebApplication3.classi
{
    public class PaginaService
    {
        public Pagina CaricaPagina(int id)
        {
            database db = new database();
            Pagina page = null;
            string querypagina = "SELECT * FROM PAGINE WHERE ID =" + id;

            OleDbDataReader reader = db.EseguiReader(querypagina);
                if (reader.Read())
                {
                    page = new Pagina();
                    page.id = Int32.Parse(reader["id"].ToString());
                    page.titolo = reader["titolo"].ToString();
                    page.contenuto = reader["contenuto"].ToString();
                    page.menu = reader["Menu"].ToString();
                }

            reader.Close();
                    return page;
        }

        public int delPagina(int _id)
        {
            Data.DB.OleDbDatabase db = new Data.DB.OleDbDatabase();
            string query = "DELETE FROM pagine WHERE id="+ _id;
            return db.EseguiNonQuery(query);
        }
        public List<Pagina> mlistapagine()
        {
            database db = new database();
            List<Pagina> page = new List<Pagina>();
            Pagina p;
            string querypagina = "SELECT * FROM pagine";
            OleDbDataReader reader = db.EseguiReader(querypagina);
            while (reader.Read())
            {
                p = new Pagina();
                p.id = Int32.Parse(reader["id"].ToString());
                p.titolo = reader["titolo"].ToString();
                page.Add(p);
            }
            reader.Close();
            return page;
        }

        public int insertPagina(Pagina pa)
        {
            Data.DB.OleDbDatabase db = new Data.DB.OleDbDatabase();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "INSERT INTO pagine (titolo,contenuto,Menu) VALUES (?,?,?)";
            cmd.Parameters.AddWithValue("titolo", pa.titolo);
            cmd.Parameters.AddWithValue("contenuto", pa.contenuto);
            cmd.Parameters.AddWithValue("menu", pa.menu);
            return db.EseguiNonQuery(cmd);
        }
        public int aggPagina(Pagina pa)
        {
            Data.DB.OleDbDatabase db = new Data.DB.OleDbDatabase();
            OleDbCommand cmd = new OleDbCommand();
            cmd.CommandText = "UPDATE PAGINE SET titolo=?, contenuto=?, menu=? WHERE id=?";
            cmd.Parameters.AddWithValue("titolo", pa.titolo);
            cmd.Parameters.AddWithValue("contenuto", pa.contenuto);
            cmd.Parameters.AddWithValue("menu", pa.menu);
            cmd.Parameters.AddWithValue("id", pa.id);
            return db.EseguiNonQuery(cmd);

    }
  }
}