Chorn Sokun

Many to many lazzziii

2008-04-23T15:22:00.007+07:00

NHibernate's rock I scratched my head for a few hours looking at this code

DetachedCriteria filter = DetachedCriteria.For(typeof(Project))
.Add(Expression.Eq("ID", pid))
.SetProjection(Projections.Property("Type"));

DetachedCriteria q = DetachedCriteria.For(typeof(List_Output), "op")
.CreateCriteria("ProjectTypes")
.Add(Subqueries.Exists(filter));

return q.GetExecutableCriteria(
holder.CreateSession(typeof(List_Output))
).List();

Wonder why I got so many sql call to the server? the domain objects in the discussion context are Project has a Type and base on selected Type a project can choices a bunch of Outputs.
So Project is belong to a Type [One-to-Many], and Type has many Outputs where Output belong to Many Types [Many-to-Many].

What I found and fix is Lazzzzzzzziiiiiiiiiiiiiiii :))
I forgot to tell Type to load Outputs in a Lazy way and vise versa once that done I got only one YEAH ! I mean ONE sql call to the server to get what I asked for instead of 2 + N (where N is number of relevant Outputs in a Type)

Thanks to DetachedCriteria & the Laziness until next time today magic word is "Lazy = true"

Woh Woh storedprocedure no more ...

2008-04-18T15:48:00.003+07:00

Read the title and want to know how to do that? come with me hacking the Castle code base or to be accurate hack NHibernate code base, what you need to bring along? not much but a SubVersion, NAnt, MbUnit and NUnit that sound enough ;)

Enjoy plug & play your database and let the Jedi rise
Happy Friday everyone !

... and so there is a response

2008-04-06T17:39:00.003+07:00

As I sad I love to see thing happen without me touching the code base :)) and how about the full fill my wish list?

MonoDevelop 1.0 go for Hardy (done)

Oh ! how about eclipse & it partner PDT? Vote it up so we "eclipse fan" can have it goes for Hardy as well ;)

Last but it the beast Ship Mono.19 with Ubuntu 8.04 go vote for it if we're true friend.

Encoded message

2008-04-06T10:32:00.002+07:00

Rob Conery the man behind "SubSonic" a blogger like to post his though in a hex; wonder what on his mind? try this online hex converter http://www.dolcevie.com/js/converter.html

Ubuntu 8.04 Hardy Heron - that for my mom

2008-04-03T00:33:00.004+07:00

If you follow my previous post you might know what I've been doing so far, well i was messing around with Ubuntu 8.04 and if you ask me how was that? I would say "Yeah, It is an OS for my mom". How about you buddi? you asked. See the problem is Ubuntu 8.04 was developed for my mom it wasn't me ! :( that kind of sad isn't it?

Now let me express what make me feel this way, I guess you know who I am right? Oh ! com'on I knew you did hahaha I write VB, PHP, Java & C# tool I am expected to see in Hardy Heron

Eclipse 3.3 (sorry we got 3.2 )
Mono 1.9 (hm hmm, wait and see u might have it next release cycle)
MonoDevelop 1.0 (oh, isn't beta 3 work great for ya ?!)

the Ubuntu guy love to play with giant snake therefore all they care about is Python.

After all I might have to do I miss catch for 8.04 cuz my mom don't use any computer :(

Ubuntu 8.04 Hardy Heron Alpha 6

2008-03-09T12:13:00.005+07:00

Khmer Script Line break solved see screenshot bellow

However I am not sure what was wrong with a few character which can't render properly.

Any thought?

IP Switch WS_FTP die die

2008-03-07T08:43:00.003+07:00

I always been a fan of WS_FTP up until last night I just can't get on with that freaking slow file transfer. I just told myself to blame ISP for not taken care of FTP connection however after tried a few different ISP connection I start to belive that was not the case. I must had to do something about it or else I better shot myself in the foot. So here come the decision:

Get rid of WS_FTP install CuteFTP from GlobalSCAPE and voilá all the pain gone thanks Budha !
Last word die die die WS_FTP.

Tabify why I never care?

2008-03-05T14:37:00.006+07:00

I thought I was one of the coder who obey coding standard, but hell no until a guy told me I wasn't. That kind of make me feel like a fool :))

Well, this is how I get around:

Tools -> Options -> Text Editor -> C# -> Tabs (Hell no ! "Insert spaces" was selected)
select "Keep tabs"

Alright let see will this work "Tabify"

Edit -> Advanced -> View White space (Crtl + R, Crtl + W)
Now reformat your code [ Ctrl + A; Ctrl + K, Ctrl + F]

Is that "Tabify" you talking about Ken ;)

What a storm !

2008-03-04T14:32:00.003+07:00

No no there is no weather news to tell ya, just being one of Ubuntu's fan I got to tell you how I love the project as well as the people behind it.

They try so hard to make it possible for everyone to contribute back and like every kids love x-mas hope their wish will come true. Now there is a new Santa looking for your wishes @

To cut the long story short here is the latest tool brainstorm ;) I find it cool to vote/write down great idea and got it build "without us do the hard work" what a storm !

ASP.NET Fileupload

2008-02-01T17:40:00.000+07:00

Call me lazy cuz I am deserved it. It shocked me a bit when a production code crash on my face. As part of my job today I have to train a few admin staffs on how to operate our newly invented site www.ncdd.gov.kh/jobs it works out quiet well on my machine cuz I dev, test & teach on Mozill Firefox. But it turn out that I don't perform enough exercise cuz I haven't test the site with IE yeah, cuz I haven't use IE for almost 3 years enough to forgot about it :)) anyway here is the story.

Do you know this guy System.Web.HttpPostedFile? yeah, he is my best friend when it comes to uploading file in ASP.NET. However you should know that he acted bit strange with browse in used.

Let say file1 is an instance of HttpPostedFile and if we ask him file1.FileName

Firefox return :
"Hello My Friend.doc"
Nice , isn't it?

IE return :
"C:\Document & Setting ....\user_name\desktop\Hello My Friend.doc"
WWOWO WHAT?! it slap me so hard to make me laugh out loud :))
Not Nice !

Anyway quick fix would be add a small detection on the file1.FileName

int lastDirSeparatorChar = file1.FileName.LastIndexOf(Path.DirectorySeparatorChar);

if (lastDirSeparatorChar > 0)
{
filename = file1.FileName.Substring(lastDirSeparatorChar + 1);
}
else
{
filename = file1.FileName
}

Lesson learn - test dev. site with IE as much as I hate "IE"

NCDD Recruitment Website is now online

2008-01-24T16:55:00.000+07:00

Early release to take away my workloads; okay now it is the HR who got fun time with the new toy.
Check it out www.ncdd.gov.kh/jobs if think you have something to do with D&D

Sagernotebook.com's Product

2008-01-23T08:18:00.001+07:00

Well, just the spec that would satisfy me :D

We had lost our buddy

2008-01-22T15:53:00.000+07:00

We are so sad to congrats our buddi who had lost his freedom.
Don't worry my friend, we will always remember all bar, bear & karaoke room that we went together.

To You & Yours Happy Couple

Extending MonoRail ViewComponent

2008-01-18T15:13:00.000+07:00

Quick note before I leave my desk for a meeting

Always apply ViewComponentDetailsAttribute on your custom ViewComponent like this

[ViewComponentDetails(string name, string sections, Type CacheKeyFactory, ViewComponentCache Cache)]

This will prevent your custom view component name clash with base component name.
Okay ! got to go

Let do Projection

2008-01-17T15:55:00.000+07:00

This would be a continue part from my previous post, what I tried to do is find out how to use ActiveRecord "NHiberate to be clear" in my reporting scenario (not a CRUD) after a quick search I come up with a few blog posts which give me some light:

It will take another post for me to wrap up how I come up with .... stay tune.

Edit: I shouldn't have missed, exploring test case
Castle.ActiveRecord.Tests\ActiveRecordGenericsTestCase.cs

Ubuntu "Dock It Mac Way"

2008-01-17T08:54:00.000+07:00

It almost 2 months since my busy schedule started, I was unable to find sometime to spend with my beloved Gutsy until today * I am no expert in Ubuntu * in the exploration process I decided to upgrade a few packages to it latest version and well I come across one cool package:

Avant Window Navigator (Awn) is a dock-like bar which sits at the bottom of the screen. It has support for launchers, task lists, and third party applets.The Awn project is the development of the ‘dock’, avant-window-navigator, and its corresponding shared library ‘libawn’, which is used to develop applets.

For more detail instruction read it @ http://www.ubuntugeek.com or direct link Avant Window Navigator enjoy fun ;)

Visual Studio 2008 stink without ReSharper

2008-01-07T08:29:00.000+07:00

Oh ! man I though VS2008 will give developer more productivity I was wrong.
Without ReSharper I feel like I take my time writing stupid code that do nothing.

VS2008 Refactoring tool is suck !

However the ReSharper 4.0 for Visual Studio 2008 is not yet release, but I can install the 3.1 with the following command

msiexec /i ReSharperSetup.3.1.Full.VS80.msi VSVERSION=9.0

And here we go all the goodness command are come back to me.
If you don't believe me watch demo video feature highlight.

This is how a GIANT learn to copy files

2008-01-06T12:07:00.000+07:00

Vista SP1 Notable Change - most notable change is MS is still learning how perform file operation (Copy/Move/Delete) the right way.

Improves performance over Windows Vista’s current performance across the following scenarios1:
25% faster when copying files locally on the same disk on the same machine
45% faster when copying files from a remote non-Windows Vista system to a SP1 system
50% faster when copying files from a remote SP1 system to a local SP1 system

Oh and here is the funny part:

Improves the copy progress estimation when copying files within Windows Explorer to about two seconds.

What so exciting improvement to be expect in the list :D Well, it sound like we have to wait for SP1+ before purchasing product release by MS.
I wonder does SP1+ = version 3.0 :)) anyway enjoy reading detail here.

Level1Remove : Unblock/block file attachments in MS. Outlook

2008-01-03T08:40:00.000+07:00

Note for myself http://support.microsoft.com/kb/837388

2008 hitting the road

2008-01-01T00:09:00.000+07:00

Let me take this opportunity wishing you all the best,

2008 refresh our brain bring more innovations and best of all let rock the Net.

2008 Wish list:

Ubuntu 8.04 Hardy Heron - more hardware support out of the box please ...
NHibernate 2.0 GA - let persist the universe
Castle 1.0 GA - let become a great warrior
MySQL 5.1/6.0 GA - falcon data engine, data partitioning
Die, die Windows Vista - don't you know how much I hate you?
MonoDevelop 1.0 - let us all have a real IDE for Mono "Unleash the Monkey"

Castle.MonoRail.Framework.IFilter - Part I

2007-12-31T15:14:00.000+07:00

Today I would like to share some technique in using Castle.MonoRail.Framework.IFilter . I am a bit sad because it takes too much time for me to realize how useful, until I read between the line over and over again

Filters are executed before and|or after your actions. It is useful for security, dynamic content and to keep away repetitive code.

Keep away repetitive code is what I am tracing, let the hear the story shall we?

This happen with one of the real world project that I am working on Data Bridge like any other web application it need authentication and passing some user preference along each action (inherit from SecureController) to the view such as List, Add, Edit & Delete action & view.

This can be done using the following technique:

Create Filters\AuthenticationFilter.cs

public class AuthenticationFilter: IFilter
{
bool IFilter.Perform(ExecuteEnum exec,
IRailsEngineContext context,
IController controller){
if(!UserNotLogin())
{
Redirect("Login", "Index");
}
else
{
controller.PropertyBag["maxRow"] = GetUserMaxRowPreference();
... set more preferences as needed
}
}
}

Create SecureController

[Layout("default"), Rescue("generalerror")]
[Filter(ExecuteEnum.BeforeAction, typeof(AuthenticationFilter))]
public abstract class SecureController : ARSmartDispatcherController
{
}

SecureController is marked as abstract, prevent from direct use.

Using SecureController

public abstract class ProductController: SecureController
{
public void List()
{
}
}

Now view part: View\Product\list.vm

When render table I want to display miximum $maxRow rows.

See there is no code need to set preference in each action method, nice.

2007 Party of the Year :))

2007-12-27T09:22:00.000+07:00

This party made especially for an old friend "Phors" he was on his scholarship assignment, Wish you all the best.

Happy New Year Everyone

IList you have me?

2007-12-05T15:40:00.000+07:00

As much as I hate to deal with numerical index I had to cross it one way or the other so be it.
Here is the fact, I am enjoy using Castle.ActiveRecord to wrap my DAL code cuz it simplify thing a lot for me > 80% somehow when it came to not so complex scenario like this one:

I want to allow my customer to list all the products and set the qty they want to order.
If they already order I would like to give them a chance to update qty for the product that they miss in the previous hit.

public IList LoadProductOrderList(int customer_id)
{
IList result;
ISessionFactoryHolder sh =
ActiveRecordMediator.GetSessionFactoryHolder();
ISession session = sh.CreateSession(typeof(AnnualTarget));
try
{
// note: code wrapped for view
string sql = "SELECT p.pid, p.name, o.qty, o.id as order_id
FROM Products p JOIN Orders o
ON p.pid = o.product_id WHERE o.customer_id = :c1
UNION
SELCT pid, name, 0 as qty, 0 order_id FROM Products";

result = session.CreateSQLQuery(sql)
.AddScalar("ID", NHibernateUtil.Int32)
.AddScalar("NAME", NHibernateUtil.String)
.AddScalar("QTY", NHibernateUtil.Int32)
.AddScalar("ORDER_ID", NHibernateUtil.Int32)
.SetInt32("c1", customer_id)
.List();
}
catch (Exception ex)
{
....
}
finally
{
sh.ReleaseSession(session);
}

return result; <- this is an IList ?!!! I don't like to work with it }

As much as I hate, it is a bad idea to pass IList back to the caller object. What is interesting about this code session.CreateSQLQuery(sql) you can tell it to map the result to an Entity by call like this

session.CreateSQLQuery(sql)
.AddEntity(typeof(EntityObjectOfTypeActiveRecord))
.List();

But anyway I have got time to dig what AddEntity would do with the object pass in to me the road a head is a bit dark. Can I have something more simple?

The simple should be:

public IList LoadProductOrderList(int customer_id)
{
IList betterResult = new List();
.....
for(int i = 0; i < curobject =" (object[])" dto =" new" id =" curObject[0];" name =" curObject[1];" qty =" curObject[2];" orderid =" curObject[3];">

Now it much better to work with

Time to play the Game > in the Castle

2007-11-16T09:47:00.000+07:00

Life is learning, after getting myself familiar with the Castle stack I started to look at another abstraction stack known as 'Rhino-Tools' as it advertises to ease my development life so why not give it a shot ;) then the story go:

Well, I did get the information from somewhere else about all these stack but let for complete reference check this out Building the Castle Stack (ish) TM - from Trunk

The point is now I have to deal with test unit to be sure everything work as advertised so I grab additional tool:

MbUnit - A Generative Unit Test Framework
NUnit - Also a Unit testing framework initially ported from JUnit

Once these tools get installed I fire up my vs.net command line:
..\castle-trunk>nant >buildLog.txt

well it still complaint me that MbUnit or NUnit can not find ... WhAT?
BCurse I did not add MbUnit or NUnit path to the execute path environment :( anyway my path string is already too long I decided to set the path of these two framework directly in the ..\castle-trunk\common.xml

....more script ...

<property name="mbunit-console" value="C:\Program Files\MbUnit\MbUnit.Cons.exe" overwrite="false">


<property name="nunit-console2" value="nunit-console2" overwrite="false">
<property name="nunit-console" value="C:\Program Files\NUnit-Net-2.0 2.2.10\bin\nunit-console.exe" overwrite="false">
....more script ...

Okay let do it again:
..\castle-trunk>nant >buildLog.txt
BUILD FAILED !? what?
Review buildLog.txt I learn that I did not enable SqlServer DTS ha sorry.
>Enable SqlServer DTS Agent
..\castle-trunk>nant >buildLog.txt
Voilá: BUILD SUCCEEDED - 1 non-fatal error(s), 0 warning(s)

Now I am ready to roll next step let u know later ;)

GPhone Android Demo

2007-11-14T09:03:00.001+07:00

Sergey Brin and Steve Horowitz discuss the availability of the SDK, that it will be open source in the future, and demo applications on the Android platform.