using System;

using System.Threading.Tasks;

using System.Data.Linq;

using System.Data.Entity;

using System.Linq;

using System.Web.Http;

​

​

/******************************

 * MODELS

 *****************************/

    public class User

    {

        public int ID {get; set;}

        public string Name {get; set;}

    }

    public class Product

    {

        public int ID {get; set;}

        public string Name { get; set;}

        public string Status {get; set;}

        public int Price {get; set;}

    }

    public class ProductOrder

    {

        public int ProductID {get; set;}

        public int UserID {get; set;}

        public int Price {get; set;}

    }

/******************************

 * ENTITY FRAMEWORK DB CONTEXT

 *****************************/

​

    public class MyDbContext : DbContext

    {

        public DbSet<User> Users;

        public DbSet<Product> Products;

        public DbSet<ProductOrder> ProductOrders;

    }

​

/******************************

 * REPOSITORY LAYER

 *****************************/

    public class MyRepository

    {

        public MyRepository()

        {

        }

        /*

        public async Task CreateNewProduct(Product newProduct)

        {

            var myContext  = new MyDbContext();

            myContext.Products.Add(newProduct);

            myContext.SaveChangesAsync().Wait();

            myContext.Dispose();

            await Task.CompletedTask;

        }*/

        public Product GetProductById(int id)

        {

            var myContext  = new MyDbContext();

            var allProducts = myContext.Products.ToList();

            return allProducts.First(x=> x.ID == id);

        }

        public void DeleteProductsByStatus(string status)

        {

            var myContext  = new MyDbContext();

            myContext.Database.ExecuteSqlCommand("DELETE FROM Products WHERE Status ='" + status + "'");

        }

        public void CreateNewProductOrder(ProductOrder newProductOrder)

        {   

            var myContext  = new MyDbContext();

            myContext.ProductOrders.Add(newProductOrder);

            myContext.SaveChangesAsync().Wait();

            myContext.Dispose();

        }

    }

​

/******************************

 * WEB API LAYER

 *****************************/

​

    public class ProductsController : ApiController

    {

        [HttpGet]

        [Route("api/order-product")]

        public void OrderProduct([FromUri] int userID, [FromUri] int productID, [FromUri] int price)

        {

            var newProductOrder = new ProductOrder()

            {

                UserID = userID,

                ProductID = productID,

                Price = price

            };

            var repo = new MyRepository();

            repo.CreateNewProductOrder(newProductOrder);    

        }

    }

​