TinyMCE writer Image Upload for C# MVC

Just a quick code sample on how to plug an Image Upload into C# and MVC.  Since I searched all around the internet with no real easy example.

Put this somewhere on the page. This will be where the person adds the image.  As you can see, we will be posting the image to the “data-action” attribute.

  @Html.TextArea("Message", string.Empty, new
                           {
                               id = "wmd-input"
                           })
                            <div id="insertImageDialog" title="Insert Image">
                                <input type="file" name="file" id="file" data-action="/forum/postimageupload" />
                            </div>

Here is the Javascript. 

1. Below, you can see in the first block, I create another button for TinyMCE panel.  I call it the imageUpload.
2. I then add it to the Plugin Manager.
3. I then enable it in the plugins: options called imageUpload.
4. I create a Modal Dialog as I am using Jquery and the Jquery.UI library within my project.
5. Below that is the hook up for the Image Upload Modal.  As you can see I use the AjaxFileUpload by jquery.

$(function () {
        tinymce.create('tinymce.plugins.imageUpload', {
            createControl: function (n, cm) {
                switch (n) {
                    case 'imageupload':
                        var c = cm.createButton('mysplitbutton', {
                            title: 'Upload Image',
                            image: '@Url.Content("~/content/images/icons/imageUpload.png")',
                            onclick: function () {
                                $dialog.dialog('open');
                            }
                        });
                        return c;
                }
                return null;
            }
        });
        tinymce.PluginManager.add('imageIupload', tinymce.plugins.imageUpload);
        tinymce.init({
            mode: "textareas",
            elements: "elm2",
            theme: "advanced",
            skin: "o2k7",
            skin_variant: "silver",
            plugins: "imageIupload,safari,style,layer,table,advhr,advimage,advlink,inlinepopups,preview,media,contextmenu,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",

            theme_advanced_buttons1: "bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,|,bullist,numlist,|,outdent,indent,blockquote,|,formatselect,fontsizeselect",
            theme_advanced_buttons2: "link,unlink,anchor,image,imageupload,cleanup,code,|,preview,|,forecolor,backcolor,|tablecontrols,|,hr,removeformat,visualaid,|,iespell,media,|,ltr,rtl",
            theme_advanced_buttons3: "",
            theme_advanced_buttons4: "",
            theme_advanced_toolbar_location: "top",
            theme_advanced_toolbar_align: "left",
            theme_advanced_statusbar_location: "bottom",
            theme_advanced_resizing: true,
            language: "en",
            relative_urls: false
        });
        var $dialog = $('#insertImageDialog').dialog({
            autoOpen: true,
            closeOnEscape: false,
            modal: false,
            open: function (event, ui) {
                $(this).parent().css('position', 'fixed');
                $(".ui-dialog-titlebar-close").hide();
            }
        });
        var $loader = $('span.loading-small', $dialog);
        var $url = $('input[type=text]', $dialog);
        var $file = $('input[type=file]', $dialog);
        var dialogInsertClick = function () {
            dialogClose();
        };
        var dialogCancelClick = function () {
            dialogClose();
        };
        var dialogClose = function () {
            $url.val('');
            $file.val('');
            $dialog.dialog('close');
        };
        $dialog.dialog('option', 'buttons', {
            'Insert': dialogInsertClick,
            'Cancel': dialogCancelClick
        });
        var uploadStart = function () {
            $loader.show();
        };
        var uploadComplete = function (response) {
            $loader.hide();
            if (response.success) {
                tinyMCE.execCommand("mceInsertContent", false, "<img src='" + response.imagePath + "'/>");
                dialogClose();
            } else {
                alert(response.message);
                $file.val('');
            }
        };
        $file.unbind('change').ajaxfileupload({
            action: $file.attr('data-action'),
            onStart: uploadStart,
            onComplete: uploadComplete,
            'params': {
                'Id': '@Model.Id',
                'TopicId': '@Model.Id'
            },
        });
        $dialog.dialog('close');
    });

Here is the MVC Model Method.

As you can see from above, within the AjaxFileUpload, I am posting a C# Model.  Its called NewPost.  Below is the Model I am passing in.

    [HttpPost]
        public ActionResult PostImageUpload(NewPost model)
        {
            string result;
            var serializer = new JavaScriptSerializer();
            try
            {
                // upload the file
                if (model.File != null && model.File.ContentLength > 0)
                {
                   
                }
            }
            catch (Exception exception)
            {
                ErrorDatabaseManager.AddException(exception, exception.GetType());
            }
            result = serializer.Serialize(
                        new { success = false, message = "Invalid image file" });
            return Content(result);
        }

public HttpPostedFileBase File { get; set; }

Hope this little write up helps someone.

List of SMS Gateways

Xamarin iOS Problem and Fix with Visual Studio

I kept running into two error messages.  My iOS Hello world app wasn’t starting up.  Just a simple app after the host machine was synced and built. So kept looking for solutions until I found one here: http://forums.xamarin.com/discussion/5217/communication-issues-from-windows-8-to-mac-mini

Here are the two messages I was running into:

1. There was an error launching the application: iOS Simulator failed to install the application.
2. has exited with code 0 or has exited with code –1

The solution was of two parts.  I had to reset the iPhone Simulator and add the identifier information in.  Once done, it seemed to work the proper way.

On iOS

Click iPhone Simulator a the top title bar, then Reset Content and Settings.

Hope that helps for someone.

What Scares Me about the Tech Behind Healthcare.gov

We are all aware of the problems with the new roll out of the healthcare.gov website.  The large amount of JS files being sent back and forth, the slow down and the inability to sign up at most hours of the day.  But thats not what worries me.

What worries me is if this thing was so POORLY designed on the UI side, what do you think it look like on the back end side?  Do you actually think they offer encryption, data protection and have taken the time to implement industry standards to protect our most important information?

Seeing that the front end is soo poorly designed, I don't really have any faith in the back end.  This is what the news should be wondering, questioning and even guessing. 

What say you?  Do you believe they did good on the back end?

Please don't bring Politics into this.  Its a purely technical talk.

Get Parameter From Url with Javascript

function getParameterByName(name){
var match = (RegExp('[?&]' + name + '=([^&]*)').exec(window.location.search);
return match && decodeURIComponent(match[1].replace(/\+/g, ' '));
}

TimeZone Import List for MSSql

Placed here for reference.

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[TimeZone](
    [ZoneId] [int] IDENTITY(1,1) NOT NULL,
    [Location] [nvarchar](max) NULL,
    [GMT] [nvarchar](max) NULL,
    [GMTOffset] [int] NOT NULL,
    [Created] [datetime] NOT NULL,
    [LastModified] [datetime] NULL,
 CONSTRAINT [PK_TimeZone] PRIMARY KEY CLUSTERED 
(
    [ZoneId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

INSERT INTO TimeZone VALUES 
( 'International Date Line West', '(GMT-12:00)', -12,'10-4-2013', '10-4-2013'),
( 'Midway Island', '(GMT-11:00)', -11,'10-4-2013', '10-4-2013'),
( 'Samoa', '(GMT-11:00)', -11,'10-4-2013', '10-4-2013'),
( 'Hawaii', '(GMT-10:00)', -10,'10-4-2013', '10-4-2013'),
( 'Alaska', '(GMT-09:00)', -9,'10-4-2013', '10-4-2013'),
( 'Pacific Time (US & Canada)', '(GMT-08:00)', -8,'10-4-2013', '10-4-2013'),
( 'Tijuana', '(GMT-08:00)', -8,'10-4-2013', '10-4-2013'),
( 'Arizona', '(GMT-07:00)', -7,'10-4-2013', '10-4-2013'),
( 'Mountain Time (US & Canada)', '(GMT-07:00)', -7,'10-4-2013', '10-4-2013'),
( 'Chihuahua', '(GMT-07:00)', -7,'10-4-2013', '10-4-2013'),
( 'La Paz', '(GMT-07:00)', -7,'10-4-2013', '10-4-2013'),
( 'Mazatlan', '(GMT-07:00)', -7,'10-4-2013', '10-4-2013'),
( 'Central Time (US & Canada)', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Central America', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Guadalajara', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Mexico City', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Monterrey', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Saskatchewan', '(GMT-06:00)', -6,'10-4-2013', '10-4-2013'),
( 'Eastern Time (US & Canada)', '(GMT-05:00)', -5,'10-4-2013', '10-4-2013'),
( 'Indiana (East)', '(GMT-05:00)', -5,'10-4-2013', '10-4-2013'),
( 'Bogota', '(GMT-05:00)', -5,'10-4-2013', '10-4-2013'),
( 'Lima', '(GMT-05:00)', -5,'10-4-2013', '10-4-2013'),
( 'Quito', '(GMT-05:00)', -5,'10-4-2013', '10-4-2013'),
( 'Atlantic Time (Canada)', '(GMT-04:00)', -4,'10-4-2013', '10-4-2013'),
( 'Caracas', '(GMT-04:00)', -4,'10-4-2013', '10-4-2013'),
( 'La Paz', '(GMT-04:00)', -4,'10-4-2013', '10-4-2013'),
( 'Santiago', '(GMT-04:00)', -4,'10-4-2013', '10-4-2013'),
( 'Newfoundland', '(GMT-03:30)', -3,'10-4-2013', '10-4-2013'),
( 'Brasilia', '(GMT-03:00)', -3,'10-4-2013', '10-4-2013'),
( 'Buenos Aires', '(GMT-03:00)', -3,'10-4-2013', '10-4-2013'),
( 'Georgetown', '(GMT-03:00)', -3,'10-4-2013', '10-4-2013'),
( 'Greenland', '(GMT-03:00)', -3,'10-4-2013', '10-4-2013'),
( 'Mid-Atlantic', '(GMT-02:00)', -2,'10-4-2013', '10-4-2013'),
( 'Azores', '(GMT-01:00)', -1,'10-4-2013', '10-4-2013'),
( 'Cape Verde Is.', '(GMT-01:00)', -1,'10-4-2013', '10-4-2013'),
( 'Casablanca', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'Dublin', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'Edinburgh', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'Lisbon', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'London', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'Monrovia', '(GMT)', 0,'10-4-2013', '10-4-2013'),
( 'Amsterdam', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Belgrade', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Berlin', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Bern', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Bratislava', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Brussels', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Budapest', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Copenhagen', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Ljubljana', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Madrid', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Paris', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Prague', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Rome', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Sarajevo', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Skopje', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Stockholm', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Vienna', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Warsaw', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'West Central Africa', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Zagreb', '(GMT+01:00)', 1,'10-4-2013', '10-4-2013'),
( 'Athens', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Bucharest', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Cairo', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Harare', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Helsinki', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Istanbul', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Jerusalem', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Kyev', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Minsk', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Pretoria', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Riga', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Sofia', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Tallinn', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Vilnius', '(GMT+02:00)', 2,'10-4-2013', '10-4-2013'),
( 'Baghdad', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Kuwait', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Moscow', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Nairobi', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Riyadh', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'St. Petersburg', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Volgograd', '(GMT+03:00)', 3,'10-4-2013', '10-4-2013'),
( 'Tehran', '(GMT+03:30)', 3,'10-4-2013', '10-4-2013'),
( 'Abu Dhabi', '(GMT+04:00)', 4,'10-4-2013', '10-4-2013'),
( 'Baku', '(GMT+04:00)', 4,'10-4-2013', '10-4-2013'),
( 'Muscat', '(GMT+04:00)', 4,'10-4-2013', '10-4-2013'),
( 'Tbilisi', '(GMT+04:00)', 4,'10-4-2013', '10-4-2013'),
( 'Yerevan', '(GMT+04:00)', 4,'10-4-2013', '10-4-2013'),
( 'Kabul', '(GMT+04:30)', 4,'10-4-2013', '10-4-2013'),
( 'Ekaterinburg', '(GMT+05:00)', 5,'10-4-2013', '10-4-2013'),
( 'Islamabad', '(GMT+05:00)', 5,'10-4-2013', '10-4-2013'),
( 'Karachi', '(GMT+05:00)', 5,'10-4-2013', '10-4-2013'),
( 'Tashkent', '(GMT+05:00)', 5,'10-4-2013', '10-4-2013'),
( 'Chennai', '(GMT+05:30)', 5,'10-4-2013', '10-4-2013'),
( 'Kolkata', '(GMT+05:30)', 5,'10-4-2013', '10-4-2013'),
( 'Mumbai', '(GMT+05:30)', 5,'10-4-2013', '10-4-2013'),
( 'New Delhi', '(GMT+05:30)', 5,'10-4-2013', '10-4-2013'),
( 'Kathmandu', '(GMT+05:45)', 5,'10-4-2013', '10-4-2013'),
( 'Almaty', '(GMT+06:00)', 6,'10-4-2013', '10-4-2013'),
( 'Astana', '(GMT+06:00)', 6,'10-4-2013', '10-4-2013'),
( 'Dhaka', '(GMT+06:00)', 6,'10-4-2013', '10-4-2013'),
( 'Novosibirsk', '(GMT+06:00)', 6,'10-4-2013', '10-4-2013'),
( 'Sri Jayawardenepura', '(GMT+06:00)', 6,'10-4-2013', '10-4-2013'),
( 'Rangoon', '(GMT+06:30)', 6,'10-4-2013', '10-4-2013'),
( 'Bangkok', '(GMT+07:00)', 7,'10-4-2013', '10-4-2013'),
( 'Hanoi', '(GMT+07:00)', 7,'10-4-2013', '10-4-2013'),
( 'Jakarta', '(GMT+07:00)', 7,'10-4-2013', '10-4-2013'),
( 'Krasnoyarsk', '(GMT+07:00)', 7,'10-4-2013', '10-4-2013'),
( 'Beijing', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Chongqing', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Hong Kong', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Irkutsk', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Kuala Lumpur', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Perth', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Singapore', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Taipei', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Ulaan Bataar', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Urumqi', '(GMT+08:00)', 8,'10-4-2013', '10-4-2013'),
( 'Osaka', '(GMT+09:00)', 9,'10-4-2013', '10-4-2013'),
( 'Sapporo', '(GMT+09:00)', 9,'10-4-2013', '10-4-2013'),
( 'Seoul', '(GMT+09:00)', 9,'10-4-2013', '10-4-2013'),
( 'Tokyo', '(GMT+09:00)', 9,'10-4-2013', '10-4-2013'),
( 'Yakutsk', '(GMT+09:00)', 9,'10-4-2013', '10-4-2013'),
( 'Adelaide', '(GMT+09:30)', 9,'10-4-2013', '10-4-2013'),
( 'Darwin', '(GMT+09:30)', 9,'10-4-2013', '10-4-2013'),
( 'Brisbane', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Canberra', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Guam', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Hobart', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Melbourne', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Port Moresby', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Sydney', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Vladivostok', '(GMT+10:00)', 10,'10-4-2013', '10-4-2013'),
( 'Magadan', '(GMT+11:00)', 11,'10-4-2013', '10-4-2013'),
( 'New Caledonia', '(GMT+11:00)', 11,'10-4-2013', '10-4-2013'),
( 'Solomon Is.', '(GMT+11:00)', 11,'10-4-2013', '10-4-2013'),
( 'Auckland', '(GMT+12:00)', 12,'10-4-2013', '10-4-2013'),
( 'Fiji', '(GMT+12:00)', 12,'10-4-2013', '10-4-2013'),
( 'Kamchatka', '(GMT+12:00)', 12,'10-4-2013', '10-4-2013'),
( 'Marshall Is.', '(GMT+12:00)', 12,'10-4-2013', '10-4-2013'),
( 'Wellington', '(GMT+12:00)', 12,'10-4-2013', '10-4-2013'),
( 'Nuku''alofa', '(GMT+13:00)', 13,'10-4-2013', '10-4-2013');

Getting Attacked by 207.210.85.102

My small software startup is being attacked right now by 207.210.85.102 using SQL Injection.  We run a small ecommerce site along with a very large Sports Portal.  They are using attacks within our variables such as

?category=31111111111111"+UNION+SELECT+CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81,45),CHAR(45,120,52,45,81,45),CHAR(45,120,53,45,81,45),CHAR(45,120,54,45,81,45),CHAR(45,120,55,45,81,45),CHAR(45,120,56,45,81,45),CHAR(45,120,57,45,81,45)+--+/*+order+by+"as+/*

?category=31111111111111'+UNION+SELECT+CHAR(45,120,49,45,81,45),CHAR(45,120,50,45,81,45),CHAR(45,120,51,45,81,45),CHAR(45,120,52,45,81,45),CHAR(45,120,53,45,81,45),CHAR(45,120,54,45,81,45),CHAR(45,120,55,45,81,45),CHAR(45,120,56,45,81,45),CHAR(45,120,57,45,81,45),CHAR(45,120,49,48,45,81,45),CHAR(45,120,49,49,45,81,45),CHAR(45,120,49,50,45,81,45),CHAR(45,120,49,51,45,81,45),CHAR(45,120,49,52,45,81,45),CHAR(45,120,49,53,45,81,45),CHAR(45,120,49,54,45,81,45),CHAR(45,120,49,55,45,81,45),CHAR(45,120,49,56,45,81,45),CHAR(45,120,49,57,45,81,45),CHAR(45,120,50,48,45,81,45),CHAR(45,120,50,49,45,81,45),CHAR(45,120,50,50,45,81,45),CHAR(45,120,50,51,45,81,45),CHAR(45,120,50,52,45,81,45)+--+/*+order+by+'as+/*

Small Google Calendar Class To Add Events

I created a small C# class to add Google calendar events to a calendar in C#.  It is quite simple, but I didn’t find it searching the internet, so here it is.  Its dead simple.

 public class GoogleCalendar
    {

        private static string GoogleUrl = "http://www.google.com/calendar/event?action=TEMPLATE";
        public string What { get; set; }
        public DateTime StartDate { get; set; }
        public DateTime EndDate { get; set; }
        public string Description { get; set; }
        public string Location { get; set; }
        public string WebsiteName { get; set; }
        public string Website { get; set; }

        public string GetGoogleUrl()
        {
            //20130918T103000Z
            return GoogleUrl + "&text=" + What + "&dates=" + StartDate.ToString("yyyyMMddTHHmmssZ") + "/" + EndDate.ToString("yyyyMMddTHHmmssZ") + "&details=" + Description + "&location=" + Location + "&trp=false" + "&sprop=" + WebsiteName + "&sprop=name:" + Website;
        }
    }

Convert Meters To Miles C#

 public static double ConvertMetersToMiles(double meters)
    {
        return (meters / 1609.344);
    }

So there I was, Searching for an obscure Email Address...

So there I was searching for an obscure email address....

And there I found a CRAZY Facebook URL....

https://www.wwww.wwww.wwww.wwww.wwww.0.facebook.com/rdnation

What is that you say?  Well I have NO idea.  

Why not you tell me?  Why does Facebook need soo many subdomains?