// ========================================================================
// Copyright 2006 - Volian Enterprises, Inc. All rights reserved.          
// Volian Enterprises - Proprietary Information - DO NOT COPY OR DISTRIBUTE
// ------------------------------------------------------------------------
// $Workfile: $     $Revision: $                                           
// $Author: $   $Date: $                                                   
//                                                                         
// $History: $                                                             
// ========================================================================

using System;
using System.Data;
using System.Data.SqlClient;
using Csla;
using Csla.Data;

namespace Volian.Object.Library
{
	/// <summary>
	///	AssignmentInfoList Generated by MyGeneration using the CSLA Object Mapping template
	/// </summary>
	[Serializable()]
	public partial class AssignmentInfoList : ReadOnlyListBase<AssignmentInfoList,AssignmentInfo>
	{
	#region Factory Methods
    /// <summary>
    /// Return a list of all projects.
    /// </summary>
    public static AssignmentInfoList Get()
    {
      return DataPortal.Fetch<AssignmentInfoList>(new Criteria());
    }


    // TODO: Add alternative gets - 
    //public static AssignmentInfoList Get(<criteria>)
    //{
    //  return DataPortal.Fetch<AssignmentInfoList>(new FilteredCriteria(<criteria>));
    //}

    private AssignmentInfoList()
    { /* require use of factory methods */ }
	
	#endregion
	#region Data Access Portal
    [Serializable()]
    private class Criteria
    { /* no criteria - retrieve all rows */ }

    private void DataPortal_Fetch(Criteria criteria)
    {
      this.RaiseListChangedEvents = false;
	  try{
     using (SqlConnection cn = Database.VEPROMS_SqlConnection)
      {
        using (SqlCommand cm = cn.CreateCommand())
        {
          cm.CommandType = CommandType.StoredProcedure;
          cm.CommandText = "getAssignments";
          using (SafeDataReader dr = new SafeDataReader(cm.ExecuteReader()))
          {
            IsReadOnly = false;
            while (dr.Read())this.Add(new AssignmentInfo(dr));
            IsReadOnly = true;
          }
        }
      }
		}
		catch(Exception ex)
		{
			Database.LogException("AssignmentInfoList",ex);
		}
      this.RaiseListChangedEvents = true;
    }
	#endregion
	} // Class
} // Namespace