Click here to Skip to main content
11,629,535 members (65,730 online)
Click here to Skip to main content
Articles » Web Development » ASP.NET » General » Downloads
Add your own
alternative version

Implementing Model-View-Presenter in ASP.NET

, 17 Nov 2007 CPOL 98.2K 2.6K 122
Three implementations of Model-View-Presenter in ASP.NET 2.0.
MVPSampleApp.zip
MVP.SampleApp
Lib
Microsoft.Practices.EnterpriseLibrary.Common.dll
Microsoft.Practices.EnterpriseLibrary.Data.dll
MySql.Data.dll
nunit.framework.dll
Rhino.Mocks.dll
Model
Data
Interfaces
Properties
Presentation
Presentation.Tests
Properties
Interfaces
Properties
SubSonic
ActiveRecord
Builder
CodeGeneration
Templates
CodeLanguage
Configuration
Controls
Calendar
lang
skin
active-bg.gif
calendar.gif
dark-bg.gif
hover-bg.gif
menuarrow.gif
normal-bg.gif
rowhover-bg.gif
status-bg.gif
title-bg.gif
today-bg.gif
Resources
DataProviders
Properties
Sql Tools
SubSonic.snk
Sugar
WebApp
App_Data
Views
SQL2000SampleDb.zip
SQL2000SampleDb.msi
using System;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Xml;
using System.Xml.Serialization;
using Model.Data.Interfaces;
using SubSonic;
using SubSonic.Utilities;

//Generated on 11/6/2007 2:44:49 PM by Alex

namespace Model.Data.Northwind{
    /// <summary>
    /// Strongly-typed collection for the Employee class.
    /// </summary>
    [Serializable]
    public partial class EmployeeCollection : ActiveList<Employee, EmployeeCollection> 
    {       
        public EmployeeCollection() {}

    }

    /// <summary>
    /// This is an ActiveRecord class which wraps the Employees table.
    /// </summary>
    [Serializable]
    public partial class Employee : ActiveRecord<Employee>, IEmployee 
    {
    
	    #region Default Settings
	    protected static void SetSQLProps() 
	    {
		    GetTableSchema();
	    }

	    #endregion
        #region Schema Accessor
	    public static TableSchema.Table Schema
        {
            get
            {
                if (BaseSchema == null)
                {
                    SetSQLProps();
                }

                return BaseSchema;
            }

        }

    	
        private static void GetTableSchema() 
	    {
            if(!IsSchemaInitialized)
            {
                //Schema declaration
				TableSchema.Table schema = new TableSchema.Table("Employees", TableType.Table, DataService.GetInstance("Northwind"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = @"dbo";
                //columns
                
                TableSchema.TableColumn colvarEmployeeID = new TableSchema.TableColumn(schema);
                colvarEmployeeID.ColumnName = "EmployeeID";
                colvarEmployeeID.DataType = DbType.Int32;
                colvarEmployeeID.MaxLength = 0;
                colvarEmployeeID.AutoIncrement = true;
                colvarEmployeeID.IsNullable = false;
                colvarEmployeeID.IsPrimaryKey = true;
                colvarEmployeeID.IsForeignKey = false;
                colvarEmployeeID.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarEmployeeID);
                
                TableSchema.TableColumn colvarLastName = new TableSchema.TableColumn(schema);
                colvarLastName.ColumnName = "LastName";
                colvarLastName.DataType = DbType.String;
                colvarLastName.MaxLength = 20;
                colvarLastName.AutoIncrement = false;
                colvarLastName.IsNullable = false;
                colvarLastName.IsPrimaryKey = false;
                colvarLastName.IsForeignKey = false;
                colvarLastName.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarLastName);
                
                TableSchema.TableColumn colvarFirstName = new TableSchema.TableColumn(schema);
                colvarFirstName.ColumnName = "FirstName";
                colvarFirstName.DataType = DbType.String;
                colvarFirstName.MaxLength = 10;
                colvarFirstName.AutoIncrement = false;
                colvarFirstName.IsNullable = false;
                colvarFirstName.IsPrimaryKey = false;
                colvarFirstName.IsForeignKey = false;
                colvarFirstName.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarFirstName);
                
                TableSchema.TableColumn colvarTitle = new TableSchema.TableColumn(schema);
                colvarTitle.ColumnName = "Title";
                colvarTitle.DataType = DbType.String;
                colvarTitle.MaxLength = 30;
                colvarTitle.AutoIncrement = false;
                colvarTitle.IsNullable = true;
                colvarTitle.IsPrimaryKey = false;
                colvarTitle.IsForeignKey = false;
                colvarTitle.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarTitle);
                
                TableSchema.TableColumn colvarTitleOfCourtesy = new TableSchema.TableColumn(schema);
                colvarTitleOfCourtesy.ColumnName = "TitleOfCourtesy";
                colvarTitleOfCourtesy.DataType = DbType.String;
                colvarTitleOfCourtesy.MaxLength = 25;
                colvarTitleOfCourtesy.AutoIncrement = false;
                colvarTitleOfCourtesy.IsNullable = true;
                colvarTitleOfCourtesy.IsPrimaryKey = false;
                colvarTitleOfCourtesy.IsForeignKey = false;
                colvarTitleOfCourtesy.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarTitleOfCourtesy);
                
                TableSchema.TableColumn colvarBirthDate = new TableSchema.TableColumn(schema);
                colvarBirthDate.ColumnName = "BirthDate";
                colvarBirthDate.DataType = DbType.DateTime;
                colvarBirthDate.MaxLength = 0;
                colvarBirthDate.AutoIncrement = false;
                colvarBirthDate.IsNullable = true;
                colvarBirthDate.IsPrimaryKey = false;
                colvarBirthDate.IsForeignKey = false;
                colvarBirthDate.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarBirthDate);
                
                TableSchema.TableColumn colvarHireDate = new TableSchema.TableColumn(schema);
                colvarHireDate.ColumnName = "HireDate";
                colvarHireDate.DataType = DbType.DateTime;
                colvarHireDate.MaxLength = 0;
                colvarHireDate.AutoIncrement = false;
                colvarHireDate.IsNullable = true;
                colvarHireDate.IsPrimaryKey = false;
                colvarHireDate.IsForeignKey = false;
                colvarHireDate.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarHireDate);
                
                TableSchema.TableColumn colvarAddress = new TableSchema.TableColumn(schema);
                colvarAddress.ColumnName = "Address";
                colvarAddress.DataType = DbType.String;
                colvarAddress.MaxLength = 60;
                colvarAddress.AutoIncrement = false;
                colvarAddress.IsNullable = true;
                colvarAddress.IsPrimaryKey = false;
                colvarAddress.IsForeignKey = false;
                colvarAddress.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarAddress);
                
                TableSchema.TableColumn colvarCity = new TableSchema.TableColumn(schema);
                colvarCity.ColumnName = "City";
                colvarCity.DataType = DbType.String;
                colvarCity.MaxLength = 15;
                colvarCity.AutoIncrement = false;
                colvarCity.IsNullable = true;
                colvarCity.IsPrimaryKey = false;
                colvarCity.IsForeignKey = false;
                colvarCity.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarCity);
                
                TableSchema.TableColumn colvarRegion = new TableSchema.TableColumn(schema);
                colvarRegion.ColumnName = "Region";
                colvarRegion.DataType = DbType.String;
                colvarRegion.MaxLength = 15;
                colvarRegion.AutoIncrement = false;
                colvarRegion.IsNullable = true;
                colvarRegion.IsPrimaryKey = false;
                colvarRegion.IsForeignKey = false;
                colvarRegion.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarRegion);
                
                TableSchema.TableColumn colvarPostalCode = new TableSchema.TableColumn(schema);
                colvarPostalCode.ColumnName = "PostalCode";
                colvarPostalCode.DataType = DbType.String;
                colvarPostalCode.MaxLength = 10;
                colvarPostalCode.AutoIncrement = false;
                colvarPostalCode.IsNullable = true;
                colvarPostalCode.IsPrimaryKey = false;
                colvarPostalCode.IsForeignKey = false;
                colvarPostalCode.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarPostalCode);
                
                TableSchema.TableColumn colvarCountry = new TableSchema.TableColumn(schema);
                colvarCountry.ColumnName = "Country";
                colvarCountry.DataType = DbType.String;
                colvarCountry.MaxLength = 15;
                colvarCountry.AutoIncrement = false;
                colvarCountry.IsNullable = true;
                colvarCountry.IsPrimaryKey = false;
                colvarCountry.IsForeignKey = false;
                colvarCountry.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarCountry);
                
                TableSchema.TableColumn colvarHomePhone = new TableSchema.TableColumn(schema);
                colvarHomePhone.ColumnName = "HomePhone";
                colvarHomePhone.DataType = DbType.String;
                colvarHomePhone.MaxLength = 24;
                colvarHomePhone.AutoIncrement = false;
                colvarHomePhone.IsNullable = true;
                colvarHomePhone.IsPrimaryKey = false;
                colvarHomePhone.IsForeignKey = false;
                colvarHomePhone.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarHomePhone);
                
                TableSchema.TableColumn colvarExtension = new TableSchema.TableColumn(schema);
                colvarExtension.ColumnName = "Extension";
                colvarExtension.DataType = DbType.String;
                colvarExtension.MaxLength = 4;
                colvarExtension.AutoIncrement = false;
                colvarExtension.IsNullable = true;
                colvarExtension.IsPrimaryKey = false;
                colvarExtension.IsForeignKey = false;
                colvarExtension.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarExtension);
                
                TableSchema.TableColumn colvarPhoto = new TableSchema.TableColumn(schema);
                colvarPhoto.ColumnName = "Photo";
                colvarPhoto.DataType = DbType.Binary;
                colvarPhoto.MaxLength = 2147483647;
                colvarPhoto.AutoIncrement = false;
                colvarPhoto.IsNullable = true;
                colvarPhoto.IsPrimaryKey = false;
                colvarPhoto.IsForeignKey = false;
                colvarPhoto.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarPhoto);
                
                TableSchema.TableColumn colvarNotes = new TableSchema.TableColumn(schema);
                colvarNotes.ColumnName = "Notes";
                colvarNotes.DataType = DbType.String;
                colvarNotes.MaxLength = 1073741823;
                colvarNotes.AutoIncrement = false;
                colvarNotes.IsNullable = true;
                colvarNotes.IsPrimaryKey = false;
                colvarNotes.IsForeignKey = false;
                colvarNotes.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarNotes);
                
                TableSchema.TableColumn colvarReportsTo = new TableSchema.TableColumn(schema);
                colvarReportsTo.ColumnName = "ReportsTo";
                colvarReportsTo.DataType = DbType.Int32;
                colvarReportsTo.MaxLength = 0;
                colvarReportsTo.AutoIncrement = false;
                colvarReportsTo.IsNullable = true;
                colvarReportsTo.IsPrimaryKey = false;
                colvarReportsTo.IsForeignKey = true;
                colvarReportsTo.IsReadOnly = false;
                
                
				colvarReportsTo.ForeignKeyTableName = "Employees";
                
                schema.Columns.Add(colvarReportsTo);
                
                TableSchema.TableColumn colvarPhotoPath = new TableSchema.TableColumn(schema);
                colvarPhotoPath.ColumnName = "PhotoPath";
                colvarPhotoPath.DataType = DbType.String;
                colvarPhotoPath.MaxLength = 255;
                colvarPhotoPath.AutoIncrement = false;
                colvarPhotoPath.IsNullable = true;
                colvarPhotoPath.IsPrimaryKey = false;
                colvarPhotoPath.IsForeignKey = false;
                colvarPhotoPath.IsReadOnly = false;
                
                
                schema.Columns.Add(colvarPhotoPath);
                
                BaseSchema = schema;
                //add this schema to the provider
                //so we can query it later
                DataService.Providers["Northwind"].AddSchema("Employees",schema);
            }

        }

        #endregion
        
        #region Query Accessor
	    public static Query CreateQuery()
	    {
		    return new Query(Schema);
	    }

	    #endregion
	    
	    #region .ctors
	    public Employee()
	    {
            SetSQLProps();
            SetDefaults();
            MarkNew();
        }

        
        public Employee(bool useDatabaseDefaults)
	    {
		    SetSQLProps();
		    if(useDatabaseDefaults)
		    {
				ForceDefaults();
			}

			MarkNew();
	    }

	    public Employee(object keyID)
	    {
		    SetSQLProps();
            SetDefaults();
		    LoadByKey(keyID);
	    }

    	 
	    public Employee(string columnName, object columnValue)
        {
            SetSQLProps();
            SetDefaults();
            LoadByParam(columnName,columnValue);
        }

        
	    #endregion
	    
	    #region Props
	    
          
        [XmlAttribute("EmployeeID")]
        public int EmployeeID 
	    {
		    get { return GetColumnValue<int>("EmployeeID"); }

            set 
		    {
			    SetColumnValue("EmployeeID", value);
            }

        }

	      
        [XmlAttribute("LastName")]
        public string LastName 
	    {
		    get { return GetColumnValue<string>("LastName"); }

            set 
		    {
			    SetColumnValue("LastName", value);
            }

        }

	      
        [XmlAttribute("FirstName")]
        public string FirstName 
	    {
		    get { return GetColumnValue<string>("FirstName"); }

            set 
		    {
			    SetColumnValue("FirstName", value);
            }

        }

	      
        [XmlAttribute("Title")]
        public string Title 
	    {
		    get { return GetColumnValue<string>("Title"); }

            set 
		    {
			    SetColumnValue("Title", value);
            }

        }

	      
        [XmlAttribute("TitleOfCourtesy")]
        public string TitleOfCourtesy 
	    {
		    get { return GetColumnValue<string>("TitleOfCourtesy"); }

            set 
		    {
			    SetColumnValue("TitleOfCourtesy", value);
            }

        }

	      
        [XmlAttribute("BirthDate")]
        public DateTime? BirthDate 
	    {
		    get { return GetColumnValue<DateTime?>("BirthDate"); }

            set 
		    {
			    SetColumnValue("BirthDate", value);
            }

        }

	      
        [XmlAttribute("HireDate")]
        public DateTime? HireDate 
	    {
		    get { return GetColumnValue<DateTime?>("HireDate"); }

            set 
		    {
			    SetColumnValue("HireDate", value);
            }

        }

	      
        [XmlAttribute("Address")]
        public string Address 
	    {
		    get { return GetColumnValue<string>("Address"); }

            set 
		    {
			    SetColumnValue("Address", value);
            }

        }

	      
        [XmlAttribute("City")]
        public string City 
	    {
		    get { return GetColumnValue<string>("City"); }

            set 
		    {
			    SetColumnValue("City", value);
            }

        }

	      
        [XmlAttribute("Region")]
        public string Region 
	    {
		    get { return GetColumnValue<string>("Region"); }

            set 
		    {
			    SetColumnValue("Region", value);
            }

        }

	      
        [XmlAttribute("PostalCode")]
        public string PostalCode 
	    {
		    get { return GetColumnValue<string>("PostalCode"); }

            set 
		    {
			    SetColumnValue("PostalCode", value);
            }

        }

	      
        [XmlAttribute("Country")]
        public string Country 
	    {
		    get { return GetColumnValue<string>("Country"); }

            set 
		    {
			    SetColumnValue("Country", value);
            }

        }

	      
        [XmlAttribute("HomePhone")]
        public string HomePhone 
	    {
		    get { return GetColumnValue<string>("HomePhone"); }

            set 
		    {
			    SetColumnValue("HomePhone", value);
            }

        }

	      
        [XmlAttribute("Extension")]
        public string Extension 
	    {
		    get { return GetColumnValue<string>("Extension"); }

            set 
		    {
			    SetColumnValue("Extension", value);
            }

        }

	      
        [XmlAttribute("Photo")]
        public byte[] Photo 
	    {
		    get { return GetColumnValue<byte[]>("Photo"); }

            set 
		    {
			    SetColumnValue("Photo", value);
            }

        }

	      
        [XmlAttribute("Notes")]
        public string Notes 
	    {
		    get { return GetColumnValue<string>("Notes"); }

            set 
		    {
			    SetColumnValue("Notes", value);
            }

        }

	      
        [XmlAttribute("ReportsTo")]
        public int? ReportsTo 
	    {
		    get { return GetColumnValue<int?>("ReportsTo"); }

            set 
		    {
			    SetColumnValue("ReportsTo", value);
            }

        }

	      
        [XmlAttribute("PhotoPath")]
        public string PhotoPath 
	    {
		    get { return GetColumnValue<string>("PhotoPath"); }

            set 
		    {
			    SetColumnValue("PhotoPath", value);
            }

        }

	    
	    #endregion
	    
	    
	    #region PrimaryKey Methods
	    
		public Model.Data.Northwind.EmployeeCollection ChildEmployees()
		{
			return new Model.Data.Northwind.EmployeeCollection().Where(Employee.Columns.ReportsTo, EmployeeID).Load();
		}

		public Model.Data.Northwind.OrderCollection Orders()
		{
			return new Model.Data.Northwind.OrderCollection().Where(Order.Columns.EmployeeID, EmployeeID).Load();
		}

		#endregion
		
	 	
			
	    
	    
	    
	    #region ForeignKey Properties
	    
        /// <summary>
        /// Returns a Employee ActiveRecord object related to this Employee
        /// 
        /// </summary>
	    public Model.Data.Northwind.Employee ParentEmployee
        {
	        get { return Model.Data.Northwind.Employee.FetchByID(this.ReportsTo); }

	        set
	        {
	        	SetColumnValue("ReportsTo", value.EmployeeID);
		        //SetColumnValue("ReportsTo", value.EmployeeID);
	        }

        }

	    
	    
	    #endregion
	    
	    
	    
	    #region Many To Many Helpers
	    
	    #endregion
	    
	    #region ObjectDataSource support
    	
    	
	    /// <summary>
	    /// Inserts a record, can be used with the Object Data Source
	    /// </summary>
	    public static void Insert(string varLastName,string varFirstName,string varTitle,string varTitleOfCourtesy,DateTime? varBirthDate,DateTime? varHireDate,string varAddress,string varCity,string varRegion,string varPostalCode,string varCountry,string varHomePhone,string varExtension,byte[] varPhoto,string varNotes,int? varReportsTo,string varPhotoPath)
	    {
		    Employee item = new Employee();
		    
            item.LastName = varLastName;
            
            item.FirstName = varFirstName;
            
            item.Title = varTitle;
            
            item.TitleOfCourtesy = varTitleOfCourtesy;
            
            item.BirthDate = varBirthDate;
            
            item.HireDate = varHireDate;
            
            item.Address = varAddress;
            
            item.City = varCity;
            
            item.Region = varRegion;
            
            item.PostalCode = varPostalCode;
            
            item.Country = varCountry;
            
            item.HomePhone = varHomePhone;
            
            item.Extension = varExtension;
            
            item.Photo = varPhoto;
            
            item.Notes = varNotes;
            
            item.ReportsTo = varReportsTo;
            
            item.PhotoPath = varPhotoPath;
            
	    
		    if (System.Web.HttpContext.Current != null)
			    item.Save(System.Web.HttpContext.Current.User.Identity.Name);
		    else
			    item.Save(System.Threading.Thread.CurrentPrincipal.Identity.Name);
	    }

    	
	    /// <summary>
	    /// Updates a record, can be used with the Object Data Source
	    /// </summary>
	    public static void Update(int varEmployeeID,string varLastName,string varFirstName,string varTitle,string varTitleOfCourtesy,DateTime? varBirthDate,DateTime? varHireDate,string varAddress,string varCity,string varRegion,string varPostalCode,string varCountry,string varHomePhone,string varExtension,byte[] varPhoto,string varNotes,int? varReportsTo,string varPhotoPath)
	    {
		    Employee item = new Employee();
		    
                item.EmployeeID = varEmployeeID;
				
                item.LastName = varLastName;
				
                item.FirstName = varFirstName;
				
                item.Title = varTitle;
				
                item.TitleOfCourtesy = varTitleOfCourtesy;
				
                item.BirthDate = varBirthDate;
				
                item.HireDate = varHireDate;
				
                item.Address = varAddress;
				
                item.City = varCity;
				
                item.Region = varRegion;
				
                item.PostalCode = varPostalCode;
				
                item.Country = varCountry;
				
                item.HomePhone = varHomePhone;
				
                item.Extension = varExtension;
				
                item.Photo = varPhoto;
				
                item.Notes = varNotes;
				
                item.ReportsTo = varReportsTo;
				
                item.PhotoPath = varPhotoPath;
				
		    item.IsNew = false;
		    if (System.Web.HttpContext.Current != null)
			    item.Save(System.Web.HttpContext.Current.User.Identity.Name);
		    else
			    item.Save(System.Threading.Thread.CurrentPrincipal.Identity.Name);
	    }

	    #endregion
	    #region Columns Struct
	    public struct Columns
	    {
		    
		    
            public static string EmployeeID = @"EmployeeID";
            
            public static string LastName = @"LastName";
            
            public static string FirstName = @"FirstName";
            
            public static string Title = @"Title";
            
            public static string TitleOfCourtesy = @"TitleOfCourtesy";
            
            public static string BirthDate = @"BirthDate";
            
            public static string HireDate = @"HireDate";
            
            public static string Address = @"Address";
            
            public static string City = @"City";
            
            public static string Region = @"Region";
            
            public static string PostalCode = @"PostalCode";
            
            public static string Country = @"Country";
            
            public static string HomePhone = @"HomePhone";
            
            public static string Extension = @"Extension";
            
            public static string Photo = @"Photo";
            
            public static string Notes = @"Notes";
            
            public static string ReportsTo = @"ReportsTo";
            
            public static string PhotoPath = @"PhotoPath";
            
	    }

	    #endregion
    }

}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Alex Mueller
Web Developer
United States United States
No Biography provided

You may also be interested in...

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150723.1 | Last Updated 17 Nov 2007
Article Copyright 2007 by Alex Mueller
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid