public void Insert(int ProjectID, int UserID)
{
ProjectAssignment item = new ProjectAssignment();
item.ProjectID = ProjectID;
item.UserID = UserID;
item.Save(UserName);
}
public void Update(int ProjectID, int UserID)
{
ProjectAssignment item = new ProjectAssignment();
item.MarkOld();
item.IsLoaded = true;
item.ProjectID = ProjectID;
item.UserID = UserID;
item.Save(UserName);
}
public static void SaveUserMap(int varId, int[] itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [ProjectAssignments] WHERE [ProjectAssignments].[ProjectID] = @ProjectID", Project.Schema.Provider.Name);
cmdDel.AddParameter("@ProjectID", varId, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (int item in itemList)
{
ProjectAssignment varProjectAssignment = new ProjectAssignment();
varProjectAssignment.SetColumnValue("ProjectID", varId);
varProjectAssignment.SetColumnValue("UserID", item);
varProjectAssignment.Save();
}
}
public static void SaveProjectMap(int varId, System.Web.UI.WebControls.ListItemCollection itemList)
{
QueryCommandCollection coll = new SubSonic.QueryCommandCollection();
//delete out the existing
QueryCommand cmdDel = new QueryCommand("DELETE FROM [ProjectAssignments] WHERE [ProjectAssignments].[UserID] = @UserID", User.Schema.Provider.Name);
cmdDel.AddParameter("@UserID", varId, DbType.Int32);
coll.Add(cmdDel);
DataService.ExecuteTransaction(coll);
foreach (System.Web.UI.WebControls.ListItem l in itemList)
{
if (l.Selected)
{
ProjectAssignment varProjectAssignment = new ProjectAssignment();
varProjectAssignment.SetColumnValue("UserID", varId);
varProjectAssignment.SetColumnValue("ProjectID", l.Value);
varProjectAssignment.Save();
}
}
}
public bool Destroy(object ProjectID)
{
return(ProjectAssignment.Destroy(ProjectID) == 1);
}
public bool Delete(object ProjectID)
{
return(ProjectAssignment.Delete(ProjectID) == 1);
}
