public MainWindow() : base(Gtk.WindowType.Toplevel) { Build (); //vbox1.Add(button); //Con esta linea añadimos un boton en toda la pantalla random = new Random (); Table table = new Table(9,10,true); //Forma de sacar las filas y las columnas for (uint row=0; row<9; row++) { for (uint col=0; col<10; col++) { uint index = row * 10 + col; int numero = (int)index + 1; Button button = new Button (); button.Label = numero.ToString(); button.Visible = true; table.Attach (button, col, col+1, row, row+1); buttons.Add (button); numeros.Add (numero); } } table.Visible = true; vbox1.Add (table); buttonNumero.Clicked += delegate { int numero = getNumero(); show(numero); buttonNumero.Sensitive = numeros.Count>0; // No cerrarse cuando se pongan todos los numeros. espeak(numero); }; }
// Initialize any Table-derived type to point to the union at the given offset. protected internal virtual Table __union(Table t, int offset) { offset += bb_pos; t.bb_pos = offset + bb.getInt(offset); t.bb = bb; return t; }
public static Table Parse(IRestResponse response) { Table table = new Table(); StringReader reader = new StringReader(response.Content); string readLine = reader.ReadLine(); if (readLine != null) { string[] collection = readLine.Split(Separator); foreach (string column in collection) { table.Columns.Add(column.TrimStart('"').TrimEnd('"')); } } string line = reader.ReadLine(); while (!string.IsNullOrEmpty(line)) { Row row = new Row(line); table.Rows.Add(row); line = reader.ReadLine(); } return table; }
private void PutAdress(Aspose.Pdf.Generator.Pdf pdf, PassengerInfo passengerInfo) { //create table to add address of the customer Table adressTable = new Table(); adressTable.IsFirstParagraph = true; adressTable.ColumnWidths = "60 180 60 180"; adressTable.DefaultCellTextInfo.FontSize = 10; adressTable.DefaultCellTextInfo.LineSpacing = 3; adressTable.DefaultCellPadding.Bottom = 3; //add this table in the first section/page Section section = pdf.Sections[0]; section.Paragraphs.Add(adressTable); //add a new row in the table Row row1AdressTable = new Row(adressTable); adressTable.Rows.Add(row1AdressTable); //add cells and text Aspose.Pdf.Generator.TextInfo tf1 = new Aspose.Pdf.Generator.TextInfo(); tf1.Color = new Aspose.Pdf.Generator.Color(111, 146, 188); tf1.FontName = "Helvetica-Bold"; row1AdressTable.Cells.Add("Bill To:", tf1); row1AdressTable.Cells.Add(passengerInfo.Name + "#$NL" + passengerInfo.Address + "#$NL" + passengerInfo.Email + "#$NL" + passengerInfo.PhoneNumber); }
public static void AssertNotModifiedByAnotherTransaction(TableStorage storage, ITransactionStorageActions transactionStorageActions, string key, Table.ReadResult readResult, TransactionInformation transactionInformation) { if (readResult == null) return; var txIdAsBytes = readResult.Key.Value<byte[]>("txId"); if (txIdAsBytes == null) return; var txId = new Guid(txIdAsBytes); if (transactionInformation != null && transactionInformation.Id == txId) { return; } var existingTx = storage.Transactions.Read(new RavenJObject { { "txId", txId.ToByteArray() } }); if (existingTx == null)//probably a bug, ignoring this as not a real tx return; var timeout = existingTx.Key.Value<DateTime>("timeout"); if (SystemTime.UtcNow > timeout) { transactionStorageActions.RollbackTransaction(txId); return; } throw new ConcurrencyException("Document '" + key + "' is locked by transacton: " + txId); }
void Initialize() { string connect = "Server=127.0.0.1;Port=5432;User Id=s;Database=practice;"; var connection = new NpgsqlConnection(connect); if(connection.State == ConnectionState.Closed) { connection.Open(); } users = new Table("users", connection); }
/* ** 2001 September 15 ** ** The author disclaims copyright to this source code. In place of ** a legal notice, here is a blessing: ** ** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give. ** ************************************************************************* ** This file contains C code routines that are called by the parser ** to handle UPDATE statements. ** ** $Id: update.c,v 1.207 2009/08/08 18:01:08 drh Exp $ ** ************************************************************************* ** Included in SQLite3 port to C#-SQLite; 2008 Noah B Hart ** C#-SQLite is an independent reimplementation of the SQLite software library ** ** $Header$ ************************************************************************* */ //#include "sqliteInt.h" #if !SQLITE_OMIT_VIRTUALTABLE /* Forward declaration */ //static void updateVirtualTable( //Parse pParse, /* The parsing context */ //SrcList pSrc, /* The virtual table to be modified */ //Table pTab, /* The virtual table */ //ExprList pChanges, /* The columns to change in the UPDATE statement */ //Expr pRowidExpr, /* Expression used to recompute the rowid */ //int aXRef, /* Mapping from columns of pTab to entries in pChanges */ //Expr pWhere /* WHERE clause of the UPDATE statement */ //); #endif // * SQLITE_OMIT_VIRTUALTABLE */ /* ** The most recently coded instruction was an OP_Column to retrieve the ** i-th column of table pTab. This routine sets the P4 parameter of the ** OP_Column to the default value, if any. ** ** The default value of a column is specified by a DEFAULT clause in the ** column definition. This was either supplied by the user when the table ** was created, or added later to the table definition by an ALTER TABLE ** command. If the latter, then the row-records in the table btree on disk ** may not contain a value for the column and the default value, taken ** from the P4 parameter of the OP_Column instruction, is returned instead. ** If the former, then all row-records are guaranteed to include a value ** for the column and the P4 value is not required. ** ** Column definitions created by an ALTER TABLE command may only have ** literal default values specified: a number, null or a string. (If a more ** complicated default expression value was provided, it is evaluated ** when the ALTER TABLE is executed and one of the literal values written ** into the sqlite_master table.) ** ** Therefore, the P4 parameter is only required if the default value for ** the column is a literal number, string or null. The sqlite3ValueFromExpr() ** function is capable of transforming these types of expressions into ** sqlite3_value objects. ** ** If parameter iReg is not negative, code an OP_RealAffinity instruction ** on register iReg. This is used when an equivalent integer value is ** stored in place of an 8-byte floating point value in order to save ** space. */ static void sqlite3ColumnDefault( Vdbe v, Table pTab, int i, int iReg ) { Debug.Assert( pTab != null ); if ( null == pTab.pSelect ) { sqlite3_value pValue = new sqlite3_value(); int enc = ENC( sqlite3VdbeDb( v ) ); Column pCol = pTab.aCol[i]; #if SQLITE_DEBUG VdbeComment( v, "%s.%s", pTab.zName, pCol.zName ); #endif Debug.Assert( i < pTab.nCol ); sqlite3ValueFromExpr( sqlite3VdbeDb( v ), pCol.pDflt, enc, pCol.affinity, ref pValue ); if ( pValue != null ) { sqlite3VdbeChangeP4( v, -1, pValue, P4_MEM ); } #if !SQLITE_OMIT_FLOATING_POINT if ( iReg >= 0 && pTab.aCol[i].affinity == SQLITE_AFF_REAL ) { sqlite3VdbeAddOp1( v, OP_RealAffinity, iReg ); } #endif } }
/* ** Given table pTab, return a list of all the triggers attached to ** the table. The list is connected by Trigger.pNext pointers. ** ** All of the triggers on pTab that are in the same database as pTab ** are already attached to pTab.pTrigger. But there might be additional ** triggers on pTab in the TEMP schema. This routine prepends all ** TEMP triggers on pTab to the beginning of the pTab.pTrigger list ** and returns the combined list. ** ** To state it another way: This routine returns a list of all triggers ** that fire off of pTab. The list will include any TEMP triggers on ** pTab as well as the triggers lised in pTab.pTrigger. */ static Trigger sqlite3TriggerList( Parse pParse, Table pTab ) { Schema pTmpSchema = pParse.db.aDb[1].pSchema; Trigger pList = null; /* List of triggers to return */ if ( pParse.disableTriggers != 0 ) { return null; } if ( pTmpSchema != pTab.pSchema ) { HashElem p; Debug.Assert( sqlite3SchemaMutexHeld( pParse.db, 0, pTmpSchema ) ); for ( p = sqliteHashFirst( pTmpSchema.trigHash ); p != null; p = sqliteHashNext( p ) ) { Trigger pTrig = (Trigger)sqliteHashData( p ); if ( pTrig.pTabSchema == pTab.pSchema && pTrig.table.Equals( pTab.zName, StringComparison.InvariantCultureIgnoreCase ) ) { pTrig.pNext = ( pList != null ? pList : pTab.pTrigger ); pList = pTrig; } } } return ( pList != null ? pList : pTab.pTrigger ); }
void BeforeWhere() { Initialize(); counter = 0; users = users.Select("*").Where("id < 3").All(); while(users.data.Read()) { counter++; } }
public static void SetBaseMethods( Table globals ) { globals[Name__G] = globals; globals[Name_Next] = Next; globals[Name_Pairs] = Pairs; globals[Name_IPairs] = IPairs; globals[Name_RawGet] = RawGet; globals[Name_RawSet] = RawSet; globals[Name_GetMetatable] = GetMetatable; globals[Name_SetMetatable] = SetMetatable; globals[Name_ToString] = ToString; globals[Name_ToNumber] = ToNumber; globals[Name_Print] = Print; globals[Name_Type] = Type; globals[Name_Select] = Select; globals[Name_CollectGarbage] = CollectGarbage_Nop; }
private void AttachToTable(Table table, Widget widget, uint x, uint y, uint width) { // table.Attach(widget, x, x + width, y, y + 1, AttachOptions.Fill, AttachOptions.Fill, 2, 2); table.Attach (widget, x, x + width, y, y + 1); }
/// <summary> /// /// </summary> /// <param name="sw"></param> public static void Export(StringWriter sw, GridView gv) { using (HtmlTextWriter htw = new HtmlTextWriter(sw)) { // Create a table to contain the grid Table table = new Table(); // include the gridline settings table.GridLines = gv.GridLines; // add the header row to the table if (gv.HeaderRow != null) { table.Rows.Add(gv.HeaderRow); } // add each of the data rows to the table foreach (GridViewRow row in gv.Rows) { table.Rows.Add(row); } // add the footer row to the table if (gv.FooterRow != null) { table.Rows.Add(gv.FooterRow); } // render the table into the htmlwriter table.RenderControl(htw); } }
public void InitDefinitions() { origTable = m_mainForm.Definition; var def = origTable?.Clone(); if (def == null) { DialogResult result = MessageBox.Show(this, string.Format("Table {0} missing definition. Create default definition?", m_mainForm.DBCName), "Definition Missing!", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (result != DialogResult.Yes) return; def = CreateDefaultDefinition(); if (def == null) { MessageBox.Show(string.Format("Can't create default definitions for {0}", m_mainForm.DBCName)); def = new Table(); def.Name = m_mainForm.DBCName; def.Fields = new List<Field>(); } } InitForm(def); }
/* ** Check to make sure the given table is writable. If it is not ** writable, generate an error message and return 1. If it is ** writable return 0; */ static bool sqlite3IsReadOnly( Parse pParse, Table pTab, int viewOk ) { /* A table is not writable under the following circumstances: ** ** 1) It is a virtual table and no implementation of the xUpdate method ** has been provided, or ** 2) It is a system table (i.e. sqlite_master), this call is not ** part of a nested parse and writable_schema pragma has not ** been specified. ** ** In either case leave an error message in pParse and return non-zero. */ if ( ( IsVirtual( pTab ) && sqlite3GetVTable( pParse.db, pTab ).pMod.pModule.xUpdate == null ) || ( ( pTab.tabFlags & TF_Readonly ) != 0 && ( pParse.db.flags & SQLITE_WriteSchema ) == 0 && pParse.nested == 0 ) ) { sqlite3ErrorMsg( pParse, "table %s may not be modified", pTab.zName ); return true; } #if !SQLITE_OMIT_VIEW if ( viewOk == 0 && pTab.pSelect != null ) { sqlite3ErrorMsg( pParse, "cannot modify %s because it is a view", pTab.zName ); return true; } #endif return false; }
public void LinqInsert_Batch_Test() { Table<Movie> nerdMoviesTable = new Table<Movie>(_session, new MappingConfiguration()); Batch batch = _session.CreateBatch(); Movie movie1 = Movie.GetRandomMovie(); Movie movie2 = Movie.GetRandomMovie(); movie1.Director = "Joss Whedon"; var movies = new List<Movie> { movie1, movie2, }; batch.Append(from m in movies select nerdMoviesTable.Insert(m)); Task taskSaveMovies = Task.Factory.FromAsync(batch.BeginExecute, batch.EndExecute, null); taskSaveMovies.Wait(); Task taskSelectStartMovies = Task<IEnumerable<Movie>>.Factory.FromAsync( nerdMoviesTable.BeginExecute, nerdMoviesTable.EndExecute, null). ContinueWith(res => Movie.DisplayMovies(res.Result)); taskSelectStartMovies.Wait(); CqlQuery<Movie> selectAllFromWhere = from m in nerdMoviesTable where m.Director == movie1.Director select m; Task taskselectAllFromWhere = Task<IEnumerable<Movie>>.Factory.FromAsync(selectAllFromWhere.BeginExecute, selectAllFromWhere.EndExecute, null). ContinueWith(res => Movie.DisplayMovies(res.Result)); taskselectAllFromWhere.Wait(); Task<List<Movie>> taskselectAllFromWhereWithFuture = Task<IEnumerable<Movie>>. Factory.FromAsync(selectAllFromWhere.BeginExecute, selectAllFromWhere.EndExecute, null). ContinueWith(a => a.Result.ToList()); Movie.DisplayMovies(taskselectAllFromWhereWithFuture.Result); }
protected override object Convert(Table table, IBindingType typeToConvertTo, CultureInfo cultureInfo) { var runtimeBindingType = (RuntimeBindingType)typeToConvertTo; var verticalTable = GetVerticalTable(table, runtimeBindingType); var values = GetValues(verticalTable); var objectInitializationData = GetObjectInitializationData(values.Keys, runtimeBindingType.Type); var bindingTypes = objectInitializationData.GetBindingTypes(); var convertedValues = values .Where(x => bindingTypes.ContainsKey(x.Key)) .ToDictionary( x => x.Key, x => stepArgumentTypeConverter.Convert(x.Value, bindingTypes[x.Key], cultureInfo)); var constructorParameters = objectInitializationData.Constructor.GetParameters() .Select(x => convertedValues[SanitizePropertyName(x.Name)]).ToArray(); var result = objectInitializationData.Constructor.Invoke(constructorParameters); foreach (var property in objectInitializationData.PropertiesToSet) { var value = convertedValues[SanitizePropertyName(property.Name)]; property.SetValue(result, value, null); } return result; }
protected override IEnumerable<DbParameter> CoreGetColumnParameters(Type connectionType, string dataSourceTag, Server server, Database database, Schema schema, Table table) { if ((object)connectionType == null) throw new ArgumentNullException(nameof(connectionType)); if ((object)dataSourceTag == null) throw new ArgumentNullException(nameof(dataSourceTag)); if ((object)server == null) throw new ArgumentNullException(nameof(server)); if ((object)database == null) throw new ArgumentNullException(nameof(database)); if ((object)schema == null) throw new ArgumentNullException(nameof(schema)); if ((object)table == null) throw new ArgumentNullException(nameof(table)); if (dataSourceTag.SafeToString().ToLower() == ODBC_SQL_SERVER_DATA_SOURCE_TAG) { return new DbParameter[] { //DatazoidLegacyInstanceAccessor.AdoNetBufferingLegacyInstance.ReflectionFascadeLegacyInstance.CreateParameter(connectionType, null,ParameterDirection.Input, DbType.String, 100, 0, 0, true, "@P1", server.ServerName), //DatazoidLegacyInstanceAccessor.AdoNetBufferingLegacyInstance.ReflectionFascadeLegacyInstance.CreateParameter(connectionType, null,ParameterDirection.Input, DbType.String, 100, 0, 0, true, "@P2", database.DatabaseName), DatazoidLegacyInstanceAccessor.AdoNetBufferingLegacyInstance.CreateParameter(connectionType, null, ParameterDirection.Input, DbType.String, 100, 0, 0, true, "@P3", schema.SchemaName), DatazoidLegacyInstanceAccessor.AdoNetBufferingLegacyInstance.CreateParameter(connectionType, null, ParameterDirection.Input, DbType.String, 100, 0, 0, true, "@P4", table.TableName) }; } throw new ArgumentOutOfRangeException(string.Format("dataSourceTag: '{0}'", dataSourceTag)); }
protected override void TestFixtureSetUp() { base.TestFixtureSetUp(); _session = Session; _session.CreateKeyspace(_uniqueKsName); _session.ChangeKeyspace(_uniqueKsName); // Create necessary tables MappingConfiguration config1 = new MappingConfiguration(); config1.MapperFactory.PocoDataFactory.AddDefinitionDefault(typeof(EntityWithTimeUuid), () => LinqAttributeBasedTypeDefinition.DetermineAttributes(typeof(EntityWithTimeUuid))); _tableEntityWithTimeUuid = new Table<EntityWithTimeUuid>(_session, config1); _tableEntityWithTimeUuid.Create(); MappingConfiguration config2 = new MappingConfiguration(); config2.MapperFactory.PocoDataFactory.AddDefinitionDefault(typeof(EntityWithNullableTimeUuid), () => LinqAttributeBasedTypeDefinition.DetermineAttributes(typeof(EntityWithNullableTimeUuid))); _tableEntityWithNullableTimeUuid = new Table<EntityWithNullableTimeUuid>(_session, config2); _tableEntityWithNullableTimeUuid.Create(); _expectedTimeUuidObjectList = EntityWithTimeUuid.GetDefaultObjectList(); _expectedNullableTimeUuidObjectList = EntityWithNullableTimeUuid.GetDefaultObjectList(); _dateBefore = DateTimeOffset.Parse("2014-2-1"); _dateAfter = DateTimeOffset.Parse("2014-4-1"); }
static Settings() { custom = new Table(); }
private static string CreateInsertSqlString(Table table, IDictionary<string, object> parameters) { var sb = new StringBuilder(); sb.AppendLine("IF NOT EXISTS (SELECT * FROM {0} WHERE {1})".Put(table.Name, table.Columns.Where(c => c.IsPrimaryKey).Select(c => "{0} = @{0}".Put(c.Name)).Join(" AND "))); sb.AppendLine("BEGIN"); sb.Append("INSERT INTO "); sb.Append(table.Name); sb.Append(" ("); foreach (var par in parameters) { sb.Append("["); sb.Append(par.Key); sb.Append("],"); } sb.Remove(sb.Length - 1, 1); sb.Append(") VALUES ("); foreach (var par in parameters) { sb.Append("@"); sb.Append(par.Key); sb.Append(","); } sb.Remove(sb.Length - 1, 1); sb.AppendLine(")"); sb.Append("END"); return sb.ToString(); }
protected void Delete_Click(object sender, EventArgs e) { try { int i = 0; Table TBL = new Table(); TBL = (Table)(Session["MessageTbl"]); int num = TBL.Rows.Count; foreach (TableRow x in TBL.Rows) { if (((x.Cells[1].Text) != "הודעות") && (i < num - 1)) { CheckBox itemBox = divmessage.FindControl("ChekBox" + i.ToString()) as CheckBox; i++; if (itemBox.Checked == true) { DBservices.DeleteMessage(x.Cells[1].Text); } } } Response.Redirect("message.aspx"); } catch (Exception ex) { ErrHandler.WriteError(ex.Message); Response.Write("ארעה שגיאה"); } }
public static Tuple<long,long> Delete(Table Data, Predicate Where) { long CurrentCount = 0; long NewCount = 0; foreach (RecordSet rs in Data.Extents) { // Append the current record count // CurrentCount += (long)rs.Count; // Delete // NewCount += Delete(rs, Where); // Push // Data.Push(rs); } BinarySerializer.Flush(Data); // Return the delta // return new Tuple<long,long>(CurrentCount, NewCount); }
public void Transaction_Delete() { using (var context = new Table()) { int? ID; // 普通Where ID = context.User.Desc(o => o.ID).GetValue(o => o.ID); context.User.Where(o => o.ID == ID).Delete(); Assert.IsFalse(context.User.Where(o => o.ID == ID).IsHaving()); // 重载 ID = context.User.Desc(o => o.ID).GetValue(o => o.ID); context.User.Delete(ID); Assert.IsFalse(context.User.Where(o => o.ID == ID).IsHaving()); // 批量 var IDs = context.User.Desc(o => o.ID).ToSelectList(5, o => o.ID); context.User.Delete(IDs); Assert.IsFalse(context.User.Where(o => IDs.Contains(o.ID)).IsHaving()); // 缓存表 ID = context.UserRole.Cache.OrderByDescending(o => o.ID).GetValue(o => o.ID); context.UserRole.Where(o => o.ID == ID).Delete(); Assert.IsFalse(context.UserRole.Cache.Where(o => o.ID == ID).IsHaving()); // 不同逻辑方式(主键为GUID) var ID2 = context.Orders.Desc(o => o.ID).GetValue(o => o.ID); context.Orders.Delete(ID2); Assert.IsFalse(context.Orders.Where(o => o.ID == ID2).IsHaving()); ID2 = context.OrdersAt.Desc(o => o.ID).GetValue(o => o.ID); context.OrdersAt.Delete(ID2); Assert.IsFalse(context.OrdersAt.Where(o => o.ID == ID2).IsHaving()); Assert.IsTrue(context.Orders.Where(o => o.ID == ID2).IsHaving()); context.OrdersBool.Delete(ID2); Assert.IsFalse(context.OrdersBool.Where(o => o.ID == ID2).IsHaving()); Assert.IsTrue(context.Orders.Where(o => o.ID == ID2).IsHaving()); context.OrdersNum.Delete(ID2); Assert.IsFalse(context.OrdersNum.Where(o => o.ID == ID2).IsHaving()); Assert.IsTrue(context.Orders.Where(o => o.ID == ID2).IsHaving()); context.OrdersBoolCache.Delete(ID2); Assert.IsFalse(context.OrdersBoolCache.Cache.Where(o => o.ID == ID2).IsHaving()); Assert.IsTrue(context.Orders.Where(o => o.ID == ID2).IsHaving()); // 手动SQL ID = context.User.Desc(o => o.ID).GetValue(o => o.ID); var table = context; table.ManualSql.Execute("DELETE FROM Members_User WHERE id = @ID", table.DbProvider.CreateDbParam("ID", ID)); Assert.IsFalse(context.User.Where(o => o.ID == ID).IsHaving()); context.SaveChanges(); } }
public void SchemaNameTest() { var schema = new TableSchema("SchemaNameTest"); Assert.AreEqual(schema.Name, "SchemaNameTest"); var table = new Table("SchemaNameTest 2"); Assert.AreEqual(table.Schema.Name, "SchemaNameTest 2"); }
public static void luaH_free(lua_State L, Table t) { if (t.node[0] != dummynode) luaM_freearray(L, t.node); luaM_freearray(L, t.array); luaM_free(L, t); }
public void CreateInstance_returns_the_object_returned_from_the_func() { var table = new Table("Field", "Value"); var expectedPerson = new Person(); var person = table.CreateInstance(() => expectedPerson); person.Should().Be(expectedPerson); }
public static void CloseConnection() { _context.Connection.Close(); _context.Dispose(); _table = null; _context = null; }
static void Main(string[] args) { #region basic config Dictionary<string, string> server_config = new Dictionary<string,string>(); server_config.Add("ipaddr", "localhost"); server_config.Add("userid", "root"); server_config.Add("password", "root"); server_config.Add("db", "translate"); int count_bits = 64; int count_blocks = 6; int num_diff_bits = 3; #endregion List<ulong> bit_mask = new List<ulong>(); bit_mask.Add(0xFFE0000000000000); bit_mask.Add(0x1FFC0000000000); bit_mask.Add(0x3FF80000000); bit_mask.Add(0x7FF00000); bit_mask.Add(0xFFE00); bit_mask.Add(0x1FF); foreach (ulong item in bit_mask) { Console.WriteLine("{0:x}", item); } Table table = new Table(server_config, count_bits, count_blocks, num_diff_bits, bit_mask); table.reset(); }
/// <summary> /// Erstellt eine Beschreibung. /// </summary> /// <param name="table">Die gesamte <i>NIT</i>.</param> /// <param name="offset">Das erste Byte dieser Beschreibung in den Rohdaten.</param> /// <param name="length">Die Größe der Rohdaten zu dieser Beschreibung.</param> private NetworkEntry( Table table, int offset, int length ) : base( table ) { // Access section Section section = Section; // Load TransportStreamIdentifier = (ushort) Tools.MergeBytesToWord( section[offset + 1], section[offset + 0] ); OriginalNetworkIdentifier = (ushort) Tools.MergeBytesToWord( section[offset + 3], section[offset + 2] ); // Read the length int descrLength = 0xfff & Tools.MergeBytesToWord( section[offset + 5], section[offset + 4] ); // Caluclate the total length Length = 6 + descrLength; // Verify if (Length > length) return; // Try to load descriptors Descriptors = Descriptor.Load( this, offset + 6, descrLength ); // Can use it IsValid = true; }
private static string GenMethodReturn(Table pTable, MethodActionType t) { StringBuilder wBuilderReturn = null; switch (t) { case MethodActionType.Insert: { Column pPK = FwkGeneratorHelper.GetPrimaryKey(pTable); if (pPK != null) { wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("InsertReturn").Content); wBuilderReturn.Replace(CommonConstants.CONST_ENTITY_PROPERTY_NAME, pPK.Name); wBuilderReturn.Replace(CommonConstants.CONST_TYPENAME, FwkGeneratorHelper.GetCSharpType(pPK)); return wBuilderReturn.ToString(); } else return " wDataBase.ExecuteNonQuery(wCmd);"; } case MethodActionType.Update: return " wDataBase.ExecuteNonQuery(wCmd);"; case MethodActionType.SearchByParam: wBuilderReturn = new StringBuilder(FwkGeneratorHelper.TemplateDocument.GetTemplate("SearchReturn").Content); return wBuilderReturn.ToString(); case MethodActionType.Delete: return " wDataBase.ExecuteNonQuery(wCmd);"; } return string.Empty; }
//回答问题 private IEnumerator SolveProblem(int index, int IsRight) { //using (new BlockingLayerHelper(0)) { var _msg = NetManager.Instance.AnswerQuestion(IsRight); yield return(_msg.SendAndWaitUntilDone()); if (_msg.State == MessageState.Reply) { bLock = false; if (_msg.ErrorCode == (int)ErrorCodes.OK) { //donghua dengdai { DataModel.Option[index].TipState = 1; if (IsRight == 1) { m_iRightCount++; DataModel.Option[index].State = 1; } else { DataModel.Option[index].State = 2; DataModel.Option[m_iCorrectId].State = 1; } DataModel.AnswerProb = m_iRightCount + "/" + m_iNextAnswer; m_bIsPlayAnimation = true; yield return(new WaitForSeconds(1f)); m_bIsPlayAnimation = false; } if (m_iNextAnswer >= MaxCount || _msg.Response.QuestionId == -1) { DataModel.IsOver = true; var _mTimeStart2 = Game.Instance.ServerTime.AddDays(1).Date.AddHours(12); DataModel.MTime = _mTimeStart2; if (m_objTimerTrigger != null) { TimeManager.Instance.DeleteTrigger(m_objTimerTrigger); m_objTimerTrigger = null; } //活动开启时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270230); //今日活动已完成请明日再来挑战 DataModel.OverString2 = GameUtils.GetDictionaryText(270228); PlayerDataManager.Instance.NoticeData.AnswerQuestion = false; yield break; } var tbSubject = Table.GetSubject(_msg.Response.QuestionId); //if (tbSubject != null) //{ BuildRadom(_msg.Response); m_iNextAnswer++; DataModel.WhichQuestion = String.Format(m_strQuestion, m_iNextAnswer); // } } else { UIManager.Instance.ShowNetError(_msg.ErrorCode); } } else { var _e = new ShowUIHintBoard(220821); EventDispatcher.Instance.DispatchEvent(_e); } } }
/// <summary> /// Opens a file for reading the script code. /// It can return either a string, a byte[] or a Stream. /// If a byte[] is returned, the content is assumed to be a serialized (dumped) bytecode. If it's a string, it's /// assumed to be either a script or the output of a string.dump call. If a Stream, autodetection takes place. /// </summary> /// <param name="file">The file.</param> /// <param name="globalContext">The global context.</param> /// <returns> /// A string, a byte[] or a Stream. /// </returns> public abstract object LoadFile(string file, Table globalContext);
public void FetchOne() { Table t = testSchema.GetTable("test"); Assert.Equal(38, t.Select("age").Execute().FetchOne()["age"]); }
public override void VisitTable(Table table) { Document document = table.Document; if (table._leftPadding.IsNull) { table._leftPadding = Unit.FromMillimeter(1.2); } if (table._rightPadding.IsNull) { table._rightPadding = Unit.FromMillimeter(1.2); } ParagraphFormat format; Style style = document._styles[table._style.Value]; if (style != null) { format = ParagraphFormatFromStyle(style); } else { table.Style = "Normal"; format = document._styles.Normal._paragraphFormat; } if (table._format == null) { table._format = format.Clone(); table._format._parent = table; } else { FlattenParagraphFormat(table._format, format); } int rows = table.Rows.Count; int clms = table.Columns.Count; for (int idxclm = 0; idxclm < clms; idxclm++) { Column column = table.Columns[idxclm]; ParagraphFormat colFormat; style = document._styles[column._style.Value]; if (style != null) { colFormat = ParagraphFormatFromStyle(style); } else { column._style = table._style; colFormat = table.Format; } if (column._format == null) { column._format = colFormat.Clone(); column._format._parent = column; if (column._format._shading == null && table._format._shading != null) { column._format._shading = table._format._shading; } } else { FlattenParagraphFormat(column._format, colFormat); } if (column._leftPadding.IsNull) { column._leftPadding = table._leftPadding; } if (column._rightPadding.IsNull) { column._rightPadding = table._rightPadding; } if (column._shading == null) { column._shading = table._shading; } else if (table._shading != null) { FlattenShading(column._shading, table._shading); } if (column._borders == null) { column._borders = table._borders; } else if (table._borders != null) { FlattenBorders(column._borders, table._borders); } } for (int idxrow = 0; idxrow < rows; idxrow++) { Row row = table.Rows[idxrow]; ParagraphFormat rowFormat; style = document._styles[row._style.Value]; if (style != null) { rowFormat = ParagraphFormatFromStyle(style); } else { row._style = table._style; rowFormat = table.Format; } for (int idxclm = 0; idxclm < clms; idxclm++) { Column column = table.Columns[idxclm]; Cell cell = row[idxclm]; ParagraphFormat cellFormat; Style cellStyle = document._styles[cell._style.Value]; if (cellStyle != null) { cellFormat = ParagraphFormatFromStyle(cellStyle); if (cell._format == null) { cell._format = cellFormat; } else { FlattenParagraphFormat(cell._format, cellFormat); } } else { if (row._format != null) { FlattenParagraphFormat(cell.Format, row._format); } if (style != null) { cell._style = row._style; FlattenParagraphFormat(cell.Format, rowFormat); } else { cell._style = column._style; FlattenParagraphFormat(cell.Format, column._format); } } if (cell._format._shading == null && table._format._shading != null) { cell._format._shading = table._format._shading; } if (cell._shading == null) { cell._shading = row._shading; } else if (row._shading != null) { FlattenShading(cell._shading, row._shading); } if (cell._shading == null) { cell._shading = column._shading; } else if (column._shading != null) { FlattenShading(cell._shading, column._shading); } if (cell._borders == null) { CloneHelper(ref cell._borders, row._borders); } else if (row._borders != null) { FlattenBorders(cell._borders, row._borders); } if (cell._borders == null) { cell._borders = column._borders; } else if (column._borders != null) { FlattenBorders(cell._borders, column._borders); } } if (row._format == null) { row._format = rowFormat.Clone(); row._format._parent = row; if (row._format._shading == null && table._format._shading != null) { row._format._shading = table._format._shading; } } else { FlattenParagraphFormat(row._format, rowFormat); } if (row._topPadding.IsNull) { row._topPadding = table._topPadding; } if (row._bottomPadding.IsNull) { row._bottomPadding = table._bottomPadding; } if (row._shading == null) { row._shading = table._shading; } else if (table._shading != null) { FlattenShading(row._shading, table._shading); } if (row._borders == null) { row._borders = table._borders; } else if (table._borders != null) { FlattenBorders(row._borders, table._borders); } } }
public static Table CreateSimpleTable(Table table) { ThemableColor bordersColor = new ThemableColor(Color.FromRgb(73, 90, 128)); ThemableColor headerColor = new ThemableColor(Color.FromRgb(34, 143, 189)); ThemableColor defaultRowColor = new ThemableColor(Color.FromRgb(176, 224, 230)); Border border = new Border(1, BorderStyle.Single, bordersColor); table.Borders = new TableBorders(border); table.TableCellPadding = new Basic.Primitives.Padding(5); //Add table header TableRow headerRow = table.Rows.AddTableRow(); headerRow.RepeatOnEveryPage = true; //Add first column TableCell column1 = headerRow.Cells.AddTableCell(); column1.State.BackgroundColor.LocalValue = headerColor; column1.Borders = new TableCellBorders(border, border, border, border, null, null, border, null); column1.PreferredWidth = new TableWidthUnit(50); //Add second column TableCell column2 = headerRow.Cells.AddTableCell(); column2.State.BackgroundColor.LocalValue = headerColor; column2.PreferredWidth = new TableWidthUnit(150); column2.VerticalAlignment = VerticalAlignment.Center; Paragraph column2Para = column2.Blocks.AddParagraph(); column2Para.TextAlignment = Alignment.Center; column2Para.State.LineSpacing = 1; TextInline column2Text = column2Para.Inlines.AddText("Product"); column2Text.State.ForegroundColor = new ThemableColor(Colors.White); column2Text.FontSize = 20; //Add third column TableCell column3 = headerRow.Cells.AddTableCell(); column3.State.BackgroundColor.LocalValue = headerColor; column3.PreferredWidth = new TableWidthUnit(250); column3.Padding = new Basic.Primitives.Padding(20, 0, 0, 0); Paragraph column3Para = column3.Blocks.AddParagraph(); column3Para.State.LineSpacing = 1; TextInline column3Text = column3Para.Inlines.AddText("Price"); column3Text.State.ForegroundColor = new ThemableColor(Colors.White); column3Text.FontSize = 20; //Add table rows Random r = new Random(); for (int i = 0; i < 50; i++) { ThemableColor rowColor = i % 2 == 0 ? defaultRowColor : new ThemableColor(Colors.White); TableRow row = table.Rows.AddTableRow(); row.Height = new TableRowHeight(HeightType.Exact, 20); TableCell idCell = row.Cells.AddTableCell(); idCell.State.BackgroundColor.LocalValue = rowColor; idCell.Blocks.AddParagraph().Inlines.AddText(i.ToString()); TableCell productCell = row.Cells.AddTableCell(); productCell.State.BackgroundColor.LocalValue = rowColor; Paragraph productPara = productCell.Blocks.AddParagraph(); productPara.TextAlignment = Alignment.Center; productPara.Inlines.AddText(String.Format("Product{0}", i)); TableCell priceCell = row.Cells.AddTableCell(); priceCell.Padding = new Basic.Primitives.Padding(20, 0, 0, 0); priceCell.State.BackgroundColor.LocalValue = rowColor; priceCell.Blocks.AddParagraph().Inlines.AddText(r.Next(10, 1000).ToString()); } return(table); }
public Table Add(Table newTable) { db.Add(newTable); return(newTable); }
public void RefreshData(UIInitArguments data) { var _args = data as AnswerArguments; if (_args != null) { if (m_objTimerTrigger != null) { TimeManager.Instance.DeleteTrigger(m_objTimerTrigger); m_objTimerTrigger = null; } m_strQuestion = GameUtils.GetDictionaryText(270227); m_iNextAnswer = PlayerDataManager.Instance.GetExData(436); m_iRightCount = PlayerDataManager.Instance.GetExData(437); DataModel.AnswerProb = m_iRightCount + "/" + m_iNextAnswer; var _beginTime = int.Parse(Table.GetClientConfig(206).Value); var _endTime = int.Parse(Table.GetClientConfig(207).Value); var _mTimeStart = Game.Instance.ServerTime.AddDays(0).Date.AddHours(_beginTime); var _mTimeEnd = Game.Instance.ServerTime.AddDays(0).Date.AddHours(_endTime); var _mTimeStart2 = Game.Instance.ServerTime.AddDays(1).Date.AddHours(_beginTime); var _mTimeEnd2 = Game.Instance.ServerTime.AddDays(1).Date.AddHours(_endTime); var _nowTime = Game.Instance.ServerTime; PlayerDataManager.Instance.NoticeData.AnswerQuestion = false; if (m_iNextAnswer >= MaxCount) { m_iNextAnswer = 0; DataModel.IsOver = true; DataModel.MTime = _mTimeStart2; //活动开启时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270230); //今日活动已完成请明日再来挑战 DataModel.OverString2 = GameUtils.GetDictionaryText(270228); return; } if (_nowTime < _mTimeStart) { DataModel.IsOver = true; m_iNextAnswer = 0; DataModel.MTime = _mTimeStart; //活动开启时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270230); //今日活动未开启 DataModel.OverString2 = GameUtils.GetDictionaryText(270229); m_objTimerTrigger = TimeManager.Instance.CreateTrigger(_mTimeStart, () => { TimeManager.Instance.DeleteTrigger(m_objTimerTrigger); m_objTimerTrigger = null; //活动剩余时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270231); DataModel.IsOver = false; DataModel.MTime = _mTimeEnd; m_iNextAnswer = 1; if (m_strQuestion != "") { DataModel.WhichQuestion = String.Format(m_strQuestion, m_iNextAnswer); NetManager.Instance.StartCoroutine(GetProblemData(m_iNextAnswer)); } }); } else if (_nowTime >= _mTimeStart && _nowTime < _mTimeEnd) { DataModel.IsOver = false; //活动剩余时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270231); DataModel.MTime = _mTimeEnd; m_objTimerTrigger = TimeManager.Instance.CreateTrigger(_mTimeEnd, () => { TimeManager.Instance.DeleteTrigger(m_objTimerTrigger); m_objTimerTrigger = null; DataModel.IsOver = true; DataModel.MTime = _mTimeStart2; //活动开启时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270230); //今日活动已完成请明日再来挑战 DataModel.OverString2 = GameUtils.GetDictionaryText(270228); }); m_iNextAnswer++; if (m_strQuestion != "") { DataModel.WhichQuestion = String.Format(m_strQuestion, m_iNextAnswer); NetManager.Instance.StartCoroutine(GetProblemData(m_iNextAnswer)); } } else { DataModel.IsOver = true; m_iNextAnswer = 0; DataModel.MTime = _mTimeStart2; //今日活动已完成请明日再来挑战 DataModel.OverString2 = GameUtils.GetDictionaryText(270228); //活动开启时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270230); m_objTimerTrigger = TimeManager.Instance.CreateTrigger(_mTimeStart2, () => { TimeManager.Instance.DeleteTrigger(m_objTimerTrigger); m_objTimerTrigger = null; DataModel.IsOver = false; DataModel.MTime = _mTimeEnd2; //活动剩余时间 DataModel.OverString1 = GameUtils.GetDictionaryText(270231); m_iNextAnswer = 1; if (m_strQuestion != "") { DataModel.WhichQuestion = String.Format(m_strQuestion, m_iNextAnswer); NetManager.Instance.StartCoroutine(GetProblemData(m_iNextAnswer)); } }); } } }
public void CheckThenControlTypeCollectionShown([NotNull] string behavior, string enabled, [NotNull] Table table) { behavior = $"should {behavior}"; CheckControlTypeCollectionShown(behavior, enabled, table, _runner.Then); }
public TableInformation this [Table table] { get { return(Tables [(int)table]); } }
public void CheckGivenControlTypeCollectionShown([NotNull] string behavior, string enabled, [NotNull] Table table) { if (behavior.Contains("are")) { behavior = behavior.Replace("are", "is"); } CheckControlTypeCollectionShown(behavior, enabled, table, _runner.Given); }
protected abstract void ExportTableProperties(Table table);
public bool HasTable(Table table) { return((Valid & (1L << (int)table)) != 0); }
protected abstract void ExportColumnProperties(Table table, Column column);
protected abstract void ExportTableExtendedProperty(Table table, string property);
public void GivenUserLoginsToAMMWithCredentialAndSeeTheAMMDirectAccountsPageLoaded(Table table) { driver.Navigate().GoToUrl(ConfigurationManager.AppSettings["amm_url"]); loginPage = new LoginPage(driver); dynamic instance = table.CreateDynamicInstance(); loginPage.Login((string)instance.Username, (string)instance.Password); aMMDirectAccountsPage = new AMMDirectAccountsPage(driver); Assert.IsTrue(aMMDirectAccountsPage.ifElementExist(aMMDirectAccountsPage.txtFID)); }
protected abstract void ExportColumnExtendedProperty(Table table, Column column, string property);
bool getInfo(string filterStr, bool isEditMode = false) { Table pTable = new Table(); CommCtrl pCommCtrl = new CommCtrl(); try { string parentItem = pDataIO.getDbCmdExecuteScalar("select RoleName from RolesTable where id = " + currID).ToString(); Control myCtrl = pCommCtrl.CreateNaviCtrl(funcItemName, parentItem, Session["BlockType"].ToString(), pDataIO,out logTracingString); this.plhNavi.Controls.Add(myCtrl); pTable.ID = "ListTable"; List<string> pLst = new List<string>(); pLst.Add("已经存在权限"); pLst.Add(""); pLst.Add("服务器权限列表"); TableHeaderRow thr = pCommCtrl.CreateMyTableHeader(pLst); if (thr != null) { pTable.Controls.Add(thr); } #region 获取当前已有的列表 DataTable pReaderTable = pDataIO.GetDataTable(filterStr, "CurrFunctionInfo"); Table currTable = new Table(); currTable.ID = "currTable"; currTableChks = new CheckBox[pReaderTable.Rows.Count]; for (int i = 0; i < pReaderTable.Rows.Count; i++) { currTableChks[i] = new CheckBox(); currTableChks[i].ID = "chkCurrID_" + pReaderTable.Rows[i]["ID"].ToString(); currTableChks[i].Checked = true; Label lblName = new Label(); lblName.Text = pReaderTable.Rows[i]["Title"].ToString(); Label lblRemark = new Label(); lblRemark.Text = pReaderTable.Rows[i]["Remarks"].ToString(); TableCell[] tcs = new TableCell[3]; tcs[0] = pCommCtrl.CreateMyTableCell(currTableChks[i]); tcs[1] = pCommCtrl.CreateMyTableCell(lblName); tcs[2] = pCommCtrl.CreateMyTableCell(lblRemark); //string[] lblItem = new string[3] { "select", "RoleName", "Remark" }; TableRow tr = new TableRow(); for (int j = 0; j < tcs.Length; j++) { tr.Cells.Add(tcs[j]); } currTable.Rows.Add(tr); } #endregion #region 服务器存在的列表 DataTable rolesListTable = pDataIO.GetDataTable("select * from FunctionTable where blockLevel=0", "FunctionTable"); Table rolesTable = new Table(); rolesTable.ID = "GlobalTable"; globalTableChks = new CheckBox[rolesListTable.Rows.Count]; for (int i = 0; i < rolesListTable.Rows.Count; i++) { globalTableChks[i] = new CheckBox(); globalTableChks[i].ID = "chkGlobalID_" + rolesListTable.Rows[i]["ID"].ToString(); Label lblName = new Label(); lblName.Text = rolesListTable.Rows[i]["Title"].ToString(); Label lblRemark = new Label(); lblRemark.Text = rolesListTable.Rows[i]["Remarks"].ToString(); TableCell[] tcs = new TableCell[3]; tcs[0] = pCommCtrl.CreateMyTableCell(globalTableChks[i]); tcs[1] = pCommCtrl.CreateMyTableCell(lblName); tcs[2] = pCommCtrl.CreateMyTableCell(lblRemark); TableRow tr = new TableRow(); for (int j = 0; j < tcs.Length; j++) { tr.Cells.Add(tcs[j]); } rolesTable.Rows.Add(tr); } #endregion TableCell dispTc0 = new TableCell(); dispTc0.Controls.Add(currTable); TableCell dispTc1 = new TableCell(); dispTc1.Text = ""; TableCell dispTc2 = new TableCell(); dispTc2.Controls.Add(rolesTable); TableRow dispTr = new TableRow(); dispTr.Cells.Add(dispTc0); dispTr.Cells.Add(dispTc1); dispTr.Cells.Add(dispTc2); pTable.Rows.Add(dispTr); setItemEnabled(isEditMode); this.plhMain.Controls.Add(pTable); this.plhMain.Controls.Add(new HtmlGenericControl("hr")); return true; } catch (Exception ex) { pDataIO.WriteErrorLogs(ex.ToString()); pDataIO.OpenDatabase(false); throw ex; } }
public void generate_tiles(Table map_data, Bitmap tileset, Viewport viewport) { if (viewport == null) { Console.WriteLine("Tilemap viewport is invalid!"); return; } Console.Write("Generating tilemap..."); //if not ready or needed, gtfo if (map_data == null || tileset == null) { if (map_data == null) { Console.WriteLine("Attempted to generate tilemap with null map_data"); } if (tileset == null) { Console.WriteLine("Attempted to generate tilemap with null tileset"); } return; } if (map_data.xsize == 0 || map_data.ysize == 0 || map_data.zsize == 0) { Console.WriteLine("Attempted to generate tilemap of size 0"); } if (!map_tiles_empty()) { Console.WriteLine("Attempted to generate a tilemap that is already generated"); return; } //get map dimensions in 64x tiles int tile_width = Math.Max(1, (int)((float)map_data.xsize / 64f)); int tile_height = Math.Max(1, (int)((float)map_data.ysize / 64f)); //set blank color Color c_blank = new Color(0, 0, 0, 0); //iterate through the 64x64 map tiles we intend to create for (int tile_x = 0; tile_x < tile_width; tile_x++) { for (int tile_y = 0; tile_y < tile_height; tile_y++) { //determine the map starting tile coordinates int start_x = tile_x * 64; int start_y = tile_y * 64; //calculate the map tile dimensions - normally 64x64 except close to bottom or right edges int bm_width = 64; int bm_height = 64; if (tile_x == tile_width - 1) { bm_width = (map_data.xsize - start_x); } if (tile_y == tile_height - 1) { bm_height = (map_data.ysize - start_y); } //create a bitmap for this map tile Bitmap bitmap = new Bitmap(bm_width * 32, bm_height * 32); //determine map tile ending coordinates int end_x = start_x + bm_width; int end_y = start_y + bm_height; //initialize tile image coordinates int tile_image_x = 0; int tile_image_y = 0; //open the bitmap for direct access System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap.bmp); g.CompositingMode = System.Drawing.Drawing2D.CompositingMode.SourceOver; //iterate the map data and fill in the tile bitmap as needed for (int x = start_x; x < end_x; x++) { for (int y = start_y; y < end_y; y++) { //get the tile id int tile_id = map_data.get(x, y, 0) - 384; if (tile_id < 0) //if tile is empty { //fill in a blank, update the image coordinates, and continue bitmap.fill_rect(tile_image_x, tile_image_y, 32, 32, c_blank); tile_image_y += 32; continue; } //direct copy bitmap info (blt is too slow) System.Drawing.Rectangle source = new System.Drawing.Rectangle(new System.Drawing.Point((tile_id % 8) * 32, (tile_id / 8) * 32), new System.Drawing.Size(32, 32)); System.Drawing.Rectangle destination = new System.Drawing.Rectangle(new System.Drawing.Point(tile_image_x, tile_image_y), new System.Drawing.Size(32, 32)); g.DrawImage(tileset.bmp, destination, source, System.Drawing.GraphicsUnit.Pixel); //update tile coordinates and continue tile_image_y += 32; } //recycle column tile_image_x += 32; tile_image_y = 0; } //close direct access to bitmap g.Dispose(); OG_Graphics.deferred_action_add(bitmap.syncBitmap); //create the tile sprite and add it to the map Sprite sprite = new Sprite(viewport); sprite.bitmap = bitmap; sprite.x = tile_x * 2048; sprite.y = tile_y * 2048; add_map_tile(sprite); } } Console.Write(" done.\n"); }
public Task <User> GetByUserAndPass(string username, string password, CancellationToken cancellationToken) { var passwordHash = SecurityHelper.GetSha256Hash(password); return(Table.Where(p => p.UserName == username && p.PasswordHash == passwordHash).SingleOrDefaultAsync(cancellationToken)); }
/// <summary> /// Constructor /// </summary> public UpgradeView(ViewBase owner) : base(owner) { Builder builder = BuilderFromResource("ApsimNG.Resources.Glade.UpgradeView.glade"); window1 = (Window)builder.GetObject("window1"); button1 = (Button)builder.GetObject("button1"); button2 = (Button)builder.GetObject("button2"); table1 = (Table)builder.GetObject("table1"); table2 = (Table)builder.GetObject("table2"); firstNameBox = (Entry)builder.GetObject("firstNameBox"); lastNameBox = (Entry)builder.GetObject("lastNameBox"); organisationBox = (Entry)builder.GetObject("organisationBox"); emailBox = (Entry)builder.GetObject("emailBox"); countryBox = (ComboBox)builder.GetObject("countryBox"); label1 = (Label)builder.GetObject("label1"); licenseContainer = (Container)builder.GetObject("licenseContainer"); checkbutton1 = (CheckButton)builder.GetObject("checkbutton1"); listview1 = (Gtk.TreeView)builder.GetObject("listview1"); alignment7 = (Alignment)builder.GetObject("alignment7"); oldVersions = (CheckButton)builder.GetObject("checkbutton2"); listview1.Model = listmodel; Version version = Assembly.GetExecutingAssembly().GetName().Version; if (version.Revision == 0) { button1.Sensitive = false; table2.Hide(); checkbutton1.Hide(); } CellRendererText textRender = new Gtk.CellRendererText(); textRender.Editable = false; TreeViewColumn column0 = new TreeViewColumn("Version", textRender, "text", 0); listview1.AppendColumn(column0); column0.Sizing = TreeViewColumnSizing.Autosize; column0.Resizable = true; TreeViewColumn column1 = new TreeViewColumn("Description", textRender, "text", 1); listview1.AppendColumn(column1); column1.Sizing = TreeViewColumnSizing.Autosize; column1.Resizable = true; // Populate the combo box with a list of valid country names. ListStore countries = new ListStore(typeof(string)); foreach (string country in Constants.Countries) { countries.AppendValues(country); } countryBox.Model = countries; // Add a cell renderer to the combo box. CellRendererText cell = new CellRendererText(); countryBox.PackStart(cell, false); countryBox.AddAttribute(cell, "text", 0); // Make the tab order a little more sensible than the defaults table1.FocusChain = new Widget[] { alignment7, button1, button2 }; table2.FocusChain = new Widget[] { firstNameBox, lastNameBox, emailBox, organisationBox, countryBox }; licenseView = new MarkdownView(owner); licenseContainer.Add(licenseView.MainWidget); tabbedExplorerView = owner as IMainView; window1.TransientFor = owner.MainWidget.Toplevel as Window; window1.Modal = true; oldVersions.Toggled += OnShowOldVersionsToggled; button1.Clicked += OnUpgrade; button2.Clicked += OnViewMoreDetail; window1.Destroyed += OnFormClosing; window1.MapEvent += OnShown; }
private static void SetProperty <T>(T obj, PropertyInfo property, object value, string columnName, Type type, Table table, Row row) { try { property.SetValue(obj, value, null); } catch (Exception e) { throw new ConfigException(e, "M_Fixture_Temp_ObjectFactory_SetProperty", columnName, type, table, row, value); } }
/*-------------------------------------------------------------------------- * Main *--------------------------------------------------------------------------*/ public static int Main( ) { // 1. Create a DynamoDB client connected to a DynamoDB-Local instance Console.WriteLine(stepString, 1, "Create a DynamoDB client connected to a DynamoDB-Local instance"); if (!createClient(true) || !pause( )) { return(1); } // 2. Create a table for movie data asynchronously Console.WriteLine(stepString, 2, "Create a table for movie data"); CreatingTable_async(movies_table_name, movie_items_attributes, movies_key_schema, movies_table_provisioned_throughput).Wait( ); if (!pause( ) || operationFailed) { return(1); } try { moviesTable = Table.LoadTable(Ddb_Intro.client, movies_table_name); } catch (Exception ex) { operationFailed = true; Console.WriteLine( " Error: Could not access the new '{0}' table after creating it;\n" + " Reason: {1}.", movies_table_name, ex.Message); pause( ); return(1); } // 3. Load movie data into the Movies table asynchronously if ((moviesTableDescription != null) && (moviesTableDescription.ItemCount == 0)) { Console.WriteLine(stepString, 3, "Load movie data into the Movies table"); LoadingData_async(moviesTable, movieDataPath).Wait( ); if (!pause( ) || operationFailed) { return(1); } } else { Console.WriteLine(stepString, 3, "Skipped: Movie data is already loaded in the Movies table"); if (!pause( )) { return(1); } } // 4. Add a new movie to the Movies table Console.WriteLine(stepString, 4, "Add a new movie to the Movies table"); Document newItemDocument = new Document(); newItemDocument["year"] = 2018; newItemDocument["title"] = "The Big New Movie"; newItemDocument["info"] = Document.FromJson( "{\"plot\" : \"Nothing happens at all.\",\"rating\" : 0}"); WritingNewMovie_async(newItemDocument).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 5. Read and display the new movie record that was just added Console.WriteLine(stepString, 5, "Read and display the new movie record that was just added"); ReadingMovie_async(2018, "The Big New Movie", true).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 6. Update the new movie record in various ways //------------------------------------------------- // 6a. Create an UpdateItemRequest to: // -- modify the plot and rating of the new movie, and // -- add a list of actors to it Console.WriteLine(stepString, "6a", "Change the plot and rating for the new movie and add a list of actors"); UpdateItemRequest updateRequest = new UpdateItemRequest() { TableName = movies_table_name, Key = new Dictionary <string, AttributeValue> { { partition_key_name, new AttributeValue { N = "2018" } }, { sort_key_name, new AttributeValue { S = "The Big New Movie" } } }, ExpressionAttributeValues = new Dictionary <string, AttributeValue> { { ":r", new AttributeValue { N = "5.5" } }, { ":p", new AttributeValue { S = "Everything happens all at once!" } }, { ":a", new AttributeValue { L = new List <AttributeValue> { new AttributeValue { S = "Larry" }, new AttributeValue { S = "Moe" }, new AttributeValue { S = "Curly" } } } } }, UpdateExpression = "SET info.rating = :r, info.plot = :p, info.actors = :a", ReturnValues = "NONE" }; UpdatingMovie_async(updateRequest, true).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 6b Change the UpdateItemRequest so as to increment the rating of the // new movie, and then make the update request asynchronously. Console.WriteLine(stepString, "6b", "Increment the new movie's rating atomically"); Console.WriteLine(" -- Incrementing the rating of the new movie by 1..."); updateRequest.ExpressionAttributeValues = new Dictionary <string, AttributeValue> { { ":inc", new AttributeValue { N = "1" } } }; updateRequest.UpdateExpression = "SET info.rating = info.rating + :inc"; UpdatingMovie_async(updateRequest, true).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 6c Change the UpdateItemRequest so as to increment the rating of the // new movie, and then make the update request asynchronously. Console.WriteLine(stepString, "6c", "Now try the same increment again with a condition that fails... "); Console.WriteLine(" -- Now trying to increment the new movie's rating, but this time\n" + " ONLY ON THE CONDITION THAT the movie has more than 3 actors..."); updateRequest.ExpressionAttributeValues.Add(":n", new AttributeValue { N = "3" }); updateRequest.ConditionExpression = "size(info.actors) > :n"; UpdatingMovie_async(updateRequest, true).Wait( ); if (!pause( ) || operationSucceeded) { return(1); } // 7. Try conditionally deleting the movie that we added // 7a. Try conditionally deleting the movie that we added Console.WriteLine(stepString, "7a", "Try deleting the new movie record with a condition that fails"); Console.WriteLine(" -- Trying to delete the new movie,\n" + " -- but ONLY ON THE CONDITION THAT its rating is 5.0 or less..."); Expression condition = new Expression(); condition.ExpressionAttributeValues[":val"] = 5.0; condition.ExpressionStatement = "info.rating <= :val"; DeletingItem_async(moviesTable, 2018, "The Big New Movie", condition).Wait( ); if (!pause( ) || operationSucceeded) { return(1); } // 7b. Now increase the cutoff to 7.0 and try to delete again... Console.WriteLine(stepString, "7b", "Now increase the cutoff to 7.0 and try to delete the movie again..."); Console.WriteLine(" -- Now trying to delete the new movie again,\n" + " -- but this time on the condition that its rating is 7.0 or less..."); condition.ExpressionAttributeValues[":val"] = 7.0; DeletingItem_async(moviesTable, 2018, "The Big New Movie", condition).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 8. Query the Movies table in 3 different ways Search search; // 8a. Just query on the year Console.WriteLine(stepString, "8a", "Query the Movies table using a Search object for all movies from 1985"); Console.WriteLine(" -- First, create a Search object..."); try { search = moviesTable.Query(1985, new Expression( )); } catch (Exception ex) { Console.WriteLine(" ERROR: Failed to create the Search object because:\n " + ex.Message); pause( ); return(1); } Console.WriteLine(" -- Successfully created the Search object,\n" + " so now we'll display the movies retrieved by the query:"); if ((search == null) || !pause( )) { return(1); } SearchListing_async(search).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 8b. SearchListing_async Console.WriteLine(stepString, "8b", "Query for 1992 movies with titles from B... to Hzz... using Table.Query"); Console.WriteLine(" -- Now setting up a QueryOperationConfig for the 'Search'..."); QueryOperationConfig config = new QueryOperationConfig( ); config.Filter = new QueryFilter( ); config.Filter.AddCondition("year", QueryOperator.Equal, new DynamoDBEntry[] { 1992 }); config.Filter.AddCondition("title", QueryOperator.Between, new DynamoDBEntry[] { "B", "Hzz" }); config.AttributesToGet = new List <string> { "year", "title", "info" }; config.Select = SelectValues.SpecificAttributes; Console.WriteLine(" -- Creating the Search object based on the QueryOperationConfig"); try { search = moviesTable.Query(config); } catch (Exception ex) { Console.WriteLine(" ERROR: Failed to create the Search object because:\n " + ex.Message); if (!pause( ) || operationFailed) { return(1); } } Console.WriteLine(" -- Successfully created the Search object,\n" + " so now we'll display the movies retrieved by the query."); if ((search == null) || !pause( )) { return(1); } SearchListing_async(search).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 8c. Query using a QueryRequest Console.WriteLine(stepString, "8c", "Query the Movies table for 1992 movies with titles from M... to Tzz..."); Console.WriteLine(" -- Next use a low-level query to retrieve a selection of movie attributes"); QueryRequest qRequest = new QueryRequest { TableName = "Movies", ExpressionAttributeNames = new Dictionary <string, string> { { "#yr", "year" } }, ExpressionAttributeValues = new Dictionary <string, AttributeValue> { { ":qYr", new AttributeValue { N = "1992" } }, { ":tSt", new AttributeValue { S = "M" } }, { ":tEn", new AttributeValue { S = "Tzz" } } }, KeyConditionExpression = "#yr = :qYr and title between :tSt and :tEn", ProjectionExpression = "#yr, title, info.actors[0], info.genres, info.running_time_secs" }; Console.WriteLine(" -- Using a QueryRequest to get the lead actor and genres of\n" + " 1992 movies with titles between 'M...' and 'Tzz...'."); ClientQuerying_async(qRequest).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 9. Try scanning the movies table to retrieve movies from several decades // 9a. Use Table.Scan with a Search object and a ScanFilter to retrieve movies from the 1950s Console.WriteLine(stepString, "9a", "Scan the Movies table to retrieve all movies from the 1950's"); ScanFilter filter = new ScanFilter( ); filter.AddCondition("year", ScanOperator.Between, new DynamoDBEntry[] { 1950, 1959 }); ScanOperationConfig scanConfig = new ScanOperationConfig { Filter = filter }; Console.WriteLine(" -- Creating a Search object based on a ScanFilter"); try { search = moviesTable.Scan(scanConfig); } catch (Exception ex) { Console.WriteLine(" ERROR: Failed to create the Search object because:\n " + ex.Message); pause( ); return(1); } Console.WriteLine(" -- Successfully created the Search object"); if ((search == null) || !pause( )) { return(1); } SearchListing_async(search).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 9b. Use AmazonDynamoDBClient.Scan to retrieve movies from the 1960s Console.WriteLine(stepString, "9b", "Use a low-level scan to retrieve all movies from the 1960's"); Console.WriteLine(" -- Using a ScanRequest to get movies from between 1960 and 1969"); ScanRequest sRequest = new ScanRequest { TableName = "Movies", ExpressionAttributeNames = new Dictionary <string, string> { { "#yr", "year" } }, ExpressionAttributeValues = new Dictionary <string, AttributeValue> { { ":y_a", new AttributeValue { N = "1960" } }, { ":y_z", new AttributeValue { N = "1969" } }, }, FilterExpression = "#yr between :y_a and :y_z", ProjectionExpression = "#yr, title, info.actors[0], info.directors, info.running_time_secs" }; ClientScanning_async(sRequest).Wait( ); if (!pause( ) || operationFailed) { return(1); } // 10. Finally, delete the Movies table and all its contents Console.WriteLine(stepString, 10, "Finally, delete the Movies table and all its contents"); DeletingTable_async(movies_table_name).Wait( ); // End: Console.WriteLine( "\n=================================================================================" + "\n This concludes the DynamoDB Getting-Started demo program" + "\n=================================================================================" + "\n ...Press any key to exit"); Console.ReadKey( ); return(0); }
public virtual async Task <Entity> GetByIdAsync(long id) { return(await Table.Where(x => x.Id == id).FirstOrDefaultAsync()); }
public void ThenXDBPanelBodyTextContains(Table table) { var bodyText = table.Rows.Select(x => x.Values.First()); bodyText.All(t => CommonLocators.XDBpanelMediaBody.Any(x => x.GetAttribute("innerText").Contains(t))).Should().BeTrue(); }
public virtual async Task <List <Entity> > AllAsync() { return(await Table.ToListAsync()); }
public void GivenAUserRepositoryWithTheFollowingUsers(Table table) { var users = table.CreateSet <User>(); _driver.CreateUsers(users); }
public virtual async Task <Dto> SearchAsync <Dto>(string expression) { return(await Table.Where(expression).ProjectTo <Dto>(_mapper.ConfigurationProvider).FirstOrDefaultAsync()); }
public virtual async Task <List <Dto> > AllAsync <Dto>() { return(await Table.ProjectTo <Dto>(_mapper.ConfigurationProvider).ToListAsync()); }
public virtual async Task <Entity> SearchAsync(string expression) { return(await Table.Where(expression).FirstOrDefaultAsync()); }
public virtual async Task <List <Dto> > SearchAllAsync <Dto>(string expression) { return(await Table.Where(expression).ProjectTo <Dto>(_mapper.ConfigurationProvider).ToListAsync()); }