public void Clear() { FoodOrders.Clear(); DrinkOrders.Clear(); IsReserved = false; numberOfPeople = 0; }
public void Clear() { FoodOrders.Clear(); DrinkOrders.Clear(); //this.NumberOfPeople = 0; IsReserved = false; }
public void Sell(int foodId, int userId, string description) { if (foodId < 1 || foodId > context.Food.Count()) { throw new ArgumentException("Invalid food Id!"); } if (userId < 1 || userId > context.Users.Count()) { throw new ArgumentException("Invalid user Id!"); } var user = context.Users.Find(userId); var order = new Order() { UserId = userId, User = user, Description = description, OrderStatus = OrderStatus.Completed }; context.Orders.Add(order); var foodOrder = new FoodOrders() { Order = order, OrderId = order.Id, Food = context.Food.Find(foodId), FoodId = foodId }; context.FoodOrders.Add(foodOrder); context.SaveChanges(); }
public static void FoodEdit(FoodOrders f) { try { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(@"UPDATE [FoodOrder] SET [FName] = @FName, [FAmount] = @FAmount, [FPrice] = @FPrice, [FTotal] = @FTotal , [FImg] = @FImg WHERE [FID] = @FID", cn); cmd.Parameters.AddWithValue("@FID", f.FID); cmd.Parameters.AddWithValue("@FName", f.FName); cmd.Parameters.AddWithValue("@FAmount", f.FAmount); cmd.Parameters.AddWithValue("@FPrice", f.FPrice); cmd.Parameters.AddWithValue("@FTotal", f.FTotal); cmd.Parameters.AddWithValue("@FImg", f.FImg); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } catch (Exception ex) { System.Console.WriteLine(ex.Message); } }
public decimal GetBill() { decimal drinkBill = DrinkOrders.Sum(x => x.Price); decimal foodBill = FoodOrders.Sum(x => x.Price); decimal totalBill = drinkBill + foodBill; return(totalBill); }
public static void FoodOrderAdd(FoodOrders f) { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand("Insert Into [FoodOrders] ([FName],[FPrice],[FAmount],[FTotal],[FImg]) Values (@FName,@FPrice,@FAmount,@FTotal,@FImg)", cn); cmd.Parameters.AddWithValue("@FName", f.FName); cmd.Parameters.AddWithValue("@FPrice", f.FPrice); cmd.Parameters.AddWithValue("@FAmount", f.FAmount); cmd.Parameters.AddWithValue("@FTotal", f.FTotal); cmd.Parameters.AddWithValue("@FImg", f.FImg); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public static void FoodOrderAdds(FoodOrders f) { SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand( @"if not exists(select 1 from[FoodOrders] where[FName] = @FName) insert into[FoodOrders]([FID],[FName],[FPrice],[FAmount],[FTotal],[FImg]) VALUES(@FID,@FName,@FPrice,@FAmount,@FTotal,@FImg) else update[FoodOrders] set [FAmount] = @FAmount, [FTotal] = @FTotal,[FImg] = @FImg WHERE [FID] = @FID", cn); cmd.Parameters.AddWithValue("@FID", f.FID); cmd.Parameters.AddWithValue("@FName", f.FName); cmd.Parameters.AddWithValue("@FPrice", f.FPrice); cmd.Parameters.AddWithValue("@FAmount", f.FAmount); cmd.Parameters.AddWithValue("@FTotal", f.FTotal); cmd.Parameters.AddWithValue("@FImg", f.FImg); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); }
public List <FoodOrders> getFoodOrderDetails(int orderId) { List <FoodOrders> lst = new List <FoodOrders>(); DataSet ds = new DataSet(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@orderid", orderId); ds = DBConnectionSQL.gettable("GetFoodOrder", param); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { FoodOrders objATT = new FoodOrders(); objATT.foodName = dr["menu_name,"].ToString(); objATT.quantity = dr["quantity"].ToString(); objATT.price = Convert.ToDouble(dr["price"]); lst.Add(objATT); } } return(lst); }
public void deleteBudget(TravelAdvisorEntities1 db, bool deleteExpense) { if (deleteExpense) { foreach (var acc in Accommodations.ToList()) { db.Accommodations.Remove(acc); } foreach (var food in FoodOrders.ToList()) { db.FoodOrders.Remove(food); } foreach (var tra in Transportations.ToList()) { db.Transportations.Remove(tra); } foreach (var othr in Other.ToList()) { db.Other.Remove(othr); } } db.Budgets.Remove(this); }
public decimal GetBill() { return(FoodOrders.Sum(x => x.Price) + DrinkOrders.Sum(x => x.Price) + Price); }
public void OrderFood(IFood food) { FoodOrders.Add(food); }