Raymund Macaalay's Dev Blog

Draggable Sorting and Saving Changes using MVC and jQuery UI

rsmacaalay — Tue, 15 May 2012 08:00:41 +0000

We’ve been posting a lot of MVC and jQuery lately and I guess you have to get used to it for a couple of months more as this the technology that I am using currently in most of my projects. For today’s session I will be discussing on how to make a sortable list which [...]

Export Telerik MVC Grid to CSV Dynamically based on a View Model

rsmacaalay — Wed, 02 May 2012 10:00:56 +0000

We may have seen examples from Telerik where they had exported data to CSV but Column Headers and Column Values are assigned manually to StreamWriter object. For this post we will improve further on that by doing it dynamically, which makes sense when you are generating your grid in dynamic fashion as well. This is [...]

How to create an Editable Sharepoint Datasheet View with Content Approval Turned on

rsmacaalay — Wed, 11 Apr 2012 07:00:21 +0000

Have you tried creating a Datasheet view in Sharepoint then suddenly found out that you can’t edit it even it says “View data in an editable spreadsheet format that is convenient for bulk editing and quick customization”? Well don’t worry you are not crazy it really works like that when Content Approval turned on in [...]

Moving a Sharepoint Sub Site to its own Site Collection in 3 easy steps

rsmacaalay — Wed, 28 Mar 2012 07:00:20 +0000

Moving a Sharepoint Sub Site to its own Site Collection why should I do that? Well there might be a lot of reasons on doing this but for me its more handing over the Site collection Administration to the business which enables business owners to choose themes, manage security within the site collection, manage activated [...]

Running a background service in a Web Application (no Windows Service was involved during this process)

rsmacaalay — Sat, 17 Mar 2012 07:00:01 +0000

This is not something new but it might be helpful for someone who needs this solution, I am sharing this as I have a current project to create background services using my Web application like usual before I start some solution I check whether I had made something like it before and to my luck [...]

info360 Addresses Enterprise IT Transformation in the New Paradigm of Social & Mobile Across the Enterprise

rsmacaalay — Fri, 16 Mar 2012 09:00:25 +0000

Newton, MA – info360 (June 12-14, 2012; Jacob Javits Convention Center), North America’s largest and most comprehensive enterprise content event, will provide information technology (IT) professionals with the tools they need to securely join data streams, connect mobile devices to established networks and boost operational efficiency. This year’s show marks its return to New York City, a [...]

Export Multiple Datasets to Multiple Excel sheets dynamically formatted according to the records Data Type

rsmacaalay — Fri, 24 Feb 2012 09:00:54 +0000

This might not be a ground breaking discovery but I was thinking I might be able to share this piece of code to someone who might need it. As usual I did searched online first whether this is available but I haven’t seen something exactly similar yet so it’s a good time to share it. [...]

Delete Row does not refresh Telerik MVC Grid Solution

rsmacaalay — Thu, 09 Feb 2012 09:00:42 +0000

Have you encountered an error in Telerik’s MVC grid where when you delete an item using Ajax Databinding the grid does not refresh but the row item was actually deleted? I came across with this issue when I was working with Telerik MVC Grid and was wondering why when I perform Ajax insert and update [...]

How to render MVC View on a Modal Popup Window

rsmacaalay — Mon, 16 Jan 2012 09:00:32 +0000

You might be wondering how to place an MVC View easily on a pop-up window like the image above that’s why you are in this page now? Well you a bit lucky as I will tell you how easy is this to execute, but first of all let me tell you that I am using [...]

Foreign Key Drop Downs on Telerik MVC Grid

rsmacaalay — Fri, 13 Jan 2012 09:00:23 +0000

If you are using MVC on your projects and you are using a Grid View control most probably it will be the Telerik Grid. While it is one of the best ones around it still have its cons but whats good with it is that the product is regularly updated even for the open source [...]

The Easy way of changing Collation of all Database objects in SQL Server

rsmacaalay — Mon, 19 Dec 2011 09:00:19 +0000

Did you encountered a problem where you wanted to change your database collation to default or even just changing it to a different type? I guess what you had initially done (like me) was to change the collation of the Database well that does not quite work well as the existing columns will not be [...]

Not all files showing on Twonky Media Server / Vodafone Broadband Complete HG553

rsmacaalay — Tue, 22 Nov 2011 10:00:12 +0000

This post will not be programming related but more of a simple hack on a device I just recently acquired, anyways this post still is technology related and I wanted to share this simple solution that others might find useful. Recently I moved to a different internet provider as my ADSL modem and Wi-Fi Router [...]

Sharepoint List View Threshold Error

rsmacaalay — Thu, 17 Nov 2011 10:00:02 +0000

You might have encountered the error below in Sharepoint thats why you stumbled upon this site. The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.<nativehr>0×80070024</nativehr><nativestack></nativestack> Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the [...]

Telerik MVC Grid workaround for not rendering properly in Internet Explorer

rsmacaalay — Thu, 29 Sep 2011 11:00:38 +0000

If you are working with Telerik MVC Grid and Internet Explorer you might have encountered an issue where columns and rows are not rendered properly. You will notice rows are not in line with their respective columns and even grid lines are not lining properly. Look at some screen shots below from different browsers I [...]

Large JSON Result for Telerik’s MVC Grid

rsmacaalay — Tue, 27 Sep 2011 11:00:13 +0000

You might have encountered this error “Error during serialization or deserialization using the JSON JavaScriptSerializer. The length of the string exceeds the value set on the maxJsonLength property.” when pushing a large data to Telerik’s MVC Grid. My best guess is you have tried solutions to update the web.config to contain sections something similar to [...]

Simple Implementation of MVC Cascading Ajax Drop Down

rsmacaalay — Wed, 21 Sep 2011 10:00:39 +0000

Don’t you miss developing the traditional way? where you can just use Update Panels and Auto Post backs, it was so easy to develop the UI before where you can see it in the design view and interact with the objects in a rich manner. But that was the past, now we have MVC where [...]

Simple TSQL and C# Entity Generator for S#arp Architecture

rsmacaalay — Fri, 16 Sep 2011 10:00:36 +0000

Recently we started a big project which uses S#arp Architecture and for those who does not know what it is you can go to the site (http://www.sharparchitecture.net/) and have a read, but in a gist it is an open source architectural foundation that uses ASP.NET MVC framework with NHibernate. The following principles of this architecture [...]

Singularize Function in TSQL

rsmacaalay — Tue, 13 Sep 2011 10:00:32 +0000

Today I was trying to make a code generator for one of our projects to make our lives easier, basically I was trying to list all objects on our SQL Server database and Print a C# code output which I can then save as a .cs file, all went fine until I realized that Entities [...]

Using jQuery with Sharepoint 2010

rsmacaalay — Tue, 06 Sep 2011 09:00:26 +0000

Several days back I was asked a question in this blog relating to using JavaScript in a Sharepoint, it ended up with multiple questions and one was using jQuery in Sharepoint, as usual I searched my own blog for answers becuase that is one of my main reasons having this is to store information like this that I may need in the future, a reference for what I had done which I may be [...]

Easily Determining what is the exact Error by using Correlation ID in Sharepoint 2010

rsmacaalay — Thu, 18 Aug 2011 09:00:48 +0000

Have you encountered an error that looks like this screenshot below? Well if you develop items in Sharepoint then most probably you had seen that not just once but a lot of times unless you are a really good developer that does not commit any mistakes. Now you are presented with a GUID without any [...]

Getting the default record type of a user for Event Creation in Salesforce

rsmacaalay — Tue, 19 Jul 2011 10:00:04 +0000

I have been twisting my head around in finding a solution for this simple task and I guess its worth while to share this information to everyone as I cannot search anything on Google or even in Developer Force any solution related to my problem. Eventually it ended up in calling their premier support for [...]

Synchronizing Google Groups and Active Directory Group Members

rsmacaalay — Tue, 12 Jul 2011 10:00:43 +0000

I have been doing a lot of synchronization projects lately like SalesForce events and Google Calendar Events, Active Directory and some Payroll Application and now Google Groups and Active Directory Groups. It may sound too complicated to develop but trust it is not as complicated as you think. For this article I will be presenting [...]

Approval Moderation in Sequential Workflow Project

rsmacaalay — Fri, 20 May 2011 10:30:55 +0000

Have you ever wondered how to automate Sharepoint approval process in a Sequential Workflow Project? Well look no futher this article is about that. Lets start with a scenario to be clear, say we have a product list where someone in your company approves every product listing based on thresholds, that threshold measure can be [...]

Converting System.Linq.IQueryable interface to System.Data.DataSet

rsmacaalay — Fri, 20 May 2011 10:00:52 +0000

Just a quick tip, in case you need to convert a System.Linq.IQueryable interface to System.Data.DataSet then check at the codes below private DataSet LINQToDataSet({Your LINQ Data Context} myDB, IQueryable item) { SqlCommand cmd = myDB.GetCommand(item) as SqlCommand; DataTable oDataTable = new DataTable(); SqlDataAdapter oDataAdapter = new SqlDataAdapter(cmd); oDataAdapter.Fill(oDataTable); DataSet oDataSet = new DataSet(); oDataSet.Tables.Add(oDataTable); return oDataSet; } Usage: var oTableResult = (from p in myDB.SampleTable where p.SampleColumn == "Test Value" select p); LINQToDataSet(myDB, oTableResult); Filed under: Programming, Tips Tagged: C#, LINQ

Managing Google Calendar Events using .Net

rsmacaalay — Sat, 14 May 2011 10:22:00 +0000

Yesterday I posted an article on how to create events in SalesForce programatically now we will do the same thing for Google Calendar. The processes are nearly the same but it’s not as straightforward as the SalesForce one specially on Event Creation and Custom fields extensions. One good thing though that Google has is a [...]

Increase 1000 Records Maximum Page Size of Active Directory

rsmacaalay — Fri, 13 May 2011 14:00:44 +0000

Just wanted to share a common question that is always asked on why Active Directory returns only 1000 results when you perform a query. It is a limitation imposed by Active Directory by default, but it does not mean you cannot increase that values. You can always increase it by changing the MaxPageSize setting in [...]

Managing SalesForce Events using .Net

rsmacaalay — Fri, 13 May 2011 10:00:00 +0000

I started a project lately to synchronize events between Google Calendar and Sales Force Calendar, there may be different products available out there but those are really expensive and some require you to setup an array of files in an end users machine. For the systems administrator it will be a nightmare specially when you [...]

Creating Visual Web Part Properties

rsmacaalay — Wed, 27 Apr 2011 10:00:43 +0000

Before reading this article I assume you already know how to create your own web parts in Sharepoint and is looking for some ways to create a property for that webpart that you can easily Set and Get from your application like this one on the image below. but if not please read this post [...]

Sending messages to workstations using Socket Programming and WCF

rsmacaalay — Sun, 03 Apr 2011 06:58:21 +0000

I am in the process of developing an application which sends information to client machines from another application (some sort of an Internal Messaging System or Desktop Alerts), I initially I had thought of using the old school NETSEND command but there are issues with it, and the main hindrance for me not using it [...]

Guide to Creating Dynamic LINQ Queries

rsmacaalay — Tue, 15 Mar 2011 10:00:23 +0000

Are you new to LINQ and trying to figure out how to create dynamic LINQ queries like the same way you do with ADO.Net? Well it’s not that hard at all and all you need to do is use a combination of the “Where” Extension method and “IQueryable” interface. So for example we have a [...]