public void Get_Indexed_ReturnsExpectedValue() { var dataRecord = Substitute.For <IDataRecord>(); var sut = new Record(dataRecord); var @bool = true; byte @byte = 4; var @char = '\t'; var reader = Substitute.For <IDataReader>(); var datatypeName = "dtn"; var time = DateTime.UtcNow; var dec = 2.4m; var dbl = 5.33d; var type = typeof(IProduct); var flt = 2.44f; var guid = Guid.NewGuid(); short @short = 21; var @int = 76; var @long = 84; var name = "n"; var str = "s"; var obj = new object(); dataRecord.GetBoolean(Index).Returns(@bool); dataRecord.GetByte(Index).Returns(@byte); dataRecord.GetChar(Index).Returns(@char); dataRecord.GetData(Index).Returns(reader); dataRecord.GetDataTypeName(Index).Returns(datatypeName); dataRecord.GetDateTime(Index).Returns(time); dataRecord.GetDecimal(Index).Returns(dec); dataRecord.GetDouble(Index).Returns(dbl); dataRecord.GetFieldType(Index).Returns(type); dataRecord.GetFloat(Index).Returns(flt); dataRecord.GetGuid(Index).Returns(guid); dataRecord.GetInt16(Index).Returns(@short); dataRecord.GetInt32(Index).Returns(@int); dataRecord.GetInt64(Index).Returns(@long); dataRecord.GetName(Index).Returns(name); dataRecord.GetString(Index).Returns(str); dataRecord.GetValue(Index).Returns(obj); dataRecord[Index].Returns(obj); Assert.AreEqual(@bool, sut.GetBoolean(Index)); Assert.AreEqual(@byte, sut.GetByte(Index)); Assert.AreEqual(@char, sut.GetChar(Index)); Assert.AreEqual(reader, sut.GetData(Index)); Assert.AreEqual(datatypeName, sut.GetDataTypeName(Index)); Assert.AreEqual(time, sut.GetDateTime(Index)); Assert.AreEqual(dec, sut.GetDecimal(Index)); Assert.AreEqual(dbl, sut.GetDouble(Index)); Assert.AreEqual(type, sut.GetFieldType(Index)); Assert.AreEqual(flt, sut.GetFloat(Index)); Assert.AreEqual(guid, sut.GetGuid(Index)); Assert.AreEqual(@short, sut.GetInt16(Index)); Assert.AreEqual(@int, sut.GetInt32(Index)); Assert.AreEqual(@long, sut.GetInt64(Index)); Assert.AreEqual(name, sut.GetName(Index)); Assert.AreEqual(obj, sut.GetValue(Index)); Assert.AreEqual(str, sut.GetString(Index)); Assert.AreEqual(obj, sut[Index]); }
public void Get_Named_ReturnsExpectedValue() { var dataRecord = Substitute.For <IDataRecord>(); var sut = new Record(dataRecord); dataRecord.GetOrdinal(Name).Returns(Index); var @bool = true; var time = DateTime.UtcNow; var dec = 2.4m; var dbl = 5.33d; var flt = 2.44f; var guid = Guid.NewGuid(); short @short = 21; var @int = 76; var @long = 84; var str = "s"; var obj = new object(); var ordinal = 3; dataRecord.GetBoolean(Index).Returns(@bool); dataRecord.GetDateTime(Index).Returns(time); dataRecord.GetDecimal(Index).Returns(dec); dataRecord.GetDouble(Index).Returns(dbl); dataRecord.GetFloat(Index).Returns(flt); dataRecord.GetGuid(Index).Returns(guid); dataRecord.GetInt16(Index).Returns(@short); dataRecord.GetInt32(Index).Returns(@int); dataRecord.GetInt64(Index).Returns(@long); dataRecord.GetOrdinal("ord").Returns(ordinal); dataRecord.GetString(Index).Returns(str); dataRecord.GetValue(Index).Returns(obj); dataRecord[Name].Returns(obj); Assert.AreEqual(@bool, sut.GetBoolean(Name)); Assert.AreEqual(time, sut.GetDateTime(Name)); Assert.AreEqual(dec, sut.GetDecimal(Name)); Assert.AreEqual(dbl, sut.GetDouble(Name)); Assert.AreEqual(flt, sut.GetFloat(Name)); Assert.AreEqual(guid, sut.GetGuid(Name)); Assert.AreEqual(@short, sut.GetInt16(Name)); Assert.AreEqual(@int, sut.GetInt32(Name)); Assert.AreEqual(@long, sut.GetInt64(Name)); Assert.AreEqual(ordinal, sut.GetOrdinal("ord")); Assert.AreEqual(str, sut.GetString(Name)); Assert.AreEqual(obj, sut.GetValue(Name)); Assert.AreEqual(obj, sut[Name]); }
User ToSession(Record r) { var user = new User(); user.Id = r.GetInt("id"); user.SessionId = r.GetString("sessionId"); user.Name = r.GetString("name"); user.IdAdmin = r.GetInt("idAdmin"); user.IdSuperAdmin = r.GetInt("idSuperAdmin"); user.IdCustomer = r.GetInt("idCustomer"); var tenant = LoadTenant(r.GetString("tenant")); user.Tenant = tenant; user.Culture = GetCulture(r.GetString("culture"), tenant); user.TimeZone = GetTimeZone(tenant); user.CreateDate = r.GetDateTime("createdate"); var items = r.GetString("items"); user.Items = !string.IsNullOrEmpty(items) ? Json.Deserialize<Map>(items) : new Map(); return user; }