public OrderDish GetOrderDish(int id) //when we know the return is only one result we use an IF-loop as decision maker { OrderDish dish = null; string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "SELECT * FROM OrderDishes where OrderDishID = @id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { dish = new OrderDish(); dish.OrderDishID = (int)dr["OrderDishID"]; dish.DishID = (int)dr["DishID"]; dish.Quantity = (int)dr["Quantity"]; dish.Price = (long)dr["Price"]; } } } } catch (Exception e) { throw e; } return(dish); }
public int UpdateOrderDish(OrderDish orderDish) { int result = 0; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "UPDATE OrderDish SET IdDish=@idDish,Quantity=@quantity,OrderDishPrice=@orderDishPrice WHERE IdOrder=@id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", orderDish.IdOrder); cmd.Parameters.AddWithValue("@idDish", orderDish.IdDish); cmd.Parameters.AddWithValue("@quantity", orderDish.Quantity); cmd.Parameters.AddWithValue("@orderDishPrice", orderDish.OrderDishPrice); cn.Open(); result = cmd.ExecuteNonQuery(); } } catch (Exception e) { throw e; } return(result); }
public OrderDish AddOrderDish(OrderDish dish) { string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Insert into OrderDishes(OrderDishID,DishID , Quantity, Price)" + "values (@id, @dishId, @quantity, @price); SELECT SCOPE_IDENTITY()"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", dish.OrderDishID); cmd.Parameters.AddWithValue("@restId", dish.DishID); cmd.Parameters.AddWithValue("@quantity", dish.Quantity); cmd.Parameters.AddWithValue("@price", dish.Price); cn.Open(); dish.DishID = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception e) { throw e; } return(dish); }
public OrderDish GetOrderDish(int id) { OrderDish orderdishes = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from Order_dishes where IdOrderDishes = @id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { orderdishes = new OrderDish(); orderdishes.IdOrder = (int)dr["IdOrder"]; orderdishes.IdDishes = (int)dr["IdDishes"]; orderdishes.Quantity = (int)dr["Quantity"]; } } } } catch (Exception e) { throw e; } return(orderdishes); }
public int UpdateOrderDish(OrderDish dish) { int result = 0; string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Update Dishes SET Quantity = @quantity where OrderDishID = @id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", dish.DishID); cmd.Parameters.AddWithValue("@quantity", dish.Quantity); cn.Open(); result = cmd.ExecuteNonQuery(); } } catch (Exception e) { throw e; } return(result); }
public OrderDish AddOrderDish(OrderDish orderDish) { //string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "insert into order_dishes(fk_orders, fk_dishes, quantity) " + "values(@fk_orders, @fk_dishes, @quantity);" + "select scope_identity();"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@fk_orders", orderDish.order.id); cmd.Parameters.AddWithValue("@fk_dishes", orderDish.dish.id); cmd.Parameters.AddWithValue("@quantity", orderDish.quantity); cn.Open(); orderDish.id = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception e) { throw e; } return(orderDish); }
private void Delete_Order1(object sender, RoutedEventArgs e) { var OrderRepo = new OrderRepository(); OrderDish orderDish = Stolik1.SelectedItem as OrderDish; OrderRepo.DeleteOrder(orderDish.OrderID); this.NavigationService.Navigate(new OrdersPage()); }
public ActionResult DeleteConfirmed(int id) { OrderDish orderDish = db.OrderDishes.Find(id); db.OrderDishes.Remove(orderDish); db.SaveChanges(); return(RedirectToAction("Index")); }
// *** public async Task <IResponseDto> CreateOrder(CreateOrderDto request) { bool areAllAvailable = true; var wantedDishesEnumerator = request.WantedDishes.GetEnumerator(); IList <Dish> wantedDishes = new List <Dish>(); IDictionary <Guid, int> wantedDishesCount = new Dictionary <Guid, int>(); while (wantedDishesEnumerator.MoveNext() && areAllAvailable == true) { var wantedDish = await _unitOfWork.DishesRepository.Get(wantedDishesEnumerator.Current.Id); wantedDishes.Add(wantedDish); wantedDishesCount.Add(wantedDish.Id, wantedDishesEnumerator.Current.Count); areAllAvailable = wantedDish.IsAvailable; } wantedDishesEnumerator.Dispose(); if (areAllAvailable == false) { return(ErrorResponseDto.Create("Some dishes are not available.")); } var createdOrder = Order.Create(DateTime.Now, request.Adress); await _unitOfWork.OrdersRepository.Add(createdOrder); foreach (var wantedDish in wantedDishes) { wantedDishesCount.TryGetValue(wantedDish.Id, out int count); var orderDish = OrderDish.Create(wantedDish, createdOrder, count); await _unitOfWork.OrderDishesRepository.Add(orderDish); foreach (var wantedDishIngredient in wantedDish.DishIngredients) { IngredientOnStock usedIngredient = wantedDishIngredient.Ingredient; usedIngredient.Quantity -= wantedDishIngredient.Quantity; await _unitOfWork.IngredientsRepository.Update(wantedDishIngredient.Ingredient); foreach (var usedIngredientDish in wantedDishIngredient.Ingredient.IngredientDishes) { if (usedIngredientDish.Quantity > wantedDishIngredient.Ingredient.Quantity) { usedIngredientDish.Dish.IsAvailable = false; await _unitOfWork.DishesRepository.Update(usedIngredientDish.Dish); } } } } await _unitOfWork.CommitAsync(); // cauta dishurile orderului //verifica daca sunt available // create order // scade din fiecare ingredient folosit in dishurile alese //si pentru fiecare ingredient modificat se verifica dishurile la care se foloseste ingredientul (is available?) return(SuccessResponseDto.Create(_mapper.Map <OrderDto>(createdOrder))); }
public bool CreateOrderDish(OrderDish instance) { if (instance.OrderDishId == 0) { Db.OrderDishs.InsertOnSubmit(instance); Db.OrderDishs.Context.SubmitChanges(); return(true); } return(false); }
public ActionResult Edit([Bind(Include = "OrderDishID,Count")] OrderDish orderDish) { if (ModelState.IsValid) { db.Entry(orderDish).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(orderDish)); }
static OrderDish MakeFryedPotato() { OrderDish potatoFree = Oficiant.GetOrderDish; potatoFree += SmallCooker.CleanProduct; potatoFree += SmallCooker.PrepareProduct; potatoFree += ShefCooker.CookDish; potatoFree += Oficiant.ServiceDish; potatoFree += Oficiant.TakeMoney; return(potatoFree); }
public ActionResult Create([Bind(Include = "OrderDishID,Count")] OrderDish orderDish) { if (ModelState.IsValid) { db.OrderDishes.Add(orderDish); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(orderDish)); }
public bool RemoveOrderDish(int OrderDishId) { OrderDish instance = Db.OrderDishs.FirstOrDefault(p => p.OrderDishId == OrderDishId); if (instance != null) { Db.OrderDishs.DeleteOnSubmit(instance); Db.OrderDishs.Context.SubmitChanges(); return(true); } return(false); }
public bool UpdateOrderDish(OrderDish instance) { OrderDish cache = Db.OrderDishs.FirstOrDefault(p => p.OrderDishId == instance.OrderDishId); if (instance.OrderDishId != 0) { cache.DishId = instance.DishId; cache.OrderId = instance.OrderId; cache.Count = instance.Count; Db.OrderDishs.Context.SubmitChanges(); return(true); } return(false); }
// GET: OrderDishes/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } OrderDish orderDish = db.OrderDishes.Find(id); if (orderDish == null) { return(HttpNotFound()); } return(View(orderDish)); }
static void Order(Client client, OrderDish orderDish) { if (client.Job == "Taxes") { orderDish -= Oficiant.TakeMoney; orderDish += (Dish d) => { d.Price = 0; }; } if (client.Job == "Police") { orderDish -= Oficiant.TakeMoney; orderDish += Oficiant.GiveMoney; } }
public List <OrderDish> GetOrderDishByOrderId(int id) { List <OrderDish> results = null; //string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "Select * from order_dishes where fk_orders = @id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <OrderDish>(); } OrderDish orderDish = new OrderDish(); orderDish.id = (int)dr["id"]; orderDish.quantity = (int)dr["quantity"]; // Voir si modifications souhaitées OrdersDB ordersDB = new OrdersDB(Configuration); orderDish.order = ordersDB.GetOrderById((int)dr["fk_orders"]); DishesDB dishesDB = new DishesDB(Configuration); orderDish.dish = dishesDB.GetDishById((int)dr["fk_dishes"]); results.Add(orderDish); } } } } catch (Exception e) { throw e; } return(results); }
public IActionResult AddToCart() { //System.Diagnostics.Debug.WriteLine(Request.Form["qty"]); int quantity = int.Parse(Request.Form["qty"]); int dishid = int.Parse(Request.Form["dishId"]); Dish dish = dishesManager.GetDishById(dishid); int userid = (int)HttpContext.Session.GetInt32("userid"); //int[] order = { userid, dish.id, quantity }; // le user veut rajouter qqch au panier, déjà qqch dedans ? // => orderid dans la session int orderid = (int)HttpContext.Session.GetInt32("orderid").GetValueOrDefault(); System.Diagnostics.Debug.WriteLine("-----------------orderid=" + orderid); Order order = new Order(); if (orderid != 0) // dans ce cas on rajoute une ligne dans order_dishes { order = ordersManager.GetOrderById(orderid); } else // sinon on doit créer une commande { Customer customer = customersManager.GetCustomerById(userid); //Deliverer deliverer = deliverersManager.GetDelivererForCity(customer.city.id); // On assigne un livreur temporaire à la commande Deliverer deliverer = deliverersManager.GetTempDeliverer(); order = new Order { customer = customer, deliverer = deliverer, delivery_time_requested = DateTime.Now }; order = ordersManager.AddOrder(order); HttpContext.Session.SetInt32("orderid", order.id); // on stocke l'id de la ville pour qu'on ne puisse commander que dans une ville par commande HttpContext.Session.SetInt32("cityid", dish.restaurant.city.id); } HttpContext.Session.SetInt32("addedToCart", 1); OrderDish orderDish = new OrderDish { order = order, dish = dish, quantity = quantity }; orderDishesManager.AddOrderDish(orderDish); return(RedirectToAction("List", "Dishes", new { id = Request.Form["restaurantId"] })); }
public ActionResult Create(int id, OrderDish od) { int idOrder = (int)HttpContext.Session.GetInt32("idOrder"); var creation = new OrderDish(); creation.IdOrder = idOrder; creation.IdDish = id; if (od.Quantity > 0 && od.Quantity <= 20) { creation.Quantity = od.Quantity; } else { ViewData["Message"] = "La Quantité doit être entre 1 et 20 !"; return(View()); } var dish = DishesManager.GetDish(id); creation.OrderDishPrice = dish.DishPrice * creation.Quantity; var test = OrderDishManager.GetOrderDishes(idOrder); if (test != null) { foreach (var t in test) { if (t.IdDish == id) { return(RedirectToAction("Update", creation)); } } } else { OrderDishManager.AddOrderDish(creation); } return(RedirectToAction("GetAllDishes", "Dish")); }
public ActionResult Update(OrderDish orderDish) { var orderdishDb = OrderDishManager.GetOrderDish(orderDish.IdOrder, orderDish.IdDish); if (orderdishDb.Quantity + orderDish.Quantity < 0 || orderdishDb.Quantity + orderDish.Quantity > 20) { ViewData["Message"] = "La Quantité doit être entre 1 et 20 !"; return(RedirectToAction("Create", orderDish.IdDish)); } orderdishDb.Quantity += orderDish.Quantity; orderdishDb.OrderDishPrice += orderDish.OrderDishPrice; OrderDishManager.UpdateOrderDish(orderdishDb); return(RedirectToAction("GetAllDishes", "Dish")); }
public List <OrderDish> GetOrderDishes(int id) { List <OrderDish> results = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "SELECT * FROM OrderDish WHERE IdOrder = @id"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@id", id); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <OrderDish>(); } OrderDish orderDishes = new OrderDish(); orderDishes.IdOrder = (int)dr["IdOrder"]; orderDishes.IdDish = (int)dr["IdDish"]; orderDishes.Quantity = (int)dr["Quantity"]; orderDishes.OrderDishPrice = (decimal)dr["OrderDishPrice"]; results.Add(orderDishes); } } } } catch (Exception e) { throw e; } return(results); }
// POST api/orderdish/ public HttpResponseMessage Post([FromBody] OrderDish value) { ServerValidationInfo vi = null; value.UpdateDate = DateTime.Now; if (!ModelState.IsValid) { vi = new ServerValidationInfo(ModelState); } if (vi != null && vi.ContainsError) { return(Request.CreateResponse(HttpStatusCode.BadRequest, vi)); } context.Entry(value).State = System.Data.EntityState.Added; context.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK, value)); }
public IActionResult DeleteItem(int id) { OrderDish od = orderDishesManager.GetOrderDishById(id); int orderid = od.order.id; List <OrderDish> orderDishes = orderDishesManager.GetOrderDishByOrderId(orderid); orderDishesManager.DeleteOrderDish(id); // S'il y a qu'un seul item dans la commande, il faut supprimer le verrour sur la ville if (orderDishes.Count() == 1) { HttpContext.Session.Remove("orderid"); HttpContext.Session.Remove("cityid"); ordersStatusHistoryManager.DeleteOrderStatusHistoryByOrderId(orderid); ordersManager.DeleteOrderById(orderid); } HttpContext.Session.SetInt32("deletedItem", 1); return(RedirectToAction("DisplayCart", "Orders")); }
public void AddOrderDishes(OrderDish orderDish) { try { using (SqlConnection cn = new SqlConnection(connectionString)) { String query = "INSERT INTO Order_dishes(IdOrder,IdDishes,Quantity) values(@IdOrder,@IdDishes,@Quantity)"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@IdDishes", orderDish.IdDishes); cmd.Parameters.AddWithValue("@IdOrder", orderDish.IdOrder); cmd.Parameters.AddWithValue("@Quantity", orderDish.Quantity); cn.Open(); cmd.ExecuteScalar(); } } catch (Exception e) { throw e; } }
public List <OrderDish> GetOrderDishes() { List <OrderDish> results = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "SELECT * FROM Order_dishes"; SqlCommand cmd = new SqlCommand(query, cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <OrderDish>(); } OrderDish orderDishes = new OrderDish(); orderDishes.IdOrder = (int)dr["IdOrder"]; orderDishes.IdDishes = (int)dr["IdDishes"]; orderDishes.Quantity = (int)dr["Quantity"]; results.Add(orderDishes); } } } } catch (Exception e) { throw e; } return(results); }
public List <OrderDish> GetOrderDishes() //if we know the query returns multiple results use while loop { List <OrderDish> results = null; string connectionString = Configuration.GetConnectionString("DefaultConnection"); try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "SELECT * FROM OrderDishes"; SqlCommand cmd = new SqlCommand(query, cn); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { while (dr.Read()) { if (results == null) { results = new List <OrderDish>(); } OrderDish dish = new OrderDish(); dish.OrderDishID = (int)dr["OrderDishID"]; dish.DishID = (int)dr["DishID"]; dish.Price = (long)dr["Price"]; results.Add(dish); } } } } catch (Exception e) { throw e; } return(results); }
protected void dell_OrderDish(int Id)//удаление рецепта из заказа { if (UserAct.Status == "guest") { List <OrderDish> asd = (List <OrderDish>)Session["OrderDishUser"]; OrderDish od = asd.Where(p => p.DishId == Id).FirstOrDefault(); Order curord = (Order)Session["OrderUser"]; curord.Price -= (decimal)Repository.Dishs.Where(p => (p.DishId == Id)).FirstOrDefault().Price *od.Count; asd.Remove(od); Session["OrderUser"] = curord; Session["OrderDishUser"] = asd; } else { OrderDish delord = Repository.OrderDishs.Where(p => (p.OrderId == CheckOrders.OrderId && p.DishId == Id)).FirstOrDefault(); Order curord = Repository.Orders.Where(p => p.OrderId == CheckOrders.OrderId).FirstOrDefault(); curord.Price -= (decimal)Repository.Dishs.Where(p => (p.DishId == Id)).FirstOrDefault().Price *delord.Count; Repository.UpdateOrder(curord); Repository.RemoveOrderDish(delord.OrderDishId); } Response.Redirect("~/Page/BasketPage.aspx"); }
public OrderDish GetOrderDish(int idOrder, int idDish) { OrderDish orderDish = null; try { using (SqlConnection cn = new SqlConnection(connectionString)) { string query = "SELECT * FROM OrderDish WHERE IdOrder = @idOrder AND IdDish = @idDish"; SqlCommand cmd = new SqlCommand(query, cn); cmd.Parameters.AddWithValue("@idOrder", idOrder); cmd.Parameters.AddWithValue("@idDish", idDish); cn.Open(); using (SqlDataReader dr = cmd.ExecuteReader()) { if (dr.Read()) { orderDish = new OrderDish(); orderDish.IdOrder = (int)dr["IdOrder"]; orderDish.IdDish = (int)dr["IdDish"]; orderDish.Quantity = (int)dr["Quantity"]; orderDish.OrderDishPrice = (decimal)dr["OrderDishPrice"]; } } } } catch (Exception e) { throw e; } return(orderDish); }
// PUT api/orderdish/ public HttpResponseMessage Put([FromBody] OrderDish value, string filter = null) { ServerValidationInfo vi = null; value.UpdateDate = DateTime.Now; if (!ModelState.IsValid) { vi = new ServerValidationInfo(ModelState); } if (filter == null) { context.Entry(value).State = System.Data.EntityState.Modified; } else { var old = context.OrderDishs.SingleOrDefault(queryBuider.CreateWhere(filter)); old.Id = value.Id; old.OrderId = value.OrderId; old.DishId = value.DishId; old.DishPrice = value.DishPrice; old.Quantity = value.Quantity; old.SizeId = value.SizeId; old.DressingId = value.DressingId; old.DressingPrice = value.DressingPrice; old.SubTotal = value.SubTotal; old.UpdateDate = value.UpdateDate; old.Remarks = value.Remarks; old.UpdateUserId = value.UpdateUserId; } if (vi != null && vi.ContainsError) { return(Request.CreateResponse(HttpStatusCode.BadRequest, vi)); } var result = context.SaveChanges() > 0; return(Request.CreateResponse(HttpStatusCode.OK, result)); }