// GET: /OrderDetailOptions/Delete/<id> public ActionResult Delete( Int32?OrderOptionId ) { if ( OrderOptionId == null ) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } dtItemOption = OrderDetailOptions_ItemOptionData.SelectAll(); OrderDetailOptions OrderDetailOptions = new OrderDetailOptions(); OrderDetailOptions.OrderOptionId = System.Convert.ToInt32(OrderOptionId); OrderDetailOptions = OrderDetailOptionsData.Select_Record(OrderDetailOptions); OrderDetailOptions.ItemOption = new ItemOption() { ItemOptionId = (Int32)OrderDetailOptions.ItemOptionId }; if (OrderDetailOptions == null) { return(HttpNotFound()); } return(View(OrderDetailOptions)); }
public ActionResult Edit([Bind(Include = " OrderOptionId" + ",OrderDetailId" + ",ItemOptionId" + ",Price" )] OrderDetailOptions OrderDetailOptions) { OrderDetailOptions oOrderDetailOptions = new OrderDetailOptions(); oOrderDetailOptions.OrderOptionId = System.Convert.ToInt32(OrderDetailOptions.OrderOptionId); oOrderDetailOptions = OrderDetailOptionsData.Select_Record(OrderDetailOptions); if (ModelState.IsValid) { bool bSucess = false; bSucess = OrderDetailOptionsData.Update(oOrderDetailOptions, OrderDetailOptions); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Update"); } } // ComboBox ViewData["ItemOptionId"] = new SelectList(OrderDetailOptions_ItemOptionData.List(), "ItemOptionId", "ItemOptionId", OrderDetailOptions.ItemOptionId); return(View(OrderDetailOptions)); }
// GET: /OrderDetailOptions/Edit/<id> public ActionResult Edit( Int32?OrderOptionId ) { if ( OrderOptionId == null ) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OrderDetailOptions OrderDetailOptions = new OrderDetailOptions(); OrderDetailOptions.OrderOptionId = System.Convert.ToInt32(OrderOptionId); OrderDetailOptions = OrderDetailOptionsData.Select_Record(OrderDetailOptions); if (OrderDetailOptions == null) { return(HttpNotFound()); } // ComboBox ViewData["ItemOptionId"] = new SelectList(OrderDetailOptions_ItemOptionData.List(), "ItemOptionId", "ItemOptionId", OrderDetailOptions.ItemOptionId); return(View(OrderDetailOptions)); }
public static bool Update(OrderDetailOptions oldOrderDetailOptions, OrderDetailOptions newOrderDetailOptions) { SqlConnection connection = OnlineSales2Data.GetConnection(); string updateStatement = "UPDATE " + " [OrderDetailOptions] " + "SET " + " [OrderDetailId] = @NewOrderDetailId " + " ,[ItemOptionId] = @NewItemOptionId " + " ,[Price] = @NewPrice " + "WHERE " + " [OrderOptionId] = @OldOrderOptionId " + " AND [OrderDetailId] = @OldOrderDetailId " + " AND [ItemOptionId] = @OldItemOptionId " + " AND [Price] = @OldPrice " + ""; SqlCommand updateCommand = new SqlCommand(updateStatement, connection); updateCommand.CommandType = CommandType.Text; updateCommand.Parameters.AddWithValue("@NewOrderDetailId", newOrderDetailOptions.OrderDetailId); updateCommand.Parameters.AddWithValue("@NewItemOptionId", newOrderDetailOptions.ItemOptionId); updateCommand.Parameters.AddWithValue("@NewPrice", newOrderDetailOptions.Price); updateCommand.Parameters.AddWithValue("@OldOrderOptionId", oldOrderDetailOptions.OrderOptionId); updateCommand.Parameters.AddWithValue("@OldOrderDetailId", oldOrderDetailOptions.OrderDetailId); updateCommand.Parameters.AddWithValue("@OldItemOptionId", oldOrderDetailOptions.ItemOptionId); updateCommand.Parameters.AddWithValue("@OldPrice", oldOrderDetailOptions.Price); try { connection.Open(); int count = updateCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static OrderDetailOptions Select_Record(OrderDetailOptions OrderDetailOptionsPara) { OrderDetailOptions OrderDetailOptions = new OrderDetailOptions(); SqlConnection connection = OnlineSales2Data.GetConnection(); string selectStatement = "SELECT " + " [OrderOptionId] " + " ,[OrderDetailId] " + " ,[ItemOptionId] " + " ,[Price] " + "FROM " + " [OrderDetailOptions] " + "WHERE " + " [OrderOptionId] = @OrderOptionId " + ""; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.CommandType = CommandType.Text; selectCommand.Parameters.AddWithValue("@OrderOptionId", OrderDetailOptionsPara.OrderOptionId); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { OrderDetailOptions.OrderOptionId = System.Convert.ToInt32(reader["OrderOptionId"]); OrderDetailOptions.OrderDetailId = System.Convert.ToInt32(reader["OrderDetailId"]); OrderDetailOptions.ItemOptionId = System.Convert.ToInt32(reader["ItemOptionId"]); OrderDetailOptions.Price = System.Convert.ToDecimal(reader["Price"]); } else { OrderDetailOptions = null; } reader.Close(); } catch (SqlException) { return(OrderDetailOptions); } finally { connection.Close(); } return(OrderDetailOptions); }
public static bool Add(OrderDetailOptions OrderDetailOptions) { SqlConnection connection = OnlineSales2Data.GetConnection(); string insertStatement = "INSERT " + " [OrderDetailOptions] " + " ( " + " [OrderDetailId] " + " ,[ItemOptionId] " + " ,[Price] " + " ) " + "VALUES " + " ( " + " @OrderDetailId " + " ,@ItemOptionId " + " ,@Price " + " ) " + ""; SqlCommand insertCommand = new SqlCommand(insertStatement, connection); insertCommand.CommandType = CommandType.Text; insertCommand.Parameters.AddWithValue("@OrderDetailId", OrderDetailOptions.OrderDetailId); insertCommand.Parameters.AddWithValue("@ItemOptionId", OrderDetailOptions.ItemOptionId); insertCommand.Parameters.AddWithValue("@Price", OrderDetailOptions.Price); try { connection.Open(); int count = insertCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public static bool Delete(OrderDetailOptions OrderDetailOptions) { SqlConnection connection = OnlineSales2Data.GetConnection(); string deleteStatement = "DELETE FROM " + " [OrderDetailOptions] " + "WHERE " + " [OrderOptionId] = @OldOrderOptionId " + " AND [OrderDetailId] = @OldOrderDetailId " + " AND [ItemOptionId] = @OldItemOptionId " + " AND [Price] = @OldPrice " + ""; SqlCommand deleteCommand = new SqlCommand(deleteStatement, connection); deleteCommand.CommandType = CommandType.Text; deleteCommand.Parameters.AddWithValue("@OldOrderOptionId", OrderDetailOptions.OrderOptionId); deleteCommand.Parameters.AddWithValue("@OldOrderDetailId", OrderDetailOptions.OrderDetailId); deleteCommand.Parameters.AddWithValue("@OldItemOptionId", OrderDetailOptions.ItemOptionId); deleteCommand.Parameters.AddWithValue("@OldPrice", OrderDetailOptions.Price); try { connection.Open(); int count = deleteCommand.ExecuteNonQuery(); if (count > 0) { return(true); } else { return(false); } } catch (SqlException) { return(false); } finally { connection.Close(); } }
public ActionResult DeleteConfirmed( Int32?OrderOptionId ) { OrderDetailOptions OrderDetailOptions = new OrderDetailOptions(); OrderDetailOptions.OrderOptionId = System.Convert.ToInt32(OrderOptionId); OrderDetailOptions = OrderDetailOptionsData.Select_Record(OrderDetailOptions); bool bSucess = false; bSucess = OrderDetailOptionsData.Delete(OrderDetailOptions); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Delete"); } return(null); }
public ActionResult Create([Bind(Include = "OrderDetailId" + "," + "ItemOptionId" + "," + "Price" )] OrderDetailOptions OrderDetailOptions) { if (ModelState.IsValid) { bool bSucess = false; bSucess = OrderDetailOptionsData.Add(OrderDetailOptions); if (bSucess == true) { return(RedirectToAction("Index")); } else { ModelState.AddModelError("", "Can Not Insert"); } } // ComboBox ViewData["ItemOptionId"] = new SelectList(OrderDetailOptions_ItemOptionData.List(), "ItemOptionId", "ItemOptionId", OrderDetailOptions.ItemOptionId); return(View(OrderDetailOptions)); }
private void OrderNowButton_Click(object sender, RoutedEventArgs e) { Double productPrice = 0; Products product = (Products)lbProducts.SelectedItem; List <OrderDetailAdOns> orderDetailAdonList = new List <OrderDetailAdOns>(); List <OrderDetailOptions> orderDetailOptionsList = new List <OrderDetailOptions>(); if (UserOrder == null) { UserOrder = new Orders(); } if (_optionPrice == 0) { productPrice = product.DefaultBranchProductPrice; } else { productPrice = _optionPrice; } if (UserOrder.OrderDetailsList == null) { UserOrder.OrderDetailsList = new List <BusinessEntities.OrderDetails>(); //SessionOrderAdonList = new List<List<BusinessEntities.OrderDetailAdOns>>(); //SessionOrderDetailOptionList = new List<List<BusinessEntities.OrderDetailOptions>>(); UserOrder.OrderStatusID = BusinessEntities.OrderStatus.NewOrder; } BusinessEntities.OrderDetails orderdetail = new BusinessEntities.OrderDetails(); if (!product.IsSpecial) { if (_optionPrice > 0) { orderdetail.Price = _optionPrice; } else { orderdetail.Price = Convert.ToDouble(product.DefaultBranchProductPrice); } } orderdetail.CategoryName = _category.Name; orderdetail.ProductName = product.Name; orderdetail.ProductID = product.ProductID; orderdetail.ProductImage = product.Image; orderdetail.Quantity = 1; if (product.IsSpecial) { MultiPorductControl control = (MultiPorductControl)MultiProductPanel.Children[0]; orderdetail.Price = control.GetPrice(); orderdetail.OrderDetailSubProducts = control.GetOrderDetailSubProducts(); orderdetail.IsGroupProduct = true; } else { #region Get Selected Option for (int i = 0; i < lbOptions.Items.Count; i++) { DependencyObject obj = lbOptions.ItemContainerGenerator.ContainerFromIndex(i); ContentPresenter optionTypeContentPresenter = FindVisualChild <ContentPresenter>(obj); OptionType optionType = (OptionType)optionTypeContentPresenter.Content; ListBox OptionList = FindVisualChild <ListBox>(obj); if (optionType.IsSamePrice && !optionType.IsMultiSelect) { for (int j = 0; j < OptionList.Items.Count; j++) { DependencyObject obj1 = OptionList.ItemContainerGenerator.ContainerFromIndex(j); // Getting the ContentPresenter of myListBoxItem ContentPresenter myContentPresenter = FindVisualChild <ContentPresenter>(obj1); // Finding textBlock from the DataTemplate that is set on that ContentPresenter DataTemplate myDataTemplate = myContentPresenter.ContentTemplate; RadioButton selectedOption = (RadioButton)myDataTemplate.FindName("SelectedOption", myContentPresenter); if (selectedOption.IsChecked.Value) { ProductOptions productOptions = (ProductOptions)myContentPresenter.Content; OrderDetailOptions orderdetailoption = new OrderDetailOptions(); orderdetailoption.ProductOptionId = productOptions.OptionID; orderdetailoption.ProductOptionName = productOptions.OptionName; orderdetailoption.Price = Convert.ToDouble(productOptions.Price); orderDetailOptionsList.Add(orderdetailoption); orderdetail.Price = productOptions.Price; } } } else if (!optionType.IsSamePrice && !optionType.IsMultiSelect) { for (int j = 0; j < OptionList.Items.Count; j++) { DependencyObject obj1 = OptionList.ItemContainerGenerator.ContainerFromIndex(j); // Getting the ContentPresenter of myListBoxItem ContentPresenter myContentPresenter = FindVisualChild <ContentPresenter>(obj1); // Finding textBlock from the DataTemplate that is set on that ContentPresenter DataTemplate myDataTemplate = myContentPresenter.ContentTemplate; RadioButton selectedOption = (RadioButton)myDataTemplate.FindName("SelectedOption", myContentPresenter); if (selectedOption.IsChecked.Value) { ProductOptions productOptions = (ProductOptions)myContentPresenter.Content; OrderDetailOptions orderdetailoption = new OrderDetailOptions(); orderdetailoption.ProductOptionId = productOptions.OptionID; orderdetailoption.ProductOptionName = productOptions.OptionName; orderdetailoption.Price = productOptions.Price; orderDetailOptionsList.Add(orderdetailoption); orderdetail.Price = productOptions.Price; } } } } #endregion #region Get Selected Toppings for (int i = 0; i < lbToppings.Items.Count; i++) { DependencyObject obj = lbToppings.ItemContainerGenerator.ContainerFromIndex(i); ContentPresenter adonTypeContentPresenter = FindVisualChild <ContentPresenter>(obj); AdonType adonType = (AdonType)adonTypeContentPresenter.Content; ListBox AdonList = FindVisualChild <ListBox>(obj); for (int j = 0; j < AdonList.Items.Count; j++) { DependencyObject obj1 = AdonList.ItemContainerGenerator.ContainerFromIndex(j); // Getting the ContentPresenter of myListBoxItem ContentPresenter myContentPresenter = FindVisualChild <ContentPresenter>(obj1); // Finding textBlock from the DataTemplate that is set on that ContentPresenter DataTemplate myDataTemplate = myContentPresenter.ContentTemplate; Int16 SelectedTopping = Convert.ToInt16(((TextBlock)myDataTemplate.FindName("SelectedTopping", myContentPresenter)).Text); if (SelectedTopping != 0) { if (!adonType.IsFreeAdonType) { Adon adon = (Adon)myContentPresenter.Content; OrderDetailAdOns orderdetailadon = new OrderDetailAdOns(); orderdetailadon.AdOnId = adon.AdOnID; orderdetailadon.AdonName = adon.AdOnName; orderdetailadon.AdonTypeName = adon.AdOnTypeName; orderdetailadon.SelectedAdonOption = (SelectedOption)SelectedTopping; orderDetailAdonList.Add(orderdetailadon); if (adon.DefaultSelected != SelectedTopping) { if (_defaultAdonPrice > 0) { productPrice += _defaultAdonPrice; } else { productPrice += (Double)adonType.Price; } } } } } } #endregion } double discountPrice = 0; Double.TryParse(txtDiscount.Text, out discountPrice); if (discountPrice > 0) { orderdetail.Price = discountPrice; } else if (orderdetail.Price == 0) { orderdetail.Price = productPrice; } UserOrder.OrderDetailsList.Add(orderdetail); UserOrder.OrderTotal += orderdetail.Price; OrderDetailOptionList.Add(orderDetailOptionsList); OrderDetailAdonList.Add(orderDetailAdonList); lbOptions.ItemsSource = null; lbToppings.ItemsSource = null; _defaultAdonPrice = 0; _optionPrice = 0; SelectedAdons.Text = string.Empty; txtDiscount.Text = String.Empty; Price.Content = String.Empty; lbProducts.UnselectAll(); this.Close(); }