public ProcessCreateResponse Update(ProcessCreateRequest request) { ProcessCreateResponse response = new ProcessCreateResponse(); ProcessEntity entityToUpdate = ToEntity(request.Process); using (var sqliteConn = ConnectionProvider.GetSqliteConn()) { sqliteConn.Execute("update process set Description = @Description, Steps = @Steps, Params = @Params, LastUpdateBy = @LastUpdateBy, LastUpdateTime = @LastUpdateTime where Id = @Id", entityToUpdate); } response.Status = 1; return(response); }
public ProcessCreateResponse Create(ProcessCreateRequest request) { ProcessCreateResponse response = new ProcessCreateResponse(); ProcessEntity entityToInsert = ToEntity(request.Process); using (var sqliteConn = ConnectionProvider.GetSqliteConn()) { sqliteConn.Execute("insert into process(Name, Description, Steps, Params, DataStatus, CreateBy, CreateTime, LastUpdateBy, LastUpdateTime) values (@Name, @Description, @Steps, @Params, @DataStatus, @CreateBy, @CreateTime, @LastUpdateBy, @LastUpdateTime)", entityToInsert); } response.Status = 1; return(response); }