lest-xu

namespace Angular6Mvc5.Models
{
    public class OrderProducts
    {
        public int OrderId { get; set; }
        public int ProductId { get; set; }
        public double UnitPrice { get; set; }
        public double Quantity { get; set; }

        public Product Product { get; set; }

lest-xu

USE [MyDB]
GO

CREATE PROCEDURE [dbo].[usp_GetOrderProducts]  

AS

 BEGIN

	--Declare Local Variables

lest-xu

namespace Angular6Mvc5.Models
{
    public class Order
    {
        public int Id { get; set; }
        public DateTime OrderDate { get; set; }
        public int OrderNumber { get; set; }
        public int CustomerId { get; set; }
        public double TotalAmount { get; set; }

lest-xu

namespace Angular6Mvc5.Models
{
    public class Customer
    {
        public int Id { get; set; }
        public string FirstName { get; set; }
        public string LastName { get; set; }
        public string City { get; set; }
        public string Country { get; set; }
        public string Phone { get; set; }

lest-xu

namespace Angular6Mvc5.Models
{
    public class Supplier
    {
        public int Id { get; set; }
        public string CompanyName { get; set; }
        public string ContactName { get; set; }
        public string ContactTitle { get; set; }
        public string City { get; set; }
        public string Country { get; set; }

lest-xu

USE [MyDB]
GO

CREATE PROCEDURE [dbo].[usp_GetCustomers]  

AS

 BEGIN

	--Declare Local Variables

lest-xu

USE [MyDB]
GO

CREATE PROCEDURE [dbo].[usp_GetOrderItems]  

AS

 BEGIN

	--Declare Local Variables

lest-xu

USE [MyDB]
GO

CREATE PROCEDURE [dbo].[usp_GetOrders]  

AS

 BEGIN

	--Declare Local Variables

lest-xu

USE MyDB
Go

CREATE PROCEDURE [dbo].[usp_GetSuppliers]  

AS

 BEGIN

	--Declare Local Variables

lest-xu

USE MyDB
GO

SET IDENTITY_INSERT Customer ON
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(1,'Maria','Anders','Berlin','Germany','030-0074321')
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(2,'Ana','Trujillo','México D.F.','Mexico','(5) 555-4729')
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(3,'Antonio','Moreno','México D.F.','Mexico','(5) 555-3932')
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(4,'Thomas','Hardy','London','UK','(171) 555-7788')
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(5,'Christina','Berglund','Luleå','Sweden','0921-12 34 65')
INSERT INTO [Customer] ([Id],[FirstName],[LastName],[City],[Country],[Phone])VALUES(6,'Hanna','Moos','Mannheim','Germany','0621-08460')