private void AddItem_Click(object sender, RoutedEventArgs e)
{
if (Quantitytxt.Text != "" || fooditem.SelectedValue != null || tableitem.SelectedValue != null)
{
_vOrderItems = new ViewOrderItems();
_oVM = new OrderingViewModel();
//fooditemsdata = _oVM.getFoodItems(); //get food detail
_vOrderItems.FoodId = fooditemsdata.FoodID;
_vOrderItems.FoodName = fooditemsdata.FoodName;
_vOrderItems.Quantity = Convert.ToInt32(Quantitytxt.Text);
_vOrderItems.TableId = Convert.ToInt32(tableitem.SelectedItem);
_vOrderItems.Price = fooditemsdata.fPrice * _vOrderItems.Quantity;
myCart.Add(_vOrderItems);
fooditemsgrid.ItemsSource = myCart;
fooditemsgrid.Items.Refresh(); //veri ekledikçe data grid güncelleme işlemi
status.Content = "Ürün Eklendi";
}
else
{
status.Content = "Tüm alanlar zorunludur.";
}
}
private void AddItem_Click(object sender, RoutedEventArgs e)//button add
{
if (!string.IsNullOrEmpty(fooditem.SelectedValue.ToString()) ||
!string.IsNullOrEmpty(tableitem.SelectedValue.ToString()) || !string.IsNullOrEmpty(Quantitytxt.Text))
{
_vOrderItems = new ViewOrderItems();
_oVM = new OrderingViewModel();
fooditemdata = _oVM.getFoodDetail(Convert.ToInt32(fooditem.SelectedValue));
_vOrderItems.Quantity = Convert.ToInt32(Quantitytxt.Text);
_vOrderItems.Price = fooditemdata.fPrice * _vOrderItems.Quantity;
_vOrderItems.FoodID = fooditemdata.FoodID;
_vOrderItems.FoodName = fooditemdata.FoodName;
_vOrderItems.TableID = Convert.ToInt32(tableitem.SelectedValue);
var createdOrder = _oVM.PlaceOrder(_vOrderItems);
if (createdOrder != null)
{
mycart.Add(_vOrderItems);
fooditemsgrid.ItemsSource = mycart;
fooditemsgrid.Items.Refresh();
status.Content = "Додано до списку замовлених страв";
}
}
else
{
status.Foreground = Brushes.Red;
status.Content = "Всі поля обов'язкові для заповнення";
status.Foreground = Brushes.Green;
}
}
public void DeleteOrderItem(ViewOrderItems order)
{
_rDBContext.Orders.Remove(new Orders {
OrderID = order.OrderID
});
_rDBContext.SaveChanges();
}
public void UpdateOrderDetails(ViewOrderItems fooditem)
{
var returnedOrder = _rDBContext.FoodOrders.First(x => x.OrderID == fooditem.OrderID);
var foodprice = returnedOrder.Price / returnedOrder.Quantity;
returnedOrder.Quantity = fooditem.Quantity;
returnedOrder.Price = fooditem.Quantity * foodprice;
var res = _rDBContext.SaveChanges();
}
public void UpdateOrderDetails(ViewOrderItems fooditem)
{
ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
conn = new SqlConnection(ConnectionString);
conn.Open();
string query = "Update FoodOrders set Quantity = @Quantity, Price = @Price where FoodOrderID = @FoodOrderID";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@FoodOrderID", fooditem.FoodOrderID);
cmd.Parameters.AddWithValue("@Quantity", fooditem.Quantity);
cmd.Parameters.AddWithValue("@Price", fooditem.Price);
cmd.ExecuteNonQuery();
conn.Close();
}
public ViewOrderItems PlaceOrder(ViewOrderItems obj)
{
var createdOrder = _rDBContext.Orders.Add(new Orders
{
TableID = obj.TableID,
CreatedDate = DateTime.UtcNow,
OrderStatus = Orderstatus.InProgress.ToString(),
TotalPrice = obj.Price
});
var resultFromDb = _rDBContext.SaveChanges();
obj.OrderID = createdOrder.OrderID;
return(obj);
}
public ObservableCollection <ViewOrderItems> getFoodOrderDetails(TableList selectedtable)
{
DataTable dt = new DataTable();
ObservableCollection <ViewOrderItems> orderItems = new ObservableCollection <ViewOrderItems>();
ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
conn = new SqlConnection(ConnectionString);
conn.Open();
string query = @"select * from TableLists t inner join Orders o on t.TableID = o.TableID inner join FoodOrders fo on
fo.OrderID = o.OrderID inner join FoodItems ft on ft.FoodID = fo.FoodID where t.BookingStatus = @BookingStatus and t.TableID = @TableID and o.OrderStatus = @OrderStatus";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@BookingStatus", bookingstatus.Booked.ToString());
cmd.Parameters.AddWithValue("@TableID", selectedtable.TableID);
cmd.Parameters.AddWithValue("@OrderStatus", Orderstatus.InProgress.ToString());
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
for (int i = 0; dt.Rows.Count > i; i++)
{
ViewOrderItems orderItem = new ViewOrderItems();
orderItem.fPrice = Convert.ToInt32(dt.Rows[i]["fPrice"]);
orderItem.FoodOrderID = Convert.ToInt32(dt.Rows[i]["FoodOrderID"]);
orderItem.OrderID = Convert.ToInt32(dt.Rows[i]["OrderID"]);
orderItem.FoodID = Convert.ToInt32(dt.Rows[i]["FoodID"]);
orderItem.TableID = Convert.ToInt32(dt.Rows[i]["FoodID"]);
orderItem.FoodName = dt.Rows[i]["FoodName"].ToString();
orderItem.TableName = dt.Rows[i]["TableName"].ToString();
orderItem.OrderCreatedDate = Convert.ToDateTime(dt.Rows[i]["CreatedDate"]);
orderItem.OrderStatus = dt.Rows[i]["OrderStatus"].ToString();
orderItem.Quantity = Convert.ToInt32(dt.Rows[i]["Quantity"]);
orderItem.Price = Convert.ToInt32(dt.Rows[i]["Price"]);
orderItem.BookingStatus = dt.Rows[i]["BookingStatus"].ToString();
orderItems.Add(orderItem);
}
return(orderItems);
}
private void AddItem_Click(object sender, RoutedEventArgs e)
{
if (fooditem.SelectedValue != null || tableitem.SelectedValue != null || Quantitytxt.Text != null)
{
_vOrderItems = new ViewOrderItems();
_oVM = new OrderingViewModel();
//fooditemsdata = _oVM.getFoodDetail() // getfooddetail
_vOrderItems.Quantity = Convert.ToInt32(Quantitytxt.Text);
_vOrderItems.Price = fooditemsdata.fPrice * _vOrderItems.Quantity;// ücret hesaplanır
_vOrderItems.TableID = Convert.ToInt32(tableitem.SelectedItem);
_vOrderItems.FoodID = fooditemsdata.FoodID;
_vOrderItems.FoodName = fooditemsdata.FoodName;
myCart.Add(_vOrderItems);
fooditemsgrid.ItemsSource = myCart;
fooditemsgrid.Items.Refresh();
status.Content = "Ürün eklendi.";
}
else
{
status.Content = "Tüm alanlar zorunlu doldurulmalıdır";
}
}
private void AddItem_Click(object sender, RoutedEventArgs e)
{
if (fooditem.SelectedValue != null || tableitem.SelectedValue != null || Quantitytxt.Text != null)
{
_vOrderItems = new ViewOrderItems();
_oVM = new OrderingViewModel();
fooditemdata = _oVM.getFoodDetail(Convert.ToInt32(fooditem.SelectedValue));
_vOrderItems.Quantity = Convert.ToInt32(Quantitytxt.Text);
_vOrderItems.Price = fooditemdata.fPrice * _vOrderItems.Quantity;
_vOrderItems.FoodID = fooditemdata.FoodID;
_vOrderItems.FoodName = fooditemdata.FoodName;
_vOrderItems.TableID = Convert.ToInt32(tableitem.SelectedValue);
mycart.Add(_vOrderItems);
fooditemsgrid.ItemsSource = mycart;
fooditemsgrid.Items.Refresh();
status.Content = "Ürün listeye eklendi";
}
else
{
status.Foreground = Brushes.Red;
status.Content = "Tüm alanlar zorunludur";
status.Foreground = Brushes.Green;
}
}
public void DeleteOrderItem(ViewOrderItems obj)
{
_rDBContext.SaveChanges();
}
public ViewOrderItems PlaceOrder(ViewOrderItems Obj)
{
_dbLayerObj = new DataAccessLayer();
return(_dbLayerObj.PlaceOrder(Obj));
}
