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 EmployeeID=@EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID); //add this in 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); }