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));
}
