// <Snippet3>
// Returns a collection of NorthwindEmployee objects.
public static ICollection GetAllEmployees()
{
ArrayList al = new ArrayList();
ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"];
SqlDataSource sds
= new SqlDataSource(cts.ConnectionString, "SELECT EmployeeID FROM Employees");
try {
IEnumerable IDs = sds.Select(DataSourceSelectArguments.Empty);
// Iterate through the Enumeration and create a
// NorthwindEmployee object for each ID.
foreach (DataRowView row in IDs)
{
string id = row["EmployeeID"].ToString();
NorthwindEmployee nwe = new NorthwindEmployee(id);
// Add the NorthwindEmployee object to the collection.
al.Add(nwe);
}
}
finally {
// If anything strange happens, clean up.
sds.Dispose();
}
return(al);
}
// Returns a collection of NorthwindEmployee objects.
public static ICollection GetAllEmployees()
{
ArrayList al = new ArrayList();
// Use the SqlDataSource class to wrap the
// ADO.NET code required to query the database.
ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"];
SqlDataSource sds
= new SqlDataSource(cts.ConnectionString,
"SELECT EmployeeID FROM Employees");
try {
IEnumerable IDs = sds.Select(DataSourceSelectArguments.Empty);
// Iterate through the Enumeration and create a
// NorthwindEmployee object for each ID.
IEnumerator enumerator = IDs.GetEnumerator();
while (enumerator.MoveNext())
{
// The IEnumerable contains DataRowView objects.
DataRowView row = enumerator.Current as DataRowView;
int id = (int)row["EmployeeID"];
NorthwindEmployee nwe = new NorthwindEmployee(id);
// Add the NorthwindEmployee object to the collection.
al.Add(nwe);
}
}
finally {
// If anything strange happens, clean up.
sds.Dispose();
}
return(al);
}
// <snippet3>
public static void UpdateEmployee(NorthwindEmployee ne)
{
bool retval = ne.Update();
if (!retval)
{
throw new NorthwindDataException("Employee update failed.");
}
}
public static void InsertNewEmployee(NorthwindEmployee ne)
{
bool retval = ne.Save();
if (!retval)
{
throw new NorthwindDataException("InsertNewEmployee failed.");
}
}
public static void DeleteEmployee(NorthwindEmployee ne)
{
bool retval = ne.Delete();
if (!retval)
{
throw new NorthwindDataException("DeleteEmployee failed.");
}
}
public static void DeleteEmployee(NorthwindEmployee ne)
{
bool retval = ne.Delete();
if (!retval)
{
throw new NorthwindDataException("Employee delete failed.");
}
// Delete the object in memory.
ne = null;
}
// This method is added as a conveniece wrapper on the original
// implementation.
public static void UpdateEmployeeWrapper(string anID,
string anAddress,
string aCity,
string aPostalCode)
{
NorthwindEmployee ne = new NorthwindEmployee(anID);
ne.Address = anAddress;
ne.City = aCity;
ne.PostalCode = aPostalCode;
UpdateEmployee(ne);
}
public static NorthwindEmployee GetEmployee(object anID)
{
ArrayList al = GetAllEmployees() as ArrayList;
IEnumerator enumerator = al.GetEnumerator();
while (enumerator.MoveNext())
{
// The IEnumerable contains initialized NorthwindEmployee objects.
NorthwindEmployee ne = enumerator.Current as NorthwindEmployee;
if (ne.EmpID.Equals(anID.ToString()))
{
return(ne);
}
}
return(null);
}
// <snippet3>
// This InsertNewEmployeeWrapper method is a wrapper method that enables
// the use of ObjectDataSource and InsertParameters, without
// substantially rewriting the true implementation for the NorthwindEmployee
// or the EmployeeLogic objects.
//
// The parameters to the method must be named the same as the
// DataControlFields used by the GridView or DetailsView controls.
public static void InsertNewEmployeeWrapper(string FirstName,
string LastName,
string Title,
string Courtesy,
int Supervisor)
{
// Build the NorthwindEmployee object and
// call the true implementation.
NorthwindEmployee tempEmployee = new NorthwindEmployee();
tempEmployee.FirstName = FirstName;
tempEmployee.LastName = LastName;
tempEmployee.Title = Title;
tempEmployee.Courtesy = Courtesy;
tempEmployee.Supervisor = Supervisor;
// Call the true implementation.
InsertNewEmployee(tempEmployee);
}
public static void DeleteEmployee(int anID)
{
NorthwindEmployee tempEmp = new NorthwindEmployee(anID);
DeleteEmployee(tempEmp);
}
public static void DeleteEmployee(NorthwindEmployee ne)
{
}
