public void UpdateStagingState(Guid id, EStagingState state, string currentstep) { using (var conn = OpenConnection(ConnectionString)) { conn.Execute("update stagings set state = @state, currentstep = @currentstep where id = @id", new { id, state = state.ToString(), currentstep }); } }
public void CreateStaging(Guid id, string creator, EStagingState state, string currentStep, string inputParams) { var created = DateTime.UtcNow; using (var conn = OpenConnection(ConnectionString)) { conn.Execute("INSERT INTO stagings(id, creator, created, lastupdated, state, currentstep, inputparams) VALUES(@id, @creator, @created, @lastupdated, @state, @currentstep, @inputparams)", new { id, creator, state = state.ToString(), currentStep, created, lastupdated = created, inputparams = inputParams }); } }