/* Insert */
public void AddPageToUser(int pageId)
{
try
{
if (_userName == string.Empty && _userId < 0)
throw new Exception("error: no user selected...");
int userId = (_userName != string.Empty
? _db.Users.Single(x => x.Name == _userName)
: _db.Users.Single(x => x.ID == _userId)).ID;
PageUsers pu = new PageUsers
{
IDUser = userId,
IDPage = pageId
};
_db.PageUsers.InsertOnSubmit(pu);
CommitPages();
}
catch (Exception ex)
{
throw new Exception("error: inserting new page to user " + _userName + " - " + ex.Message + " ...");
}
}
private PageUsers CopyPage(PageUsers pu)
{
PageUsers npu = new PageUsers
{
IDPage = pu.IDPage,
IDUser = pu.IDUser
};
return npu;
}
private void PageUsers_Detach(PageUsers entity)
{
this.SendPropertyChanging();
entity.Users = null;
}
public void AddPageToUser(string username, int pageId)
{
try
{
using (_db)
{
int userId = _db.Users.Single(u => u.Name == username).ID;
PageUsers pu = new PageUsers
{
IDUser = userId,
IDPage = pageId
};
_db.PageUsers.InsertOnSubmit(pu);
CommitPages();
}
}
catch (Exception ex)
{
throw new Exception("error: inserting new page to user " + _userName + " - " + ex.Message + " ...");
}
}
private void PageUsers_Attach(PageUsers entity)
{
this.SendPropertyChanging();
entity.Users = this;
}
