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
http://felixmondelo.blogspot.com/2008/08/exchange-2007-web-services-iii-update.html
and
http://social.technet.microsoft.com/Forums/en-US/exchangesvrdevelopment/thread/b8f91d59-9c1f-4a61-8e5d-3e33ca28fd9e/

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.


Credits:
http://blogs.msdn.com/b/brismith/archive/2010/08/25/project-server-adding-custom-fields-to-projects-and-tasks-using-the-psi.aspx

http://blogs.msdn.com/b/project_programmability/archive/2008/02/28/custom-field-and-lookup-table-webcast.aspx

Sunday, October 24, 2010

Rails routes, respond_to and more

As pulled from:
http://info.michael-simons.eu/2007/08/06/rails-respond_to-method/

I've used respond_to previously...but it slipped my mind..so 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.html
format.js { render :partial => 'list.html.erb' }
end

Tuesday, February 23, 2010

Flot - jQuery Graphing

http://code.google.com/p/flot/

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

JS:



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 http://snippets.dzone.com/posts/show/2486 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.