DELETE FROM [dbo].[Potrebnost] WHERE (([idpotrebnost] = @Original_idpotrebnost) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_minplosh = 1 AND [minplosh] IS NULL) OR ([minplosh] = @Original_minplosh)) AND ((@IsNull_maxplosh = 1 AND [maxplosh] IS NULL) OR ([maxplosh] = @Original_maxplosh)) AND ((@IsNull_minetazh = 1 AND [minetazh] IS NULL) OR ([minetazh] = @Original_minetazh)) AND ((@IsNull_maxetazh = 1 AND [maxetazh] IS NULL) OR ([maxetazh] = @Original_maxetazh)) AND ((@IsNull_minkomnat = 1 AND [minkomnat] IS NULL) OR ([minkomnat] = @Original_minkomnat)) AND ((@IsNull_maxkomnat = 1 AND [maxkomnat] IS NULL) OR ([maxkomnat] = @Original_maxkomnat)) AND ((@IsNull_mincena = 1 AND [mincena] IS NULL) OR ([mincena] = @Original_mincena)) AND ((@IsNull_maxcena = 1 AND [maxcena] IS NULL) OR ([maxcena] = @Original_maxcena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno))) INSERT INTO [dbo].[Potrebnost] ([idklient], [idrielter], [minplosh], [maxplosh], [minetazh], [maxetazh], [minkomnat], [maxkomnat], [mincena], [maxcena], [zaversheno]) VALUES (@idklient, @idrielter, @minplosh, @maxplosh, @minetazh, @maxetazh, @minkomnat, @maxkomnat, @mincena, @maxcena, @zaversheno); SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM Potrebnost WHERE (idpotrebnost = SCOPE_IDENTITY()) SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM dbo.Potrebnost UPDATE [dbo].[Potrebnost] SET [idklient] = @idklient, [idrielter] = @idrielter, [minplosh] = @minplosh, [maxplosh] = @maxplosh, [minetazh] = @minetazh, [maxetazh] = @maxetazh, [minkomnat] = @minkomnat, [maxkomnat] = @maxkomnat, [mincena] = @mincena, [maxcena] = @maxcena, [zaversheno] = @zaversheno WHERE (([idpotrebnost] = @Original_idpotrebnost) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_minplosh = 1 AND [minplosh] IS NULL) OR ([minplosh] = @Original_minplosh)) AND ((@IsNull_maxplosh = 1 AND [maxplosh] IS NULL) OR ([maxplosh] = @Original_maxplosh)) AND ((@IsNull_minetazh = 1 AND [minetazh] IS NULL) OR ([minetazh] = @Original_minetazh)) AND ((@IsNull_maxetazh = 1 AND [maxetazh] IS NULL) OR ([maxetazh] = @Original_maxetazh)) AND ((@IsNull_minkomnat = 1 AND [minkomnat] IS NULL) OR ([minkomnat] = @Original_minkomnat)) AND ((@IsNull_maxkomnat = 1 AND [maxkomnat] IS NULL) OR ([maxkomnat] = @Original_maxkomnat)) AND ((@IsNull_mincena = 1 AND [mincena] IS NULL) OR ([mincena] = @Original_mincena)) AND ((@IsNull_maxcena = 1 AND [maxcena] IS NULL) OR ([maxcena] = @Original_maxcena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno))); SELECT idpotrebnost, idklient, idrielter, minplosh, maxplosh, minetazh, maxetazh, minkomnat, maxkomnat, mincena, maxcena, zaversheno FROM Potrebnost WHERE (idpotrebnost = @idpotrebnost) DELETE FROM [dbo].[predlozhenie] WHERE (([idpredlozhenie] = @Original_idpredlozhenie) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_adres = 1 AND [adres] IS NULL) OR ([adres] = @Original_adres)) AND ((@IsNull_plosh = 1 AND [plosh] IS NULL) OR ([plosh] = @Original_plosh)) AND ((@IsNull_etazh = 1 AND [etazh] IS NULL) OR ([etazh] = @Original_etazh)) AND ((@IsNull_komnat = 1 AND [komnat] IS NULL) OR ([komnat] = @Original_komnat)) AND ((@IsNull_cena = 1 AND [cena] IS NULL) OR ([cena] = @Original_cena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno))) INSERT INTO [dbo].[predlozhenie] ([idklient], [idrielter], [adres], [plosh], [etazh], [komnat], [cena], [zaversheno]) VALUES (@idklient, @idrielter, @adres, @plosh, @etazh, @komnat, @cena, @zaversheno); SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM predlozhenie WHERE (idpredlozhenie = SCOPE_IDENTITY()) SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM dbo.predlozhenie UPDATE [dbo].[predlozhenie] SET [idklient] = @idklient, [idrielter] = @idrielter, [adres] = @adres, [plosh] = @plosh, [etazh] = @etazh, [komnat] = @komnat, [cena] = @cena, [zaversheno] = @zaversheno WHERE (([idpredlozhenie] = @Original_idpredlozhenie) AND ([idklient] = @Original_idklient) AND ([idrielter] = @Original_idrielter) AND ((@IsNull_adres = 1 AND [adres] IS NULL) OR ([adres] = @Original_adres)) AND ((@IsNull_plosh = 1 AND [plosh] IS NULL) OR ([plosh] = @Original_plosh)) AND ((@IsNull_etazh = 1 AND [etazh] IS NULL) OR ([etazh] = @Original_etazh)) AND ((@IsNull_komnat = 1 AND [komnat] IS NULL) OR ([komnat] = @Original_komnat)) AND ((@IsNull_cena = 1 AND [cena] IS NULL) OR ([cena] = @Original_cena)) AND ((@IsNull_zaversheno = 1 AND [zaversheno] IS NULL) OR ([zaversheno] = @Original_zaversheno))); SELECT idpredlozhenie, idklient, idrielter, adres, plosh, etazh, komnat, cena, zaversheno FROM predlozhenie WHERE (idpredlozhenie = @idpredlozhenie) DELETE FROM [dbo].[Sdelka] WHERE (([idsdelka] = @Original_idsdelka) AND ([idpotrebnost] = @Original_idpotrebnost) AND ([idpredlozhenie] = @Original_idpredlozhenie) AND ((@IsNull_datesdelka = 1 AND [datesdelka] IS NULL) OR ([datesdelka] = @Original_datesdelka))) INSERT INTO [dbo].[Sdelka] ([idpotrebnost], [idpredlozhenie], [datesdelka]) VALUES (@idpotrebnost, @idpredlozhenie, @datesdelka); SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM Sdelka WHERE (idsdelka = SCOPE_IDENTITY()) SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM dbo.Sdelka UPDATE [dbo].[Sdelka] SET [idpotrebnost] = @idpotrebnost, [idpredlozhenie] = @idpredlozhenie, [datesdelka] = @datesdelka WHERE (([idsdelka] = @Original_idsdelka) AND ([idpotrebnost] = @Original_idpotrebnost) AND ([idpredlozhenie] = @Original_idpredlozhenie) AND ((@IsNull_datesdelka = 1 AND [datesdelka] IS NULL) OR ([datesdelka] = @Original_datesdelka))); SELECT idsdelka, idpotrebnost, idpredlozhenie, datesdelka FROM Sdelka WHERE (idsdelka = @idsdelka) DELETE FROM [dbo].[Users] WHERE (([idusers] = @Original_idusers) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([type] = @Original_type)) INSERT INTO [dbo].[Users] ([fam], [name], [login], [password], [type], [photo]) VALUES (@fam, @name, @login, @password, @type, @photo); SELECT idusers, fam, name, login, password, type, photo FROM Users WHERE (idusers = SCOPE_IDENTITY()) SELECT idusers, fam, name, login, password, type, photo FROM dbo.Users UPDATE [dbo].[Users] SET [fam] = @fam, [name] = @name, [login] = @login, [password] = @password, [type] = @type, [photo] = @photo WHERE (([idusers] = @Original_idusers) AND ((@IsNull_fam = 1 AND [fam] IS NULL) OR ([fam] = @Original_fam)) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ([login] = @Original_login) AND ([password] = @Original_password) AND ([type] = @Original_type)); SELECT idusers, fam, name, login, password, type, photo FROM Users WHERE (idusers = @idusers)