string sSql = "select value,Denomination,TopupLevel,TopupActive,isNote,isCoin,MinFloat from kioskdenominations where machineid = @MachineID ";
hile (rdr.Read()) {
denominations d = new denominations();
if (rdr["Value"] != DBNull.Value) d.denomVal = Convert.ToInt16(rdr["Value"]);
if (rdr["Denomination"] != DBNull.Value) d.denomination = rdr["Denomination"].ToString();
if (rdr["TopupLevel"] != DBNull.Value) d.topuplevel = Convert.ToInt16(rdr["TopupLevel"]);
if (rdr["isNote"] != DBNull.Value) d.isNote = Convert.ToBoolean(rdr["isNote"]);
if (rdr["isCoin"] != DBNull.Value) d.isCoin = Convert.ToBoolean(rdr["isCoin"]);
d.topupActive = Convert.ToBoolean(rdr["TopupActive"]);
if (rdr["minFloat"] != DBNull.Value) d.minimum = Convert.ToInt16(rdr["minFloat"]);
_availdenoms.Add(d);
}
if (_availdenoms.Count > 0)
{
returnVal = true; // should always be at least one!
}
IApzdHJpbmcgc1NxbCA9ICJzZWxlY3QgdmFsdWUsRGVub21pbmF0aW9uLFRvcHVwTGV2ZWwsVG9wdXBBY3RpdmUsaXNOb3RlLGlzQ29pbixNaW5GbG9hdCBmcm9tIGtpb3NrZGVub21pbmF0aW9ucyB3aGVyZSBtYWNoaW5laWQgPSBATWFjaGluZUlEICI7CgogCiAKIGhpbGUgKHJkci5SZWFkKCkpIHsKIAlkZW5vbWluYXRpb25zIGQgPSBuZXcgZGVub21pbmF0aW9ucygpOwogCWlmIChyZHJbIlZhbHVlIl0gIT0gREJOdWxsLlZhbHVlKSBkLmRlbm9tVmFsID0gQ29udmVydC5Ub0ludDE2KHJkclsiVmFsdWUiXSk7CiAJaWYgKHJkclsiRGVub21pbmF0aW9uIl0gIT0gREJOdWxsLlZhbHVlKSBkLmRlbm9taW5hdGlvbiA9IHJkclsiRGVub21pbmF0aW9uIl0uVG9TdHJpbmcoKTsKIAlpZiAocmRyWyJUb3B1cExldmVsIl0gIT0gREJOdWxsLlZhbHVlKSBkLnRvcHVwbGV2ZWwgPSBDb252ZXJ0LlRvSW50MTYocmRyWyJUb3B1cExldmVsIl0pOwogCWlmIChyZHJbImlzTm90ZSJdICE9IERCTnVsbC5WYWx1ZSkgZC5pc05vdGUgPSBDb252ZXJ0LlRvQm9vbGVhbihyZHJbImlzTm90ZSJdKTsKIAlpZiAocmRyWyJpc0NvaW4iXSAhPSBEQk51bGwuVmFsdWUpIGQuaXNDb2luID0gQ29udmVydC5Ub0Jvb2xlYW4ocmRyWyJpc0NvaW4iXSk7CiAJZC50b3B1cEFjdGl2ZSA9IENvbnZlcnQuVG9Cb29sZWFuKHJkclsiVG9wdXBBY3RpdmUiXSk7CiAJaWYgKHJkclsibWluRmxvYXQiXSAhPSBEQk51bGwuVmFsdWUpIGQubWluaW11bSA9IENvbnZlcnQuVG9JbnQxNihyZHJbIm1pbkZsb2F0Il0pOwogCV9hdmFpbGRlbm9tcy5BZGQoZCk7CiB9CiAKIGlmIChfYXZhaWxkZW5vbXMuQ291bnQgPiAwKQp7CnJldHVyblZhbCA9IHRydWU7ICAgICAgICAvLyBzaG91bGQgYWx3YXlzIGJlIGF0IGxlYXN0IG9uZSEKfQ==