Dee Dubs – Page 5 – Application Development Cloud

Custom Stationary Designs

Here is a design for a Custom Letterhead and envelope. There is also a business card front and back.

3D Metaverse Script, Sculpt, Model and Design

I have a wide variety of Metaverse scripting skills, as well as 3D sculpting, modeling and design. Please check out the samples.

I have certifications in 3D sculpting, modeling and animation using 3D Studio Max. I also have skills using Unity, Blender, True Space 3D, Maya, Poser and Bryce

Clothing Design

For my final project in Adobe Illustrator class, I decided to show off my creative side, and design some clothes. I look forward to designing and releasing a line someday.

Upgrading a Website from Legacy to Web 2.0

The IT team that is quietly powering the entire Skagit Valley College information infrastructure is a talented team of Technology Specialists. This diverse group of enthusiastic developers has helped redefine the way technology is used and have dramatically impacted the future of web development. We were laughing about how small the website looked in the screens of the new large monitors. I mentioned hearing about a flexible website layout that would allow to better use the screen space. My leaders asked me to put together some information about the subject.

I began with the initial research of web frameworks and responsive web technology, and then I presented my findings to the web team. From there we decided to go with a responsive web site rather than creating a separate mobile site. The technology that we have put in to place can now detect a user’s screen size, and then “respond” by changing the web page to best fit the user’s devices from PC to smart TV to iPhones and beyond.

The previous site was built at a fixed size for the monitors of the day.

The new design looked great on desktop computers as well as mobile devices.

SVC website in responsive mode on mobile device

Favicon Generator

This is an awesome resource to create the various Icons for your project. From the browser “Favicon” to the home screens of windows, Android and Apple devices, this will create the perfect sizes and filetypes.

https://realfavicongenerator.net/

Use variables from the web config C# Visual Studio

We create a helper class to use. This will return a variable that is set to the correct type. Credits to Steam Webhosting!

 public static class AppSettingsHelper
    {
        public static T GetValue<T>(string key, T defaultValue)
        {
            var value = ConfigurationManager.AppSettings[key];

            if (string.IsNullOrEmpty(value))
                return defaultValue;

            return (T)Convert.ChangeType(value, typeof(T));
        }
    }

We use the helper function to get the value and set the types of the variables.

        // debug / test settings
        static readonly bool testmode       = AppSettingsHelper.GetValue<bool>("TestMode", false); // toggle test mode
        static readonly bool disableupload  = AppSettingsHelper.GetValue<bool>("DisableUpload", false); // disables the upload to server if true

        // sftp settings
        static readonly int port            = AppSettingsHelper.GetValue<int>("SFTPPort", 22);
        static readonly string host         = AppSettingsHelper.GetValue<string>("SFTPHost", "feeds.dwdenney.com");

Skagit Valley College Educational Planning Tool

Faculty and students needed a way to plan out the degree path of a student. The faculty and counselors needed to be able to track the student’s progress over the time they are attending SVC.

My role in this project was to create a responsive modern view to allow the faculty or student to create a “Degree Plan” using live data from our catalog of classes and student records.

Integrated student and class data from legacy systems using a custom built api to convert the data between modern display style and the legacy storage style.

Needed to overcome obstacles related to the formatting of the legacy data such as converting dates and times into human readable text. Also creating conversion algorithms to deal with displaying legible content instead of the codes that the data is stored in.

allow the faculty counselor and mentors to track the student progress over the life of the plan.

SQL Select with variable and IF statement

Sometimes I need to select from sql based on criteria from another query. In certain situations, you can use the server side scripting to manipulate and call queries, but other times for performance, the best way is to have SQL server handle the workload.

I can declare a variable and set it from one query, and use it in another. For example, I want to check if there are only one record for an RID code passed in as a parameter, and then update the record if so:

declare @RecordCount int

    set @RecordCount = (select  count(*) FROM [My].[dbo].[Table]  where RID= @RID)

IF @RecordCount == 1
UPDATE [My].[dbo].[Table] SET myBitField= 1 WHERE RecordId= @RecordId

Compare alphanumeric strings for greater/less than equality C#

I have some alphanumeric strings to compare. I need to know if A1234 is before B5678 when sorted alphanumerically. I also want to ignore the case of the alphabetic characters.

int comparison = String.Compare(A1234, B5678, comparisonType: StringComparison.OrdinalIgnoreCase);

The integer returned will be -1 if lower in order, 0 if equal and 1 if greater.

Split a comma delimited string into an array in C#

The ability to split a string is a common feature in programming. The way to implement this in c# is a bit different than most languages.

We have a string such as:

string myVars = “var1, var2, var3, var4”;

We need to split this string into an array of individual variables. That’s where our String.Split() method comes into play. Its pretty easy once you know the syntax. The Microsoft docs don’t mention this way:

string[] myArray = myVars.Split(‘,’);

The key is the single quotes around your delimiter in the split method.