public async Task <TrainTaskExecutor> GetExecutorById(int executorId)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new ExecutorSqls();
var executor = await conn.QueryFirstOrDefaultAsync <TrainTaskExecutor>(sql.GetExecutorById, new { executorId });
return(executor);
}
}
public async Task <TrainTaskExecutor> AddNewExecutorToTask(TrainTaskExecutor data, User user, bool timeShift)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var sql = new ExecutorSqls();
var query = sql.AddExecutorToTask;
if (timeShift)
{
query = sql.AddExecutorToTaskTimeShift;
}
var id = await conn.QueryFirstOrDefaultAsync <int>(query,
new { task_id = data.TrainTaskId, brigade_type = data.BrigadeType, user_id = data.UserId }
);
var result = await GetExecutorById(id);
return(result);
}
}
