public static void UpdateCartDB(string action, string itemName)
{
RestaurantAppDBEntities DB = new RestaurantAppDBEntities();
switch (action)
{
case "ADD":
{
int menuPK = 0;
var menu = from m in DB.Menus
where m.ItemName == itemName
select m;
menuPK = menu.ToList()[0].pk;
RestaurantDB.Cart tmp = new RestaurantDB.Cart();
tmp.fk_user = theCart.pk;
tmp.fk_item = menuPK;
DB.Carts.Add(tmp);
DB.SaveChanges();
}
break;
case "DEL":
{
int menuPK = 0;
var menu = from m in DB.Menus
where m.ItemName == itemName
select m;
menuPK = menu.ToList()[0].pk;
int amount = 0;
var cart = from c in DB.Carts
where c.fk_user == theCart.pk
select c;
RestaurantDB.Cart tmp = new RestaurantDB.Cart();
foreach (var i in cart)
{
if (i.fk_item == menuPK)
{
amount++;
tmp = i;
}
}
DB.Carts.Remove(tmp);
//for (int i = 0; i < amount - 1; i++)
//{
// DB.Carts.Add(tmp);
//}
DB.SaveChanges();
}
break;
default:
break;
}
}
public static void LoadCart(string userName, string Password)
{
RestaurantAppDBEntities DB = new RestaurantAppDBEntities();
var user = from u in DB.Users
where u.UserName == userName && u.UserPassword == Password
select u;
if (user.ToList().Count == 0)
{
User userTmp = new User();
userTmp.UserName = userName;
userTmp.UserPassword = Password;
userTmp.UserAddress = "Unknown";
DB.Users.Add(userTmp);
DB.SaveChanges();
user = from u in DB.Users
where u.UserName == userName && u.UserPassword == Password
select u;
}
theCart.name = user.ToList()[0].UserName;
theCart.address = user.ToList()[0].UserAddress;
theCart.password = user.ToList()[0].UserPassword;
theCart.pk = user.ToList()[0].pk;
theCart.items.Clear();
var cart = from c in DB.Carts
where c.fk_user == theCart.pk
select c;
foreach (var i in cart)
{
var menu = from m in DB.Menus
where m.pk == i.fk_item
select m;
if (menu.ToList()[0].ItemName != null)
{
AddToCart(menu.ToList()[0].ItemName, 1, menu.ToList()[0].Price);
}
}
}
