Rudy Setyo Purnomo

Changeable SyntaxHighlighter Theme on BlogEngine.NET using Extension

2009-08-12T04:39:57Z

Alex Gorbatchev create a great tool, write on JavaScript, to highlight our code on blog posting. But how to implement SyntaxHighlighter on every post in our BlogEngine.NET? There is a good Windows Live Writer Plugin by David Pokluda that implement SyntaxHighlighter into BlogEngine.NET using the Extension.

But the extension by Pokluda doesn’t have the ability to change the SyntaxHighlighter Theme, by 30 July 2009, SyntaxHighlighter have 6 built in theme, please check at the web. Therefore i want to extend the extension by Pokluda to have an ability to change the theme.

Basically, to do this we need a setting for the extension, using ExtensionSettings class would be the answer.

// Code by Rudy Setyo Purnomo
// http://rudysetyo.it

ExtensionSettings settings = new ExtensionSettings(“SyntaxHighlighter”);

settings.AddParameter(
    "shTheme", 
    "shTheme", 
    50, 
    true, 
    true, 
    ParameterType.RadioGroup);
settings.AddValue(
    "shTheme", 
    new string[] 
        { 
            "shThemeDefault",
            "shThemeDjango", 
            "shThemeEmacs", 
            "shThemeFadeToGrey",
            "shThemeMidnight",
            "shThemeRDark"
        }, 
    "shThemeDefault");

settings.Help = "SyntaxHighlighter Theme";

ExtensionManager.ImportSettings(settings);

If you see the original code by Pokluda, you’ll see that the AddStylesheetToPage method only have one parameter, i add one more parameter to set the Theme.

// Code by Rudy Setyo Purnomo
// http://rudysetyo.it

private void AddStylesheetToPage(Page page, string theme)
{
    HtmlLink css = new HtmlLink();
    css.Attributes["type"] = "text/css";
    css.Attributes["rel"] = "stylesheet";
    css.Attributes["href"] = GetAbsoluteFromRelativeUrl("SyntaxHighlighter/Styles/shCore.css");
    page.Header.Controls.Add(css);

    css = new HtmlLink();
    css.Attributes["type"] = "text/css";
    css.Attributes["rel"] = "stylesheet";
    css.Attributes["href"] = GetAbsoluteFromRelativeUrl("SyntaxHighlighter/Styles/" + theme + ".css");
    page.Header.Controls.Add(css);
}

// and use this code to receive Theme name from setting parameter.

string theme = _settings.GetSingleValue("shTheme");

These screenshot is the setting screen to change the theme

And the is the 6 theme:

shThemeDefault

shThemeDjango

shThemeEmacs

shThemeFadeToGrey

shThemeMidnight

shThemeRDark

You could find the full code here, put the SyntaxHighlighter.cs at App_Code/Extensions folder.

ASP.NET Membership and Role Provider using Oracle database part 1

2008-11-19T23:07:13Z

We all know that in ASP.NET 2.0 there are Built-In Providers to help developers to build a robust application.

Membership
Role management
Site map
Profile
Session state
Web events
Web Parts personalization
Protected configuration

What i want to write here is about Membership Provider and Role Provider,

Membership
System.Web.Security.ActiveDirectoryMembershipProvider
System.Web.Security.SqlMembershipProvider

Role management
System.Web.Security.AuthorizationStoreRoleProvider
System.Web.Security.SqlRoleProvider
System.Web.Security.WindowsTokenRoleProvider

OK, how about developer with Oracle database in their hand? Off course ASP.NET have their API for that, for example Membership Provider, according to http://msdn.microsoft.com/en-us/library/system.web.security.sqlmembershipprovider.aspx the Inheritance Hierarchy from System.Web.Security.SqlMembershipProvider is:

System.Object
System.Configuration.Provider.ProviderBase
System.Web.Security.MembershipProvider
System.Web.Security.SqlMembershipProvider

From that information, we have enough material to build our Membership Provider, let say Erudeye.Web.Security.OracleMembershipProvider, the Inheritance Hierarchy maybe look like this:

System.Object
System.Configuration.Provider.ProviderBase
System.Web.Security.MembershipProvider
Erudeye.Web.Security.OracleMembershipProvider

Done, we have a vision for the Provider, how about persistent data? Again, we "copy" SQL Server Provider schema structure from SqlMembershipProvider.

The table above is specific to each Provider, some table are use by Membership and Role Provider. When we want to "copy" the database schema, bringing that picture only is not enough, we need to know exactly what information behind that, like data type, constraint and so on. The complete query from schema above could be found on C:\Windows\Microsoft.NET\Framework\v2.0.50727 with the .sql filetype. From that query, we could make our own Oracle schema, example for aspnet_Users table in Oracle way:

We already have the vision about Provider and the Persistent data is ready, what next on part 2? Build an Oracle Provider and Provider Helper for Oracle.

a "netTiers like" LINQ to SQL application

2008-02-05T05:25:00Z

Some of us maybe familiar with netTiers when building an application, it's really helping us to cut the development time, LINQ does cut the time also... No, i don't want to compare between netTiers and LINQ to SQL, although in some cases they're comparable... What i want to share here is how to make a simple data visualization using gridview, really simple coz we will use LINQ to accomodate the simpleness... What "simple" i'm talking about? commonly when we build a CRUD application, we use ADO.NET or DAAB to access the database, but in this case, ADO.NET was handled by LINQ.

Familiar with the search control above? if you are new to that control, that is GridViewSearchPanel of netTiers. But what i'll show you is we'll create our own search to GridView exactly the same function as netTiers have.

    <form id="form1" runat="server">
    <div>
        Look for :
        <asp:DropDownList ID="DropDownList1" runat="server">
            <asp:ListItem>Code</asp:ListItem>
            <asp:ListItem>Description</asp:ListItem>
        </asp:DropDownList>
        Which :
        <asp:DropDownList ID="DropDownList2" runat="server">
            <asp:ListItem Value="0">Contains</asp:ListItem>
            <asp:ListItem Value="1">Ends With</asp:ListItem>
            <asp:ListItem Value="2">Starts With</asp:ListItem>
        </asp:DropDownList>
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <asp:Button ID="Button1"
            runat="server" Text="Search" onclick="Button1_Click" />
        <asp:Button ID="Button2"
            runat="server" Text="Reset" onclick="Button2_Click" />
        <p></p>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="true">
        </asp:GridView></div>
    </form>

1. Add an aspx page right exactly the same as above.

2. Add LINQ to SQL (.dbml), disobey what behind the dbml right now, we talk about it later, here is my dbml:

3. Go to your code behind, add this code and play it:

    protected void Page_Load(object sender, EventArgs e)
    {
        GridView1.DataSource = GetJobPrefix(0);
        GridView1.DataBind();
    }

    public IList<JobPrefix> GetJobPrefix(int rowStatus)
    {
        using (JobPrefixDataContext context = new JobPrefixDataContext())
        {
            return (from c in context.JobPrefixes
                    where c.RowStatus == rowStatus
                    select c).ToList();
        }
    }

    protected void Button1_Click(object sender, EventArgs e){}

    protected void Button2_Click(object sender, EventArgs e){}

In my application, the aspx will render like this, at this point the search facility didn't worked yet.

4. Next we'll create a method for searching and filtering.

    public IList<JobPrefix> GetJobPrefix(int rowStatus, string desc, string code, SearchOperator searchOperator)
    {
        using (JobPrefixDataContext context = new JobPrefixDataContext())
        {
            switch (searchOperator)
            {
                case SearchOperator.contains:
                    return (from c in context.JobPrefixes
                            where c.RowStatus == rowStatus && c.JobPrefixDesc.Contains(desc) && c.JobPrefixCode.Contains(code)
                            select c).ToList();
                    break;
                case SearchOperator.endswith:
                    return (from c in context.JobPrefixes
                            where c.RowStatus == rowStatus && c.JobPrefixDesc.EndsWith(desc) && c.JobPrefixCode.EndsWith(code)
                            select c).ToList();
                    break;
                case SearchOperator.startswith:
                    return (from c in context.JobPrefixes
                            where c.RowStatus == rowStatus && c.JobPrefixDesc.StartsWith(desc) && c.JobPrefixCode.StartsWith(code)
                            select c).ToList();
                    break;
                default:
                    return (from c in context.JobPrefixes
                            where c.RowStatus == rowStatus && c.JobPrefixDesc.Contains(desc) && c.JobPrefixCode.Contains(code)
                            select c).ToList();
            }
        }
    }

    public enum SearchOperator
    {
        contains = 0,
        endswith = 1,
        startswith = 2,
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        switch (DropDownList1.SelectedValue)
        {
            case "Code":
                GridView1.DataSource = GetJobPrefix(0, string.Empty,TextBox1.Text,(SearchOperator)Convert.ToInt32(DropDownList2.SelectedValue));
                GridView1.DataBind();
                break;
            case "Description":
                GridView1.DataSource = GetJobPrefix(0, TextBox1.Text, string.Empty, (SearchOperator)Convert.ToInt32(DropDownList2.SelectedValue));
                GridView1.DataBind();
                break;
        }

    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        GridView1.DataSource = GetJobPrefix(0);
        GridView1.DataBind();
    }

Ok, that's it. When i try to filter the data using keyword "in" in the Description(JobPrefixDesc) field with the "Contains" method, the aspx will render like this (you could try the "Ends With" and "Starts With" by yourself)

Really simple isn't it? build our own "netTiers like" GridViewSearchPanel using LINQ to SQL. Please enjoy...