Odd issue with Inserting photos

Reply

Member

6 Points

Odd issue with Inserting photos

Feb 10, 2009 10:03 PM|nimish|LINK

I upload pictures to the default upload folder at web root. But when I see the contents - I only see image files by the name 0. like 0.Lg.jpg, 0.Md.jpg, 0.Sm.jpg. Then when I upload another image, it would overwrite existing 0 files. So in other words I see only 0 files.. just 3 files.

When I debug this issue, found that in photo.cs file, the db.insertphoto always returns photoid= 0. This is coming from the dataadapter. When I run the method manually from the ads.xsd, it returns the correct photoid. The stored procedure also returns correct value. For some reasons, Line 13 always returns 0.

Can anyone help?

public static int InsertPhoto(int adId, byte[] bytesFull, byte[] bytesMedium, byte[] bytesSmall, bool useAsPreview)
        {
            int photoId = -1;
            if (bytesFull != null && bytesMedium != null && bytesSmall != null)
            {
                SiteSettings s = SiteSettings.GetSharedSettings();
                using (PhotosDataAdapter db = new PhotosDataAdapter())
                {
                    if (s.StorePhotosInDatabase)
                        photoId = Convert.ToInt32(db.InsertPhoto(adId, bytesFull, bytesMedium, bytesSmall, useAsPreview, DateTime.Now));
                    else
                    {
                        photoId = Convert.ToInt32(db.InsertPhoto(adId, null, null, null, useAsPreview, DateTime.Now));


                        string fullSizePath = GetFilePath(photoId, false, PhotoSize.Full);
                        string mediumSizePath = GetFilePath(photoId, false, PhotoSize.Medium);
                        string smallSizePath = GetFilePath(photoId, false, PhotoSize.Small);


                        WriteToFile(fullSizePath, bytesFull);
                        WriteToFile(mediumSizePath, bytesMedium);
                        WriteToFile(smallSizePath, bytesSmall);


                    }
                }
            }
            return photoId;
        }

Reply

darkknight18...

Participant

1165 Points

1035 Posts

Re: Odd issue with Inserting photos

Feb 12, 2009 11:49 PM|darkknight187|LINK

The problem is that you are using the beta version of the classifieds kit instead of the final version.

The problem lies in your stored procedure InsertPhoto
Not the public static you have above.

Open the InsertPhoto Stored Procedure and I forget what it says in your version.
But the issue is at the end of it.

Try this:

SELECT @Id AS [Id]

If it doesn't work paste your stored procedure.

Good Luck

- Daniel

Web: www.Detelli.com
Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.

Reply

nimish

Member

6 Points

214 Posts

Re: Odd issue with Inserting photos

Feb 13, 2009 08:29 PM|nimish|LINK

I downloaded the kit from asp.net starter kit section. If I run the method in dataset, it returns correct value.

Below is SP my code-

ALTER PROCEDURE InsertPhoto
@AdId int,
@BytesFull image = NULL,
@BytesMedium image = NULL,
@BytesSmall image = NULL,
@IsMainPreview bit = 0,
@DateCreated smalldatetime = getdate
AS
DECLARE @Id int;
INSERT Photos
(AdId, BytesFull, BytesMedium, BytesSmall, IsMainPreview, DateCreated)
VALUES
(@AdId, @BytesFull, @BytesMedium, @BytesSmall, @IsMainPreview, @DateCreated)
SET @Id = @@IDENTITY;


IF @IsMainPreview = 1
UPDATE Ads SET PreviewImageId = @Id WHERE Id = @AdId


RETURN @Id