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