ASP.NET

DECLARE @MATIERE nvarchar(max)   <br />
SELECT @MATIERE =   <br />
  STUFF(   <br />
  (   <br />
  select distinct ',[' + LIBELLE_MATIERE + ']'  <br />
  from MATIERE where CODE_MODULE =11   <br />
  for xml path('')   <br />
 ),   <br />
 1,1,'')   <br />
  <br />
DECLARE @SQL nvarchar(max)   <br />
SELECT @SQL = N'   <br />
select  <br />
 *   <br />
from (   <br />
  <br />
  SELECT     ETUDIANT.NUM_INSCRIPTION, ETUDIANT.NOM_PRENOM_ETUDIANT_ARABE,EXAMEN.CODE,    <br />
 EXAMEN.NOTE,    <br />
                     MATIERE.LIBELLE_MATIERE   <br />
FROM         ETUDIANT INNER JOIN  <br />
                      EXAMEN ON ETUDIANT.NUM_INSCRIPTION = EXAMEN.NUM_INSCRIPTION INNER JOIN  <br />
                      CAPITALISE_MODULE ON    <br />
                      ETUDIANT.NUM_INSCRIPTION = CAPITALISE_MODULE.NUM_INSCRIPTION INNER JOIN  <br />
                      MATIERE ON EXAMEN.CODE_MATIERE = MATIERE.CODE_MATIERE INNER JOIN  <br />
                      MODULE ON CAPITALISE_MODULE.CODE_MODULE = MODULE.CODE_MODULE    <br />
                      AND MATIERE.CODE_MODULE = MODULE.CODE_MODULE   <br />
WHERE      (CAPITALISE_MODULE.CODE_MODULE = 11) AND    <br />
                      (CAPITALISE_MODULE.CODE_TYPE_RELATION_MODULE = 1)   <br />
) Data   <br />
PIVOT (   <br />
 SUM(NOTE)   <br />
 FOR LIBELLE_MATIERE   <br />
 IN (   <br />
  ' + @MATIERE + '  <br />
 )   <br />
) PivotTable   <br />
'   <br />
  <br />
exec sp_executesql @SQL  <br />

I did the above code in MODEL folder of MVC project. 
would you mind telling me what I have to write in the controler folder

public ItemRepository()
{

// instantiate the connection
_connection = new SqlConnection(datasource);

}

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace MvcApplication1.Models.Repository.DTO
{
    public class Item
    {
        //definition of class's fileds
        public int _id;
        public int _code;
        public string _description;
        public string _creator;
        public DateTime _created;


        //definition of properties
        public int Id
        {
            set 
            {
                _id = value;
                if (value < 0)
                    throw new ArgumentException(string.Format("Id should be greater than 0 !"));
            }
            get { return _id; }
        }
        public int Code
        {
            set { _code = value; }
            get { return _code; }
        }
        public string Description
        {
            set { _description = value; }
            get { return _description; }
        }
        public string Creator
        {
            set { _creator = value; }
            get { return _creator; }
        }
        public DateTime Created
        {
            set { _created = value; }
            get { return _created; }
        }

        //definiton of constructor
        public Item(int id, int code, string description, string creator, DateTime created)
        {
            this._id = id;
            this._code = code;
            this._description = description;
            this._creator = creator;
            this._created = created;
        }
    }
}

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using MvcApplication1.Models.Repository.DTO;

namespace MvcApplication1.Repository
{
    public class ItemRepository
    {
        //definition of fields
        private const string datasource =
            "Data Source= Dell\\SQLEXPRESS;Initial Catalog=DB_Furniture.mdf;Integrated Security=True;User Instance=True";

        private SqlConnection _connection;
        private SqlCommand _sqlcommand;
        private SqlDataReader _datareader;
        //definition of constructor
        public ItemRepository()
        {           
            // instantiate the connection
            _connection = new SqlConnection(datasource);     
        }
        //definition of insert method
        public void Insert(string code, string description, DateTime created, string creator)
        {
            //definition of SQl SP parameters
            _sqlcommand = new SqlCommand("Ins_item",_connection);
            _sqlcommand.CommandType = CommandType.StoredProcedure;
            _sqlcommand.Parameters.AddWithValue("@Code", code);
            _sqlcommand.Parameters.AddWithValue("@Description", description);
            _sqlcommand.Parameters.AddWithValue("@Created", created);
            _sqlcommand.Parameters.AddWithValue("@Creator", creator);
            _datareader = _sqlcommand.ExecuteNOnQuery();

        }
    }
}

ing System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Mvc.Ajax;
using MvcApplication1.Models.Repository.DTO;
using MvcApplication1.Models.Repository;
using MvcApplication1.Repository;
namespace MvcApplication1.Controllers
{
    public class FurnitureController : Controller
    {
        //
        // GET: /Furniture/

        public ActionResult Index()
        {
            return View();
        }

        //Get: /Furniture/Create
        public ActionResult Create()
        {
            return View();
        }

        // POST: /Furniture/Create
        //  [AcceptVerbs(HttpVerbs.Post)]
        public ActionResult Craete(Item item)
        {
            try
            {
                ItemRepository ItemRep = new ItemRepository();
??????????????????????????????????????????????????????????????????????????????????
?
 ??
            }
            catch
            {
            }
        }

    } 
}

Member 4674360 wrote:

public ActionResult Craete(Item item)
{
try
{
ItemRepository ItemRep = new ItemRepository();
??????????????????????????????????????????????????????????????????????????????????
?
??
}
catch
{
}
}

Class DataAccessorX
{
    //blah blah blah constructors, etc.
    public void DeployFrickingLazers(int A, int B, int C)
    {
      ...
    }
}

Class MazingerZ
{
     //blah blah blah constructors, etc.
     public void WeNeedKillingPowerNow()
     {
        DataAccessorX oldSkoolAnime = new DataAccessorX();
        oldSkoolAnime.DeployFrickingLazers(ArmOnePilotID, ArmTwoPilotID, ArmThreePilotID);
     }
}