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); }