public static void UpdateRightsRelation(int userId, int rightId, bool relationExist)
{
CanonDataContext db = Cdb.Instance;
try
{
UsersRight uc = db.UsersRights.First(u => u.UserId == userId && u.Rights == rightId);
if (!relationExist)
{
db.UsersRights.DeleteOnSubmit(uc);
}
}
catch (Exception ex)
{
//there is no such relation
if (relationExist)
{
UsersRight newUc = new UsersRight();
newUc.Rights = rightId;
newUc.UserId = userId;
db.UsersRights.InsertOnSubmit(newUc);
}
}
db.SubmitChanges();
}
public static void UpdateRightsRelation(int userId, int rightId, bool relationExist)
{
CanonDataContext db = Cdb.Instance;
try
{
UsersRight uc = db.UsersRights.First(u => u.UserId == userId && u.Rights == rightId);
if (!relationExist)
db.UsersRights.DeleteOnSubmit(uc);
}
catch (Exception ex)
{
//there is no such relation
if (relationExist)
{
UsersRight newUc = new UsersRight();
newUc.Rights = rightId;
newUc.UserId = userId;
db.UsersRights.InsertOnSubmit(newUc);
}
}
db.SubmitChanges();
}
