public async Task <bool> DeleteAll(Expression <Func <T, bool> > query, params Expression <Func <T, object> >[] includes)
{
var toRtn = false;
try
{
using (var dbContext = new AuctionsContext())
{
var objs = dbContext.Set <T>().IncludeMultiple(includes).Where(query);
foreach (var obj in objs)
{
dbContext.Set <T>().Remove(obj);
}
await dbContext.SaveChangesAsync();
}
toRtn = true;
}
catch (Exception ex)
{
var msg = ex.Message;
}
return(toRtn);
}
public AdminController(AuctionsContext context, UserManager <User> user_manager, IMapper mapper, SignInManager <User> sign_in_manager)
{
this.context = context;
this.user_manager = user_manager;
this.mapper = mapper;
this.sign_in_manager = sign_in_manager;
}
public async Task <List <T> > SaveAll(List <T> entities)
{
try
{
using (var dbContext = new AuctionsContext())
{
foreach (var entity in entities)
{
dbContext.Set <T>().AddOrUpdate(entity);
}
await dbContext.SaveChangesAsync();
}
}
catch (DbEntityValidationException e)
{
var ls = new List <string>();
foreach (var eve in e.EntityValidationErrors)
{
var errs = eve.ValidationErrors.Select(x => $"Property: {x.PropertyName}, Error:{x.ErrorMessage}");
var msg = $"Entity of type \"{eve.Entry.Entity.GetType().Name}\" in state \"{eve.Entry.State}\" has the following validation errors: {string.Join(Environment.NewLine, errs)}";
ls.Add(msg);
}
//logger.Error(string.Join(Environment.NewLine, ls));
//throw;
}
catch (Exception ex)
{
var msg = ex.Message;
}
return(entities);
}
public async Task <List <T> > Search(Expression <Func <T, bool> > query, Expression <Func <T, object> > orderBy = null, int?skip = null, int?take = null, params Expression <Func <T, object> >[] includes)
{
try
{
using (var dbContext = new AuctionsContext())
{
var s = skip.GetValueOrDefault();
var t = take ?? 100000;
var q = dbContext.Set <T>().Where(query).IncludeMultiple(includes);
if (orderBy != null)
{
q.OrderBy(orderBy).Skip(s);
}
var result = await q.Take(t).ToListAsync();
return(result);
}
}
catch (Exception ex)
{
var msg = ex.Message;
return(null);
}
}
public HomeController(ILogger <HomeController> logger, AuctionsContext context, UserManager <User> user_manager, IMapper mapper, SignInManager <User> sign_in_manager)
{
this.context = context;
this.user_manager = user_manager;
this.mapper = mapper;
this.sign_in_manager = sign_in_manager;
_logger = logger;
}
public async Task <List <T> > GetAll(params Expression <Func <T, object> >[] includes)
{
using (var dbContext = new AuctionsContext())
{
var result = await dbContext.Set <T>().IncludeMultiple(includes).ToListAsync();
return(result);
}
}
public async Task <T> Get(Expression <Func <T, bool> > query, params Expression <Func <T, object> >[] includes)
{
using (var dbContext = new AuctionsContext())
{
var result = await dbContext.Set <T>().IncludeMultiple(includes).FirstOrDefaultAsync(query);
return(result);
}
}
public Startup(IConfiguration configuration)
{
Configuration = configuration;
using (var client = new AuctionsContext(new DbContextOptions <AuctionsContext>()))
{
//client.Database.EnsureCreated();
client.Database.Migrate();
}
}
protected virtual void Dispose(bool pBolDisposing)
{
if (pBolDisposing)
{
if (mObjContext != null)
{
mObjContext.Dispose();
mObjContext = null;
}
}
}
public async Task <T> Save(T entity)
{
try
{
using (var dbContext = new AuctionsContext())
{
dbContext.Set <T>().AddOrUpdate(entity);
await dbContext.SaveChangesAsync();
}
return(entity);
}
catch (Exception ex)
{
var msg = ex.Message;
return(null);
}
}
public void DoTest()
{
using (var lObjContext = new AuctionsContext())
{
Console.WriteLine("Creado transacción....");
var a = lObjContext.User.ToList();
using (var lObjTransaction = lObjContext.Database.BeginTransaction())
{
try
{
Console.WriteLine("Transacción creada");
EETransactionDAO <User> lObjUserDAO = new EETransactionDAO <User>(lObjContext);
for (int i = 0; i < 5; i++)
{
lObjUserDAO.SaveOrUpdateEntity(new User()
{
UserTypeId = 1,
UserName = string.Format("User {0}", i),
FirstName = string.Format("Nombre {0}", i),
LastName = string.Format("Apellido {0}", i),
Password = string.Format("Contraseña {0}", i).Encode(),
EmailAddress = string.Format("Correo{0}@email.com", i).Encode(),
Image = string.Empty
});
Console.WriteLine(string.Format("Usuario {0} creado", i));
}
lObjTransaction.Commit();
Console.WriteLine("Cambios aplicados");
}
catch (Exception lObjException)
{
Console.ForegroundColor = ConsoleColor.Red;
Console.WriteLine(lObjException.Message);
Console.ForegroundColor = ConsoleColor.Gray;
}
}
}
}
public DashboardController(AuctionsContext context)
{
_dbContext = context;
}
public TransactionDAO(AuctionsContext pObjContext)
{
mObjContext = pObjContext;
SetObjectContext();
}
public PluginConfig(AuctionsContext auctionsContext)
{
_auctionsContext = auctionsContext;
}
public HomeController(AuctionsContext dbc)
{
context = dbc;
}
public ListAuctionsViewComponent(AuctionsContext context)
{
_context = context;
}
public RunAuctionsController(AuctionsContext context)
{
_context = context;
}
public PluginConfig(AuctionsContext auctionsContext)
{
_auctionsContext = auctionsContext;
}
public HomeController(AuctionsContext context)
{
dbContext = context;
}
public AuctionsController(IImageHandler imageHandler, AuctionsContext context)
{
_imageHandler = imageHandler;
_context = context;
}
public UserController(AuctionsContext context)
{
_context = context;
}
