C# Models.ProductContext類代碼示例

 public IQueryable<Category> GetCategories()
 {
     //get an instance of the database
     var db = new WingtipToys.Models.ProductContext();
     //create and retur a queryable(as a set of data result)
     IQueryable<Category> query = db.Categories;
     return query;
 }

 public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId, [RouteData] string categoryName)
 {
     var _db = new ProductContext();
     IQueryable<Product> query = _db.Products;
     if (categoryId.HasValue && categoryId > 0)
         query = query.Where(p => p.CategoryID == categoryId);
     if (!string.IsNullOrEmpty(categoryName))
         query = query.Where(p => string.Compare(p.Category.CategoryName, categoryName) == 0);
     return query;
 }

 public IQueryable<Product> GetProducts([QueryString("id")] int? categoryId)
 {
     var _db = new WingtipToys.Models.ProductContext();
     IQueryable<Product> query = _db.Products;
     if (categoryId.HasValue && categoryId > 0)
     {
         query = query.Where(p => p.CategoryID == categoryId);
     }
     return query;
 }

 public IQueryable<Product> GetProduct([QueryString("productID")] int? productId, [RouteData] string productName)
 {
     var _db = new ProductContext();
     IQueryable<Product> query = _db.Products;
     if (productId.HasValue && productId > 0)
         query = query.Where(p => p.ProductID == productId);
     else if (!string.IsNullOrEmpty(productName))
         query = query.Where(p => string.Compare(p.ProductName, productName) == 0);
     else
         query = null;
     return query;
 }

 // The return type can be changed to IEnumerable, however to support
 // paging and sorting, the following parameters must be added:
 //     int maximumRows
 //     int startRowIndex
 //     out int totalRowCount
 //     string sortByExpression
 public IQueryable<Category> GetCategories()
 {
     try
     {
         var _db = new WingtipToys.Models.ProductContext();
         IQueryable<Category> query = _db.Categories;
         return query;
     }
     catch(Exception exp)
     {
         throw;
     }
 }

 public IQueryable<Product> GetProduct([QueryString("productID")]int? productId)
 {
     var _db = new WingtipToys.Models.ProductContext();
     IQueryable<Product> query = _db.Products;
     if (productId.HasValue && productId > 0)
     {
         query = query.Where(p => p.ProductID == productId);
     }
     else
     {
         query = null;
     }
     return query;
 }

 public bool AddProduct(string ProductName, string ProductDesc,
     string ProductPrice, string ProductCategory, string ProductImagePath)
 {
     var myProduct = new Product();
     myProduct.ProductName = ProductName;
     myProduct.Description = ProductDesc;
     myProduct.UnitPrice = Convert.ToDouble(ProductPrice);
     myProduct.ImagePath = ProductImagePath;
     myProduct.CategoryID = Convert.ToInt32(ProductCategory);
     using (ProductContext _db = new ProductContext())
     {
         _db.Products.Add(myProduct);
         _db.SaveChanges();
     }
     return true;
 }

        protected void RemoveProductButton_Click(object sender, EventArgs e)
        {
            using (var _db=new WingtipToys.Models.ProductContext())
            {
                int productId = Convert.ToInt16(DropDownRemoveProduct.SelectedValue);
                var myItem = (from c in _db.Products where c.ProductID == productId select c).FirstOrDefault();
                if (myItem != null)
                {
                    _db.Products.Remove(myItem);
                    _db.SaveChanges();

                    // Reload the page.
                    string pageUrl = Request.Url.AbsoluteUri.Substring(0, Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count());
                    Response.Redirect(pageUrl + "?ProductAction=remove");
                }
                else
                    LabelRemoveStatus.Text = "Unable to locate product.";
            }
        }

 public IQueryable<Product> GetProduct(
                     [QueryString("ProductID")] int? productId,
                     [RouteData] string productName)
 {
   var _db = new WingtipToys.Models.ProductContext();
   IQueryable<Product> query = _db.Products;
   if (productId.HasValue && productId > 0)
   {
     query = query.Where(p => p.ProductID == productId);
   }
   else if (!String.IsNullOrEmpty(productName))
   {
     query = query.Where(p =>
               String.Compare(p.ProductName, productName) == 0);
   }
   else
   {
     query = null;
   }
   return query;
 }

        Tuple<int, int> DeliveryServicesSurvey(DateTime time)
        {
            int timeOut = 100;
            offDeliveryService = true;
            Tuple<int, int> result = null;

            resultDeliveryServiceGlobal = null;
            using (ProductContext _db = new ProductContext())
            {
                foreach (var system in _db.DeliveryServices)
                {
                    object[] parameters = new object[] { system.ID,
                                                         system.ConnectionString,
                                                         time };

                    Thread thread = new Thread(DeliveryServiceSurvey);
                    thread.Start(parameters);
                }
            }

            for (int i = 0; i < 20 && null == result; ++i)
            {
                Thread.Sleep(timeOut);
                lock (lockDeliveryService)
                {
                    result = resultDeliveryServiceGlobal;
                }
            }

            if (null == result)
            {
                if (offDeliveryService)
                {
                    throw new ExceptionDeliveryServiceOff();
                }
                else
                {
                    throw new ExceptionDeliveryServiceWrongTime();
                }
            }
            Console.WriteLine("  resultDeliveryService={0}:{1}", result.Item1, result.Item2);

            return result;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack)
            {
                NVPAPICaller payPalCAller = new NVPAPICaller();

                string retMsg = "";
                string token = "";
                string PayerID = "";
                NVPCodec decoder = new NVPCodec();
                token = Session["token"].ToString();

                bool ret = payPalCAller.GetCheckoutDetails( token, ref PayerID, ref decoder, ref retMsg );
                if(ret)
                {
                    Session["payerId"] = PayerID;

                    var myOrder = new Order();
                    myOrder.OrderDate = Convert.ToDateTime(decoder["TIMESTAMP"].ToString());
                    myOrder.Uername = User.Identity.Name;
                    myOrder.FirstName = decoder["FIRSTNAME"].ToString();
                    myOrder.LastName = decoder["LASTNAME"].ToString();
                    myOrder.Address = decoder["SHIPTOSTREET"].ToString();
                    myOrder.City = decoder["SHIPTOCITY"].ToString();
                    myOrder.State = decoder["SHIPTOSTATE"].ToString();
                    myOrder.PostalCode = decoder["SHIPTOZIP"].ToString();
                    myOrder.Country = decoder["SHIPTOCOUNTRYCODE"].ToString();
                    myOrder.Email = decoder["EMAIL"].ToString();
                    myOrder.Total = Convert.ToDecimal( decoder["AMT"].ToString() );

                    //verify total payment amount as set on checkout start.aspx.
                    try
                    {
                        decimal paymentAmountOnCheckout = Convert.ToDecimal( Session["payment_amt"].ToString() );
                        decimal paymentAmountFromPayPal = Convert.ToDecimal( decoder["AMT"].ToString() );
                        if (paymentAmountOnCheckout != paymentAmountFromPayPal)
                        {
                            Response.Redirect( "CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch." );
                        }
                    }
                    catch (Exception)
                    {
                        Response.Redirect("CheckoutError.aspx?" + "Desc=Amount%20total%20mismatch.");
                    }

                    //get db context
                    ProductContext _db = new ProductContext();

                    //add order to db
                    _db.Orders.Add(myOrder);
                    _db.SaveChanges();

                    //Get the shopping cart items and process them
                    using (WingtipToys.Logic.ShoppingCartActions usersShoppingCart = new WingtipToys.Logic.ShoppingCartActions())
                    {
                        List<CartItem> myOrderList = usersShoppingCart.GetCartItems();

                        //add oderdetail info to the db for each product purchased
                        for (int i= 0; i < myOrderList.Count; i++)
                        {
                            //create new order detail object
                            var myOrderDetail = new OrderDetail();
                            myOrderDetail.OrderId = myOrder.OrderId;
                            myOrderDetail.Username = User.Identity.Name;
                            myOrderDetail.ProductId = myOrderList[i] .ProductId;
                            myOrderDetail.Quantity = myOrderList[i] .Quantity;
                            myOrderDetail.UnitPrice = myOrderList[i] .Product.UnitPrice;

                            // add orderdetail to db
                            _db.OrderDetails.Add(myOrderDetail);
                            _db.SaveChanges();
                        }
                        // set order id
                        Session["currentOrderId"] = myOrder.OrderId;

                        //displayorder info
                        List<Order> orderList = new List<Order>();
                        orderList.Add(myOrder);
                        ShipInfo.DataSource = orderList;
                        ShipInfo.DataBind();

                        //display order detail
                        OrderItemList.DataSource = myOrderList;
                        OrderItemList.DataBind();
                    }
                }
                else
                {
                    Response.Redirect("CheckoutError.aspx?" + retMsg);
                }
            }
        }

 public void UpdateItem(string updateCartID, int updateProductID, int quantity)
 {
     using (var _db = new WingtipToys.Models.ProductContext())
     {
         try
         {
             var myItem = (from c in _db.ShoppingCartItems where c.CartId == updateCartID && c.Product.ProductID == updateProductID select c).FirstOrDefault();
             if (myItem != null)
             {
                 myItem.Quantity = quantity;
                 _db.SaveChanges();
             }
         }
         catch (Exception exp)
         {
             throw new Exception("ERROR: Unable to Update Cart Item - " + exp.Message.ToString(), exp);
         }
     }
 }

        Tuple<int, int> SupplierSystemsSurvey(Good[] itemIDAndCount)
        {
            int timeOut = 100;
            offSupplierSystem = true;
            Tuple<int, int> result = null;

            resultSupplierSystemGlobal = null;
            using (ProductContext _db = new ProductContext())
            {
                foreach (var system in _db.SupplierSystems)
                {
                    object[] parameters = new object[] { system.ID,
                                                         system.ConnectionString,
                                                         itemIDAndCount };

                    Thread thread = new Thread(SupplierSystemSurvey);
                    thread.Start(parameters);
                }
            }

            for (int i = 0; i < 20 && null == result; ++i)
            {
                Thread.Sleep(timeOut);
                lock (lockSupplierSystem)
                {
                    result = resultSupplierSystemGlobal;
                }
            }

            if (null == result)
            {
                if (offSupplierSystem)
                {
                    throw new ExceptionSupplierSystemOff();
                }
                else
                {
                    throw new ExceptionSupplierSystemNotGood();
                }
            }
            Console.WriteLine("  resultSupplierSystem={0}:{1}", result.Item1, result.Item2);

            return result;
        }

        public void UpdateShoppingCartDatabase(String cartId, ShoppingCartUpdates[] CartItemUpdates)
        {
            using (var db = new WingtipToys.Models.ProductContext()) ;
            {
                try
                {
                    int CartItemCount = CartItemUpdates.Count();

                    List<CartItem> myCart = GetCartItems();

                    foreach (var cartItem in myCart)
                    {
                        // Iterate through allrows within shopping cart list
                        for (int i = 0; i < CartItemCount; i++)
                        {
                            if (cartItem.Product.ProductID == CartItemUpdates[i].ProductId)
                            {
                                if (CartItemUpdates[i].PurchaseQuantity < 1 || CartItemUpdates[i].RemoveItem == true)
                                {
                                    RemoveItem(cartId, cartItem.ProductId);
                                }

                                else
                                {
                                    UpdateItem(cartId, cartItem.ProductId, CartItemUpdates[i].PurchaseQuantity);
                                }
                            }
                        }
                    }
                }
                catch (Exception exp)
                {

                    throw new Exception("ERROR: Unable to update cart database - " + exp.Message.ToString(), exp);
                }
            }
        }

        public void RemoveItem(string removeCartID, int removeProductID)
        {
            using (var _db = new WingtipToys.Models.ProductContext())
            {
                try
                {
                    var myItem = (from c in _db.ShoppingCartItems where c.CartId == removeCartID && c.Product.ProductID == removeProductID select c).FirstOrDefault();

                    if (myItem != null)
                    {
                        // Remove Item
                        _db.ShoppingCartItems.Remove(myItem);
                        _db.SaveChanges();
                    }
                }

                catch (Exception exp)
                {
                    throw new Exception("ERROR: Unable to remove cart item - " + exp.Message.ToString(), exp);
                }
            }
        }