mandag den 26. august 2013

Generating n number of GUID's with a TSQL query

Self-explanatory title, here's the snippet:

DECLARE @i int = 0
DECLARE @tmp_Accounts TABLE (
Id UniqueIdentifier

    SET @i = @i + 1
 INSERT INTO @tmp_Accounts (Id)
SELECT newid();

select * from @tmp_Accounts


tirsdag den 6. august 2013

Image orientation of images uploaded via fileupload control

Even though the pictures you take with your smartphone or such are in portrait orientation, when you transfer them to other systems you can't be sure their orientation will come out right. This happened to me with my iPhone: images I took when uploaded via the fileUpload control were presented in a landscape fashion, despite being shot in the portrait orientation.

The trick in getting the images back to normal is to read the EXIF orientation information off the images's property list. In the below I'll demonstrate how to do this:

byte[] imageData = new byte[fileUpload.ContentLength];
fileUpload.InputStream.Read(imageData, 0, fileUpload.ContentLength);

MemoryStream ms = new MemoryStream(imageData);
Image originalImage = Image.FromStream(ms);

if (originalImage.PropertyIdList.Contains(0x0112))
int rotationValue = originalImage.GetPropertyItem(0x0112).Value[0];
switch (rotationValue)
case 1: // landscape, do nothing

case 8: // rotated 90 right
// de-rotate:
originalImage.RotateFlip(rotateFlipType: RotateFlipType.Rotate270FlipNone);

case 3: // bottoms up
originalImage.RotateFlip(rotateFlipType: RotateFlipType.Rotate180FlipNone);

case 6: // rotated 90 left
originalImage.RotateFlip(rotateFlipType: RotateFlipType.Rotate90FlipNone);

As always, I hope this helps someone.