public void Insert(int EmployeeID, string TerritoryID) { EmployeeTerritory item = new EmployeeTerritory(); item.EmployeeID = EmployeeID; item.TerritoryID = TerritoryID; item.Save(UserName); }
public void Update(int EmployeeID, string TerritoryID) { EmployeeTerritory item = new EmployeeTerritory(); item.EmployeeID = EmployeeID; item.TerritoryID = TerritoryID; item.MarkOld(); item.Save(UserName); }
public static void SaveTerritoryMap(int varEmployeeID, int[] itemList) { 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 (int item in itemList) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeTerritory.SetColumnValue("TerritoryID", item); varEmployeeTerritory.Save(); } }
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 static void SaveEmployeeMap(string varTerritoryID, System.Web.UI.WebControls.ListItemCollection itemList) { 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 (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { EmployeeTerritory varEmployeeTerritory = new EmployeeTerritory(); varEmployeeTerritory.SetColumnValue("TerritoryID", varTerritoryID); varEmployeeTerritory.SetColumnValue("EmployeeID", l.Value); varEmployeeTerritory.Save(); } } }
public bool Destroy(object EmployeeID) { return(EmployeeTerritory.Destroy(EmployeeID) == 1); }
public bool Delete(object EmployeeID) { return(EmployeeTerritory.Delete(EmployeeID) == 1); }