Beispiel #1
0
        public void ToIntTest()
        {
            const string SAMPLE_STRING = "fortythree";
            const string SAMPLE_NUMBER = "45";

            Assert.IsTrue(SmartConvert.ToInt(SAMPLE_NUMBER) == 45);
            Assert.IsFalse(SmartConvert.ToInt(SAMPLE_STRING) == 45);
        }
Beispiel #2
0
        public void ToIntTest_WithInvalidObject()
        {
            var actual = SmartConvert.ToInt("55.44.45");

            Assert.AreEqual(0, actual);

            actual = SmartConvert.ToInt("test 55.45.89");
            Assert.AreEqual(0, actual);
        }
Beispiel #3
0
        public void ToIntTest_WithMoreThanInteger()
        {
            var actual = SmartConvert.ToInt("559999999999999.458989894679");

            Assert.AreEqual(0, actual);

            actual = SmartConvert.ToInt("-5599999999999999.458989894679");
            Assert.AreEqual(0, actual);
        }
Beispiel #4
0
        public void ToIntTest_WithNullsAndEmpties()
        {
            var actual = SmartConvert.ToInt(null);

            Assert.AreEqual(0, actual);

            actual = SmartConvert.ToInt(DBNull.Value);
            Assert.AreEqual(0, actual);

            actual = SmartConvert.ToInt(string.Empty);
            Assert.AreEqual(0, actual);
        }
Beispiel #5
0
        public void ToIntTest_WithFloats()
        {
            var actual = SmartConvert.ToInt(55.4699);

            Assert.AreEqual(actual, 55);

            actual = SmartConvert.ToInt(55.6699);
            Assert.AreEqual(actual, 56);

            actual = SmartConvert.ToInt("55.6699");
            Assert.AreEqual(actual, 56);
        }
        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);
        }