public async Task <int> Add(FlowStatesEntity entity) { entity.CreatedOn = DateTime.Now; var sql = "INSERT INTO FlowStates (Id, FlowId, StateId, [Order], CreatedOn) Values (@Id, @FlowId, @StateId, @Order, @CreatedOn);"; var affectedRows = await Connection.ExecuteAsync(sql, new { Id = entity.Id, FlowId = entity.FlowId, StateId = entity.StateId, Order = entity.Order, CreatedOn = entity.CreatedOn }, Transaction); return(affectedRows); /*using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"))) * { * connection.Open(); * var affectedRows = await connection.ExecuteAsync(sql, entity); * return affectedRows; * }*/ }
public async Task <int> Update(FlowStatesEntity entity) { throw new NotImplementedException(); entity.ModifiedOn = DateTime.Now; var sql = "UPDATE FlowStates SET [Order] = @Order WHERE Id = @Id;"; var affectedRows = await Connection.ExecuteAsync(sql, entity, Transaction); return(affectedRows); /*using (var connection = new SqlConnection(_configuration.GetConnectionString("DefaultConnection"))) * { * connection.Open(); * var affectedRows = await connection.ExecuteAsync(sql, entity); * return affectedRows; * }*/ }
public async Task <Guid> Create(FlowModel model) { var entity = new FlowEntity(); entity.Name = model.Name; entity.Id = Guid.NewGuid(); var result = await _unitOfWork.Flows.Add(entity); foreach (var state in model.States) { var stateEntity = new FlowStatesEntity { FlowId = entity.Id, Id = Guid.NewGuid(), Order = state.Order, StateId = state.StateId, CreatedOn = DateTime.Now }; await _unitOfWork.FlowStates.Add(stateEntity); } _unitOfWork.Commit(); return(entity.Id); }