public string Order(OrderFoodVM orderFood)
{
int rowAffected = _orderGateway.Order(orderFood);
if (rowAffected > 0)
{
return("This Order has been saved.");
}
return("Order Failed!");
}
public int Order(OrderFoodVM orderFood)
{
SqlConnection connection = new SqlConnection(connectionString);
string query = "INSERT INTO Orders(MemberId,FoodItemId,Quantity,OrderDate) VALUES (" + orderFood.MemberId +
"," + orderFood.FoodItemId + "," + orderFood.Quantity + ",'" +
orderFood.OrderDate.Date.ToString("d") + "');";
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
}
public ActionResult Save(OrderFoodVM orderFood)
{
List <Member> members = _orderManager.GetAllMembers();
ViewBag.Members = new SelectList(members, "Id", "Code");
List <FoodItem> foodItems = _orderManager.GetAllFoodItems();
ViewBag.Foods = new SelectList(foodItems, "Id", "Name");
if (ModelState.IsValid)
{
ViewBag.Message = _orderManager.Order(orderFood);
}
return(View());
}
// GET: Order
public ActionResult Order()
{
//UserLIst
UserOrderVM userListOrderVm = new UserOrderVM();
var memberList = db.Users.ToList();
userListOrderVm.UserOrderList = new SelectList(memberList, "Id", "Code");
ViewBag.UserList = userListOrderVm.UserOrderList;
//FoodList
OrderFoodVM orderFood = new OrderFoodVM();
var foodList = db.FoodItems.ToList();
orderFood.FoodOrderList = new SelectList(foodList, "Id", "FoodName");
ViewBag.FoodList = orderFood.FoodOrderList;
return(View());
}
