[Springnet-commits] Spring.Net/examples/Spring/Spring.DataQuickStart/src/Spring/Spring.DataQuickStart/DataQuickStart/Dao/GenericTemplate CustOrdersDetailStoredProc.cs, NONE, 1.1 OrderDetailRowMapper.cs, NONE, 1.1

[Mark P. <mar...@us...>]

Update of /cvsroot/springnet/Spring.Net/examples/Spring/Spring.DataQuickStart/src/Spring/Spring.DataQuickStart/DataQuickStart/Dao/GenericTemplate
In directory sc8-pr-cvs8.sourceforge.net:/tmp/cvs-serv18067/DataQuickStart/Dao/GenericTemplate

Added Files:
	CustOrdersDetailStoredProc.cs OrderDetailRowMapper.cs 
Log Message:
add dataset and generic stored proc example to data access quickstart

--- NEW FILE: OrderDetailRowMapper.cs ---
#region Licence

/*
 * Copyright 2002-2006 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

#endregion

using System.Data;
using System.Data.SqlClient;
using Spring.Data.Generic;
using Spring.DataQuickStart.Domain;

namespace Spring.DataQuickStart.Dao.GenericTemplate
{
    public class OrderDetailRowMapper<T> : IRowMapper<T> where T : OrderDetails, new()
    {
        /// <summary>
        /// Map a row of data to a OrderDetails object.
        /// </summary>
        /// <remarks>This method should not call Next() on the 
        /// DataReader; it should only extract the values of the current row.
        /// </remarks>
        /// <param name="dataReader">The IDataReader to map</param>
        /// <param name="rowNum">the number of the current row.</param>
        /// <returns>A Customer object.</returns>
        public T MapRow(IDataReader dataReader, int rowNum)
        {
            SqlDataReader dr = dataReader as SqlDataReader;
            
            T ods = new T();
            
            ods.ProductName = dr.GetString(0);
            ods.UnitPrice = dr.GetSqlMoney(1).ToDouble();
            ods.Quantity = dr.GetInt16(2);
            ods.Discount = dr.GetInt32(3);
            ods.ExtendedPrice = dr.GetSqlMoney(4).ToDouble();
            
            return ods;
        }
    }
}

--- NEW FILE: CustOrdersDetailStoredProc.cs ---
using System.Collections;
using System.Collections.Generic;
using Spring.Data.Common;
using Spring.Data.Objects.Generic;
using Spring.DataQuickStart.Domain;

namespace Spring.DataQuickStart.Dao.GenericTemplate
{
    public class CustOrdersDetailStoredProc : StoredProcedure
    {
        private static string procedureName = "CustOrdersDetail";

        public CustOrdersDetailStoredProc(IDbProvider dbProvider) : base(dbProvider, procedureName)
        {           
            DeriveParameters();
            AddRowMapper("orderDetailRowMapper", new OrderDetailRowMapper<OrderDetails>() );
            Compile();
        }
        
        public virtual List<OrderDetails> GetOrderDetails(int orderid)
        {
            
            IDictionary outParams = Query<OrderDetails>(orderid);
            return outParams["orderDetailRowMapper"] as List<OrderDetails>;
        }

    }
}