public ResultModel <object> Add(TaskDTO model)
{
ResultModel <object> result = new ResultModel <object>();
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var task = _mapper.Map <TaskDTO, Task>(model);
_context.Entry(task).State = Microsoft.EntityFrameworkCore.EntityState.Added;
_context.SaveChanges();
transaction.Commit();
result.SetSuccess("Data successfuly added");
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.ToString());
}
}
}
catch (Exception ex)
{
result.SetFailed(ex.Message);
_logging.WriteErr(ex);
}
return(result);
}
public async Task <IActionResult> PutTask(int id, dataLayer.Task task)
{
if (id != task.TaskId)
{
return(BadRequest());
}
_context.Entry(task).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!TaskExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public async Task <ResultModel <object> > UpdateToken(string tokenRefresh)
{
ResultModel <object> result = new ResultModel <object>();
try
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
var data = await _context.TokenRefreshes
.Where(x => x.Token == tokenRefresh && x.IsUsed == false)
.FirstOrDefaultAsync();
if (data != null)
{
data.IsUsed = true;
_context.Entry(data).State = EntityState.Modified;
await _context.SaveChangesAsync();
transaction.Commit();
result.SetSuccess("success");
}
else
{
result.SetFailed("Token not found!");
}
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
result.SetFailed(ex.Message);
_logging.WriteErr(ex);
}
return(result);
}