public User ConvertToModel(SqlDataReader dataReader)
        {
            User user = new User();

            user.SetUserId(dataReader.GetGuid(dataReader.GetOrdinal("Id")));
            user.SetMedicalPersonnelId(dataReader.GetGuid(dataReader.GetOrdinal("MedicalPersonnelId")));
            user.SetPassword(dataReader.GetString(dataReader.GetOrdinal("Password")));
            user.username = dataReader.GetString(dataReader.GetOrdinal("Username"));

            return(user);
        }