public EmployeeCollection FetchByQuery(Query qry)
{
EmployeeCollection coll = new EmployeeCollection();
coll.Load(qry.ExecuteReader());
return(coll);
}
public EmployeeCollection FetchAll()
{
EmployeeCollection coll = new EmployeeCollection();
Query qry = new Query(Employee.Schema);
coll.Load(qry.ExecuteReader());
return(coll);
}
public static Chapter08.NorthwindDAL.EmployeeCollection GetEmployeeCollection(string varTerritoryID)
{
SubSonic.QueryCommand cmd = new SubSonic.QueryCommand(
"SELECT * FROM Employees INNER JOIN EmployeeTerritories ON " +
"Employees.EmployeeID=EmployeeTerritories.EmployeeID WHERE EmployeeTerritories.TerritoryID=@TerritoryID", Territory.Schema.Provider.Name);
cmd.AddParameter("@TerritoryID", varTerritoryID);
IDataReader rdr = SubSonic.DataService.GetReader(cmd);
EmployeeCollection coll = new EmployeeCollection();
coll.LoadAndCloseReader(rdr);
return(coll);
}
public static void SaveEmployeeMap(string varTerritoryID, EmployeeCollection items)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeTerritories WHERE TerritoryID=@TerritoryID", Territory.Schema.Provider.Name);
cmdDel.AddParameter("@TerritoryID", varTerritoryID);
//add this in
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (Employee item in items)
{
EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory();
varEmployeeTerritory.SetColumnValue("TerritoryID", varTerritoryID);
varEmployeeTerritory.SetColumnValue("EmployeeID", item.GetPrimaryKeyValue());
varEmployeeTerritory.Save();
}
}
public EmployeeCollection FetchByID(object EmployeeID)
{
EmployeeCollection coll = new EmployeeCollection().Where("EmployeeID", EmployeeID).Load();
return(coll);
}
