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);
}
}
