Hello,
Thank you very much for dwelling on my project, yes indeed I have already done this procedure but I am a photographer and I am trying to create a sales site for my photographs.
But in my case the same photo could have several different prices depending on its size and the type of printing.
Unfortunately I do not know how to build the necessary tables according to these criteria that my client can do.
I built my page a bit like this :(Example)
The final price would be displayed on the screen, in a tag (p)
<p id="ReturnPrice" class="card-text p-3 mb-2 bg-secondary text-white">
Here will be displayed the Price
</p>
It is very easy for me to recover the sum even in hidden session or sessionstorage style with jquery without taking the value that is displayed on the screen.
I tried to add 3 tables like this but it doesn't work, I don't have experience... here it is :
[dbo].[Gammes] = ranges (type of print)
[dbo].[Tailles] = sizes (four different sizes)
[dbo].[TableTarifs] = price table (combined the different prices)
create database Bdd_Album_Photos;
use Bdd_Album_Photos;
CREATE TABLE [dbo].[__MigrationHistory] (
[MigrationId] NVARCHAR (150) NOT NULL,
[ContextKey] NVARCHAR (300) NOT NULL,
[Model] VARBINARY (MAX) NOT NULL,
[ProductVersion] NVARCHAR (32) NOT NULL,
CONSTRAINT [PK_dbo.__MigrationHistory] PRIMARY KEY CLUSTERED ([MigrationId] ASC, [ContextKey] ASC)
);
CREATE TABLE [dbo].[Albums] (
[AlbumId] INT IDENTITY (1, 1) NOT NULL,
[CategorieId] INT NOT NULL,
[PhotoId] INT NOT NULL,
[TableTarifId] INT NULL,
[Title] NVARCHAR (MAX) NULL,
[Prix] DECIMAL (18, 2) NOT NULL,
[UrlMiniature] NVARCHAR (1024) CONSTRAINT [UrlMiniature] DEFAULT (N'/Content/Images/placeholder.gif') NULL
);
CREATE TABLE [dbo].[Carts] (
[RecordId] INT IDENTITY (1, 1) NOT NULL,
[CartId] NVARCHAR (MAX) NULL,
[AlbumId] INT NOT NULL,
[Count] INT NOT NULL,
[DateCreated] DATETIME NOT NULL
);
CREATE TABLE [dbo].[Categories] (
[CategorieId] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (MAX) NULL,
[Description] NVARCHAR (MAX) NULL
);
CREATE TABLE [dbo].[OrderDetails] (
[OrderDetailId] INT IDENTITY (1, 1) NOT NULL,
[OrderId] INT NOT NULL,
[AlbumId] INT NOT NULL,
[Quantity] INT NOT NULL,
[UnitPrice] DECIMAL (18, 2) NOT NULL
);
CREATE TABLE [dbo].[Orders] (
[OrderId] INT IDENTITY (1, 1) NOT NULL,
[OrderDate] DATETIME NOT NULL,
[Username] NVARCHAR (MAX) NULL,
[FirstName] NVARCHAR (160) NOT NULL,
[LastName] NVARCHAR (160) NOT NULL,
[Address] NVARCHAR (70) NOT NULL,
[City] NVARCHAR (40) NOT NULL,
[State] NVARCHAR (40) NOT NULL,
[PostalCode] NVARCHAR (10) NOT NULL,
[Country] NVARCHAR (40) NOT NULL,
[Phone] NVARCHAR (24) NOT NULL,
[Email] NVARCHAR (MAX) NOT NULL,
[Total] DECIMAL (18, 2) NOT NULL
);
CREATE TABLE [dbo].[Photos] (
[PhotoId] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (MAX) NULL
);
CREATE TABLE [dbo].[Gammes] (
[GammeId] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (MAX) NOT NULL,
);
CREATE TABLE [dbo].[Tailles] (
[TailleId] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (10) NOT NULL
);
CREATE TABLE [dbo].[TableTarifs] (
[TableTarifId] INT IDENTITY (1, 1) NOT NULL,
[GammeId] INT NOT NULL,
[TailleId] INT NOT NULL,
[PrixUnit] DECIMAL (10, 2) NOT NULL
);
alter table [dbo].[Gammes] add constraint [Pk_Gamme] primary key CLUSTERED ([GammeId] ASC);
alter table [dbo].[Tailles] add constraint [Pk_Taille] primary key CLUSTERED ([TailleId] ASC);
alter table [dbo].[TableTarifs] add constraint [Pk_TableTarif] primary key CLUSTERED ([TableTarifId] ASC);
alter table [dbo].[Albums] add constraint [Pk_Album] primary key CLUSTERED ([AlbumId] ASC);
alter table [dbo].[Carts] add constraint [Pk_Cart] primary key ([RecordId] ASC);
alter table [dbo].[Categories] add constraint [Pk_Categorie] primary key CLUSTERED ([CategorieId] ASC);
alter table [dbo].[Orders] add constraint [Pk_Order] primary key CLUSTERED ([OrderId] ASC);
alter table [dbo].[OrderDetails] add constraint [Pk_OrderDetail] primary key CLUSTERED ([OrderDetailId] ASC);
alter table [dbo].[Photos] add constraint [Pk_Photo] primary key CLUSTERED ([PhotoId] ASC);
alter table [dbo].[Albums] add constraint Fk_AlbumTableTarif foreign key ([TableTarifId]) references [dbo].[TableTarifs]([TableTarifId]);
alter table [dbo].[TableTarifs] add constraint Fk_TableTarifGamme foreign key ([GammeId]) references [dbo].[Gammes]([GammeId]) ON DELETE CASCADE;
alter table [dbo].[TableTarifs] add constraint Fk_TableTarifTaille foreign key ([TailleId]) references [dbo].[Tailles]([TailleId]) ON DELETE CASCADE;
alter table [dbo].[Albums] add constraint Fk_AlbumCategorie foreign key ([CategorieId]) references [dbo].[Categories]([CategorieId]) ON DELETE CASCADE;
alter table [dbo].[Albums] add constraint Fk_AlbumPhoto foreign key ([PhotoId]) references [dbo].[Photos]([PhotoId]) ON DELETE CASCADE;
alter table [dbo].[OrderDetails] add constraint Fk_OrderDetailAlbum foreign key ([AlbumId]) references [dbo].[Albums]([AlbumId]) ON DELETE CASCADE;
alter table [dbo].[OrderDetails] add constraint Fk_OrderDetailOrder foreign key ([OrderId]) references [dbo].[Orders]([OrderId]) ON DELETE CASCADE;
alter table [dbo].[Carts] add constraint Fk_CartAlbum foreign key ([AlbumId]) references [dbo].[Albums]([AlbumId]) ON DELETE CASCADE;
SET IDENTITY_INSERT [dbo].[Gammes] ON
INSERT [dbo].[Gammes] ([GammeId], [Name]) VALUES (1, N'Mat')
INSERT [dbo].[Gammes] ([GammeId], [Name]) VALUES (2, N'Brillant')
INSERT [dbo].[Gammes] ([GammeId], [Name]) VALUES (3, N'PhotoRicePaper')
INSERT [dbo].[Gammes] ([GammeId], [Name]) VALUES (4, N'FineArtClassique')
INSERT [dbo].[Gammes] ([GammeId], [Name]) VALUES (5, N'FineArtPrestige')
SET IDENTITY_INSERT [dbo].[Gammes] OFF
SET IDENTITY_INSERT [dbo].[Tailles] ON
INSERT [dbo].[Tailles] ([TailleId], [Name]) VALUES (1, N'20x30')
INSERT [dbo].[Tailles] ([TailleId], [Name]) VALUES (2, N'30x40')
INSERT [dbo].[Tailles] ([TailleId], [Name]) VALUES (3, N'40x50')
INSERT [dbo].[Tailles] ([TailleId], [Name]) VALUES (4, N'50x70')
SET IDENTITY_INSERT [dbo].[Tailles] OFF
SET IDENTITY_INSERT [dbo].[TableTarifs] ON
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (1, 1, 1, CAST(25.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (2, 1, 2, CAST(30.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (3, 1, 3, CAST(35.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (4, 1, 4, CAST(40.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (5, 2, 1, CAST(30.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (6, 2, 2, CAST(35.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (7, 2, 3, CAST(40.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (8, 2, 4, CAST(45.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (9, 3, 1, CAST(35.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (10, 3, 2, CAST(40.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (11, 3, 3, CAST(45.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (12, 3, 4, CAST(50.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (13, 4, 1, CAST(40.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (14, 4, 2, CAST(45.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (15, 4, 3, CAST(55.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (16, 4, 4, CAST(65.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (17, 5, 1, CAST(45.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (18, 5, 2, CAST(55.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (19, 5, 3, CAST(65.00 AS Numeric(10, 2)))
INSERT [dbo].[TableTarifs] ([TableTarifId], [GammeId], [TailleId], [PrixUnit]) VALUES (20, 5, 4, CAST(80.00 AS Numeric(10, 2)))
SET IDENTITY_INSERT [dbo].[TableTarifs] OFF
SET IDENTITY_INSERT [dbo].[Categories] ON
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (1, N'Animaux', N'Description sur les Animaux.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (2, N'Humain', N'Description sur les Humain.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (3, N'Mécanique', N'Description sur les Mécanique.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (4, N'Nature', N'Description sur les Nature.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (5, N'Oiseaux', N'Description sur les Oiseaux.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (6, N'Paysage', N'Description sur les Paysage.')
INSERT [dbo].[Categories] ([CategorieId], [Name], [Description]) VALUES (7, N'Création', N'Description sur les Création.')
SET IDENTITY_INSERT [dbo].[Categories] OFF
SET IDENTITY_INSERT [dbo].[Photos] ON
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (1, N'PB161252')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (2, N'PB181614')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (3, N'PC021603')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (4, N'PC032156')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (5, N'PC021504')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (6, N'PC052829')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (7, N'PC021509')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (8, N'PC073087')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (9, N'PC073147')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (10, N'PC073132')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (11, N'PC073161')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (12, N'PC052777')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (13, N'PC042304')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (14, N'PC021645')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (15, N'PB301087')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (16, N'PB191730')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (17, N'PC083415')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (18, N'PB181618')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (19, N'PB181688')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (20, N'PB140979')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (21, N'PB080213')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (22, N'PB140964')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (23, N'PB140985')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (24, N'PB100387')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (25, N'PB100390')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (26, N'PB120656')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (27, N'PB120661')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (28, N'PB120668')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (29, N'PC052903')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (30, N'PC062980')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (31, N'PC083325')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (32, N'PB270714')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (33, N'PB260677')
INSERT [dbo].[Photos] ([PhotoId], [Name]) VALUES (34, N'PB270736')
SET IDENTITY_INSERT [dbo].[Photos] OFF
SET IDENTITY_INSERT [dbo].[Albums] ON
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (1, 6, 29, N'Beauté des couleurs sur la rivière Okavango, Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (2, 6, 30, N'Coucher de soleil sur la rivière Chobe, Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (3, 6, 31, N'Chutes Victoria sur le fleuve Zambèze, frontière naturelle Zimbabwe et Zambie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (4, 6, 32, N'Sossusvlei désert du namib, Namibie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (5, 6, 33, N'Désert du namib, Namibie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (6, 6, 34, N'Désert du namib, Namibie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (7, 5, 26, N'Aras de Macao Sur la côte pacifique du Costa Rica, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (8, 5, 27, N'Aras de Macao Sur la côte pacifique du Costa Rica, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (9, 5, 28, N'Toucan à carène, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (10, 4, 18, N'Le maïs, sept mille ans d histoire.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (11, 4, 19, N'Marché de San Cristóbal de Las Casas, Méxique.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (12, 4, 20, N'Lotus du Costa Rica, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (13, 4, 21, N'30m de haut pour ce Ceiba Pentandra de 400 ans, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (14, 4, 22, N'Nymphée odorante du Costa Rica, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (15, 4, 23, N'Forêt tropicale humide du Costa Rica, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (16, 4, 24, N'Orchidée, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (17, 4, 25, N'Orchidée, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (18, 3, 17, N'Traversée du pont Darwin entre le Zimbabwe et la Zambie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (19, 3, 16, N'Trucks of Guatemala.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (20, 2, 15, N'Enfants Himbas, peuple autochtone bantou, Namibie.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (21, 1, 1, N'Crocodile américain dans le chiapas, Amérique Centrale.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (22, 1, 2, N'Chat-thérapie, méditation et zenitude.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (23, 1, 3, N'Le grand koudou, Afrique du Sud.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (24, 1, 4, N'Rhinocéros blanc, Afrique du Sud.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (25, 1, 5, N'Zèbres dans le désert du Kalahari au Sud du Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (26, 1, 6, N'Hippopotame au nord du delta de l Okavango, Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (27, 1, 7, N'Zèbres dans le désert du Kalahari au Sud du Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (28, 1, 8, N'Chobe National Park, le royaume des éléphants, Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (29, 1, 9, N'Phacochères commun, Afrique du Sud.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (30, 1, 10, N'Girafe du Sud dans le parc de Chobe, Botswana.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (31, 1, 11, N'Le plus grand lézard d Afrique, le Varan du Nil.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (32, 7, 14, N'Éléphant de savane d Afrique.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (33, 7, 13, N'Damalisque à front blanc (Blesbok), Afrique du Sud.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
INSERT [dbo].[Albums] ([AlbumId], [CategorieId], [PhotoId], [Title], [Prix], [UrlMiniature]) VALUES (34, 7, 12, N'L hippopotame menaçant et menacé, Afrique.', CAST(1.00 AS Numeric(10, 2)), N'/Content/Images/placeholder.gif')
SET IDENTITY_INSERT [dbo].[Albums] OFF
Thanks for your help..