public Operation <Seccione> getRecordsByMemberInfo(string gender, int age)
{
try
{
//Obtaining the upper age limit of the section in which the member can be assigned by default
int?upper = EntitySingleton.Context.Secciones.Where(x => (x.rangoFin >= age && x.rangoInicio <= age) || (x.rangoFin == null && x.rangoInicio <= age) && x.baja).FirstOrDefault().rangoFin;
List <Seccione> data;
//If the upper age limit is null, it is already in the maximum level of sections
if (upper == null)
{
data = EntitySingleton.Context.Secciones.
Where(x => x.sexo.Equals(gender) && x.rangoFin == null && x.rangoInicio <= age && x.baja).ToList();
}
//If the upper age limit is not null, it will return the section(s) in which the member can be
//assigned by its age, plus the section corresponding to its next level
else
{
data = EntitySingleton.Context.Secciones.
Where(x => x.sexo.Equals(gender) &&
((x.rangoFin >= age && x.rangoInicio <= age) || x.rangoInicio == (upper + 1)) && x.baja).ToList();
}
return(FactoryOperation <Seccione> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Seccione> .getFailOperation(e.Message));
}
}
public Operation <Departamento> getRecords()
{
try
{
List <Departamento> data = EntitySingleton.Context.Departamentos.ToList();
return(FactoryOperation <Departamento> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Departamento> .getFailOperation(e.Message));
}
}
public Operation <MiembroEvento> getRecordsByEvent(Evento ev)
{
try
{
List <MiembroEvento> data = EntitySingleton.Context.MiembroEventoes.Where(x => x.idEvento == ev.idEvento).ToList();
return(FactoryOperation <MiembroEvento> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <MiembroEvento> .getFailOperation(e.Message));
}
}
public Operation <MiembroFuncion> getRecords()
{
try
{
List <MiembroFuncion> data = EntitySingleton.Context.MiembroFuncions.ToList();
return(FactoryOperation <MiembroFuncion> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <MiembroFuncion> .getFailOperation(e.Message));
}
}
public Operation <Escolaridad> getRecords()
{
try
{
List <Escolaridad> data = EntitySingleton.Context.Escolaridads.ToList();
return(FactoryOperation <Escolaridad> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Escolaridad> .getFailOperation(e.Message));
}
}
public Operation <Evento> getActiveRecords()
{
try
{
List <Evento> data = EntitySingleton.Context.Eventos.Where(x => x.baja).ToList();
return(FactoryOperation <Evento> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Evento> .getFailOperation(e.Message));
}
}
public Operation <Perfile> getRecords()
{
try
{
List <Perfile> data = EntitySingleton.Context.Perfiles.ToList();
return(FactoryOperation <Perfile> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Perfile> .getFailOperation(e.Message));
}
}
public Operation <Miembro> getActiveRecords()
{
try
{
List <Miembro> data = EntitySingleton.Context.Miembros.Where(member => member.baja).ToList();
return(FactoryOperation <Miembro> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Miembro> .getFailOperation(e.Message));
}
}
public Operation <Inscripcione> getRecordsByMember(Miembro mem)
{
try
{
List <Inscripcione> data = EntitySingleton.Context.Inscripciones.Where(x => x.idMiembro == mem.idMiembro).ToList();
return(FactoryOperation <Inscripcione> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Inscripcione> .getFailOperation(e.Message));
}
}
public Operation <Grupos> getActiveRecords()
{
try
{
List <Grupos> data = EntitySingleton.Context.Grupos.Where(g => g.baja).ToList();
return(FactoryOperation <Grupos> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Grupos> .getFailOperation(e.Message));
}
}
public Operation <tipo_carrera> getActiveRecords()
{
try
{
List <tipo_carrera> data = EntitySingleton.Context.tipo_carrera.Where(x => x.estado).ToList();
return(FactoryOperation <tipo_carrera> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <tipo_carrera> .getFailOperation(e.Message));
}
}
public Operation <plan> getActiveRecordsByCareer(int idCarrera)
{
try
{
List <plan> data = EntitySingleton.Context.plans.Where(x => x.estado).Where(x => x.idCarrera == idCarrera).ToList();
return(FactoryOperation <plan> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <plan> .getFailOperation(e.Message));
}
}
public Operation <pensum> getRecordsByPlan(long idPlan)
{
try
{
List <pensum> data = EntitySingleton.Context.pensums.Where(x => x.idPlan == idPlan).OrderBy(x => x.corr).ToList();
return(FactoryOperation <pensum> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <pensum> .getFailOperation(e.Message));
}
}
public Operation <materia> getActiveRecords(bool selective)
{
try
{
List <materia> data = EntitySingleton.Context.materias.Where(x => x.estado && x.electiva == selective).ToList();
return(FactoryOperation <materia> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <materia> .getFailOperation(e.Message));
}
}
public Operation <ListaNegra> getBansByResponsableAndMember(int responsable, int member)
{
try
{
List <ListaNegra> data = EntitySingleton.Context.ListaNegras
.Where(ban => ban.idMiembro == member && ban.responsable == responsable && ban.baja).ToList();
return(FactoryOperation <ListaNegra> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <ListaNegra> .getFailOperation(e.Message));
}
}
public Operation <Municipio> getRecordsByDepartment(Departamento department)
{
try
{
List <Municipio> data = EntitySingleton.Context.Municipios.
Where(x => x.idDepartamento.Equals(department.idDepartamento) && x.baja).ToList();
return(FactoryOperation <Municipio> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Municipio> .getFailOperation(e.Message));
}
}
public Operation <tournament> getRecords()
{
try
{
// Los datos en el contexto de torneo, los convierte en lista
List <tournament> data = EntitySingleton.Context.tournament.ToList();
// Retornamos la data
return(FactoryOperation <tournament> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <tournament> .getFailOperation(e.Message));
}
}
public Operation <Miembro> getUnbannedMembers()
{
try
{
List <ListaNegra> bans = EntitySingleton.Context.ListaNegras.Where(ban => ban.baja).ToList();
Func <Miembro, bool> CheckMember = member =>
{
ListaNegra ban = bans.Find(b => b.Miembro.idMiembro == member.idMiembro);
return(member.baja && (ban == null || !ban.baja));
};
List <Miembro> data = EntitySingleton.Context.Miembros.Where(CheckMember).ToList();
return(FactoryOperation <Miembro> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Miembro> .getFailOperation(e.Message));
}
}
public Operation <Miembro> getActiveRecordsByGroupAndEventAvailability(Grupos group, Evento ev)
{
try
{
List <Miembro> unfilteredData = EntitySingleton.Context.Miembros.Where(x => x.baja).ToList();
List <Miembro> data = new List <Miembro>();
List <Cargo> eventPositions = new List <Cargo>();
foreach (EventoCargo ec in ev.EventoCargoes)
{
eventPositions.Add(ec.Cargo);
}
List <Funcione> eventFunctions = new List <Funcione>();
foreach (EventosFuncione ef in ev.EventosFunciones)
{
eventFunctions.Add(ef.Funcione);
}
foreach (Miembro member in unfilteredData)
{
bool isInGroup = false;
bool sectionValid = false;
bool positionValid = false;
bool functionValid = false;
bool hasNoBlackList = true;
//Checking if the member is in the selected group
if (member.Grupos == group)
{
isInGroup = true;
}
//Checking if the member's section is applicable for the event
foreach (EventoSeccion es in ev.EventoSeccions)
{
if (member.Seccione == es.Seccione)
{
sectionValid = true;
break;
}
}
//Checking if one of the member's positions are apllicable for the event
foreach (MiembroCargo mc in member.MiembroCargoes)
{
if (eventPositions.Contains(mc.Cargo))
{
positionValid = true;
break;
}
}
//Checking if one of the member's functions are apllicable for the event
foreach (MiembroFuncion mc in member.MiembroFuncions)
{
if (eventFunctions.Contains(mc.Funcione))
{
if (DateTime.Today >= mc.fechaInicio && DateTime.Today <= mc.fechaFin)
{
functionValid = true;
}
break;
}
}
//Checking if the user is banned
foreach (ListaNegra ln in member.ListaNegras1)
{
if (ln.baja)
{
hasNoBlackList = false;
}
}
//If all conditions are true, the member is applicable for the event
if (isInGroup && sectionValid && positionValid && functionValid && hasNoBlackList)
{
data.Add(member);
}
}
return(FactoryOperation <Miembro> .getDataOperation(data));
}
catch (Exception e)
{
return(FactoryOperation <Miembro> .getFailOperation(e.Message));
}
}
