public T Select(int id)
{
using (var data = new SQLContext(_OptionsBuilder))
{
return(data.Set <T>().Find(id));
}
}
public IList <T> SelectByQuantidade(int tamanhoListaAutores)
{
using (var data = new SQLContext(_OptionsBuilder))
{
return(data.Set <T>().Take(tamanhoListaAutores).ToList());
}
}
public async Task <IList <Autor> > SelectByQuantidadeAsync(int quantidadeListaAutores)
{
using (var data = new SQLContext(_OptionsBuilder))
{
return(await data.Set <Autor>().Take(quantidadeListaAutores).ToListAsync());
}
}
public IList <T> SelectAll()
{
using (var data = new SQLContext(_OptionsBuilder))
{
return(data.Set <T>().ToList());
}
}
public void Delete(int id)
{
using (var data = new SQLContext(_OptionsBuilder))
{
data.Set <T>().Remove(Select(id));
data.SaveChanges();
}
}
public void Insert(T obj)
{
using (var data = new SQLContext(_OptionsBuilder))
{
data.Set <T>().Add(obj);
data.SaveChanges();
}
}
public Repository(SQLContext dbContext)
{
_dbContext = dbContext;
_dbSet = _dbContext.Set <T>();
}
private static void ImportFromTable(bool doDelete = false)
{
using (var context = new SQLContext())
{
context.Database.Migrate();
context.Database.SetCommandTimeout(300);
bool end = false;
int i = 0;
var codes = context.Set <CancelCode>().ToDictionary(a => a.Code, a => a);
var airlines = context.Set <Airline>().ToDictionary(a => a.Code, a => a);
var locations = context.Set <Location>().ToDictionary(a => a.Code, a => a);
var count = context.Set <DataToImport>().LongCount();
Console.WriteLine("Ilość rekordów do zaimportowania: " + count);
while (!end)
{
List <Flight> flights = new List <Flight>();
List <DataToImport> data;
List <DataToImport> recordsToDelete = new List <DataToImport>();
if (doDelete)
{
data = context.Set <DataToImport>().Skip(NUMBER_OF_RECORDS * i).Take(NUMBER_OF_RECORDS).ToList();
}
else
{
data = context.Set <DataToImport>().Skip(errorsNumber).Take(NUMBER_OF_RECORDS).ToList();
}
foreach (var record in data)
{
if (!GetOrCreateCancelCode(record, codes, out CancelCode code))
{
code = null;
}
if (!GetOrCreateAirline(record, airlines, out Airline airline))
{
continue;
}
if (!GetOrCreateDestinationLocation(record, locations, out Location destLocation))
{
continue;
}
if (!GetOrCreateOriginLocation(record, locations, out Location originLocation))
{
continue;
}
if (!CreateFlight(record, originLocation, destLocation, code, airline, out Flight flight))
{
continue;
}
flights.Add(flight);
if (doDelete)
{
recordsToDelete.Add(record);
}
}
if (doDelete)
{
context.Set <DataToImport>().RemoveRange(recordsToDelete);
}
context.Set <Flight>().AddRange(flights);
context.SaveChanges();
Console.WriteLine((NUMBER_OF_RECORDS * i) + data.Count + "/" + count);
++i;
if (data.Count < NUMBER_OF_RECORDS)
{
end = true;
}
}
}
}
public T Insert(T obj)
{
context.Set <T>().Add(obj);
context.SaveChanges();
return(obj);
}
/// <summary>
/// Construtor de contexto do banco de dados
/// </summary>
/// <param name="_sqlContext"></param>
public RepositoryBase(SQLContext _sqlContext, INotificationManager _notificationManager) : base(_notificationManager)
{
sqlContext = _sqlContext;
DbSet = sqlContext.Set <TEntity>();
}
public Repository(SQLContext context)
{
Db = context;
DbSet = Db.Set <T>();
}
public SeedInitialData(SQLContext context)
{
_context = context;
_users = context.Set <User>();
}
public virtual IEnumerable <TEntity> GetAll()
{
return(_context.Set <TEntity>().ToList());
}
public AuthRepository(SQLContext context)
{
_context = context;
_users = context.Set <User>();
}
public virtual T BuscarPorId(Guid?Id)
{
if (HttpContext.Current.User.Identity.IsAuthenticated)
{
if (usuarioLogado_usuarioprincipal)
{
return
((from entidades in dbSet
join usuarios in Db.Set <Usuario>() on entidades.CriadoPor equals usuarios.UserName
where usuarios.Id_Usuario_Principal == usuarioLogado_id || usuarios.Id == usuarioLogado_id &&
entidades.Id == Id
select entidades).FirstOrDefault());
}
else if (usuarioLogado_organizador)
{
return(dbSet.SingleOrDefault(t => t.CriadoPor == usuarioLogado_username && t.Id == Id));
}
else if (usuarioLogado_id_usuario_principal.Any())
{
return
((from entidades in dbSet
join usuarios in Db.Set <Usuario>() on entidades.CriadoPor equals usuarios.UserName
where usuarios.Id_Usuario_Principal == usuarioLogado_id_usuario_principal || usuarios.Id == usuarioLogado_id_usuario_principal || usuarios.Id == usuarioLogado_id &&
entidades.Id == Id
select entidades).FirstOrDefault());
}
else if (usuarioLogado_caixaevento)
{
return
((from entidades in dbSet
join usuarioEvento in Db.Set <Evento_Usuario>() on entidades.CriadoPor equals usuarioEvento.Usuario.UserName
join usuarios in Db.Set <Usuario>() on entidades.CriadoPor equals usuarios.UserName
where usuarioEvento.Evento.Id_organizador == usuarioLogado_id_usuario_organizador ||
usuarios.id_usuario_organizador == usuarioLogado_id_usuario_organizador ||
entidades.CriadoPor == usuarioLogado_id &&
entidades.Deletado == false &&
entidades.Id == Id
select entidades).FirstOrDefault());
}
else
{
return(dbSet.FirstOrDefault(t => t.Id == Id));
}
}
else
{
return(dbSet.FirstOrDefault(t => t.Id == Id));
}
}
public Repository()
{
Db = new SQLContext();
dbSet = Db.Set <T>();
}
public BaseRepository(SQLContext context)
{
_context = context;
DbSet = _context.Set <TEntity>();
}
public Repository(SQLContext context)
{
_context = context;
_collection = context.Set <TEntity>();
}
/// <summary>
/// Construtor de contexto do banco de dados
/// </summary>
/// <param name="_sqlContext"></param>
public RepositoryBase(SQLContext _sqlContext)
{
sqlContext = _sqlContext;
DbSet = sqlContext.Set <TEntity>();
}
public SQLRepository(SQLContext context)
{
_context = context;
_dbSet = _context.Set <TEntity>();
}
public GenericRepository(SQLContext context)
{
_context = context;
_dataSet = _context.Set <T>();
}
public async Task <T> ObterAsync(int id)
{
return(await context.Set <T>().FindAsync(id));
}
