// 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();
}
