Notes

create procedure [dbo].[Sp_Update_Categories]
(
@CategoryId int,
@CategoryName varchar(15),
@Description ntext,
@Picture image
)
as
begin
update Categories set CategoryName = @CategoryName, Description=@Description, Picture= @Picture where @CategoryId =@CategoryId
end
GO



create procedure [dbo].[Sp_Update_Customers]
(
@CustomerID int,
@CompanyName nvarchar(40),
@ContactName nvarchar(30),
@ContactTitle nvarchar(30),
@Address nvarchar(60),
@City nvarchar(15),
@Region nvarchar(15),
@PostalCode nvarchar(10),
@Country varchar(15),
@Phone varchar(24),
@Fax varchar(24)
)
as
begin
update Customers set CompanyName=@CompanyName ,ContactName=@ContactName ,ContactTitle=@ContactTitle , Address=@Address ,City=@City, Region=@Region, PostalCode=@PostalCode, Country=@Country, Phone=@Phone, Fax=@Fax where @CustomerId=@CustomerId
end

GO

create procedure [dbo].[Sp_Update_Employees]
(
@EmployeeID int,
@LastName nvarchar(20),
@FirstName nvarchar(10),
@Title nvarchar(30),
@TitleOfCourtesy nvarchar(25),
@BirthDate datetime,
@HireDate datetime,
@Address nvarchar(60),
@City nvarchar(15),
@Region varchar(15),
@PostalCode nvarchar(10),
@Country varchar(15),
@HomePhone varchar(24),
@Extension nvarchar(4),
@Photo image,
@Notes ntext,
@PhotoPath nvarchar(255)
)
as
begin
update Employees set LastName=@LastName, FirstName=@FirstName, Title=@Title ,TitleOfCourtesy=@TitleOfCourtesy, BirthDate=@BirthDate, HireDate=@HireDate , Address=@Address, City=@City, Region=@Region ,PostalCode=@PostalCode, Country=@Country, HomePhone=@HomePhone, Extension=@Extension, Photo=@Photo, Notes=@Notes, PhotoPath=@PhotoPath where @EmployeeId =@EmployeeId
end

GO

---create procedure [Sp_Update_EmployeeTerritories]-----
---(
----@EmployeeID int,-----
--@TerritoryID nvarchar(20)
--)
--as
--begin
-- update EmployeeTerritories set EmployeeID=@EmployeeID ,TerritoryID=@EmployeeID where @EmployeeId=@EmployeeId
--end

---GO-----

create procedure [dbo].[Sp_Update_Order Details]
(
@OrderID int,
@UnitPrice money,
@Quantity smallint,
@Discount real
)
as
begin
update [Order Details] set UnitPrice= @UnitPrice, Quantity=@Quantity ,Discount=@Discount where @OrderId=@OrderId
end

GO

create procedure [dbo].[Sp_Update_Orders]
(
@OrderId int,
@OrderDate datetime,
@RequiredDate datetime,
@ShippedDate datetime,
@Freight money,
@ShipName nvarchar(40),
@ShipAddress nvarchar(60),
@ShipCity nvarchar(15),
@ShipRegion nvarchar(15),
@ShipPostalCode nvarchar(10),
@ShipCountry nvarchar(15)
)
as
begin
update Orders set OrderDate=@OrderDate, RequiredDate=@RequiredDate ,ShippedDate=@ShippedDate ,Freight=@Freight ,ShipName=@ShipName ,ShipAddress=@ShipAddress ,ShipCity=@ShipCity ,ShipRegion=@ShipRegion ,ShipPostalCode=@ShipPostalCode ,ShipCountry=@ShipCountry where @OrderId=@OrderId
end

GO

create procedure [dbo].[Sp_Update_Products]
(
@ProductId int,
@ProductName nvarchar(40),
@QuantityPerUnit nvarchar(20),
@UnitPrice money,
@UnitsInStock smallint,
@UnitsOnOrder smallint,
@ReorderLevel smallint,
@Discontinued bit
)
as
begin
update Products set ProductName=@ProductName ,QuantityPerUnit=@QuantityPerUnit, UnitPrice=@UnitPrice ,UnitsInStock=@UnitsInStock ,UnitsOnOrder=@UnitsOnOrder ,ReorderLevel=@ReorderLevel ,Discontinued=@Discontinued where @ProductId=@ProductId
end

GO

create procedure [dbo].[Sp_Update_Region]
(
@RegionID int,
@RegionDescription nchar(50)
)
as
begin
update Region set RegionDescription=@RegionDescription where @RegionID=@RegionID
end

GO


create procedure [dbo].[Sp_Update_Roles]
(
@RoleId int,
@RoleName nvarchar(50),
@Description nvarchar(150)
)
as
begin
update Roles set RoleName=@RoleName, Description=@Description where @RoleId=@RoleId
end

GO

create procedure [dbo].[Sp_Update_RolesToAccess]
(
@Id int,
@RoleId int,
@FormName nvarchar(50)

)
as
begin
update RolesToAccess set RoleId=@RoleId, FormName=@FormName where @Id=@Id

end

GO

create procedure [dbo].[Sp_Update_Shippers]
(
@ShipperID int,
@CompanyName nvarchar(40),
@Phone nvarchar(24)
)
as
begin
update Shippers set CompanyName=@CompanyName, Phone=@Phone where @ShipperID=@ShipperID
end

GO

create procedure [dbo].[Sp_Update_Suppliers]
(
@SupplierID int,
@CompanyName nvarchar(40),
@ContactName nvarchar(30),
@ContactTitle nvarchar(30),
@Address nvarchar(60),
@City nvarchar(15),
@Region varchar(15),
@PostalCode nvarchar(10),
@Country varchar(15),
@Phone varchar(24),
@Fax nvarchar(24),
@HomePage ntext
)
as
begin
update Suppliers set CompanyName=@CompanyName, ContactName=@ContactName, ContactTitle=@ContactTitle, Address=@Address, City=@City, Region=@Region, PostalCode=@PostalCode, Country=@Country, Phone=@Phone, Fax=@Fax, HomePage=@HomePage where @SupplierID=@SupplierID
end

GO

create procedure [dbo].[Sp_Update_Territories]
(
@TerritoryID int,
@TerritoryDescription nchar(50)
)
as
begin
update Territories set TerritoryDescription=@TerritoryDescription where @TerritoryID=@TerritoryID
end

GO

create procedure [dbo].[Sp_Update_Users]
(
@UserId int,
@UserName nvarchar(50),
@Password nvarchar(50),
@IsApproved bit
)
as
begin
update Users set UserName=@UserName, IsApproved=@IsApproved where @UserId=@UserId
end