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 SubSonic;
using SubSonic.Utilities;
//Generated on 11/6/2007 2:44:49 PM by Alex
namespace Model.Data.Northwind
{
/// <summary>
/// Controller class for Employees
/// </summary>
[System.ComponentModel.DataObject]
public partial class EmployeeController
{
// Preload our schema..
Employee thisSchemaLoad = new Employee();
private string userName = string.Empty;
protected string UserName
{
get
{
if (userName.Length == 0)
{
if (System.Web.HttpContext.Current != null)
{
userName=System.Web.HttpContext.Current.User.Identity.Name;
}
else
{
userName=System.Threading.Thread.CurrentPrincipal.Identity.Name;
}
}
return userName;
}
}
[DataObjectMethod(DataObjectMethodType.Select, true)]
public EmployeeCollection FetchAll()
{
EmployeeCollection coll = new EmployeeCollection();
Query qry = new Query(Employee.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
[DataObjectMethod(DataObjectMethodType.Select, false)]
public EmployeeCollection FetchByID(object EmployeeID)
{
EmployeeCollection coll = new EmployeeCollection().Where("EmployeeID", EmployeeID).Load();
return coll;
}
[DataObjectMethod(DataObjectMethodType.Select, false)]
public EmployeeCollection FetchByQuery(Query qry)
{
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
[DataObjectMethod(DataObjectMethodType.Delete, true)]
public bool Delete(object EmployeeID)
{
return (Employee.Delete(EmployeeID) == 1);
}
[DataObjectMethod(DataObjectMethodType.Delete, false)]
public bool Destroy(object EmployeeID)
{
return (Employee.Destroy(EmployeeID) == 1);
}
[DataObjectMethod(DataObjectMethodType.Delete, true)]
public bool Delete(int EmployeeID)
{
Query qry = new Query(Employee.Schema);
qry.QueryType = QueryType.Delete;
qry.AddWhere("EmployeeID", EmployeeID);
qry.Execute();
return (true);
}
/// <summary>
/// Inserts a record, can be used with the Object Data Source
/// </summary>
[DataObjectMethod(DataObjectMethodType.Insert, true)]
public void Insert(string LastName,string FirstName,string Title,string TitleOfCourtesy,DateTime? BirthDate,DateTime? HireDate,string Address,string City,string Region,string PostalCode,string Country,string HomePhone,string Extension,byte[] Photo,string Notes,int? ReportsTo,string PhotoPath)
{
Employee item = new Employee();
item.LastName = LastName;
item.FirstName = FirstName;
item.Title = Title;
item.TitleOfCourtesy = TitleOfCourtesy;
item.BirthDate = BirthDate;
item.HireDate = HireDate;
item.Address = Address;
item.City = City;
item.Region = Region;
item.PostalCode = PostalCode;
item.Country = Country;
item.HomePhone = HomePhone;
item.Extension = Extension;
item.Photo = Photo;
item.Notes = Notes;
item.ReportsTo = ReportsTo;
item.PhotoPath = PhotoPath;
item.Save(UserName);
}
/// <summary>
/// Updates a record, can be used with the Object Data Source
/// </summary>
[DataObjectMethod(DataObjectMethodType.Update, true)]
public void Update(int EmployeeID,string LastName,string FirstName,string Title,string TitleOfCourtesy,DateTime? BirthDate,DateTime? HireDate,string Address,string City,string Region,string PostalCode,string Country,string HomePhone,string Extension,byte[] Photo,string Notes,int? ReportsTo,string PhotoPath)
{
Employee item = new Employee();
item.EmployeeID = EmployeeID;
item.LastName = LastName;
item.FirstName = FirstName;
item.Title = Title;
item.TitleOfCourtesy = TitleOfCourtesy;
item.BirthDate = BirthDate;
item.HireDate = HireDate;
item.Address = Address;
item.City = City;
item.Region = Region;
item.PostalCode = PostalCode;
item.Country = Country;
item.HomePhone = HomePhone;
item.Extension = Extension;
item.Photo = Photo;
item.Notes = Notes;
item.ReportsTo = ReportsTo;
item.PhotoPath = PhotoPath;
item.MarkOld();
item.Save(UserName);
}
}
}