public void ToBoolean_WhenTrue_ReturnsTrue() { const string SAMPLE_STRING = "first"; const int SAMPLE_NUMBER = 45; Assert.IsTrue(SmartConvert.ToBool(SAMPLE_NUMBER == 45)); Assert.IsTrue(SmartConvert.ToBool(SAMPLE_STRING == "first")); Assert.IsTrue(SmartConvert.ToBool(1)); Assert.IsTrue(SmartConvert.ToBool(new SqlInt32(1))); Assert.IsTrue(SmartConvert.ToBool(true)); Assert.IsTrue(SmartConvert.ToBool("true")); Assert.IsTrue(SmartConvert.ToBool("TRUE")); }
public void ToBoolean_WhenFalsy_ReturnsFalse() { const string SAMPLE_STRING = "first"; const int SAMPLE_NUMBER = 45; Assert.IsFalse(SmartConvert.ToBool('#')); Assert.IsFalse(SmartConvert.ToBool(Double.NaN)); Assert.IsFalse(SmartConvert.ToBool(Double.PositiveInfinity)); Assert.IsFalse(SmartConvert.ToBool(SAMPLE_STRING == "second")); Assert.IsFalse(SmartConvert.ToBool(SAMPLE_NUMBER == 55)); Assert.IsFalse(SmartConvert.ToBool(0)); Assert.IsFalse(SmartConvert.ToBool(null)); Assert.IsFalse(SmartConvert.ToBool(DBNull.Value)); Assert.IsFalse(SmartConvert.ToBool(false)); Assert.IsFalse(SmartConvert.ToBool("false")); Assert.IsFalse(SmartConvert.ToBool("FALSE")); }
public IList <MemberDiagnosisDto> GetMemberDiagnosis(int memberId) { var resultSet = new List <MemberDiagnosisDto>(); using (connection) { using (IDbCommand cmd = new SqlCommand(GET_MEMBER_DIAGNOSIS_AND_SEVERITY_COMMAND)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = connection; cmd.Parameters.Add(new SqlParameter("@MemberId", memberId)); try { connection.Open(); var reader = cmd.ExecuteReader(); while (reader.Read()) { var diagnosis = new MemberDiagnosisDto { MemberId = SmartConvert.ToInt(reader["MemberID"]), FirstName = reader["FirstName"].ToString(), LastName = reader["LastName"].ToString(), MostSevereDiagnosisId = SmartConvert.ToNullableInt(reader["MostSevereDiagnosisID"]), MostSevereDiagnosisDescription = reader["MostSevereDiagnosisDescription"].ToString(), DiagnosisCategoryId = SmartConvert.ToInt(reader["CategoryID"]), DiagnosisCategoryDescription = reader["CategoryDescription"].ToString(), DiagnosisCategoryScore = SmartConvert.ToInt(reader["CategoryScore"]), IsMostSevere = SmartConvert.ToBool(reader["IsMostSevere"]) }; resultSet.Add(diagnosis); } } catch (Exception ex) { connection.Close(); throw; } } } return(resultSet); }