public virtual async Task <bool> DeletePermanentAsync(int id, IMySQLContext dbContext)
{
var obj = Activator.CreateInstance <T>();
obj.Id = id;
return(await dbContext.Connection.DeleteAsync(obj, dbContext.Transaction));
}
public virtual bool DeletePermanent(int id, IMySQLContext dbContext)
{
var obj = Activator.CreateInstance <T>();
obj.Id = id;
return(dbContext.Connection.Delete(obj, dbContext.Transaction));
}
public virtual bool Delete(Expression <Func <T, bool> > linqExpression, IMySQLContext dbContext)
{
var entities = Select(linqExpression);
entities = SetInativeData(entities);
return(Update(entities, dbContext));
}
public virtual bool Delete(int id, IMySQLContext dbContext)
{
var entity = GetById(id);
entity = SetInativeData(entity);
return(Update(entity, dbContext));
}
public virtual T SelectFirst(Expression <Func <T, bool> > linqExpression, IMySQLContext dbContext)
{
if (_repositorySpecific != null)
{
return(_repositorySpecific.ConfigurarBuscaObjetoCompleto(linqExpression, dbContext).FirstOrDefault());
}
return(dbContext.Connection.FirstOrDefault(linqExpression, dbContext.Transaction));
}
public virtual T GetById(int id, IMySQLContext dbContext)
{
if (_repositorySpecific != null)
{
return(_repositorySpecific.ConfigurarBuscaObjetoCompleto(o => o.Id == id, dbContext).FirstOrDefault());
}
return(dbContext.Connection.Get <T>(id, dbContext.Transaction));
}
public virtual IEnumerable <T> GetAll(IMySQLContext dbContext)
{
if (_repositorySpecific != null)
{
return(_repositorySpecific.ConfigurarBuscaObjetoCompleto(o => o.Id > 0, dbContext));
}
return(dbContext.Connection.GetAll <T>(dbContext.Transaction));
}
public virtual async Task <T> GetByIdAsync(int id, IMySQLContext dbContext)
{
if (_repositorySpecific != null)
{
return(await Task.Run(() => _repositorySpecific.ConfigurarBuscaObjetoCompleto(o => o.Id == id, dbContext).FirstOrDefault()));
}
return(await dbContext.Connection.GetAsync <T>(id, dbContext.Transaction));
}
public virtual async Task <IEnumerable <T> > GetAllAsync(IMySQLContext dbContext)
{
if (_repositorySpecific != null)
{
return(await Task.Run(() => _repositorySpecific.ConfigurarBuscaObjetoCompleto(o => o.Id > 0, dbContext)));
}
return(await dbContext.Connection.GetAllAsync <T>(dbContext.Transaction));
}
public virtual IEnumerable <T> Insert(IEnumerable <T> entities, IMySQLContext dbContext)
{
entities = SetIncludeData(entities);
T[] lstEntity = entities.ToArray();
for (int i = 0; i < lstEntity.Count(); i++)
{
lstEntity[i] = Insert(lstEntity[i], dbContext);
}
return(lstEntity);
}
public virtual bool Update(IEnumerable <T> entities, IMySQLContext dbContext)
{
entities = SetAlterData(entities);
int countSuccess = 0;
T[] lstEntity = entities.ToArray();
for (int i = 0; i < lstEntity.Count(); i++)
{
countSuccess = Update(lstEntity[i], dbContext) ? (countSuccess + 1) : (countSuccess + 0);
}
return(countSuccess == lstEntity.Count());
}
public virtual void ParallelInsert(IEnumerable <T> entities, IMySQLContext dbContext)
{
entities = SetIncludeData(entities);
List <Task <object> > taks = new List <Task <object> >();
foreach (T entity in entities)
{
var t = InsertAsync(entity, dbContext);
taks.Add(t);
}
Task.WaitAll(taks.ToArray());
}
public virtual bool DeletePermanent(IEnumerable <T> entities, IMySQLContext dbContext)
{
bool sucesso = false;
foreach (T entity in entities)
{
sucesso = DeletePermanent(entity, dbContext);
if (!sucesso)
{
break;
}
}
return(sucesso);
}
public EvaluationResult <VendorData> MySQLDownload(IMySQLContext context, string tableName)
{
var result = new EvaluationResult <VendorData>();
try
{
result.Results = context.GetData(tableName);
result.Code = result.Results.Count > 0 ? 0 : 1;
result.Text = result.Results.Count > 0 ? "Successfully downloaded vendor data" : "There was no vendor data downloaded.";
}
catch (Exception ex)
{
result.Code = 2;
result.Text = $"Error loading data: {ex.Message}";
}
return(result);
}
public EvaluationResult <VendorData> MySQLUpload(IMySQLContext context, string tableName)
{
var result = new EvaluationResult <VendorData>();
try
{
context.CreateTable(tableName);
context.LoadData(sampleData.VendorData(), tableName);
result.Text = "Successfully uploaded vendor data to MySQL";
result.Code = 0;
}
catch (Exception ex)
{
result.Code = 2;
result.Text = $"Error loading vendor data to MySQL: {ex.Message}";
}
return(result);
}
public virtual async Task <object> InsertAsync(T entity, IMySQLContext dbContext)
{
entity = SetIncludeData(entity);
return(await dbContext.Connection.InsertAsync(entity, dbContext.Transaction));
}
public virtual async Task <bool> DeleteAsync(Expression <Func <T, bool> > linqExpression, IMySQLContext dbContext)
{
return(await Task.Run(() =>
{
var entities = Select(linqExpression);
entities = SetInativeData(entities);
return Update(entities, dbContext);
}));
}
public virtual async Task <bool> DeleteAsync(IEnumerable <T> entities, IMySQLContext dbContext)
{
entities = SetInativeData(entities);
return(await UpdateAsync(entities, dbContext));
}
public T ExecuteProcedureFirst(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null, bool buffered = true)
{
if (dbContext == null)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(context.Connection.QueryFirstOrDefault <T>(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure));
}
}
else
{
return(dbContext.Connection.QueryFirstOrDefault <T>(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure));
}
}
public async Task <IEnumerable <T> > ExecuteProcedureAsync(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null)
{
if (dbContext == null)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(await context.Connection.QueryAsync <T>(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure));
}
}
else
{
return(await dbContext.Connection.QueryAsync <T>(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure));
}
}
protected virtual IEnumerable <T> ConfigurarBuscaObjetoCompleto(Expression <Func <T, bool> > linqExpression, IMySQLContext dbContext)
{
throw new PlatformNotSupportedException("Não possui o método RecuperarCompleto nesse repositório.");
}
public async Task <SqlMapper.GridReader> ExecuteProcedureMultipleAsync(string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null, bool buffered = true)
{
if (dbContext == null)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(await context.Connection.QueryMultipleAsync(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure));
}
}
else
{
return(await dbContext.Connection.QueryMultipleAsync(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure));
}
}
public static IEnumerable <dynamic> ExecuteProcedureMultiple(string connectionString, string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null, bool buffered = true)
{
List <dynamic> selects = new List <dynamic>();
if (dbContext == null)
{
using (var context = ReturnMySqlContext(connectionString))
{
using (var ret = context.Connection.QueryMultiple(storedProcedure, objParameters, null, timeout, CommandType.StoredProcedure))
{
while (!ret.IsConsumed)
{
selects.Add(ret.Read());
}
return(selects);
}
}
}
else
{
using (var ret = dbContext.Connection.QueryMultiple(storedProcedure, objParameters, dbContext.Transaction, timeout, CommandType.StoredProcedure))
{
while (!ret.IsConsumed)
{
selects.Add(ret.Read());
}
return(selects);
}
}
}
public static IEnumerable <TEntity> ExecuteProcedure <TEntity>(string connectionString, string storedProcedure, object objParameters = null, int?timeout = 120, IMySQLContext dbContext = null)
{
if (dbContext == null)
{
using (var context = ReturnMySqlContext(connectionString))
{
return(context.Connection.Query <TEntity>(storedProcedure, objParameters, null, true, timeout, CommandType.StoredProcedure));
}
}
else
{
return(dbContext.Connection.Query <TEntity>(storedProcedure, objParameters, dbContext.Transaction, true, timeout, CommandType.StoredProcedure));
}
}
public virtual bool Delete(T entity, IMySQLContext dbContext)
{
entity = SetInativeData(entity);
return(Update(entity, dbContext));
}
public EmployeeRepository(IMySQLContext context)
{
this._context = context;
}
public virtual bool Delete(IEnumerable <T> entities, IMySQLContext dbContext)
{
entities = SetInativeData(entities);
return(Update(entities, dbContext));
}
public virtual async Task <IEnumerable <T> > InsertAsync(IEnumerable <T> entities, IMySQLContext dbContext)
{
return(await Task.Run(() => Insert(entities, dbContext)));
}
public virtual async Task <bool> DeleteAsync(T entity, IMySQLContext dbContext)
{
return(await Task.Run(() => Delete(entity, dbContext)));
}
public virtual T Insert(T entity, IMySQLContext dbContext)
{
entity = SetIncludeData(entity);
entity.Id = Convert.ToInt32(dbContext.Connection.Insert(entity, dbContext.Transaction));
return(entity);
}
