public async Task <List <UserReportDto> > GetUsersByShiftId(int shiftId)
{
var command = CurrentUnitOfWork.GetDbContext <AttendanceDbContext>().Database.GetDbConnection().CreateCommand();
command.CommandText = "GetEmployeeByShift";
command.CommandType = CommandType.StoredProcedure;
command.Transaction = (DbTransaction)_transactionProvider.GetActiveTransaction(new ActiveTransactionProviderArgs {
{ "ContextType", typeof(AttendanceDbContext) }, { "MultiTenancySide", MultiTenancySides.Tenant }
});
var param = new SqlParameter("@shiftId", shiftId);
command.Parameters.Add(param);
using (var dataReader = await command.ExecuteReaderAsync())
{
var result = new List <UserReportDto>();
while (dataReader.Read())
{
result.Add(new UserReportDto()
{
UserId = (int)(long)dataReader[0],
UserName = dataReader[1].ToString(),
ShiftName = dataReader[2].ToString(),
ShiftId = (int)dataReader[3],
StartDate = DateTime.Parse(dataReader[4].ToString()),
EndDate = DateTime.Parse(dataReader[5].ToString())
});;
}
return(result);
}
}
// lấy cái transaction đc active
private DbTransaction GetActiveTransaction()
{
return((DbTransaction)_transaction.GetActiveTransaction(new ActiveTransactionProviderArgs
{
{ "ContextType", typeof(SoftwareArchitectureDbContext) },
{ "MultiTenancySide", MultiTenancySide }
}));
}
public override DbTransaction GetActiveTransaction()
{
return((DbTransaction)_activeTransactionProvider.GetActiveTransaction(ActiveTransactionProviderArgs));
}
public DapperRepositoryBase(IActiveTransactionProvider activeTransactionProvider)
{
Connection = activeTransactionProvider.GetActiveConnection();
Transaction = activeTransactionProvider.GetActiveTransaction();
}
public virtual DbTransaction GetActiveTransaction()
{
var connection = _activeTransactionProvider.GetActiveTransaction(ActiveTransactionProviderArgs.Empty);
return((DbTransaction)connection);
}
