//-- DeletePermanent (T entity)
public virtual bool DeletePermanent(T entity)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(context.Connection.Delete(entity));
}
}
//-- DeletePermanentAsync (T entity)
public virtual async Task <bool> DeletePermanentAsync(T entity)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(await context.Connection.DeleteAsync(entity));
}
}
//-- InsertAsync (T entity)
public virtual async Task <object> InsertAsync(T entity)
{
entity = SetIncludeData(entity);
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(await context.Connection.InsertAsync(entity));
}
}
//-- UpdateAsync (T entity)
public virtual async Task <bool> UpdateAsync(T entity)
{
entity = SetAlterData(entity);
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(await context.Connection.UpdateAsync(entity));
}
}
//-- Update (T entity)
public virtual bool Update(T entity)
{
entity = SetAlterData(entity);
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
return(context.Connection.Update(entity));
}
}
//-- Insert (T entity)
public virtual T Insert(T entity)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
entity = SetIncludeData(entity);
entity.Id = Convert.ToInt32(context.Connection.Insert(entity));
return(entity);
}
}
//-- DeletePermanent (int id)
public virtual bool DeletePermanent(int id)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
var obj = Activator.CreateInstance <T>();
obj.Id = id;
return(context.Connection.Delete(obj));
}
}
//-- DeletePermanentAsync (int id)
public virtual async Task <bool> DeletePermanentAsync(int id)
{
using (var context = DBRepository.ReturnMySqlContext(_connectionString))
{
var obj = Activator.CreateInstance <T>();
obj.Id = id;
return(await context.Connection.DeleteAsync(obj));
}
}
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 <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 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));
}
}
public virtual IEnumerable <T> GetAll()
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(GetAll(dbContext));
}
public IMySQLContext NewConnection(string connectionString)
{
_connectionString = connectionString;
return(DBRepository.ReturnMySqlContext(_connectionString));
}
public virtual async Task <IEnumerable <T> > GetAllAsync()
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(await GetAllAsync(dbContext));
}
public virtual async Task <T> GetByIdAsync(int id)
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(await GetByIdAsync(id, dbContext));
}
public virtual T SelectFirst <TKey>(Expression <Func <T, bool> > linqExpression, bool ascOrder, Func <T, TKey> orderExpression)
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(SelectFirst(linqExpression, ascOrder, orderExpression, dbContext));
}
public virtual IEnumerable <T> Select(Expression <Func <T, bool> > linqExpression)
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(Select(linqExpression, dbContext));
}
public virtual T GetById(int id)
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(GetById(id, dbContext));
}
public virtual async Task <T> SelectFirstAsync(Expression <Func <T, bool> > linqExpression)
{
using var dbContext = DBRepository.ReturnMySqlContext(_connectionString);
return(await SelectFirstAsync(linqExpression, dbContext));
}