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