ASP.NET

CREATE TABLE item(
         id INT,
         itemModel VARCHAR(100),
         name VARCHAR(100),
         description VARCHAR(100),
         created VARCHAR(100),
         creator VARCHAR(100),

using System;
using System.Data;
using System.Configuration;
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.ComponentModel;

namespace WebApplication1.Repository.BusinessObject
{
    public class Items
    {
        private int _id = -1;
        private string _model = string.Empty;
        private string _name = string.Empty;
        private string _description = string.Empty;
        private DateTime _created = DateTime.MinValue;
        private string _ctreator = string.Empty;


        [DataObjectFieldAttribute(true,true,false)]
        public int ID
        {
            set { _id = value; }
            get { return _id; }
        }

        public string Model
        {
            set { _model = value; }
            get { return _model; }
        }

        public string Name
        {
            set { _name = value; }
            get { return _name; }
        }

        public string Description
        {
            set { _description = value; }
            get { return _description; }
        }

        public DateTime Created
        {
            set { _created = value; }
            get { return _created; }
        }

        public string Creator
        {
            set { _ctreator = value; }
            get { return _ctreator; }
        }


        public Items(int id, string model, string name, string description,
                        DateTime created, string ctreator)
        {
            this._id = id;
            this._model = model;
            this._name = name;
            this._description = description;
            this._created = created;
            this._ctreator = Creator;
        }
    }
}

using System;
using System.Data;
using System.Configuration;
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 WebApplication1.Repository.BusinessObject;
using System.Data.Common;
using System.Data.SqlClient;




namespace WebApplication1.Repository.DataAccessLayer
{
    public class ItemsDB
    {
        public static int Save(Items NewItems)
        {
            int Result = 0;
            SqlConnection MyConnection = new SqlConnection(ConfigurationManager.
                                     ConnectionStrings["ConnectionString"].ConnectionString);
            SqlCommand MyCommand = new SqlCommand("SprocInsertUpdateSingleItem",
                                     MyConnection);
            MyCommand.CommandType = CommandType.StoredProcedure;
            if (NewItems.ID == -1)
            {
                MyCommand.Parameters.AddWithValue("@id", DBNull.Value);
            }
            else
            {
                MyCommand.Parameters.AddWithValue("@id", NewItems.ID);
            }
            MyCommand.Parameters.AddWithValue("@ItemModel", NewItems.Model);
            MyCommand.Parameters.AddWithValue("@Name", NewItems.Name);
            MyCommand.Parameters.AddWithValue("@Description", NewItems.Description);
            MyCommand.Parameters.AddWithValue("@Created", NewItems.Created);
            MyCommand.Parameters.AddWithValue("@Creator", NewItems.Creator);

            DbParameter returnValue;
            returnValue = MyCommand.CreateParameter();
            returnValue.Direction = ParameterDirection.ReturnValue;
            MyCommand.Parameters.Add(returnValue);

            MyConnection.Open();
            MyCommand.ExecuteNonQuery();

            Result = Convert.ToInt32(returnValue.Value);
            MyConnection.Close();

            return Result;
        }
    }
}

using System;
using System.Collections.Generic;
using System.Web;
using System.ComponentModel;
using System.Transactions;

using WebApplication1.Repository.DataAccessLayer;
using WebApplication1.Repository.BusinessObject;

namespace WebApplication1.Repository.BusinessLayer
{
    public class ItemsManager
    {
        [DataObjectMethod(DataObjectMethodType.Update,true)]
        public static int Save(Items NewItem)
        {
            using (TransactionScope MyTransactioScope = new TransactionScope())
            {
                int ItemId = ItemsDB.Save(NewItem);

                foreach ( Items itemId in NewItem.ID)
                {
                    itemId.ID = ItemId;
                    ItemsDB.Save(itemId);
                }
                NewItem.ID = ItemId;

                MyTransactioScope.Complete();

                return ItemId;                
            }

        }
    }
}

<br />
  foreach statement cannot operate on variables of type 'int' because 'int' does not contain a public definition for 'GetEnumerator'	<br />

[DataObjectMethod(DataObjectMethodType.Select, false)] 

and
  
[DataObjectMethod(DataObjectMethodType.Select, True)]