henri's blogg

C#/Sharepoint: get lists and list contents from webservice

2011-02-18T14:28:00.005+01:00

I had access to part of a sharepoint site at
http://sharepointserver/areas/myarea
(in norwegian http://sharepointserver/omrader/myarea, I think it's called area in english installation)
Within the area there was a list I wanted to extract some data from.

Started up .Net and created a new winforms-project.
Add service reference - Advanced - Add web reference
In url I added the string /_vti_bin/Lists.asmx resulting in something like
http://sharepointserver/areas/myarea/_vti_bin/Lists.asmx
there are other services available, but Lists was the part I was interested in.
I gave it the name sharepoint_lists
Now I could get a list of all lists in this part of sharepoint:

using (var sharepoint = new sharepoint_lists.Lists()) { sharepoint.UseDefaultCredentials = true; var lister = sharepoint.GetListCollection(); VisXML(lister, txtXML); } ...

private void VisXML(XmlNode node, Control txt) { txt.Text = node.OuterXml; }

This gives me an XML containg all the lists in this part of sharepoint.
By glancing through it I could see my lists ID and Title, I could now use either to get the contents of my list:

using (var sharepoint = new sharepoint_lists.Lists()) { sharepoint.UseDefaultCredentials = true; var query = SorterQuery("Title"); var felter=LagViewFields(new string[]{"ID", "Title", "Beskrivelse"}); //var node = sharepoint.GetListItems("4dab35f1-d2c3-4270-9c7b-555555b55555", "",query ,felter, "", null, null); var node = sharepoint.GetListItems("My list", "", query, felter, "", null, null); VisXML(node, txtXML); }

SorterQuery and LagViewFields are just some quick helpers I created to help with sorting and returning fields

private XmlNode SorterQuery(string sortBy) { XmlDocument xmlDoc = new System.Xml.XmlDocument(); XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element, "Query", ""); ndQuery.InnerXml = "<OrderBy>" + "<FieldRef Name=\"" + sortBy + "\" />" + "</OrderBy>"; return ndQuery; } private XmlNode LagViewFields(string[] felter) { var xmlDoc = new System.Xml.XmlDocument(); var node = xmlDoc.CreateNode(XmlNodeType.Element, "ViewFields", ""); foreach (var s in felter) { node.InnerXml += "<FieldRef Name='" + s + "' />"; } return node; }

With this I now have access to all the elements in my list,
and further processing is just a matter of parsing xml etc.

c#: Lambda expression is not a delegate type

2010-12-28T10:24:00.002+01:00

I was changing some code from Silverlight to WPF and ran into this error:

Cannot convert lambda expression to type 'System.Windows.Threading.DispatcherPriority' because it is not a delegate type

The code was something like this

gui.BeginInvoke(
        ()=>
        {
         Orders = new ObservableCollection<Order>(x);
        }
        ,null
);

The problem is described in detail here:

http://visualstudiomagazine.com/articles/2009/02/01/use-lambda-expressions-for-abstract-delegates.aspx

The article suggests a couple of ways around this, but the best solution in my opinion is found in the comments:

Cast the lambda to an Action explicitly.

It's fast to do, easy and intuitive:

        gui.BeginInvoke(
         (Action)(()=>
             {
                         Orders = new ObservableCollection<Order>(x);
                })
                 ,null
        );

This compiles and runs fine.

Happy holidays

/Henri

c#: switch multiple values in case 1,2,3 using extension methods in(1,2,3)

2010-12-22T15:37:00.001+01:00

I want to check if a variable contains one of several values, and if so do something about it.

Here's the usual switch way:

switch (value)

{

case 1:

case 2:

case 3:

//do some stuff

break;

case 4:

case 5:

case 6:

//do some different stuff

break;

default:

//default stuff

break;

}

Does that feel ok to you?

To me it's just feels too verbose and cludgy.

In VB it's possible to write like this:

Select Case value

Case 1 To 3

'do some stuff

Case 4, 5, 6

'do some different stuff

Case Else

'default stuff

End Select

which is way more elegant.

So how do we get this in c#?

I ended up with this solution:

if(value.In(1,2,3))

{ /* do some stuff */ }

else if (value.In(4,5,6))

{ /* do some different stuff */ }

else

{ /*default stuff */ }

You likey - likey? ;)

And it's also more flexible than a switch statement.

The magic behind is just this sweet little extension method:

public static class Extensions

{

public static bool In<T>(this T t, params T[] values)

{ return values.Contains(t); }

}

Me likey

Henri

TFS: reattach solution to TFS, and compare folder to source control

2010-12-22T11:41:00.002+01:00

I recently was in a situation where I had to add and change files in a solution that was originally in TFS,

but where TFS was unavailable because of migration to new hardware.

So I removed source control bindings and programmed away.

Now the server was up again, and I wanted to add my changes back to TFS.

I opened the solution in VS 2010, right-clicked it in Solution explorer and selected Add to source-control.

That gave me a warning and asked me to use the command Change source control, as it found this solution already in TFS (the "old" version).

So I went to File - source control - Change source control, and there I could bind my solution back to TFS by selecting the projects and clicking Bind.

But this only gets my already known solution files bound to TFS.

All new files added in the meantime is not detected.

All modified files are not marked as checked out.

So I could of course try to remember what files I changed, added etc., or even get the latest version from TFS into another folder, and then do a compare from there.

But as it turns out, TFS has this capability built right in to Visual Studio, if you only know where to look.

Open up Soure Control Explorer (View - Other Windows - Source Control Explorer)

Find your solution in the tree and select it. Then click this button:

The next window will give you alternatives regarding what changes you want to find, defaults are fine with me:

Select ok, and voila!

You now get a window showing you all the files that are different, new etc, and the options to do something about it.

Great stuff, and easier than I had imagined when I started looking for it.

regards

Henri

c#: Linq/Lamba remove duplicates from list

2010-12-17T23:41:00.001+01:00

I have a list as a result of a join, and it contains duplicates.

private IEnumerable<Sak> LagListeMedSaker(IEnumerable<KorrespondanseInfo> korr, IEnumerable<Saksinfo> liste)

{

var result = from l in liste

join k in korr

on l.Saksnummer equals k.Saksnummer

select new Sak

{

Saksnr = l.Saksnummer,

Tag = l.Tag

};

return result;

}

The list korr can contain duplicates of the same Saksnummer, even though the korr liste entries are unique in it self, i.e they contain other properties that are different.

Now I want to remove duplicates of the result list.

I wanted to use .Distinct something like this:

//remove duplicates, not working (nor compiling..)

result= result.Distinct(t=>t.Saksnr);

but Distinct doesn't support Funcs, and rather requires you to create an implentation of IEqualityComparer.

Btw the default .Distinct() without parameters won't work correctly for your custom objects unless you provide correct

implementations og Equals and GetHashCode. See http://blogs.msdn.com/b/csharpfaq/archive/2009/03/25/how-to-use-linq-methods-to-compare-objects-of-custom-types.aspx

for more info if interested.

So I'm feeling lazy, and want to do this in just a line or two, what are the options?

I went with this solution someone posted at stackoverflow (lost the link sorry):

result= result.GroupBy(sak => sak.Saksnr).Select(y => y.First());

I really like this as it is really fast to implement and change according to your needs.

You can also group on multiple values by using an anonymous type, i.e:

result = result.GroupBy(sak => new { sak.Saksnr, sak.Tag }).Select(y => y.First());

See for example http://www.devcurry.com/2009/02/groupby-multiple-values-in-linq.html for full example of grouping on multiple values.

PS. I found another post using this kind of solution on stackoverflow, this contains both these concepts:

http://stackoverflow.com/questions/489258/linq-distinct-on-a-particular-property

(see post from David B)

PSPS. One could use HashSet<T> to get unique entries but that requires mostly the same as when you use .Distinct(), i.e either provide IEqualityComparer or override GetHashCode and Equals.

PSPSPS. Yes, I should have removed the duplicates before the join, …sorry :)

Silverlight: Cannot resolve TargetProperty or OMG how hard can it be to debug this cr...p

2010-09-20T16:23:00.001+02:00

Sorry for the title of this post, but a little bit frustrated after using a looong time to find out why my animations didn't work.

I tried rotating two usercontrols on a page, and I constantly got this runtime-error:

Cannot resolve TargetProperty (UIElement.Projection).(PlaneProjection.RotationY) on specified object.

My setup was a kind of Master-Detail story, where I wanted the details usercontrol to rotate in when selecting an item in my master-control.

So I already had my ViewModel, my States and Messages setup and working.

Now I just wanted to try to get that sweet rotation thingie going, and that's the part that was giving me some headache:

My VisualState was something like this:

<VisualStateManager.VisualStateGroups>

<DoubleAnimationUsingKeyFrames BeginTime="00:00:00" Storyboard.TargetName="List"

Storyboard.TargetProperty="(UIElement.Projection).(PlaneProjection.RotationY)">

<EasingDoubleKeyFrame.EasingFunction>

</EasingDoubleKeyFrame.EasingFunction>

</EasingDoubleKeyFrame>

<EasingDoubleKeyFrame.EasingFunction>

</EasingDoubleKeyFrame.EasingFunction>

</EasingDoubleKeyFrame>

</DoubleAnimationUsingKeyFrames>

<ObjectAnimationUsingKeyFrames Storyboard.TargetName="Details"

Storyboard.TargetProperty="(UIElement.Visibility)">

</ObjectAnimationUsingKeyFrames>

<ObjectAnimationUsingKeyFrames Storyboard.TargetName="List"

Storyboard.TargetProperty="(UIElement.Visibility)">

</ObjectAnimationUsingKeyFrames>

</Storyboard>

</VisualState>

…. the opposite….

</VisualState>

</VisualStateGroup>

</VisualStateManager.VisualStateGroups>

And my two Usercontrols:

<views:TilbudsListe x:Name="List">

</views:TilbudsListe>

<views:TilbudDetaljer x:Name="Details" Visibility="Collapsed">

</views:TilbudDetaljer>

When using these Storyboards, I get the aforementioned runtime-exception:

Cannot resolve TargetProperty (UIElement.Projection).(PlaneProjection.RotationY) on specified object.

I tried googling this, I checked my code, my xaml, my naming, my eyes, my keyboard…. etc but just couldn't get this to work.

Finally I saw someones examplecode, looking kind-of half finished I thought:

<Rectangle.Projection>

</Rectangle.Projection>

</Rectangle>

At first I had just thought that the empty Rectangle.Projection properties was because of some code he had tried and then forgotten to remove.

But then it struck me; could this be the "magic" needed for xaml/silverlight to put the missing properties on my usercontrols?

And it was. Here is the revised usercontrols:

<views:TilbudsListe x:Name="List">

<views:TilbudsListe.Projection>

</views:TilbudsListe.Projection>

</views:TilbudsListe>

<views:TilbudDetaljer x:Name="Details" Visibility="Collapsed">

<views:TilbudDetaljer.Projection>

</views:TilbudDetaljer.Projection>

</views:TilbudDetaljer>

This obviously (?) works, and my two views now rotate in and out.

Arrrgggggh!

I want the last two hours back! Now!!

Better luck for anyone reading this…

rgds

Henri Merkesdal

Posted via email from Henris blogg

Silverlight - templated usercontrols and automatic conversion

2010-09-17T15:37:00.001+02:00

When changing from manually defining my fields and values in xaml,

to defining a custom/templated usercontrol some of my bindings stopped working.

I created a custom control with two properties,

FeltLabel

and

FeltVerdi

FeltVerdi was defined as a textbox, and in my generic.xaml I had content bound like this:

<Setter.Value>

<Grid>

….

<TextBox Style="{StaticResource felt}"

Text="{TemplateBinding FeltVerdi />

….

</Grid>

</ControlTemplate>

</Setter.Value>

</Setter>

</Style>

This worked ok for most of the fields I bound to the ViewModel, but for a couple of fields it seemed as if the binding wasn't working anymore.

After doublechecking my code and bindings I couldn't find anything wrong, so I started to notice that the fields that wouldn't display anymore

were fields defined as numbers in my ViewModel.

It looked like the builtin automatic converters didn't work any more.

I googled it and found a post that helped me, see below.

The solution was to change the binding like this:

<Setter.Value>

<Grid>

….

<TextBox Style="{StaticResource felt}"

DataContext="{TemplateBinding FeltVerdi}" Text="{Binding}" />

….

</Grid>

</ControlTemplate>

</Setter.Value>

</Setter>

</Style>

This way automatic conversion stilll works, and my numbers etc is displaying nicely

This post helped me: http://blogs.msdn.com/b/marlat/archive/2009/05/13/silverlight-3-template-binding-vs-relative-binding.aspx

Might be helpful for others?

Rgds

Henri

Posted via email from Henris blogg

c# dependency injection -> look no interface :)

2010-06-20T14:13:00.001+02:00

So I have a class with a method that calls a webservice.

I want to bring my class under test, so I have/want to remove the dependency on the webservice.

So the usual routine is:

- create an interface around dependencies in your class (DLs, Webservicecalls etc)

- let the dependencies implement their interface

- create constructor in your class that takes in instances of the new interfaces

But I just use this one method on the ws, and if I follow this I get

- one file for the interface

- one file using partial class to expand my automatic webproxy so that it implements the interface

- either a new constructor taking in the new interface,

- or I could send it in to the method actually doing the call,
but if I use several methods on the ws I would get many small interfaces littering my code
ie one for each method I’m using on the ws

It feels a little bit like overkill for the problem I have at hand.

This has been churning in the back of my mind lately, but I have just done this the usual way with constructor injection.

Then I was reading this post: http://blacksheep.parry.org/archives/diy-di

And one of the things that caught my attention was the Provider-pattern.

(Check out step 8 if you’re interested. )

While pondering it’s implication it suddenly dawned on me a solution to my webservice-dependency.

The way I use the webservice in my method is usually something like:

private IEnumerable<Duck> GetDucks(GetDucksParam param) {

IEnumerable<Duck> result = ws.GetListOfDucks(param);

….

return result;

}

Isn’t that a perfect match for a Func<T,TResult>?

Ie:

private IEnumerable<Duck> GetDucks(GetDucksParam param, Func<GetDucksParam ,IEnumerable<Duck>> GetDucksFunction) {

IEnumerable<Duck> result = GetDucksFunction(param);

….

return result;

}

This is still just in my mind, as I haven’t tested it yet, but doesn’t it seem like it should work...?

Benefits?

- No need for an interface, the Func is defining the contract

- No partial class hacking to extend the webproxy

- No new constructor, just send in the function that is going do the actual work

- You can use a lambda in your unit-test for the Func

I think I will have to try this.

Btw I would recommend reading the full post on http://blacksheep.parry.org/archives/diy-di

It’s an interesting read, for example:

“Mock objects

Too many mock objects, or mock objects that return other mock objects, should be a code smell. Ideally a unit test won’t use any mocks or stubs or fakes or dummies. Refactor the product code using inversion of control techniques, so that all classes ask directly for the values they need, not for the intermediaries that produce those values. (Good developers have spent the last few years honing their skills with mock objects, so this advice may come as a surprise. Strong testing habits no longer require the use of sophisticated mocking libraries.) “

Rgds from

Henri

Posted via email from Henris blogg

C#: Convert List to List

2010-05-11T17:18:00.002+02:00

If I have objects that implement or inherits from a parent, I can cast them implicitly to their base class:

Here KorrespondanseParameter implements IPurrefrister:

KorrespondanseParameter k=new KorrespondanseParameter();

IPurrefrister deadline= k;

or even:

IPurrefrister deadline= new KorrespondanseParameter();

Same with this where NytegningAktoerRetur inherits from NytegningRetur:

NytegningAktoerRetur nar=new NytegningAktoerRetur();

NytegningRetur obj= nar;

Often I have some kind of List of objects that I want to cast to it something else.

One could think that this should work:

List< KorrespondanseParameter> list=new List< KorrespondanseParameter>();

List< IPurrefrister> plist=list;

or explicit:

List< IPurrefrister> plist= (List< IPurrefrister>) list;

neither compiles.

Solution with delegates:

List<KorrespondanseParamer> to List<IPurrefrister> where

public static List<IPurrefrister> LagIPurrefrister(List<KorrespondanseParameter> korr)

{

if (korr != null)

{

return korr.ConvertAll<IPurrefrister>(

delegate(KorrespondanseParameter k)

{

return k;

});

}

else

{

return null;

}

lambda:

IEnumerable<NytegningAktoerRetur> to List<NytegningRetur>

List<NytegningRetur> liste = TilbudsListe.ToList().ConvertAll<NytegningRetur>(t=> t);

Nice and short :)

rgds

Henri

Posted via email from Henris blogg

C# Handy extension methods to check if a value/object is set or not

2010-05-11T17:12:00.001+02:00

I really dislike writing these statements:

if(!string.IsNullOrEmpty(param.ID))

….something

earlier I made an extension method for this:

public static bool IsNullOrEmpty(this string test)

{

return String.IsNullOrEmpty(test);

}

which gives you nicer code like this

if(!param.ID.IsNullOrEmpty())

…. something

I usually make this as well:

public static bool IsNotNullOrEmpty(this string test)

{

return !String.IsNullOrEmpty(test);

}

giving:

if(param.ID.IsNotNullOrEmpty())

…. something

But today I was checking parameters on a webservice and started to want these methods for all my parameteres, so here goes:

public static bool IsNull(this object @object)
{
return @object == null;
}

public static bool IsNullOrDefault<T>(this T value)

{

return value.IsNull() ? true : trueEqualityComparer<T>.Default.Equals(value, default(T)) ;

}

this returns true if

object == null

int == 0

bool == false

etc.

Then I didn't quite like the way it looked in code:

if(!param.ID.IsNullOrDefault())

…. something

so I made a couple of aliases:

public static bool ErSatt<T>(this T value)

{

return value.IsNotNullOrDefault();

}

public static bool ErIkkeSatt<T>(this T value)

{

return value.IsNullOrDefault();

}

that's nice in norwegian, in english they could be named something like:

public static bool IsSet<T>(this T value)

public static bool IsNotSet<T>(this T value)

Anyhow I can now write the first line:

if(!string.IsNullOrEmpty(param.ID))

….something

like this

if(param.ID.ErSatt())

….something

or in english:

if(param.ID.IsSet())

….something

much more intuitive in my book ;)

rgds

Posted via email from Henris blogg

c#: ConvertAll with Lists

2010-03-04T13:34:00.001+01:00

Convert all members in a List from one entity to another.

I have posted before about ConvertAll, but there I used an anonymous method within ConvertAll.

I wanted to use a normal mapping-method that I could reuse, but still call it with ConvertAll.

I had to use some time to get the syntax right, and that's what this post is about.

Here is the syntax I ended up with:

List<KorrespondanseParameter> newlist = mylist.ConvertAll<KorrespondanseParameter>(new Converter<IKorrespondanseParameter,KorrespondanseParameter>(Map));

And the converter:

private static KorrespondanseParameter Map(IKorrespondanseParameter k)

{

KorrespondanseParameter r = new KorrespondanseParameter();

r.GjelderAktoerId = k.GjelderAktoerId;

r.Mottatt = k.Mottatt;

r.Oppgave = k.Oppgave;

r.Saksnummer = k.Saksnummer;

r.Sendt = k.Sendt;

return r;

}

As we can see the implementation is straightforward, nothing complex there as long as you know how to call it.

Still took me some extra time to get this right.

Rgds

Posted via email from Henris blogg

Visual studio/Sourcesafe: Remove sourcecontrol bindings

2009-12-11T15:53:00.001+01:00

If connected to sourcecontrol:

Open solution in vs,

select File - Change sourcecontrol - Unbind.

Exit Vs.

Optionally copy files and folders to a new location.

Find all files ending with *.scc (including in subfolders) and delete them.

Delete *.vssscc (mine had only one)

Remove write-protection on files.

Now they are free from Sourcesafe source-control.

Posted via email from Henris blogg

Visual Studio 2005/2008 - Open code file instead of form

2009-12-09T11:27:00.001+01:00

In VS when doubleclicking a form.cs file, default behaviour is to open Form Designer.

In my case most often I want to get to the code itself.

To set this as default:

Right-click the file in Solution Explorer and select Open With.

In the new window change to CSharp Editor (or VB if that's your thing) in stead of CSharp Form Editor.

click Set as Default, OK and your good to go.

Next time you doubleclick a form it will default to code view.

PS. you can right-click - View Designer when you want to use that,

or click the View Designer-icon on top of Solution Explorer.

Posted via email from Henris blogg

c# Infragistics ultragrid setfocus on cell

2009-12-08T14:19:00.001+01:00

Problem: We have a form with a ultragrid displaying values.

On the form is a button to add a new row to the grid.

When clicking it we want the new row to be activated and the first cell to be selected.

In this solution the button adds a row with empty values to the datasource.

So in this solution we:

1) sort grid on column "Key" ("Key" is the name of one of our columns)

myGrid.DisplayLayout.Bands[0].Columns["Key"].SortIndicator = SortIndicator.Ascending;

2)activate the new row, with the desired cell

myGrid.Rows[0].Cells["Key"].Activate();

3) open the cell for edit

myGrid.PerformAction(UltraGridAction.EnterEditMode, false, false);

Posted via email from Henris blogg

Visual Studio: Testing and deployment of files

2009-11-26T13:24:00.001+01:00

When doing unit testing in VS (2008) the default is as follows:

VS copies the compiled and all referenced assemblies to a folder named Testresults in a subfolder called something like:

username_pcname currentdatetime

If you have extra files, like for instance wse3policy.config, you need to tell vs to copy these files to the test folder, or else your tests will fail.

One way of doing it is by adding an attribute [DeploymentItem(path)] to your tests.

This will copy the files to the out folder.

You can also use menu Test - Edit Test Run configuration and from within there select Deployment and select all the files you need for your tests to run.

But today I found a third option:

Turn off Deployment.

In the same menu you selected files, you can uncheck the Deployment checkbox, and by doing this disable the entire copy assemblies and related files to a folder I really don't want issue… :)

This saves you the trouble of selecting which files you need for your tests,

it also makes your tests run a bit faster, as you don't have to wait for vs to create folders and copy all files to it for each run.

Be aware that this disables code coverage results, untill you either enable deployment again, or if you go into code coverage you will be told that to do this you need it enabled, and given the option to turn it back on.

Also note that you need to do this pr solution, as MS in their wisdom has made deployment the default, with no way to select a new default afaik.

If you have a lot of tests in your solution there is another option that can help speed things up.

Test Tools menu within Tools - Options, select Test Project and Disable background discovery of test.

This can help things speed along.

rgds

Henri

Posted via email from Henris blogg

c#/Linq: Remove duplicates in a list, using group and orderby in linq

2009-11-16T16:07:00.001+01:00

I had some really ugly code to remove duplicates in a list.

Here's my take at doing the same with linq and grouping.

Probably could be improved, but I like this way better then the ugly original.

I find it really easy to read too.

Because of the way the original was constructed, I used a couple of tries to get to this.

My first attempt used the same way of thinking as the original,

and that wasn't much prettier then the old c# 2.0 code.

private static List<NytegningAktoerRetur> GetSisteTilbudPåSammeNrLinq(List<NytegningAktoerRetur> liste)

{

var MidlertidigNrTilbud = from t in liste

group t by t.MidlertidigForsNr;

var FinListe = new List<NytegningAktoerRetur>();

foreach (var midlert in MidlertidigNrTilbud)

{

if (midlert.Count() > 1)

{

//Finn siste

var t = from tilbud in midlert

orderby FinnOppgaveID(tilbud.TilbudID) descending, tilbud.DatoRegistrert descending

select tilbud;

FinListe.Add(t.First());

}

else

FinListe.Add(midlert.First());

}

return FinListe;

}

The original is here for warning purposes only :)

Don't try this at home…:

private static void GetSisteTilbudPåSammeNr(FinnTilbudAktoerReturMelding retur, bool InkluderStartedeTilbud)

{

Dictionary<string, FinnTilbudHolder> liste = new Dictionary<string, FinnTilbudHolder>();

List<string> sakstartet = new List<string>();

FinnTilbudHolder h;

foreach (NytegningAktoerRetur r in retur.TilbudsListe)

{

int OppgaveID = FinnOppgaveID(r.TilbudID);

h = new FinnTilbudHolder();

h.Tilbud = r;

h.OppgaveID = OppgaveID;

//finn nyeste

if (liste.ContainsKey(h.Tilbud.MidlertidigForsNr))

{

//finn siste basert på oppgaveid

FinnTilbudHolder org = liste[h.Tilbud.MidlertidigForsNr];

if (OppgaveID > org.OppgaveID)

{ //denne (r) er nyest, skal erstatte org i listen

liste[h.Tilbud.MidlertidigForsNr] = h;

}

else if (org.OppgaveID > OppgaveID) //org er nyest basert på oppgaveid

{

//beholder org

}

else if (org.OppgaveID == 0 && OppgaveID == 0) //ingen oppgaveid angitt, returner nyeste på dato

{

//hvis nyerere "vinner" den (r), ellers ingen endring

if (h.Tilbud.DatoRegistrert > org.Tilbud.DatoRegistrert)

liste[h.Tilbud.MidlertidigForsNr] = h;

}

else

{

liste.Add(h.Tilbud.MidlertidigForsNr, h);

}

//husk de som har startet sak

if (!String.IsNullOrEmpty(h.Tilbud.Saksnr)) sakstartet.Add(h.Tilbud.MidlertidigForsNr);

}

if (!InkluderStartedeTilbud)

{

//fjern de som har startet sak

foreach (string forsnr in sakstartet)

{

liste.Remove(forsnr);

}

List<NytegningAktoerRetur> l = new List<NytegningAktoerRetur>();

foreach (FinnTilbudHolder f in liste.Values)

{

l.Add(f.Tilbud);

}

retur.TilbudsListe.Clear();

retur.TilbudsListe.AddRange(l.ToArray());

}

That's it for the old retarted ehh I mean retired code :)

To be fair, I also moved the code of InkluderStartedeTilbud out of this function, it goes like this:

if (!param.InkluderStartedeTilbud)

{

//Fjern startede tilbud

retur.TilbudsListe.RemoveAll(g => !String.IsNullOrEmpty(g.Saksnr));

}

I just moved it out to make the function more clear.

The refactoring to linq also allowed me to remove the FinnTilbudHolder class, as it was just used to keep record of each records id,

because it was an expensive operation to get it (ws call).

In addition and it was now easy to just get the id when I knew that there was more then one record with the same number.

I could (should) have done that with the old code too, but now it was real easy to do because of the grouping and count.

I'm happy with the new and refactored linq version, and the easy grouping, counting and sorting in linq.

Rgds

Posted via email from Henris blogg

C#/Linq : Filter a list based on From/ To dates (and IENUMERABLE to LIST)

2009-11-16T12:31:00.001+01:00

Filter my List (retur.Tilbudsliste)

based on input of from and to-dates

if (param.FromDato > DateTime.MinValue || param.ToDate > DateTime.MinValue)

{

//filter on date

var filtrert = from t in retur.TilbudsListe

where t.DateRegistered >= param.FromDate &&

(param.ToDate == DateTime.MinValue || t.DateRegistered <= param.ToDate)

select t;

retur.TilbudsListe = filtrert.ToList();

}

The result filtrert is of type Ienumerable, and is then cast to a list with:

retur.TilbudsListe = filtrert.ToList();

Note that with the check on DateTime.Minvalue we've made both inputs optional,

allowing us to specify none, one or both params.

Posted via email from Henris blogg

Team Foundation server: policy error

2009-11-06T15:58:00.001+01:00

When checking in to Team Foundation Server I got error:

TF10139

with several errors regarding policies, including:

Internal error in changeset comments policy

Solution:

Modify my Team Foundation Server Power Tools-installation

and select the Check-In Policy Pack

Team Foundation Server Power Tools can be downloaded from here: http://msdn.microsoft.com/en-us/teamsystem/bb980963.aspx

As I already have it installed I'm not sure if you have to select Custom etc when installing, but you should verify that this is selected when installing, or modify afterwards as I just did. :)

That's it.

Have a nice weekend.

Rgds

Henri

Posted via email from Henris blogg

c#: Changing a value in a dictionary in a foreach

2009-11-05T15:30:00.001+01:00

I was trying to loop through a dictionary,

update it's value if a certain condition was met,

if not remove the item from the dictionary.

(Seems I have done something lke this before, but that's why I blog it, so I can remember next time… :))

Here's my first attempt:

private void FindEditedFieldsNotWorking(Dictionary<string, string> dictionary, Control ctrl)

{

foreach (KeyValuePair<string,string> kvp in dictionary)

{

CheckBox c = ctrl.Controls["chk" + kvp.Key] as CheckBox;

if (c != null && c.Checked)

{

dictionary[kvp.Key] = ctrl.Controls[kvp.Key].Text;

}

else

dictionary.Remove(kvp.Key);

}

It compiles ok and seems ok.

Might have a misgiving with removing the item in a loop, but hey it's worth a shot..

When running this I got an exception something like

"Collection was modified; enumeration operation may not execute."

My first thought was that my dictionary.Remove was the culprit, so I put a breakpoint there.

But that was not the case (although that is not supported either in this loop)

It seems that I can't actually change the freakin' value within my foreach loop…!

So I tried the same but this time using just the keys in the loop:

private void FindEditedFieldsNotWorkingEither(Dictionary<string, string> dictionary, Control ctrl)

{

foreach (string Key in dictionary.Keys)

{

CheckBox c = ctrl.Controls["chk" + Key] as CheckBox;

if (c != null && c.Checked)

{

dictionary[Key] = ctrl.Controls[Key].Text;

}

else

dictionary.Remove(Key);

}

Still no go, same error.

Eventually I read a little bit about this using google and found that I couldn't do any changes while enumerating.

Here are some links I used:

http://stackoverflow.com/questions/1070766/editing-dictionary-values-in-a-foreach-loop

http://stackoverflow.com/questions/1562729/why-cant-we-change-values-of-a-dictionary-while-enumerating-its-keys

Seems like a bad design decision has made this a problem for many ppl.

The incling is probably the implisit add functionality when doing dict[key]=value; when key is not existing.

Anyways we have to get around this somehow.

The solution I thought was nicest when I couldn't use the "logic" solution is:

.Net 2.0

private void FindEditedFieldsWorking(Dictionary<string, string> dictionary, Control ctrl)

{

List<string> keys = new List<string>(dictionary.Keys);

foreach (string key in keys)

{

CheckBox c = ctrl.Controls["chk" + key] as CheckBox;

if (c != null && c.Checked)

{

dictionary[key] = ctrl.Controls[key].Text;

}

else

dictionary.Remove(key);

}

Almost as nice as the first version, and with the added premium that dictionary.Remove won't be a problem.

Or if you're running .Net 3.0 or higher you could just do this:

private void FindEditedFieldsWorking(Dictionary<string, string> dictionary, Control ctrl)

{

foreach (var key in dictionary.Keys.ToList())

{

CheckBox c = ctrl.Controls["chk" + key] as CheckBox;

if (c != null && c.Checked)

{

dictionary[key] = ctrl.Controls[key].Text;

}

else

dictionary.Remove(key);

}

where the ToList does the same as our 2.0 solution, namely creating a temp list to hold the keys.

Nice solution on a not so nice problem.

Hope this helps someone,

it will help me next time anyways :)

Regards

Henri Merkesdal

MERIT

Posted via email from Henris blogg

c#: Modal forms, ShowDialog and Close()

2009-10-21T14:39:00.001+02:00

In first form you want to show a modal form to user, and get some object/property back from it.

You create a new form and shows it using ShowDialog()

frmTilbud frm = new frmTilbud(t)

frm.ShowDialog();

…. some more code after frm is closed here

How do you get the object back to the first form?

You of course have the Dialogresult, but that's just a simple Ok/Cancel etc.

You could call methods and set properties on the first form, but then you wouldn't want/need the modal dialog.

You should think that when closing the modal form, you would also loose any properties etc on the modal form.

But this is the clue and solution:

even calling this.Close() in the modal form does not unload it from memory

That means you can create public properties on your modal form, and check them when it's closed again

frmTilbud frm = new frmTilbud()

frm.ShowDialog();

if (frm.MyProperty != null)

resultprop=frm.MyProperty;

..etc

This also means that you're modal dialog isn't disposed before you explicitly call dispose on it (or you exit your application)

So a good practice is this:

using (frmTilbud frm = new frmTilbud())

{

frm.ShowDialog();

if (frm.MyProperty != null)

resultprop = frm.MyProperty;

}

This disposes the form when you're finished with the curly braces.

rgds

Henri

Posted via email from Henris blogg

VSS Sourcesafe automatic logon

2009-06-24T15:01:00.001+02:00

To logon sourcesafe automaticly:

Create userenvironment

variable SSUSER value your username

the password can be specified the same way: SSPWD

spanspan

Posted via email from Henris blogg

sourcesafe share/branch

2009-06-24T13:11:00.001+02:00

How to a share/branch a project in sourcesafe.

Say I have

$/Tools/MyTool/v1.0.0

in sourcesafe.

Now I want to create

$/Tools/MyTool/v2.0.0

either by sharing (links to same copy of file) or branching (separate files, copied at branching)

Instead of doing the obvious, Rightclick v1.0.0 and select share etc here's how you do it:

1) select the place you want the files to end, in this example

$/Tools/MyTool

2) rightclick and select Share to …

3) now select your version i.e $/Tools/MyTool/v1.0.0,

and optionally select Branch after share for a separate copy

4) in the next dialog you can specify a name, in this example it should bee v2.0.0

remember to select recursive

Thank MS for not being this counterintuitive usually… :)

Happy branching

span

Posted via email from Henris blogg

Sort List

2009-06-16T11:50:00.001+02:00

Sort with a delegate:

Sorts a list by name/string

List<VomWS.Variabel> liste = new List<Variabel>();

liste.AddRange(samling.Liste);

liste.Sort(delegate(VomWS.Variabel v1, VomWS.Variabel v2) { return v1.Navn.CompareTo(v2.Navn); });

Sort with Comparer:

Sorts a list by date in descending order

List<OppgaveInformasjon> liste = HentOppgaverDA(oppgaveType, dato, AntDager);

liste.Sort(new OppgaveInformasjonDatoDescCompare());

public class OppgaveInformasjonDatoDescCompare : IComparer<VOMVariabler.VomWS.OppgaveInformasjon>

{

public int Compare(VOMVariabler.VomWS.OppgaveInformasjon x, VOMVariabler.VomWS.OppgaveInformasjon y)

{

return DateTime.Compare(y.DatoRegistrert, x.DatoRegistrert);

}

Posted via email from Henris blogg

Mouse hourglass and back

2009-06-11T09:30:00.001+02:00

public partial class frmOppgaver : Form

{

Cursor før;

private void SettMusHourglass()

{

før = this.Cursor;

this.Cursor = Cursors.WaitCursor;

}

private void SettMusTilbake()

{

this.Cursor = før;

}

Posted via email from Henris blogg

delegate find

2009-06-10T12:58:00.001+02:00

ModulSamling m = modulsamling.Find(delegate(ModulSamling ms) { return ms.ID== item.Tag; });

Instead of:

ModulSamling m=FindModul(modulsamling, item.Tag);

…

privat ModulSamling FindModul(List<ModulSamling list, string tag)

{

foreach(ModulSamling m in list)

{

if(m.ID==tag)

return m;

}

return null;

}

Posted via email from Henris blogg

Convert a list from one type to another using Predicate and ConvertAll

2009-06-05T11:25:00.002+02:00

List<Variabel> lv = new List<Variabel>();

lv.AddRange(liste);

List<string> lst = lv.ConvertAll<string>(delegate(Variabel g) { return g.Navn; });

Converts a list of objects with type Variabel,

to a list of strings.

Variabel contains a string property called Navn, and this is what gets translated to the list of strings,

{ return g.Navn)}

Posted via email from Henris blogg

Visual Studio: Design view missing for Form

2009-05-18T11:40:00.001+02:00

Recently I had a problem opening my form in Design View within Visual Studio. (C# / 2005).

Seems the problem was a corrupt project file .csproj

My form was defined in the project file as follows:

</Compile>

<DependentUpon>frmOppgaver.cs</DependentUpon>

</Compile>

…..

<SubType>Designer</SubType>

<DependentUpon>frmOppgaver.cs</DependentUpon>

</EmbeddedResource>

Somehow VS has removed a line telling it that this is a form.

To correct this I had to check out the .csproj file and open it in a text-editor.

The correct values with my addition in bold:

<SubType>Form</SubType>

</Compile>

<DependentUpon>frmOppgaver.cs</DependentUpon>

</Compile>

…

<SubType>Designer</SubType>

<DependentUpon>frmOppgaver.cs</DependentUpon>

</EmbeddedResource>

This has happened a couple of times. I suspect it is when I move my project to a different place,

or use a copy of an existing project for start of another which sums up to the same :)

Brgds Henri

Posted via email from Henris blogg

Sort a List of custom objects

2009-04-28T16:28:00.001+02:00

fakta.AddRange(retur.Fakta);

FaktaCompare c = new FaktaCompare();

fakta.Sort(c);

public class FaktaCompare : IComparer<FaktaEntitet>

{

#region IComparer<FaktaEntitet> Members

public int Compare(FaktaEntitet x, FaktaEntitet y)

{

return String.Compare(x.Key, y.Key);

}

Posted via email from Henris blogg

wse3policyCache.config and Visual Studio test-project

2009-03-25T16:54:00.001+01:00

Trying to test a project that used Webservices with WSE3

I got an exception: " Failed parsing the policy document."

while trying to set the policy.

Ie:

MyWebServiceWse ws = new MyWebServiceWse ();

ws.UseDefaultCredentials=true;

ws.SetPolicy("WebServicePolicy");

Looking closer, Innerexception told me that:

Could not find file 'C:\\Something\\MyProject\\TestResults\\username_MYPC 2009-03-25 16_40_25\\Out\\wse3policyCache.config' and more..

Which seems to mean that the Testproject is not finding the wse3policyCache.config where it's currently running.

To solve it I had to edit my localtestrun.testrunconfig, so that it copied this file to the current test-directory when it started testing.

I.e: Menu - Edit test run config - Local test run - Deployment - Add file and select the aforementioned wse3policyCache.config file.

Btw, if you are like me and only select the test from Test results and try to run or debug it,

it still doesn't work…. I had to select my testproject in Solution Explorer ,

go to menu Test and

Start selected test project (with or without Debugger)

Finally my testproject was executing with my policies…

Now only to get my bugs fixed… :)

HTH somebody

Brgds

Henri

Posted via email from Henris blogg

Winform-CAB/Smart Client Software Factory: _presenter.OnViewReady NullReferenceException

2009-01-15T09:43:00.001+01:00

When developing a module recently using Smart Client Software Factory

I got an exception I could not understand.

SCSF is using MVP- design and has some special attributes to create different objects, insert dependencies etc.

The problem was with a view and presenter using a well-used design , straight out from the wizard.

The following code is created by the Add view (with presenter) package/wizard (this is from the View):

/// <summary>

/// Sets the presenter. The dependency injection system will automatically

/// create a new presenter for you.

/// </summary>

[CreateNew]

public VisXMLPresenter Presenter

{

set

{

_presenter = value;

_presenter.View = this;

}

protected override void OnLoad(EventArgs e)

{

_presenter.OnViewReady();

}

As the comments from the wizard so beautifully states: The dependency injection system will automatically

/// create a new presenter for you

However, when running the module the OnLoad function was called before the _presenter was set,

leaving the _presenter at null, and generating the exception.

Which is very strange considering the framework/factory is handling the internal workings of generating the _presenter due to the [CreateNew] attribute. Add to that that this has been tested and used in many other modules by me and a lot others.

What was the problem? As usual, Google is my friend.

It seems that the Webbrowsercontrol I had dragged onto my form was the culprit.

This made the call to the OnLoad-function before the framework was finished doing it's magic.

The solution: add a Panel to the View/form first and add the Webbrowser to the panel.

This solves the issue until the Webbrowsercontrol itself starts behaving… :)

And here's the link I found using Googie: http://www.codeplex.com/smartclient/Thread/View.aspx?ThreadId=7559

Happy coding ;)

Posted via email from Henris blogg

Sql/sqlserver/sp/stored procedure: Ignore optional parameters in update + CRUD functionality in SP

2008-12-19T11:58:00.001+01:00

You have a Stored Procedure which can do updates.

One or more of the parameters are optional.

How do you express this?

The first solution that springs to mind is IFs.

If param1 is null

Update without param1

else

Update with param1

Another more elegant solution could be this:

Update SomeDB

SET

SomeColumn=@SomeParam,

Antall = ISNULL(@Param1,Antall) --If @Param1 is null, use the exisiting column value, i.e no update

Of course if you want to set the column to NULL this solution can't be used.

Below full stored procedure with full CRUD functionality and optional parameters:

USE [SOMEDB]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[HendelserVarslet_siud]

@FraDato DateTime = null,

@Tildato DateTime = null,

@HendelseTypeID smallint=NULL,

@HendelseInformasjonID int=NULL,

@RaadgiverNr nvarchar(50)=NULL,

@Antall int=NULL,

@Funksjon Char(1)='L'

BEGIN

SET NOCOUNT ON;

IF(@Funksjon='L' OR @Funksjon='S')

-- List records

BEGIN

-- set default dates

IF @FraDato IS NULL

SET @FraDato = dbo.StartOfday(GETDATE())

IF @Tildato IS NULL

SET @Tildato= dbo.EndOfday(@FraDato)

-- Get records

SELECT

V.HendelseInformasjonID, I.HendelseTypeID,

T.HendelseType, V.RaadgiverNr, V.Antall,

V.LoggetDato, I.Beskrivelse, I.RegistrertDato

FROM HendelseVarslet AS V

INNER JOIN

HendelseInformasjon AS I

ON V.HendelseInformasjonID=I.HendelseInformasjonID

INNER JOIN

HendelseType T

ON T.HendelseTypeId = I.HendelseTypeId

WHERE

V.LoggetDato>=@FraDato

AND

V.LoggetDato<=@TilDato

AND

(I.HendelseTypeID=@HendelseTypeID OR @HendelseTypeID IS NULL)

AND

(V.HendelseInformasjonID=@HendelseInformasjonID OR @HendelseInformasjonID IS NULL)

AND

(V.RaadgiverNr=@RaadgiverNr OR @RaadgiverNr IS NULL)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='I')

-- Insert record

BEGIN

IF (@RaadgiverNr IS NOT NULL AND @HendelseInformasjonID IS NOT NULL AND @Antall IS NOT NULL)

AND

NOT EXISTS ( SELECT HendelseinformasjonId, RaadgiverNr FROM [PFA].[dbo].HendelseVarslet

WHERE

RaadgiverNr=@RaadgiverNr AND HendelseInformasjonID=@HendelseInformasjonID)

AND

EXISTS ( SELECT HendelseinformasjonId, RaadgiverTil FROM [PFA].[dbo].Hendelse

Where (RaadgiverTil=@RaadgiverNr OR Eier=@RaadgiverNr)

AND HendelseInformasjonID=@HendelseInformasjonID )

BEGIN

INSERT INTO [PFA].[dbo].[HendelseVarslet]

(

HendelseInformasjonID,

RaadgiverNr,

Antall,

LoggetDato

)

VALUES

(

@HendelseInformasjonID,

@RaadgiverNr,

@Antall,

getdate()

)

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR(' Invalid parameters or these values already exists in db',11,1)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='U')

-- update record

BEGIN

IF (@RaadgiverNr IS NOT NULL AND @HendelseInformasjonID IS NOT NULL)

AND

(EXISTS ( SELECT HendelseinformasjonId, RaadgiverNr FROM [PFA].[dbo].HendelseVarslet

WHERE

RaadgiverNr=@RaadgiverNr AND HendelseInformasjonID=@HendelseInformasjonID)

)

BEGIN

UPDATE [PFA].[dbo].[HendelseVarslet]

SET

HendelseInformasjonID=@HendelseInformasjonID,

RaadgiverNr=@RaadgiverNr,

Antall = ISNULL(@Antall,Antall) --If @Antall IS NULL, don't update Antall column

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR(Invalid parameters or this combination of HendelseInformasjonId and rådgiver is non-existant ',11,1)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='D')

-- Delete record

BEGIN

IF EXISTS ( SELECT HendelseinformasjonId, RaadgiverNr FROM [PFA].[dbo].HendelseVarslet

WHERE

(RaadgiverNr=@RaadgiverNr AND HendelseInformasjonID=@HendelseInformasjonID)

)

AND @RaadgiverNr IS NOT NULL AND @HendelseInformasjonID IS NOT NULL

BEGIN

DELETE FROM [PFA].[dbo].[HendelseVarslet]

WHERE

HendelseInformasjonID=@HendelseInformasjonID

AND

RaadgiverNr=@RaadgiverNr

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR('Invalid parameters or this combination of HendelseInformasjonId and rådgiver is non-existant,11,1)

RETURN @@ERROR

END

ELSE

-- Unknown function

BEGIN

RAISERROR('Function unknown,11,1)

RETURN @@ERROR

END

Posted via email from Henris blogg

SQL/Sqlserver/SP/Stored procedure: Funksjon som støtter Select, Insert, Update og Delete

2008-12-17T14:45:00.001+01:00

Etter inspirasjon fra grensesnittet på en SP noen databasekolleger har laget

kommer her en Stored Procedure som har støtte for CRUD-operasjoner.

Eller SIUD på databasisk(...nytt ord:)

Ps Jeg har ingen databasekompetanse, jeg bare lager det jeg trenger akkurat der og da…

De som kan det kan helt sikkert forbedre dette :)

Enjoy:

USE [DINDATABASE]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[HentConfig]

@Valg Varchar(100) = NULL,

@Verdi Varchar(MAX) = NULL,

@Funksjon Char(1)='L'

BEGIN

SET NOCOUNT ON;

IF(@Funksjon='L')

-- List records

BEGIN

SELECT

Valg, Verdi

FROM

HendelseVarselKonfig

WHERE

(Valg=@Valg OR @Valg IS NULL)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='I')

-- Insert record

BEGIN

IF NOT EXISTS (SELECT Verdi FROM HendelseVarselKonfig

WHERE Valg=@Valg )

BEGIN

INSERT INTO HendelseVarselKonfig

(Valg, Verdi)

VALUES

(@Valg, @Verdi)

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR('Denne verdien finnes allerede',11,1)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='U')

-- update record

BEGIN

IF EXISTS (SELECT Verdi FROM HendelseVarselKonfig

WHERE Valg=@Valg )

BEGIN

UPDATE HendelseVarselKonfig

SET Verdi=@Verdi

WHERE

Valg=@Valg

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR('Denne verdien finnes ikke',11,1)

RETURN @@ERROR

END

ELSE

IF(@Funksjon='D')

-- Slett record

BEGIN

IF EXISTS (SELECT Verdi FROM HendelseVarselKonfig

WHERE Valg=@Valg )

BEGIN

DELETE FROM HendelseVarselKonfig

WHERE

Valg=@Valg

RETURN @@ERROR

END

ELSE

BEGIN

RAISERROR('Denne verdien finnes ikke',11,1)

RETURN @@ERROR

END

ELSE

-- UKJENT FUNKSJON

BEGIN

RAISERROR('Denne funksjonen finnes ikke',11,1)

RETURN @@ERROR

END

Posted via email from Henris blogg

Sql/sqlserver/sp/stored procedure: Finne alle records laget en dag

2008-12-17T13:34:00.002+01:00

Å finne start /slutt på en dag er et forholdsvis vanlig behov.

Her er to sqlscript for å lage to funksjoner som returner start og slutt på inndato.

(2 ms oppløsning på sluttdato…)

Lenger ned kan du se de i bruk:

CREATE function dbo.StartOfDay

(

@Date DATETIME

)

RETURNS DATETIME

BEGIN

RETURN DATEADD(d,DATEDIFF(d,0,@Date),0)

END

SET QUOTED_IDENTIFIER OFF

SET ANSI_NULLS ON

CREATE function dbo.EndOfDay

(

@Date DATETIME

)

RETURNS DATETIME

BEGIN

RETURN DATEADD(ms,-2,DATEADD(d,1,dbo.StartOfDay(@Date)))

END

Denne prosedyren finner default alle poster laget i dag.

Bruker funksjonene over for å finne dagen i dag sin start og slutt:

USE [ENDATABASE]

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE PROCEDURE [dbo].[HentHendelserVarslet]

-- Add the parameters for the stored procedure here

@FraDato DateTime = null,

@Tildato DateTime = null,

@HendelseTypeID smallint = null

BEGIN

IF @FraDato IS NULL

SET @FraDato = dbo.StartOfday(GETDATE())

IF @Tildato IS NULL

SET @Tildato= dbo.EndOfday(@FraDato)

SET NOCOUNT ON;

SELECT

V.HendelseInformasjonID, I.HendelseTypeID,

T.HendelseType, V.RaadgiverNr, V.Antall,

V.LoggetDato, I.Beskrivelse

FROM HendelseVarslet AS V

INNER JOIN

HendelseInformasjon AS I

ON V.HendelseInformasjonID=I.HendelseInformasjonID

INNER JOIN

HendelseType T

ON T.HendelseTypeId = I.HendelseTypeId

WHERE

V.LoggetDato>=@FraDato

AND

V.LoggetDato<=@TilDato

AND

(I.HendelseTypeID=@HendelseTypeID OR @HendelseTypeID IS NULL)

END

Posted via email from Henris blogg

Visual Studio/c#: Åpne asmx.cs fil i code editor

2008-12-17T11:16:00.001+01:00

På min Visual Studio 2008 åpner web-service codebehind-filer (asmx.cs)

seg i Design Mode når jeg dobbeltklikker de.

Det er garantert IKKE det jeg ønsker.

For å få de til å åpne seg i Code View:

i Visual Studio høyreklikk filen og velg Open With

velg CSharp Editor og klikk [Set as Default] og velg OK.

Nå kan du dobbeltklikke i vei… :)

Posted via email from Henris blogg

c#: mappe/caste automatisk fra en klasse til en annen

2008-12-16T15:39:00.001+01:00

Ved å lage en ny metode kan vi automatisk konvertere et objekt til et annet.

Uten å måtte caste eller lage egne mapping-funksjoner.

Ønsker du kun eksplisitt konvertering kan du bruke nøkkelordet explicit i stedet for i metodedefinisjonen.

(Denne koden utvider samtidig en klasse som er returnert/generert automatisk fra en Webtjeneste,

og legger til en ny metode på denne vha partial class.

Dersom du skal gjøre det må du passe på at namespacene er like for

klassen i Reference.cs og din utvidede klasse)

Eksempel:

namespace BOHjelpeklasser

{

namespace ProsesserAgent

{

/// <summary>

/// Utvider classen returnert fra ProsesserAgent med hjelpemetoder

/// </summary>

public partial class BrukerEntitetExt :Entitet

{

static public implicit operator BrukerEntitet(BrukerEntitetExt bruker)

{

var retur = new BrukerEntitet()

{

arbeidsgiver = bruker.arbeidsgiver,

brukerID = bruker.brukerID,

epostadresse = bruker.epostadresse,

etternavn = bruker.epostadresse,

fornavn = bruker.fornavn,

host = bruker.host,

ID = bruker.ID,

IsUptodate = bruker.IsUptodate,

poststed = bruker.poststed,

rådgivernummer = bruker.rådgivernummer,

Tag = bruker.Tag,

telefonnummer = bruker.telefonnummer

};

return retur;

}

Posted via email from Henris blogg

Oppdatert CookieUtil

2008-12-10T14:27:00.005+01:00

Oppdatert cookieutil som tar med brukernavn i cookie, og sletter cookie dersom dette har endret seg, dvs ny bruker har logget på samme maskin.

   1:      /// <summary>

   2:      /// util for å serialize /deserialize objekter til cookies

   3:      /// </summary>

   4:      public static class CookieUtils

   5:      {

6:

   7:          /// <summary>

   8:          /// Henter satt cookie som object, returnerer null hvis cookie ikke finnes

   9:          /// </summary>

  10:          /// <param name="navn"></param>

  11:          /// <returns></returns>

  12:          public static T GetCookie<T>(string navn) where T : class, new()

  13:          {

14:

  15:              try

  16:              {

17:

  18:                  HttpCookie c = HttpContext.Current.Request.Cookies[navn];

  19:                  if (c == null || string.IsNullOrEmpty(c.Value))

  20:                      return default(T);

21:

22:

  23:                  string[] verdier = c.Value.Split('|');

24:

25:

26:

  27:                  //fjern cookie hvis den er for en annen bruker

  28:                  string brukerident = verdier[0]; //første==brukerident

  29:                  if (brukerident != Kontroller.HentCurrentUser())

  30:                  {

  31:                      SlettCookie(navn);

  32:                      return default(T);

  33:                  }

  34:                  int n = 1; //start på 1, 0==brukerident...

  35:                  T objekt = new T();

36:

  37:                  Type type = objekt.GetType();

  38:                  //Type type = objekt.GetType();

  39:                  FieldInfo[] felter = type.GetFields();

  40:                  foreach (FieldInfo feltinf in felter)

  41:                  {

  42:                      feltinf.SetValue(objekt, verdier[n++]);

  43:                  }

44:

  45:                  PropertyInfo[] props = type.GetProperties();

  46:                  foreach (PropertyInfo propinf in props)

  47:                  {

  48:                      SetProperty(propinf, verdier[n++], objekt);

  49:                  }

50:

51:

52:

  53:                  return objekt;

  54:              }

  55:              catch (Exception ex)

  56:              {

  57:                  throw new BasisException(ex);

  58:              }

59:

60:

  61:          }

  62:          /// <summary>

  63:          /// Lager cookie av gjeldende objekt som utløper om 10 timer

  64:          /// </summary>

  65:          /// <param name="navn"></param>

  66:          /// <param name="objekt"></param>

  67:          public static void SetCookie(string navn, object objekt)

  68:          {

  69:              SetCookie(navn, objekt, DateTime.Now.AddHours(10));

  70:          }

71:

  72:          /// <summary>

  73:          /// Lager cookie av gjeldende objekt

  74:          /// </summary>

  75:          /// <param name="navn"></param>

  76:          /// <param name="objekt"></param>

  77:          /// <param name="utløper"></param>

  78:          public static void SetCookie(string navn, object objekt, DateTime utløper)

  79:          {

80:

81:

  82:              try

  83:              {

84:

  85:                  StringBuilder streng = new StringBuilder();

  86:                  streng.Append(Kontroller.HentCurrentUser() + "|");

  87:                  Type type = objekt.GetType();

  88:                  FieldInfo[] felter = type.GetFields();

  89:                  foreach (FieldInfo feltinf in felter)

  90:                  {

  91:                      if (feltinf != null)

  92:                      {

  93:                          object verdi = feltinf.GetValue(objekt);

  94:                          streng.Append(verdi.ToString() + "|");

95:

  96:                      }

  97:                  }

98:

  99:                  PropertyInfo[] props = type.GetProperties();

 100:                  foreach (PropertyInfo propinf in props)

 101:                  {

 102:                      if (propinf != null)

 103:                      {

 104:                          object verdi = propinf.GetValue(objekt, null);

 105:                          streng.Append(verdi.ToString() + "|");

 106:                      }

 107:                  }

 108:

 109:                  HttpCookie c = new HttpCookie(navn, streng.ToString());

 110:

 111:                  c.Expires = utløper;

 112:

 113:                  if (HttpContext.Current.Request.Cookies[navn] != null)

 114:                      //finnes fra før

 115:                      HttpContext.Current.Response.Cookies.Set(c);

 116:                  else

 117:                      //finnes ikke, lag ny

 118:                      HttpContext.Current.Response.Cookies.Add(c);

 119:

 120:              }

 121:              catch (Exception ex)

 122:              {

 123:                  throw new BasisException(ex);

 124:              }

 125:          }

 126:

 127:

 128:          /// <summary>

 129:          /// sletter en satt cookie

 130:          /// (resetter verdi og setter utløpsdato tilbake i tid)

 131:          /// </summary>

 132:          /// <param name="navn"></param>

 133:          public static void SlettCookie(string navn)

 134:          {

 135:              //tømmer verdi og setter utløpt for ett år siden

 136:              HttpCookie c = new HttpCookie(navn, "");

 137:              c.Expires = DateTime.Now.AddYears(-1);

 138:

 139:              if (HttpContext.Current.Request.Cookies[navn] != null)

 140:                  //finnes fra før

 141:                  HttpContext.Current.Response.Cookies.Set(c);

 142:

 143:          }

 144:

 145:

 146:

 147:

 148:

 149:          /// <summary>

 150:          /// Hjelpemetode for å sette en verdi via reflection etc

 151:          /// </summary>

 152:         /// <param name="pInfo"></param>

 153:         /// <param name="propertyValue"></param>

 154:         /// <param name="objectToSetValue"></param>

 155:          private static void SetProperty(PropertyInfo pInfo, string propertyValue, object objectToSetValue)

 156:          {

 157:              Type pType = pInfo.PropertyType;

 158:

 159:              if (pType == typeof(string))

 160:                  pInfo.SetValue(objectToSetValue, propertyValue, null);

 161:              else if (pType == typeof(bool))

 162:                  pInfo.SetValue(objectToSetValue, Convert.ToBoolean(propertyValue), null);

 163:              else if (pType == typeof(int))

 164:                  pInfo.SetValue(objectToSetValue, Convert.ToInt32(propertyValue), null);

 165:              else

 166:                  throw new NotImplementedException("Objektet har felttype som ikke er implementert enda..");

 167:          }

 168:      }

Ajax: AutoCompleteExtender

2008-12-03T13:58:00.001+01:00

Eksempel på bruk av AutoCompleteExtender fra AjaxControlToolkit:

Husk updatepanel og scriptmanager på siden.

ASPX:

Du kan bruke denne tekstboksen til å finne rådgivernummer.<br />

Skriv inn starten på rådgivers navn (minst tre tegn) for å søke:<br />

<asp:TextBox ID="TextBox1" runat="server" Width="320"></asp:TextBox>

<cc1:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="TextBox1"

ServiceMethod="FinnRadgivereListe" MinimumPrefixLength="3" CompletionInterval="1000"

EnableCaching="true" CompletionSetCount="20"

CompletionListCssClass="autocomplete_completionListElement"

CompletionListItemCssClass="autocomplete_listItem"

CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem"

</cc1:AutoCompleteExtender>

</p>

</div>

<cc1:RoundedCornersExtender BorderColor="Yellow" Radius="15" ID="round1" TargetControlID="info" runat="server">

</cc1:RoundedCornersExtender>

ASPX.CS:

[WebMethod]

[ScriptMethod]

public static string[] FinnRadgivereListe(string prefixText, int count)

{

string[] liste=null;

try

{

liste=Kontroller.FinnRadgivere(Convert.ToInt32(Kontroller.HentRadgiverNr()), prefixText, count);

}

catch

{

}

return liste;

}

CSS:

.autocomplete_completionListElement

{

visibility : hidden;

margin : 0px!important;

background-color : inherit;

color : windowtext;

border : buttonshadow;

border-width : 1px;

border-style : solid;

cursor : 'default';

overflow : auto;

text-align : left;

list-style-type : none;

}

.autocomplete_listItem

{

background-color : window;

color : windowtext;

padding : 1px;

}

.autocomplete_highlightedListItem

{

background-color: #ffff99;

color: black;

padding: 1px;

}

Posted by email from Henris blogg (posterous)

LINQ/Cast/Array/Take: Caste fra IENumerable til Array II

2008-12-02T19:03:00.001+01:00

For å f.eks konvertere et LINQ-resultatsett til en array:

CASTE til ARRAY

[WebMethod(Description="Metode for bruk av Ajax autocompleteExtension")]

public string[] FinnRadgivere(string prefixText)

{

var rslt=SokRadgiver(prefixText); //returnerer f.eks en liste med radgiverentiteter

var q = from radgiver in rslt

select new

{

radgiver.Navn

};

return q.Cast<string>().ToArray();

}

enklere variant:

[WebMethod(Description="Metode for bruk av Ajax autocompleteExtension")]

public string[] FinnRadgivere(string prefixText)

{

var rslt=SokRadgiver(prefixText);

var q = from radgiver in rslt

select radgiver.Navn;

return q.ToArray();

}

annen variant som gjør tilsvarende:

HendelseInformasjonEntitet[] q = HendelseTjeneste.HentHendelseInformasjonListe(param, out melding);

var w = from h in q

select new HendelseInformasjonRadgiverEntitet()

{

Beskrivelse = h.Beskrivelse,

EksternHendelseID = h.EksternHendelseID,

HendelseBestiller = h.HendelseBestiller,

HendelseDato = h.HendelseDato,

HendelseEier = h.HendelseEier,

HendelseEierNavn = HentRådgiver(h.HendelseEier, h.HendelseEier),

HendelseInformasjonID = h.HendelseInformasjonID,

HendelsetypeID = h.HendelsetypeID,

Status = h.Status,

Viderefordeling = h.Viderefordeling

};

return w.Cast<HendelseInformasjonRadgiverEntitet>().ToArray();

LINQ TAKE

Returner X antall poster vha Take:

[WebMethod(Description="Metode for bruk av Ajax autocompleteExtension")]

public string[] FinnRadgivere(string prefixText, int count)

{

var rslt=SokRadgiver(prefixText);

var q = from radgiver in rslt.Take(count)

select radgiver.Navn;

return q.ToArray();

}

Posted by email from Henris blogg (posterous)

Caste fra IENumerable til Array

2008-12-02T18:47:00.001+01:00

For å f.eks konvertere et LINQ-resultatsett til en array:

var rslt=SokRadgiver(bruker); //returnerer f.eks en liste med radgiverentiteter

var q = from radgiver in rslt

select new

{

radgiver.Navn

};

return q.Cast<string>().ToArray();

eller annen variant som gjør det samme:

HendelseInformasjonEntitet[] q = HendelseTjeneste.HentHendelseInformasjonListe(param, out melding);

var w = from h in q

select new HendelseInformasjonRadgiverEntitet()

{

Beskrivelse = h.Beskrivelse,

EksternHendelseID = h.EksternHendelseID,

HendelseBestiller = h.HendelseBestiller,

HendelseDato = h.HendelseDato,

HendelseEier = h.HendelseEier,

HendelseEierNavn = HentRådgiver(h.HendelseEier, h.HendelseEier),

HendelseInformasjonID = h.HendelseInformasjonID,

HendelsetypeID = h.HendelsetypeID,

Status = h.Status,

Viderefordeling = h.Viderefordeling

};

return w.Cast<HendelseInformasjonRadgiverEntitet>().ToArray();

Posted by email from Henris blogg (posterous)

Shelveset og Visual Studio/Team Foundation Server

2008-12-02T13:35:00.001+01:00

Shelveset er en fin funksjon som lar deg lagre dine endringer under sourcecontrol, uten å sjekke de inn.

Du kan deretter jobbe videre på disse filene, elller hente siste versjon fra tfs og hente shelveset tilbake senere.

Du vil imidlertid fort oppdage en liten "issue" med dette.

Dersom shelvesettet ditt inneholder utsjekkete filer (og det vil det jo som oftest),

og du senere sjekker inn alle disse filene så vil du se noe merkelig.

Alle filer som var utsjekket vil ha det ikonet som viser at noen andre har filene sjekket ut:

Og tooltipet på disse filene sier: checked out by someone else in another place e.l.

Hvis du derimot sjekker i Source Explorer vil du se at disse filene ikke er sjekket ut.

Og slik vil det altså se ut for alle som jobber mot disse filene.

Det gjør det litt vanskeligere å kjapt få oversikt over utsjekkete filer.

mer detaljer evt her (som jeg har stjålet bildet over fra): http://blogs.infosupport.com/marcelv/archive/2007/12/03/Team-Foundation-Server-2008-shows-incorrect-version-control-status-in-team-explorer-.aspx

Pr des. 2008 har jeg ikke sett en fiks på dette.

Eneste løsningen er faktisk å slette selve shelvesettet når du er ferdig med det.

Det gjør du slik:

i VS: File - Source Control - Unshelve Pending changes

du vil da få opp en liste med dine shelveset.

Her kan velge ett eller flere og trykke Delete.

(se evt her: http://msdn.microsoft.com/en-us/library/ms245473(VS.80).aspx)

Hvis du henter løsningen på nytt vil du se at tingene er tilbake til "normalt".

Posted by email from Henris blogg (posterous)

Finne hvilken kontroll som har ført til Postback av siden

2008-11-27T09:46:00.004+01:00

Av og til er det nødvendig å kunne sjekke hvilken kontrollsom førte til postback.

Det kan f.eks være en side med mange egendefinerte filtreosv, med egendefinert databinding,

hvor hvis man ventet til Eventhandleren for Button ellerDropDown så ville man måtte hente data flere ganger osv.

Page_Load har jo object sender, og hvis man googler litt serman at flere foreslår å caste sender til button.

Det virker dessverre ikke. Når en knapp har postet er detsiden selv som står som sender.

Tilsvarende foreslår mange å bruke"__EventTarget".

Det fungerer fint for dropdowns osv., men igjen, for buttonsog kusinene vil denne ikke virke. Da er eventtarget tom/""

Løsningen for Button og dens venner er (dessverre) å loopeigjennom Request.Form, caste til control, og sjekke om det er en Button.

Hvis ja kan man slutte å loope, da den eneste gangen enbutton vil være i Request.Form-samlingen er hvis det er den som Postet siden.

Krøkkete men funker.

Her er i alle fall en util for å finne kontrollen som harpostet siden:

(en kollega har laget denne, jeg har bare utvidet den med enfiks for Imagebutton)

1 public static class Utils
2 {
3
4 /// <summary>
5 /// Denne funksjonen finne hvilken kontroll som har forårsaket postback på en side.
6 /// </summary>
7 /// <param name="page">Siden vi vil finne postback for</param>
8 /// <returns>Returnerer kontroll som har forårsaket postback</returns>
9 public static Control FinnPostbackControl ( Page page )
10 {
11 Control control = null;
12
13 //Kontroll som forårsaker postback ligger i _EVENTTARGET...
14 string ctrlName = page.Request.Params.Get("__EVENTTARGET");
15 if ( !String.IsNullOrEmpty(ctrlName) )
16 {
17 control = page.FindControl(ctrlName);
18 }
19 else
20 {
21 Control c; //bruker en temp controlholder slik at control==null hvis ikke funnet
22 //...utenom Button, den ligger i Request.Form (ingen andre knapper en postback-knappen vil ligge her)
23 foreach ( string str in page.Request.Form )
24 {
25 //fix for imagebutton-kontroller
26 if (str.EndsWith(".x") || str.EndsWith(".y"))
27 {
28 string nystr = str.Substring(0, str.Length - 2);
29 c = page.FindControl(nystr);
30 if (c is ImageButton)
31 {
32 control = c;
33 break;
34 }
35 }
36 else
37 {
38 c = page.FindControl(str);
39 if (c is Button)
40 {
41 control = c;
42 break;
43 }
44 }
45 }
46 }
47
48 return control;
49 }
50

Infragistics UltraWebChart og sti til ChartImages

2008-11-25T11:31:00.002+01:00

Som default vil Infragistics opprette en ny chartImages i hver mappe hvor man har en side som benytter en chart-kontroll.

F.eks
/ChartImages
/Hendelser/ChartImages

osv.

For å styre disse mot samme mappe (f.eks når man har et cluster og må opprette en delt ressurs mellom nodene) må man endre properties for kontrollen.

Nå har UltraWebChart en property som heter ChartImagesPath.

Den er det selvfølgelig ikke…

I stedet må du lage en seksjon kalt: DeploymentScenario:

Her ser du koden jeg bruker for å samle alt i en felles mappe i rot:

<DeploymentScenario
FilePath="~/ChartImages/"
ImageURL="../ChartImages/RapportFront_#SEQNUM(100).png" />

Som du ser er det en fleksibel løsning hvor du kan angi navngivingsregler osv.

Denne vil lage bilder kalt RapportFront_0.png osv til RapportFront_99.png, deretter begynner telleren på nytt.

Tallet kan økes fra 100 til dine ønsker.

Du kan også bruke session_id i navngivingen, i kombinasjon med #seqnum, eller i stedet for.

Da heter variabelen #SESSION

For en chart-kontroll et nivå under roten vil det kunne se slik ut:

<igchart:UltraChart ID="UltraChart1" runat="server" BorderWidth="0px" Width="750px"
Version="8.2" BackColor="" ForeColor="Black" >
<DeploymentScenario
FilePath="~/ChartImages/"
ImageURL="../ChartImages/RapportFront_#SEQNUM(100).png"
/>
<Tooltips Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False"
Font-Underline="False" />
………../>

NB. i første versjon av posten hadde jeg med variabelen #EXT som erstatning for filtypen (.png i eksempelet over.)

Da den ikke virket men ga meg filnavn som faktisk sluttet med .#EXT så har jeg fjernet denne nå.

Posted by email from Henris blogg (posterous)

c#/Asp.Net: Objectdatasource

2008-11-19T14:43:00.001+01:00

Strevde med å få en Objectdatasource til å virke i Designmode.

Trikset var: bruk properties i stedet forfields i ditt Business Object.

Hvis ikke får du ikke Design-time goodness :)

Her er kode som virker:

(metoder osv er forenklet for å illustrere konseptet uten ågjøre eksempelet for stort)

.CS (bør ligge i App_Code)

Mitt dataobjekt som altså nå har properties:

public class RapportPeriode

{

public string Type {get;set;}

public int HendelseTypeID {get;set;}

public int Totalt {get;set;}

}

/*********************************************************************

denne klassen kan ikke benyttes som utgangspunktfor Objectdatasource

den har fields som verdier i stedet forproperties

public class RapportPeriode

{

public string Type;

public int HendelseTypeID;

public int Totalt;

}

*********************************************************************/

//Klasse du bruker mot Objektdatasource:

public class RapportHjelper

{

public List<RapportPeriode> GetData(int År)

{

List<RapportPeriode> liste = newList<RapportPeriode>();

RapportPeriode rad = new RapportPeriode();

rad.Type = "Totalt"

rad.HendelseTypeID = 0;

rad.Totalt = 100;

liste.Add(rad);

rad = new RapportPeriode();

rad.Type = "Noe "

rad.HendelseTypeID = 1;

rad.Totalt = 7;

liste.Add(rad);

return liste;

}

.ASPX:

<asp:GridView ID="GridView1"runat="server" DataSourceID="ds"

AutoGenerateColumns="False">

<asp:BoundFieldDataField="Type" HeaderText="Type"SortExpression="Type" />

<asp:BoundFieldDataField="HendelseTypeID" HeaderText="HendelseTypeID"

SortExpression="HendelseTypeID"Visible="false" />

<asp:BoundFieldDataField="Totalt" HeaderText="Totalt"

SortExpression="Totalt"/>

</Columns>

</asp:GridView>

<asp:ObjectDataSource

ID="ds" runat="server"

SelectMethod="GetData"

typename="RapportHjelper" >

<asp:ControlParameterControlID="lblPeriode" DefaultValue="DateTime.Now.Year"

Name="År"PropertyName="Text" Type="Int32" />

</SelectParameters>

</asp:ObjectDataSource>

Posted by email from Henris blogg (posterous)

Javascript: pause/vent til bruker er ferdig med å skrive før funksjon kalles

2008-11-12T10:31:00.001+01:00

Denne venter mens brukeren skriver, og etter en selvbestemtpause (750ms i dette tilfellet) kalles en funksjon:

(Brukes f.eks sammen med Ajax for å filtrere mens manskriver osv)

Jeg bruker denne slik på en textbox:

var count = 0;

/* kjører kun oppdatering/spørring når bruker harsluttet å skrive*/

function VentOppdater(txtbox)

{

count = count+1;

setTimeout("VentOk("+count+",'"+ txtbox.id +"','" + txtbox.value + "')",750);

}

function VentOk(currCount,myid,verdi)

{

if(currCount == count)

{

count = 0;

Oppdater(myid,verdi);

}

function Oppdater(id,verdi)

{

/*Her kjøres det filtrering etc som du ønsker skalskje når bruker har sluttet/pauset skrivingen*/

}

</script>

Posted by email from Henris blogg (posterous)

C#: Lagre objekt til cookie

2008-11-05T10:36:00.002+01:00

    /// <summary>
    /// util for å serialize /deserialize objekter til cookies
    /// </summary>
    public static class CookieUtils
    {

        /// <summary>
        /// Henter satt cookie som object, returnerer null hvis cookie ikke finnes
        /// </summary>
        /// <param name="navn"></param>
        /// <returns></returns>
        public static T GetCookie<T>(string navn) where T : class, new()
        {
            StringReader stream;

try
{

                HttpCookie c = HttpContext.Current.Request.Cookies[navn];
                if (c == null || string.IsNullOrEmpty(c.Value))
                    return default(T);

string[] verdier = c.Value.Split('|');
int n = 0;

T objekt = new T();

                Type type = objekt.GetType();
                //Type type = objekt.GetType();
                FieldInfo[] felter = type.GetFields();
                foreach (FieldInfo feltinf in felter)
                {
                    feltinf.SetValue(objekt, verdier[n++]);
                }

                PropertyInfo[] props = type.GetProperties();
                foreach (PropertyInfo propinf in props)
                {
                    SetProperty(propinf, verdier[n++], objekt);
                }

                return objekt;
            }
            catch (Exception ex)
            {
                throw new BasisException(ex);
            }

        }
        /// <summary>
        /// Lager cookie av gjeldende objekt som utløper om 10 timer
        /// </summary>
        /// <param name="navn"></param>
        /// <param name="objekt"></param>
        public static void SetCookie(string navn, object objekt)
        {
            SetCookie(navn, objekt, DateTime.Now.AddHours(10));
        }

        /// <summary>
        /// Lager cookie av gjeldende objekt
        /// </summary>
        /// <param name="navn"></param>
        /// <param name="objekt"></param>
        /// <param name="utløper"></param>
        public static void SetCookie(string navn, object objekt, DateTime utløper)
        {

try
{

                StringBuilder streng = new StringBuilder();
                Type type = objekt.GetType();
                FieldInfo[] felter = type.GetFields();
                foreach (FieldInfo feltinf in felter)
                {
                    if (feltinf != null)
                    {
                        object verdi = feltinf.GetValue(objekt);
                        streng.Append(verdi.ToString() + "|");

}
}

                PropertyInfo[] props = type.GetProperties();
                foreach (PropertyInfo propinf in props)
                {
                    if (propinf != null)
                    {
                        object verdi = propinf.GetValue(objekt, null);
                        streng.Append(verdi.ToString() + "|");
                    }
                }

HttpCookie c = new HttpCookie(navn, streng.ToString());

c.Expires = utløper;

                if (HttpContext.Current.Request.Cookies[navn] != null)
                    //finnes fra før
                    HttpContext.Current.Response.Cookies.Set(c);
                else
                    //finnes ikke, lag ny
                    HttpContext.Current.Response.Cookies.Add(c);

            }
            catch (Exception ex)
            {
                throw new BasisException(ex);
            }
        }

        /// <summary>
        /// sletter en satt cookie
        /// (resetter verdi og setter utløpsdato tilbake i tid)
        /// </summary>
        /// <param name="navn"></param>
        public static void SlettCookie(string navn)
        {
            //tømmer verdi og setter utløpt for ett år siden
            HttpCookie c = new HttpCookie(navn, "");
            c.Expires = DateTime.Now.AddYears(-1);

            if (HttpContext.Current.Request.Cookies[navn] != null)
                //finnes fra før
                HttpContext.Current.Response.Cookies.Set(c);

}

        /// <summary>
        /// Hjelpemetode for å sette en verdi via reflection etc
        /// </summary>
        /// <param name="pInfo"></param>
        /// <param name="propertyName"></param>
        /// <param name="propertyValue"></param>
        /// <param name="control"></param>
        /// <param name="objectToSetValue"></param>
        private static void SetProperty(PropertyInfo pInfo, string propertyValue, object objectToSetValue)
        {
            Type pType = pInfo.PropertyType;

            if (pType == typeof(string))
                pInfo.SetValue(objectToSetValue, propertyValue, null);
            else if (pType == typeof(bool))
                pInfo.SetValue(objectToSetValue, Convert.ToBoolean(propertyValue), null);
            else if (pType == typeof(int))
                pInfo.SetValue(objectToSetValue, Convert.ToInt32(propertyValue), null);
            else
                throw new NotImplementedException("Objektet har felttype som ikke er implementert enda..");
        }
    }

Posted by email from Henris blogg (posterous)

SQL: Oppdatere en tabell basert på en annen

2008-11-05T10:09:00.001+01:00

Setter Eier for Hendelse lik HendelseEier i tabellen HendelseInformasjon.

Merk at at en HendelseInformasjonId i HendelseInformasjon kan inneholde mange relaterte poster i Hendelse.

Alle disse vil da bli oppdatert.

UPDATE    Hendelse
SET              Eier =
                          (SELECT     HendelseEier
                            FROM          HendelseInformasjon
                            WHERE      (Hendelse.HendelseInformasjonId = HendelseInformasjonId))

Struktur:

Posted by email from Henris blogg (posterous)

SQL: Inserte flere poster samtidig

2008-10-30T14:13:00.001+01:00

Her er en måte å inserte flere records i samme insert:

INSERT INTO [Database].[dbo].[StatusType]
           ([StatusId]
           ,[HendelseTypeId]
           ,[Status]
           ,[LogtilKode]
           ,[Velgbar]
           ,[XStatus])
SELECT
15,1,'',1,0,'STARTSAK'
UNION ALL
SELECT
15,2,'',1,0,'STARTSAK'
union all
SELECT
15,3,'',1,0,'STARTSAK'
UNION ALL
SELECT
15,4,'',1,0,'STARTSAK'
UNION ALL
SELECT
15,5,'',1,0,'STARTSAK'
UNION ALL
SELECT
15,6,'',1,0,'STARTSAK'
UNION ALL

SELECT
  23,1,'Eierskifte',1,0,'EIERSKIFTE'
UNION ALL
SELECT
  23,2,'Eierskifte',1,0,'EIERSKIFTE'
union all
SELECT
  23,3,'Eierskifte',1,0,'EIERSKIFTE'
UNION ALL
SELECT
  23,4,'Eierskifte',1,0,'EIERSKIFTE'
UNION ALL
SELECT
  23,5,'Eierskifte',1,0,'EIERSKIFTE'
UNION ALL
SELECT
  23,6,'Eierskifte',1,0,'EIERSKIFTE'

union all

SELECT
  13,1,'Ok/Lest',1,0,'UNDER_ARBEID'
UNION ALL
SELECT
  13,2,'Ok/Lest',1,0,'UNDER_ARBEID'
union all
SELECT
  13,3,'Ok/Lest',1,0,'UNDER_ARBEID'
UNION ALL
SELECT
  13,4,'Ok/Lest',1,0,'UNDER_ARBEID'
UNION ALL
SELECT
  13,5,'Ok/Lest',1,0,'UNDER_ARBEID'
UNION ALL
SELECT
  13,6,'Ok/Lest',1,0,'UNDER_ARBEID'

Posted by email from Henris blogg (posterous)