.NET GENES

When I was a developer in a large corporation before, I was assigned to a Sitecore CMS project. While working on the CMS's services in getting the contents, I encountered an error as mentioned in a title post. After doing some research, I found out that the CMS's parser does not recognize special characters of the data returned from it's search query. So the workaround that I found from an article was to surround the data returned with hash tags. In the sample codes below, I just added a snippet to insert hashtags to data returned from the parser. Sample Data Returned: Tel-Aviv Formatted data: #Tel-Aviv# Original method: 1 2 3 4 5 6 7 8 9 10 11 public static IEnumerable<IUniversity> GetSchoolsByState(Guid stateProvinceId, Language languageVersion) { if (stateProvinceId.Equals(Guid.Empty)) return null ; var stateProvinceReferenceItem = Context.Database.GetItem(ID.Parse(stateProvinceId)); if (stateProvinceReferenceItem == nul

I created an ASP.NET MVC 5 simple application with entry forms integrating bootstrap and jQuery validation. Upon testing, the valid() built-in function is not recognized by the browser as stated in the title of this post. After series of investigation, I found out that by default, ASP.NET MVC does not render the jQuery validation scripts by default in _Layout.cshtml. Only jQuery core scripts. The fix is to render jqueryval validation scripts in _Layout.cshtml. The scripts have already been bundled in the BundleConfig file. @Scripts.Render("~/bundles/jquery") @Scripts.Render("~/bundles/jqueryval") @*code fix*@ @Scripts.Render("~/bundles/bootstrap") On page load, the scripts are indeed rendered to the browser using chrome dev tools.

Here's a simple way of adding/deleting WPF Datagrid rows using observable collection. XAML Code 1 2 3 4 5 6 7 8 <DataGrid AutoGenerateColumns= "False" ItemsSource= "{Binding}" Margin= "12,12,12,41" Name= "dataGrid1" CanUserResizeRows= "False" CommandManager.PreviewExecuted= "UserDataGrid_PreviewDeleteCommandHandler" RowEditEnding= "dataGrid1_RowEditEnding" RowHeaderWidth= "20" > <DataGrid.Columns> <DataGridTextColumn Binding= "{Binding UserName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" Header= "User name" Width= "230" > </DataGridTextColumn> <DataGridTextColumn Binding= "{Binding FirstName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" Header= "First Name" Width= "245" > </DataGridTextColumn> </DataGrid.Columns> </DataGrid> C#

As I was doing some research on chart controls to be integrated in ASP.NET MVC, I found a working from Shield UI which is MVC 4 regarding Sales Dashboard. As I was running the application to the browser, only the left container shows the chart. The right and bottom part does not show anything. It seems the remaining chart samples will be manually shown to the browser by entering the correct URL. To solve this, I added a ViewModel class, modified the HTML markup in the Index view and modified the codes in Home Controller. See updates below: SalesDashboardViewModel.cs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace SalesDashboardMVC.Models { public class SalesDashboardViewModel { public IEnumerable<QuarterlySales> Quarterly_Sales { get ; set ; } public IEnumerable<SalesByProduct> Sales_By_Products { get ; set ; } public IEnumerable<Perfor

Here's a simple Image Helper for showing known image types. I've tested this for old format such as bitmaps and images with OLE headers. This helper sets the image width and height with fixed values. You may change it dynamically or update this helper to accept parameters for width and height. C# Code 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 /// <summary> /// Helper for showing images /// </summary> public static MvcHtmlString ImageLink( this HtmlHelper htmlHelper, byte [] photo, string id) { string imageSrc = null ; if (photo != null ) { using(MemoryStream ms = new MemoryStream()) { string imageBase64 = string .Empty; Image xImage = (Bitmap)(( new ImageConverter()).ConvertFrom(photo)); if (ImageFormat.Bmp.Equals(xImage.RawFormat)) { // strip out 78 byte OLE header (don't need to do this for normal images) ms.Write(photo, 78, photo.Length - 78); } else { ms.Write(photo, 0, photo.Length);

I recently created a copy of Northwind database and called it NorthwindBootstrap. This database has a built-in membership tables added to it. The copy includes both of mdf and ldf files. My next step is to create a new database based from the recently copied/renamed files in which I have no idea on how to do it. After doing some research, I stumbled upon a t-sql script based from my requirement. USE [master] GO CREATE DATABASE [NorthwindBootstrap] ON ( FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NorthwindBootstrap.mdf' ), ( FILENAME = N 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\NorthwindBootstrap.ldf' ) FOR ATTACH GO Cheers! :)

Based from the issue, the fix is to check the database field against the view model class. In my case, the database field is smallint (nullable). So, the fix is to change the model code from int datatype: public int? StockOnHand { get ; set ; } To Int16 datatype: public Int16? UnitsInStock { get ; set ; } :-)

Here's what I did in order to recognize the draggable function in one of my asp.net mvc page. 1. Add jquery-ui.js to scripts folder. 2. Bundle the js file in BundleConfig.cs 3. Render the bundled script in _Layout.cshtml. Cheers! :-)

Hello, Here's a function to hide divs if it's children specifically images does not render correctly to the browser or an error has occured. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 function ImageDivHandler() { $( "div.gallery" ).each( function () { if ($( this ).children().length == 0) { $( this ).hide(); } else { var img = $( this ).find( ".image-responsive" ); if (img != null || img != undefined ) { imgSrc = $( this ).find( ".image-responsive" ).attr( "src" ); if (imgSrc == "" || imgSrc == null || imgSrc == "null" ) { $( this ).find( ".image-responsive" ).closest( "div.gallery" ).hide(); } else { $( this ).find( ".image-responsive" ).error( function () { $( this ).closest( "div.gallery" ).hide();

Hello, In order for the jQuery intellisense to work in Visual Studio 2013, perform the following steps. 1. Proceed by clicking Tools -> Options -> Text Editor -> JavaScript -> Intellisense -> References. 2. Change Reference Group to Implicit (Web)   By default a reference has been added to _references.js. If not, add a new reference file under Scripts folder. 3. Open _references.js file using your Visual Studio IDE or any text editor software. 4. Add reference path to jquery files (.js, .min.js, and .intellisense.js). 5. Close Visual Studio and Open it again. (I was struggling for hours as to why performing steps 1 through 4 didn't work. This step fixed the issue) Reference: jQuery intellisense not working in VS 2012 Regards, :)