?using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using VinciDataAccess.Entity;
using VinciDataAccess.Linq;

namespace VinciDataAccess.DataAccess
{
    public class OrderDetailsStore
    {
        private ProductsDataContext _orderDetailsDataContext = null;

        public OrderDetailsStore()
        {
            _orderDetailsDataContext = new ProductsDataContext();
        }
        /// <summary>
        /// Define Method OrderDetailsObjectToEntity
        /// Return OrderDetailsEntity
        /// </summary>
        /// <param name="orderDetail"></param>
        /// <returns></returns>
        private OrderDetailsEntity OrderDetailsObjectToEntity(Order_Details orderDetail)
        {
            OrderDetailsEntity orderDetailsEntity = new OrderDetailsEntity();
            orderDetailsEntity.OrderID = orderDetail.OrderID;
            orderDetailsEntity.ProductID = orderDetail.ProductID;
            orderDetailsEntity.Quantity = orderDetail.Quantity;
            orderDetailsEntity.Discount = orderDetail.Discount;
            orderDetailsEntity.UnitPrice = orderDetail.UnitPrice;
            return orderDetailsEntity;
        }
        /// <summary>
        /// Get List Of OrderDetails
        /// </summary>
        /// <returns></returns>
        public OrderDetailsCollection GetOrderDetailsList()
        {
            OrderDetailsCollection orderDetailsList = new OrderDetailsCollection();
            IEnumerable<Order_Details> orderDetails = from orderDetail in this._orderDetailsDataContext.Order_Details
                                                      orderby orderDetail.OrderID
                                                      select orderDetail;
            foreach(Order_Details orderDetail in orderDetails)
            {
                orderDetailsList.Add(this.OrderDetailsObjectToEntity(orderDetail));
            }
            return orderDetailsList;
        }
        public OrderDetailsCollection GetAllOrderDetailsList(int orderID)//Coder:Tom
        {
           // OrderDetailsCollection orderDetailsList = new OrderDetailsCollection();
            //IEnumerable<>
            OrderDetailsCollection orderDetailsList = new OrderDetailsCollection();
            IEnumerable<Order_Details> orderDetails = from orderDetail in this._orderDetailsDataContext.Order_Details
                                                      where orderDetail.OrderID==orderID
                                                      orderby orderDetail.OrderID descending
                                                      select orderDetail;
            foreach (Order_Details orderDetail in orderDetails)
            {
                orderDetailsList.Add(this.OrderDetailsObjectToEntity(orderDetail));
            }
            return orderDetailsList;

        }
        /// <summary> 
        /// Get Single OrderDetail Information
        /// Select It By OrderID And ProdcutID
        /// </summary>
        /// <param name="orderID"></param>
        /// <param name="productID"></param>
        /// <returns></returns>
        public OrderDetailsEntity GetOrderDetailInfo(int orderID, int productID)
        {
            OrderDetailsEntity orderDetailsEntity = new OrderDetailsEntity();
            IEnumerable<Order_Details> orderDetails = from orderDetail in this._orderDetailsDataContext.Order_Details
                                                      where orderDetail.OrderID == orderID && orderDetail.ProductID == productID
                                                      select orderDetail;
            foreach (Order_Details orderDetail in orderDetails)
            {
                orderDetailsEntity = this.OrderDetailsObjectToEntity(orderDetail);
            }
            return orderDetailsEntity;
        }
        public OrderDetailsEntity GetOrderDetailInfoOnePar(int orderID)//Coder:Tom
        {
            OrderDetailsEntity orderDetailsEntity = new OrderDetailsEntity();
            IEnumerable<Order_Details> orderDetails = from orderDetail in this._orderDetailsDataContext.Order_Details
                                                     where orderDetail.OrderID == orderID                                                       select orderDetail;
            foreach (Order_Details orderDetail in orderDetails)
            {
                orderDetailsEntity = this.OrderDetailsObjectToEntity(orderDetail);
            }
            return orderDetailsEntity;
        }
        /// <summary>
        /// Add New OrderDetails  //Chark.Xu 3.10
        /// </summary>
        public void AddOrderDetails(OrderDetailsEntity orderDetailsEntity)
        {
            _orderDetailsDataContext.ExecuteCommand(@"Insert into [Order Details] (OrderID,ProductID,UnitPrice,Quantity,Discount) values ({0},{1},{2},{3},{4})",
                                                                                    orderDetailsEntity.OrderID,
                                                                                    orderDetailsEntity.ProductID,
                                                                                    orderDetailsEntity.UnitPrice,
                                                                                     orderDetailsEntity.Quantity,
                                                                                     orderDetailsEntity.Discount
                                                                                  );
                                                                                    
        }
        /// <summary>
        /// 
        /// Delete OrderDetails
        /// Select It By Primary Key OrderID And ProdcutID
        /// </summary>
        /// <param name="orderDetialsEntity"></param>
        public void DeleteOrderDetail(OrderDetailsEntity orderDetailsEntity)
        {
            _orderDetailsDataContext.ExecuteCommand(@"Delete from [Order_Details] where OrderID={0} and ProductID={1}",
                                                    orderDetailsEntity.OrderID,
                                                    orderDetailsEntity.ProductID);
        }
        /// <summary>
        /// Update OrderDetail Information
        /// Select It By OrderID And ProductID
        /// </summary>
        /// <param name="orderDetailsEntity"></param>
        public void UpdateOrderDetail(OrderDetailsEntity orderDetailsEntity)
        {
            _orderDetailsDataContext.ExecuteCommand(@"Update [Order Details] 
                                                      set UnitPrice={0},
                                                          Quantity={1},
                                                          Discount={2} where OrderID={3} and ProductID={4}",
                                                    orderDetailsEntity.UnitPrice,
                                                    orderDetailsEntity.Quantity,
                                                    orderDetailsEntity.Discount,
                                                    orderDetailsEntity.OrderID,
                                                    orderDetailsEntity.ProductID);
        }        
    }
}