void CreateInstanceInternal() { if (!HasResult) { Result = new ExecuteResult(); } string sql = $@"insert into {Fields.TableName} ( {Fields.Name} ,{Fields.ReqNum} ,{Fields.LogPath} ,{Fields.PId} ,{Fields.Status} ,{Fields.StatusMsg} ,{Fields.Dttm} ) values ( '{Name}' ,'{StartInfo.RequestNumber}' ,'{"plan.LogPath"}' ,{Result.PId} ,{(int)Result.Status} ,'{Result.Status.ToString()}' ,{_dal.GetEpoch()} ) "; using (SQLiteConnection c = new SQLiteConnection(SynapseDal.ConnectionString)) { c.Open(); _dal.ExecuteNonQuery(sql, c); _instanceId = _dal.GetLastRowId(c).Value; } if (InstanceId == 0) { InstanceId = _instanceId; } }
internal void CreateInstance(long? parentId) { if( !HasResult ) Result = new ExecuteResult(); string parIdFld = parentId.HasValue ? $",{Fields.ParentId}" : ""; string parIdVal = parentId.HasValue ? $",{parentId.Value}" : ""; string sql = $@"insert into {Fields.TableName} ( {Fields.Name} ,{Fields.PlanId} ,{Fields.PId} ,{Fields.Status} ,{Fields.StatusMsg} ,{Fields.StatusSeq} ,{Fields.Dttm} {parIdFld} ) values ( '{Name}' ,{PlanInstanceId} ,{Result.PId} ,{(int)Result.Status} ,'{Result.Status.ToString()}' ,{-100} ,{_dal.GetEpoch()} {parIdVal} ) "; using( SQLiteConnection c = new SQLiteConnection( SynapseDal.ConnectionString ) ) { c.Open(); _dal.ExecuteNonQuery( sql, c ); InstanceId = _dal.GetLastRowId( c ).Value; } }