public void DeleteGlobalParameters(string type, string name = null) { using (var connection = new NpgsqlConnection(ConnectionString)) { WorkflowGlobalParameter.DeleteByTypeAndName(connection, type, name); } }
public void SaveGlobalParameter <T>(string type, string name, T value) { using (var connection = new NpgsqlConnection(ConnectionString)) { var parameter = WorkflowGlobalParameter.SelectByTypeAndName(connection, type, name).FirstOrDefault(); if (parameter == null) { parameter = new WorkflowGlobalParameter() { Id = Guid.NewGuid(), Type = type, Name = name, Value = JsonConvert.SerializeObject(value) }; parameter.Insert(connection); } else { parameter.Value = JsonConvert.SerializeObject(value); parameter.Update(connection); } } }
public List <T> LoadGlobalParameters <T>(string type) { using (var connection = new NpgsqlConnection(ConnectionString)) { var parameters = WorkflowGlobalParameter.SelectByTypeAndName(connection, type); return(parameters.Select(p => JsonConvert.DeserializeObject <T>(p.Value)).ToList()); } }
public T LoadGlobalParameter <T>(string type, string name) { using (var connection = new NpgsqlConnection(ConnectionString)) { var parameter = WorkflowGlobalParameter.SelectByTypeAndName(connection, type, name).FirstOrDefault(); if (parameter == null) { return(default(T)); } return(JsonConvert.DeserializeObject <T>(parameter.Value)); } }