Monday, May 7, 2012

C# Escaping Generic Objects for SQL Server

In response to a need to escape various fields within any given class object, I worked up this guy. Essentially, iterates through all members of a given object and replaces single quotes with doubles on any String object. private static void SQLServerEscapeObject(object obj) { foreach (System.Reflection.PropertyInfo property in obj.GetType().GetProperties()) { try { if (property.PropertyType.FullName == "System.String" && property.GetValue(obj, null) != null) { property.SetValue(obj, property.GetValue(obj, null).ToString().Replace("'", "''"), null); } } catch (Exception e) { Logger.Log("Issue clensing SQL query: " + e.Message, Logger.Loglevel.Warning); } } return; }

Wednesday, August 3, 2011

Exchange web-services

Actual code to come later one.
in short, thanking

for assistance in making Calendar update requests.

Wednesday, January 12, 2011

Project Server 2010 PSI - CustomFields

Here is a method that will add a CustomFieldRow to a ProjectDataSet for use in ProjectServer 2010 through the PSI.

Here are the support calls to get the necessary GUID's.


Sunday, October 24, 2010

Rails routes, respond_to and more

As pulled from:

I've used respond_to previously...but it slipped my i figured I'd repost it here.

Here is the snippit that replaced a separate (and now useless method) for each major entry view page.

respond_to do |format|
format.js { render :partial => 'list.html.erb' }

Tuesday, February 23, 2010

Flot - jQuery Graphing

Here is one use of Flot in an app I'm working on:


Some ruby to fill in the data/ticks variables:

and that's about it. Some tweaking to clean things up, but I now have a nice weight over time graph with appropriate BMI ranges coloring the background.

Friday, February 19, 2010

Remove .svn folders from a project (bash)

Many thanks to for this one:

If you want remove all your .svn directories from a project run this:

find . -name ".svn" -exec rm -rf {} \; 

Thursday, February 18, 2010

jQueryUI - datepicker on multiple elements by class

I was having some difficulties in placing numerous datepickers on the same form as I'd have to assign ids in my code...I didn't want to do that.
So i made jQuery assign the ID's for me. Loop through each..assign an ID...voila I now have fully functional datepickers on each element as designated by the 'datefield' class.

some jQuery for which I should be ashamed..

This beauty is for a wellness app that I'm working on (in Rails). What makes me proud (ashamed) is my use of 'var that = this'. I saw this somewhere..and couldn't help but laugh..and keep up the fun.

/* Click Event for Goal Completion */ $(".goal_link a").click(function(){ var that = this; $.ajax({ type: "PUT", url: $(this).attr("href"), data: "authenticity_token=#{form_authenticity_token}", success: function(msg){ $(that).parent().parent().parent().parent().parent().hide("slow"); }, error: function(req, status, error){ $("#user_goals_messages").html("We're sorry, but there was a problem updating this goal"); } }); return false; });

This bind event simply performs an ajax call (which would otherwise be sent normally) to mark a "Goal" complete. Upon success it is hidden.