Developing Next Generation Smart Clients using .NET 2.0 working with Existing .NET 1.1 SOA-based XML Web Services

	 
#region "Using directives"

using System;
using System.Data;
using System.Collections;
using System.Diagnostics;
using SmartInstitute;

#endregion

namespace SmartInstitute.DataAccessLayer
{

///<summary>
/// This class is the base Repository that exposes CRUD methods for SectionRoutine objects.
///</summary>
public interface ISectionRoutineRepository
{
			
	#region "Get from  Many To Many Relationship Functions"
	#endregion	
	
	

				
	/// <summary>
	/// 	Deletes a row from the DataSource.
	/// </summary>
	/// <param name="ID">. Primary Key.</param>	
	/// <remarks>Deletes based on primary key(s).</remarks>
	/// <returns>Returns true if operation suceeded.</returns>
	bool Delete(System.Int32 ID, DateTime ChangeStamp);
		

	
	
	
	
	/// <summary>
	/// 	Gets All rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of SectionRoutine objects.</returns>
	 SectionRoutineCollection GetAll( int start, int pagelen);
	 
	 /// <summary>
	/// Gets a page of rows from the DataSource.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pageLength">Number of rows to return.</param>
	/// <param name="count">Number of rows in the DataSource.</param>
	/// <param name="whereClause">Specifies the condition for the rows returned by a query (Name='John Doe', Name='John Doe' AND Id='1', Name='John Doe' OR Id='1').</param>
	/// <param name="orderBy">Specifies the sort criteria for the rows in the DataSource (Name ASC; BirthDay DESC, Name ASC);</param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of SectionRoutine objects.</returns>
	SectionRoutineCollection GetPaged(string whereClause, string orderBy, int start, int pageLength, out int count);
	

	
		
	/// <summary>
	/// 	Gets rows from the datasource based on the FK_SectionRoutine_Section key.
	///		FK_SectionRoutine_Section Description: 
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="SectionID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of SectionRoutine objects.</returns>
	SectionRoutineCollection GetBySectionID(System.Int32 SectionID, int start, int pagelen);
	
	
	
	
	
	
	
	/// <summary>
	/// 	Gets rows from the datasource based on the PK_SectionRoutine index.
	/// </summary>
	/// <param name="start">Row number at which to start reading.</param>
	/// <param name="pagelen">Number of rows to return.</param>
	/// <param name="ID"></param>
	/// <remarks></remarks>
	/// <returns>Returns a typed collection of SectionRoutine objects.</returns>
	SectionRoutineCollection GetByID(System.Int32 ID, int start, int pagelen);



		
	/// <summary>
	/// 	Inserts a SectionRoutine object into the datasource using a transaction.
	/// </summary>
	/// <param name="entity">SectionRoutine object to insert.</param>
	/// <remarks>After inserting into the datasource, the SectionRoutine object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	bool Insert(SectionRoutine entity);


			
	/// <summary>
	/// 	Update an existing row in the datasource.
	/// </summary>
	/// <param name="entity">SectionRoutine object to update.</param>
	/// <remarks>After updating the datasource, the SectionRoutine object will be updated
	/// to refelect any changes made by the datasource. (ie: identity columns)</remarks>
	/// <returns>Returns true if operation is successful.</returns>
	bool Update(SectionRoutine entity);


}//end class
} // end namespace