public static void SaveEmployeeMap(byte varShiftID, byte[] itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE ShiftID=@ShiftID", Shift.Schema.Provider.Name); cmdDel.AddParameter("@ShiftID", varShiftID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (byte item in itemList) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", varShiftID); varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", item); varEmployeeDepartmentHistory.Save(); } }
public static void SaveShiftMap(int varEmployeeID, ShiftCollection items) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE EmployeeID=@EmployeeID", Employee.Schema.Provider.Name); cmdDel.AddParameter("@EmployeeID", varEmployeeID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (Shift item in items) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("EmployeeID", varEmployeeID); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", item.GetPrimaryKeyValue()); varEmployeeDepartmentHistory.Save(); } }
public static void SaveDepartmentMap(byte varShiftID, System.Web.UI.WebControls.ListItemCollection itemList) { QueryCommandCollection coll = new SubSonic.QueryCommandCollection(); //delete out the existing QueryCommand cmdDel = new QueryCommand("DELETE FROM EmployeeDepartmentHistory WHERE ShiftID=@ShiftID", Shift.Schema.Provider.Name); cmdDel.AddParameter("@ShiftID", varShiftID); coll.Add(cmdDel); DataService.ExecuteTransaction(coll); foreach (System.Web.UI.WebControls.ListItem l in itemList) { if (l.Selected) { EmployeeDepartmentHistory varEmployeeDepartmentHistory = new EmployeeDepartmentHistory(); varEmployeeDepartmentHistory.SetColumnValue("ShiftID", varShiftID); varEmployeeDepartmentHistory.SetColumnValue("DepartmentID", l.Value); varEmployeeDepartmentHistory.Save(); } } }