public static void SaveTerritoryMap(int varEmployeeID, TerritoryCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM [EmployeeTerritories] WHERE [EmployeeTerritories].[EmployeeID] = @EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID, DbType.Int32); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Territory item in items) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeTerritory.SetColumnValue("TerritoryID", item.GetPrimaryKeyValue()); varEmployeeTerritory.Save(); } }
public TerritoryCollection FetchByID(object TerritoryID) { TerritoryCollection coll = new TerritoryCollection().Where("TerritoryID", TerritoryID).Load(); return(coll); }