DELETE FROM [dbo].[Customers] WHERE (([CustomerID] = @Original_CustomerID)) INSERT INTO [dbo].[Customers] ([FirstName], [LastName], [Address], [Email], [City], [CreditCard], [PhoneNumbers], [Downloads]) VALUES (@FirstName, @LastName, @Address, @Email, @City, @CreditCard, @PhoneNumbers, @Downloads) SELECT CustomerID, FirstName, LastName, Address, Email, City, CreditCard, PhoneNumbers, Downloads FROM dbo.Customers UPDATE [dbo].[Customers] SET [FirstName] = @FirstName, [LastName] = @LastName, [Address] = @Address, [Email] = @Email, [City] = @City, [CreditCard] = @CreditCard, [PhoneNumbers] = @PhoneNumbers, [Downloads] = @Downloads WHERE (([CustomerID] = @Original_CustomerID)) dbo.InsertCustomer DELETE FROM [dbo].[Films] WHERE (([FilmID] = @Original_FilmID)) INSERT INTO [dbo].[Films] ([Title], [Duration], [CategoryID], [Addingdate], [LoadingCount], [Price], [Description], [Cover], [Url]) VALUES (@Title, @Duration, @CategoryID, @Addingdate, @LoadingCount, @Price, @Description, @Cover, @Url) SELECT FilmID, Title, Duration, CategoryID, Addingdate, LoadingCount, Price, Description, Cover, Url FROM dbo.Films UPDATE [dbo].[Films] SET [Title] = @Title, [Duration] = @Duration, [CategoryID] = @CategoryID, [Addingdate] = @Addingdate, [LoadingCount] = @LoadingCount, [Price] = @Price, [Description] = @Description, [Cover] = @Cover, [Url] = @Url WHERE (([FilmID] = @Original_FilmID)) dbo.InsertFilm DELETE FROM [dbo].[Orders] WHERE (([FilmID] = @Original_FilmID) AND ([CustomerID] = @Original_CustomerID)) INSERT INTO [dbo].[Orders] ([FilmID], [CustomerID], [DownloadDate]) VALUES (@FilmID, @CustomerID, @DownloadDate) SELECT FilmID, CustomerID, DownloadDate FROM dbo.Orders UPDATE [dbo].[Orders] SET [FilmID] = @FilmID, [CustomerID] = @CustomerID, [DownloadDate] = @DownloadDate WHERE (([FilmID] = @Original_FilmID) AND ([CustomerID] = @Original_CustomerID))