Getting Entity Framework Exception Details

Could not load file or assembly 'SqlTrackingParticipant' or one of its dependencies. An attempt was made to load a program with an incorrect format

Problem Statement:   Could not load file or assembly 'SqlTrackingParticipant' or one of its dependencies. An attempt was made to load a program with an incorrect format

Solution :  CLR is unable to load the assembly because the assembly is not complied in X64 platform. Change it to "Any CPU" using "Right Click on the Project -> Properties -> Build -> Platform target.

highlighting a row in JqGrid based on a column value

function hightlightGridRows(grid, colName, valueToCheck) {     
    var grid_ids = grid.jqGrid('getDataIDs');
    var rowcount = grid_ids.length;
    var columnNames = grid.jqGrid('getGridParam', 'colNames');
    
    $.each(columnNames, function (i, v) {
        columnNames[i] = v.toUpperCase();
    });

    var colNameInUpper = colName.toUpperCase();

    if ($.inArray(colNameInUpper, columnNames) > -1) {
        for (var counter = 0; counter < rowcount; counter++) {
            var rowid = grid_ids[counter];
            var aRow = grid.jqGrid('getRowData', rowid);
            var celldata = grid.getCell(rowid, colName);

            if (celldata == valueToCheck) {
                var trElement = $("#" + rowid, grid);
                trElement.removeClass('ui-widget-content');
                trElement.addClass("gridHighlightRow");
            }
        }
    }
    else {
        alert("Invalid column name to evaluate the condition for highlighting rows in the grid");
    }

}

where
ui-widget-content = It is css class that is applied by default to a JqGrid row.
gridHighlightRow = It is the custom css class to highlight grid row.

References: http://tpeczek.codeplex.com/

Update an item of a querystring using Jquery

function updateQuerystring(str, itemToReplace, value) {
    if (str != null) {
        var pairs = str.split('&');
        $.each(pairs, function (i, v) {
            if (v.indexOf(itemToReplace) >= 0) {
                pairs[i] = itemToReplace + "=" + value;
            }
        });
        str = '';
        $.each(pairs, function (i, v) {
            if (pairs[i].indexOf("?") >= 0)
                str = pairs[i];
            else
                str = str.concat("&" + pairs[i]);
        });
    }

    return str;
}

Extension class for IEnumerable( Of T)

public static class IEnumerableExtensions
    {
        /// 

        /// ForEach extension method for IEnumerable(Of T)
        /// 
        /// The element type of the IEnumerable object
        /// The IEnumerable(Of T) source
        /// The delegate to perform on each element of the IEnumerable(Of T)
        public static void ForEach(this IEnumerable source, Action action)
        {
            if (action == null)
            {
                throw new ArgumentNullException("action");
            }

            foreach (T item in source)
            {
                action(item);
            }
        }

        /// 

        /// Converts an IEnumerable(Of T) to a delimited string
        /// 
        /// The element type of the IEnumerable object
        /// The IEnumerable(Of T) object
        /// The delimiter to be used in the output string
        /// Delimited string representation of the items
        /// Null or empty items are ignored
        public static string ToDelimitedString(this IEnumerable items, string separator)
        {
            if (items == null || items.Count() == 0)
            {
                return string.Empty;
            }

            return string.Join(separator, items.Where(i => i != null && !i.ToString().IsNullOrWhiteSpace()));
        }

        /// 

        /// Converts an IEnumerable(Of T) to a comma-delimited string
        /// 
        /// The element type of the IEnumerable object
        /// The IEnumerable(Of T) object
        /// Comma-delimited string representation of the items
        /// Null or empty items are ignored
        public static string ToSpaceDelimitedString(this IEnumerable items)
        {
            return items.ToDelimitedString(" ");
        }

        /// 

        /// Converts an IEnumerable(Of T) to a space-delimited string
        /// 
        /// The element type of the IEnumerable object
        /// The IEnumerable(Of T) object
        /// Space-delimited string representation of the items
        /// Null or empty items are ignored
        public static string ToCommaDelimitedString(this IEnumerable items)
        {
            return items.ToDelimitedString(",");
        }
    }

Masking SSN in C#

 public static string MaskSSN(string ssn)
        {
            string pattern = @"(?:\d{3})-(?:\d{2})-(\d{4})";
            return (null != ssn) ? Regex.Replace(ssn, pattern, "XXX-XX-$1") : string.Empty;
        }

Storing files in DB in asp.net MVC

CSHTML

@using (Html.BeginForm("SaveFile", "MyController", FormMethod.Post, new { enctype = "multipart/form-data", id = "fileAjaxForm", autocomplete="off" }))
{

}

Controller

public JsonResult SaveFile(HttpPostedFileBase resumeFile)
{  
   if (resumeFile != null && resumeFile.ContentLength > 0)
   {
        int size = resumeFile.ContentLength;
        byte[] fileData = resumeFile.InputStream.Read(fileData, 0, size);
        DataAccess.SaveFileData(Path.GetFileName(resumeFile.FileName),resumeFile.ContentType, fileData)  
   }
}

DB

 Field Name

 Type



FileName

nvarchar(255)



Content Type
nvarchar(255)



Content
image