public Dictionary <Pivot, bool> GetByRefereeId(Guid congressId, Guid?refreeId) { try { var list = new Dictionary <Pivot, bool>(); var byFilter = new PivotBO().OrderBy(this.ConnectionHandler, x => x.Order, x => x.CongressId == congressId); var refereePivotBo = new RefereePivotBO(); var @select = refereePivotBo.Select(ConnectionHandler, new Expression <Func <RefereePivot, object> >[] { x => x.RefereeId, x => x.PivotId }, x => x.Pivot.CongressId == congressId); foreach (var variable in byFilter) { var added = false; if (refreeId != null) { added = @select.Any(x => x.RefereeId == refreeId && x.PivotId == variable.Id); } list.Add(variable, added); } return(list); } catch (KnownException ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public override bool Delete(params object[] keys) { try { this.ConnectionHandler.StartTransaction(IsolationLevel.ReadUncommitted); this.EnterpriseNodeConnection.StartTransaction(IsolationLevel.ReadUncommitted); var obj = new RefereeBO().Get(this.ConnectionHandler, keys); var byFilter = new RefereeCartableBO().Any(this.ConnectionHandler, cartable => cartable.RefereeId == obj.Id); if (byFilter) { throw new Exception(Resources.Congress.ErrorInDeleteRefereeBecauseHisCartablContainArticle); } var refereePivotBo = new RefereePivotBO(); var list = refereePivotBo.Select(this.ConnectionHandler, x => x.PivotId, x => x.RefereeId == obj.Id); foreach (var refereePivot in list) { if (!refereePivotBo.Delete(this.ConnectionHandler, obj.Id, refereePivot)) { throw new Exception(Resources.Congress.ErrorInEditReferee); } } if (!new RefereeBO().Delete(this.ConnectionHandler, keys)) { throw new Exception(Resources.Congress.ErrorInDeleteReferee); } if ( !EnterpriseNodeComponent.Instance.EnterpriseNodeTransactionalFacade(this.EnterpriseNodeConnection) .Delete(keys)) { return(false); } this.ConnectionHandler.CommitTransaction(); this.EnterpriseNodeConnection.CommitTransaction(); return(true); } catch (KnownException ex) { this.ConnectionHandler.RollBack(); this.EnterpriseNodeConnection.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { this.ConnectionHandler.RollBack(); this.EnterpriseNodeConnection.RollBack(); Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }
public Dictionary <Referee, bool> GetBypivotId(Guid pivotId) { try { var list = new Dictionary <Referee, bool>(); var byFilter = new RefereePivotBO().OrderBy(this.ConnectionHandler, x => x.Referee.EnterpriseNode.RealEnterpriseNode.FirstName + " " + x.Referee.EnterpriseNode.RealEnterpriseNode.LastName, x => x.PivotId == pivotId); foreach (var variable in byFilter) { list.Add(variable.Referee, true); } return(list); } catch (KnownException ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } catch (Exception ex) { Log.Save(ex.Message, LogType.ApplicationError, ex.Source, ex.StackTrace); throw new KnownException(ex.Message, ex); } }