public static Roomdata FromDbDataRecord(DbDataRecord record) { Roomdata r = new Roomdata(record.GetString(COL_ROOM)); r.LastMessageDt = SqlDatabase.StringOrNull(record, COL_LASTMESSAGEDT); r.Subject = SqlDatabase.StringOrNull(record, COL_SUBJECT); r.DoJoin = (JoinMode)record.GetInt32(COL_DO_JOIN); r.DisplayName = SqlDatabase.StringOrNull(record, COL_DISPLAY_NAME); r.LastSeenDt = SqlDatabase.StringOrNull(record, COL_LASTSEENDT); r.Notify = (NotifyMode)record.GetInt32(COL_NOTIFY); r.DisplayPosition = record.GetInt32(COL_DISPLAY_POSITION); return(r); }
//Assuming at least one CreditCard PaymentMethod has been created using the Orders UI public Guid GetPaymentMethodID() { Guid creditCardPaymentMethodId = Guid.Empty; Boolean ccPmtMethodFound = false; //Get all PaymentMethods DataSet pmtMethods = orderCtx.GetPaymentMethods(); DataTableReader reader = pmtMethods.CreateDataReader(); IEnumerator readerEnum = reader.GetEnumerator(); while (readerEnum.MoveNext() && !ccPmtMethodFound) { DbDataRecord rec = (DbDataRecord)readerEnum.Current; switch (rec.GetInt32(rec.GetOrdinal("PaymentType"))) { case (int)PaymentMethodTypes.CreditCard: creditCardPaymentMethodId = rec.GetGuid(rec.GetOrdinal("PaymentMethodId")); ccPmtMethodFound = true; break; } } if (Guid.Empty == creditCardPaymentMethodId) { throw new ApplicationException("This demo requires at least one CreditCard type of PaymentMethod to be defined!"); } return(creditCardPaymentMethodId); }
public static int GetInt32(this DbDataRecord dr, string columnName) { Check.ArgNotNull(dr, nameof(dr)); int ordinal = dr.GetOrdinal(columnName); return(dr.GetInt32(ordinal)); }
public static Int32 Int32OrDefault(DbDataRecord reader, int column, int defValue = 0) { if (reader.IsDBNull(column)) { return(defValue); } else { return(reader.GetInt32(column)); } }
public Film ConvertRecordToFilm(DbDataRecord rec) { if (rec == null || rec.FieldCount < filmRecFieldCount) { return(null); } var film = new Film { Id = rec.GetInt32((int)FilmColumns.Id), Picture = GetImageFromDbRec(rec.GetString((int)FilmColumns.Picture)), Name = rec.GetString((int)FilmColumns.Name), Country = rec.GetString((int)FilmColumns.Country), Year = rec.GetInt32((int)FilmColumns.Year), Producer = new Producer(rec.GetString((int)FilmColumns.Producer)), MainActors = new List <Actor>() }; return(film); }
public ActorToFilm ConvertRecordToActorToFilm(DbDataRecord rec) { if (rec == null || rec.FieldCount < actorToFilmFieldCount) { return(null); } var actorToFilm = new ActorToFilm { FilmId = rec.GetInt32((int)ActorToFilmColumn.FilmId), Actor = new Actor(rec.GetString((int)ActorToFilmColumn.ActorName)) }; return(actorToFilm); }
public void GetEnumeratorTest() { this.fixture.ExecuteCommand(command => { command.CommandText = "SELECT * FROM ORDERS"; using (var reader = command.ExecuteReader()) { IEnumerator enumerator = reader.GetEnumerator(); while (enumerator.MoveNext()) { DbDataRecord record = (DbDataRecord)enumerator.Current; Assert.Equal(reader.FieldCount, record.FieldCount); Assert.Equal(reader.GetInt32(0), record.GetInt32(0)); Assert.Equal(reader.GetString(1), record.GetString(1)); Assert.Equal(reader.GetInt32(2), record.GetInt32(2)); Assert.Equal(reader.GetDateTime(3), record.GetDateTime(3)); Assert.Equal(reader.GetDateTime(4), record.GetDateTime(4)); Assert.Equal(reader.GetValue(5), record.GetValue(5)); Assert.Equal(reader.GetInt32(6), record.GetInt32(6)); Assert.Equal(reader.GetDecimal(7), record.GetDecimal(7)); reader.Read(); } } }); }
//Entity Provider private static void PrintEntityResults(DbConnection conn, DbCommand cmd, string commandText) { cmd.CommandType = CommandType.Text; cmd.CommandText = commandText; if (conn.State == ConnectionState.Closed) { conn.Open(); } var dr = cmd.ExecuteReader(CommandBehavior.SequentialAccess); while (dr.Read()) { DbDataRecord record = (DbDataRecord)dr[0]; Console.WriteLine(record.GetInt32(0) + ": " + record.GetString(1)); } }
public void EnumeratorTest () { DataTable table = new DataTable (); table.Columns.Add ("col1", typeof(int)); table.Rows.Add (new object[] {0}); table.Rows.Add (new object[] {1}); DataTableReader rdr = table.CreateDataReader (); IEnumerator enmr = rdr.GetEnumerator (); table.Rows.Add (new object[] {2}); table.Rows.RemoveAt (0); //Test if the Enumerator is stable int i = 1; while (enmr.MoveNext ()) { DbDataRecord rec = (DbDataRecord)enmr.Current; Assert.AreEqual (i, rec.GetInt32 (0), "#2_" + i); i++; } }
private void SearchByOther() { listRooms = DataLayer.GetAllRooms(); decimal minCost, maxCost; if (decimal.TryParse(txbxMinCost.Text, out minCost)) { for (int i = 0; i < listRooms.Count; i++) { DbDataRecord room = listRooms[i] as DbDataRecord; if (room.GetDecimal(6) < minCost) { listRooms.Remove(room); i--; } } } if (decimal.TryParse(txbxMaxCost.Text, out maxCost)) { for (int i = 0; i < listRooms.Count; i++) { DbDataRecord room = listRooms[i] as DbDataRecord; if (room.GetDecimal(6) > maxCost) { listRooms.Remove(room); i--; } } } if (chbxNumberOfRooms.SelectedItem != null) { for (int i = 0; i < listRooms.Count; i++) { DbDataRecord room = listRooms[i] as DbDataRecord; if (room.GetInt32(5) != (chbxNumberOfRooms.SelectedItem as DbDataRecord).GetInt32(3)) { listRooms.Remove(room); i--; } } } if (chbxNumberOfSeats.SelectedItem != null) { for (int i = 0; i < listRooms.Count; i++) { DbDataRecord room = listRooms[i] as DbDataRecord; if (room.GetInt32(4) != (chbxNumberOfSeats.SelectedItem as DbDataRecord).GetInt32(2)) { listRooms.Remove(room); i--; } } } lsbxCategories.SelectedItem = -1; dgRooms.ItemsSource = listRooms; }
/// <summary> /// GetNullSafeInt32() - Checks the Int32 column to be accessed and if it is DBNull, /// 0 will be returned. /// </summary> /// <param name="rec">Database Record</param> /// <param name="colIndex">Column Index</param> /// <returns>Actual DateTime or MinValue (if null)</returns> public int GetNullSafeInt32(DbDataRecord rec, int colIndex) { return(rec.IsDBNull(colIndex) ? 0 : rec.GetInt32(colIndex)); }