DELETE FROM [Trattative] WHERE (([CodTrattativa] = @Original_CodTrattativa) AND ([Data] = @Original_Data) AND ([codiceCliente] = @Original_codiceCliente) AND ([Descrizione] = @Original_Descrizione) AND ([Referente] = @Original_Referente) AND ([BasePath] = @Original_BasePath)) INSERT INTO [Trattative] ([CodTrattativa], [Data], [codiceCliente], [Descrizione], [Referente], [BasePath]) VALUES (@CodTrattativa, @Data, @codiceCliente, @Descrizione, @Referente, @BasePath); SELECT CodTrattativa, Data, codiceCliente, Descrizione, Referente, BasePath FROM Trattative WHERE (CodTrattativa = @CodTrattativa) SELECT * FROM Trattative UPDATE [Trattative] SET [CodTrattativa] = @CodTrattativa, [Data] = @Data, [codiceCliente] = @codiceCliente, [Descrizione] = @Descrizione, [Referente] = @Referente, [BasePath] = @BasePath WHERE (([CodTrattativa] = @Original_CodTrattativa) AND ([Data] = @Original_Data) AND ([codiceCliente] = @Original_codiceCliente) AND ([Descrizione] = @Original_Descrizione) AND ([Referente] = @Original_Referente) AND ([BasePath] = @Original_BasePath)); SELECT CodTrattativa, Data, codiceCliente, Descrizione, Referente, BasePath FROM Trattative WHERE (CodTrattativa = @CodTrattativa) DELETE FROM [DocCom] WHERE (([CodDocCom] = @Original_CodDocCom) AND ([CodTrattativa] = @Original_CodTrattativa) AND ([NumDoc] = @Original_NumDoc) AND ([DocType] = @Original_DocType) AND ([Data] = @Original_Data) AND ([CodBasket] = @Original_CodBasket) AND ([DocPath] = @Original_DocPath)) INSERT INTO [DocCom] ([CodDocCom], [CodTrattativa], [NumDoc], [DocType], [Data], [CodBasket], [DocPath]) VALUES (@CodDocCom, @CodTrattativa, @NumDoc, @DocType, @Data, @CodBasket, @DocPath); SELECT CodDocCom, CodTrattativa, NumDoc, DocType, Data, CodBasket, DocPath FROM DocCom WHERE (CodDocCom = @CodDocCom) SELECT * FROM DocCom UPDATE [DocCom] SET [CodDocCom] = @CodDocCom, [CodTrattativa] = @CodTrattativa, [NumDoc] = @NumDoc, [DocType] = @DocType, [Data] = @Data, [CodBasket] = @CodBasket, [DocPath] = @DocPath WHERE (([CodDocCom] = @Original_CodDocCom) AND ([CodTrattativa] = @Original_CodTrattativa) AND ([NumDoc] = @Original_NumDoc) AND ([DocType] = @Original_DocType) AND ([Data] = @Original_Data) AND ([CodBasket] = @Original_CodBasket) AND ([DocPath] = @Original_DocPath)); SELECT CodDocCom, CodTrattativa, NumDoc, DocType, Data, CodBasket, DocPath FROM DocCom WHERE (CodDocCom = @CodDocCom) DELETE FROM [Listino] WHERE (([CodItem] = @Original_CodItem) AND ([ResType] = @Original_ResType) AND ([UM] = @Original_UM) AND ([Descrizione] = @Original_Descrizione) AND ([UnitCost] = @Original_UnitCost) AND ([UnitPrice] = @Original_UnitPrice)) INSERT INTO [Listino] ([CodItem], [ResType], [UM], [Descrizione], [UnitCost], [UnitPrice]) VALUES (@CodItem, @ResType, @UM, @Descrizione, @UnitCost, @UnitPrice); SELECT CodItem, ResType, UM, Descrizione, UnitCost, UnitPrice FROM Listino WHERE (CodItem = @CodItem) SELECT * FROM Listino UPDATE [Listino] SET [CodItem] = @CodItem, [ResType] = @ResType, [UM] = @UM, [Descrizione] = @Descrizione, [UnitCost] = @UnitCost, [UnitPrice] = @UnitPrice WHERE (([CodItem] = @Original_CodItem) AND ([ResType] = @Original_ResType) AND ([UM] = @Original_UM) AND ([Descrizione] = @Original_Descrizione) AND ([UnitCost] = @Original_UnitCost) AND ([UnitPrice] = @Original_UnitPrice)); SELECT CodItem, ResType, UM, Descrizione, UnitCost, UnitPrice FROM Listino WHERE (CodItem = @CodItem) DELETE FROM [Risorse] WHERE (([IdxRes] = @Original_IdxRes) AND ([CodDocCom] = @Original_CodDocCom) AND ([Ordinal] = @Original_Ordinal) AND ([CodItem] = @Original_CodItem) AND ([Qty] = @Original_Qty) AND ([QtyOffered] = @Original_QtyOffered) AND ([UnitPriceOffered] = @Original_UnitPriceOffered)) INSERT INTO [Risorse] ([CodDocCom], [Ordinal], [CodItem], [Qty], [QtyOffered], [UnitPriceOffered]) VALUES (@CodDocCom, @Ordinal, @CodItem, @Qty, @QtyOffered, @UnitPriceOffered); SELECT IdxRes, CodDocCom, Ordinal, CodItem, Qty, QtyOffered, UnitPriceOffered FROM Risorse WHERE (IdxRes = SCOPE_IDENTITY()) SELECT * FROM Risorse UPDATE [Risorse] SET [CodDocCom] = @CodDocCom, [Ordinal] = @Ordinal, [CodItem] = @CodItem, [Qty] = @Qty, [QtyOffered] = @QtyOffered, [UnitPriceOffered] = @UnitPriceOffered WHERE (([IdxRes] = @Original_IdxRes) AND ([CodDocCom] = @Original_CodDocCom) AND ([Ordinal] = @Original_Ordinal) AND ([CodItem] = @Original_CodItem) AND ([Qty] = @Original_Qty) AND ([QtyOffered] = @Original_QtyOffered) AND ([UnitPriceOffered] = @Original_UnitPriceOffered)); SELECT IdxRes, CodDocCom, Ordinal, CodItem, Qty, QtyOffered, UnitPriceOffered FROM Risorse WHERE (IdxRes = @IdxRes) DELETE FROM [Baskets] WHERE (([CodBasket] = @Original_CodBasket) AND ([Data] = @Original_Data) AND ([codiceCliente] = @Original_codiceCliente) AND ([Descrizione] = @Original_Descrizione)) INSERT INTO [Baskets] ([CodBasket], [Data], [codiceCliente], [Descrizione]) VALUES (@CodBasket, @Data, @codiceCliente, @Descrizione); SELECT CodBasket, Data, codiceCliente, Descrizione FROM Baskets WHERE (CodBasket = @CodBasket) SELECT * FROM Baskets UPDATE [Baskets] SET [CodBasket] = @CodBasket, [Data] = @Data, [codiceCliente] = @codiceCliente, [Descrizione] = @Descrizione WHERE (([CodBasket] = @Original_CodBasket) AND ([Data] = @Original_Data) AND ([codiceCliente] = @Original_codiceCliente) AND ([Descrizione] = @Original_Descrizione)); SELECT CodBasket, Data, codiceCliente, Descrizione FROM Baskets WHERE (CodBasket = @CodBasket) DELETE FROM [Fatture] WHERE (([IdxFatt] = @Original_IdxFatt) AND ((@IsNull_anno = 1 AND [anno] IS NULL) OR ([anno] = @Original_anno)) AND ((@IsNull_num = 1 AND [num] IS NULL) OR ([num] = @Original_num)) AND ((@IsNull_idxCli = 1 AND [idxCli] IS NULL) OR ([idxCli] = @Original_idxCli)) AND ((@IsNull_tipo = 1 AND [tipo] IS NULL) OR ([tipo] = @Original_tipo)) AND ([emesso] = @Original_emesso) AND ([ritenuta] = @Original_ritenuta) AND ([scelta] = @Original_scelta) AND ((@IsNull_dataPagam = 1 AND [dataPagam] IS NULL) OR ([dataPagam] = @Original_dataPagam)) AND ([Id] = @Original_Id) AND ([data] = @Original_data) AND ((@IsNull_scadenza = 1 AND [scadenza] IS NULL) OR ([scadenza] = @Original_scadenza)) AND ([token] = @Original_token) AND ([new_id] = @Original_new_id) AND ([dtEvent] = @Original_dtEvent) AND ([CodDocCom] = @Original_CodDocCom) AND ([changed] = @Original_changed)) INSERT INTO [Fatture] ([anno], [num], [idxCli], [tipo], [emesso], [ritenuta], [scelta], [dataPagam], [token], [new_id], [dtEvent], [CodDocCom], [changed]) VALUES (@anno, @num, @idxCli, @tipo, @emesso, @ritenuta, @scelta, @dataPagam, @token, @new_id, @dtEvent, @CodDocCom, @changed); SELECT IdxFatt, anno, num, idxCli, tipo, emesso, ritenuta, scelta, dataPagam, Id, data, scadenza, token, new_id, dtEvent, CodDocCom, changed FROM Fatture WHERE (IdxFatt = SCOPE_IDENTITY()) SELECT * FROM Fatture UPDATE [Fatture] SET [anno] = @anno, [num] = @num, [idxCli] = @idxCli, [tipo] = @tipo, [emesso] = @emesso, [ritenuta] = @ritenuta, [scelta] = @scelta, [dataPagam] = @dataPagam, [token] = @token, [new_id] = @new_id, [dtEvent] = @dtEvent, [CodDocCom] = @CodDocCom, [changed] = @changed WHERE (([IdxFatt] = @Original_IdxFatt) AND ((@IsNull_anno = 1 AND [anno] IS NULL) OR ([anno] = @Original_anno)) AND ((@IsNull_num = 1 AND [num] IS NULL) OR ([num] = @Original_num)) AND ((@IsNull_idxCli = 1 AND [idxCli] IS NULL) OR ([idxCli] = @Original_idxCli)) AND ((@IsNull_tipo = 1 AND [tipo] IS NULL) OR ([tipo] = @Original_tipo)) AND ([emesso] = @Original_emesso) AND ([ritenuta] = @Original_ritenuta) AND ([scelta] = @Original_scelta) AND ((@IsNull_dataPagam = 1 AND [dataPagam] IS NULL) OR ([dataPagam] = @Original_dataPagam)) AND ([Id] = @Original_Id) AND ([data] = @Original_data) AND ((@IsNull_scadenza = 1 AND [scadenza] IS NULL) OR ([scadenza] = @Original_scadenza)) AND ([token] = @Original_token) AND ([new_id] = @Original_new_id) AND ([dtEvent] = @Original_dtEvent) AND ([CodDocCom] = @Original_CodDocCom) AND ([changed] = @Original_changed)); SELECT IdxFatt, anno, num, idxCli, tipo, emesso, ritenuta, scelta, dataPagam, Id, data, scadenza, token, new_id, dtEvent, CodDocCom, changed FROM Fatture WHERE (IdxFatt = @IdxFatt)