public PlanningRepository(StudentDbContext context)
{
_context = context;
_dbSetPlanning = _context.Set <Planning>();
_dbSetSGroupe = _context.Set <PlanningSGroupe>();
_dbSetSection = _context.Set <Section>();
}
public IEnumerable <T> ExecuteSql(string commandText, params object[] parameters)
{
// return new List<TEntity>();
/*******************************************************************************************
* // TODO: Find a way to execute stored procedures with ad hoc classes/ arbitary datatypes //
*******************************************************************************************/
if (parameters == null && parameters.Length <= 0)
{
return(_context.Set <T>().FromSql(commandText, parameters));
}
var count = 0;
foreach (var param in parameters)
{
var p = param as DbParameter;
if (p == null)
{
throw new Exception("Invalid parameter");
}
commandText += count == 0 ? " " : ",";
commandText += '@' + p.ParameterName;
count++;
}
return(_context.Set <T>().FromSql(commandText, parameters));
}
public ResultatRepository(StudentDbContext context) : base(context)
{
_context = context;
_dbSetResultat = _context.Set <Resultat>();
_dbSetUnite = _context.Set <UnitePedagogique>();
_dbSetParcour = _context.Set <Parcour>();
_dbSetMatiere = _context.Set <Matiere>();
}
public async Task <bool> Add(T entity)
{
try
{
context.Set <T>().Add(entity);
await context.SaveChangesAsync();
return(await Task.FromResult(true));
}
catch
{
return(await Task.FromResult(false));
}
}
public ParcourRepository(StudentDbContext context) : base(context)
{
_context = context;
_dbSet = _context.Set <Parcour>();
}
// Constructor
public GenericRepository(StudentDbContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public DocumentPartageRepository(StudentDbContext context) : base(context)
{
_context = context;
_dbSet = _context.Set <DocumentPartage>();
}
public SectionRepository(StudentDbContext context) : base(context)
{
_context = context;
_dbSet = _context.Set <Section>();
}
public GenericRepository(StudentDbContext context)
{
_context = context;
entities = context.Set <T>();
}
public GenericRepository(StudentDbContext context)
{
_context = context;
_dbSet = _context.Set <T>();
}
public NiveauSpecialiteRepository(StudentDbContext context) : base(context)
{
_context = context;
_dbSet = _context.Set <NiveauSpecialite>();
}
