public ActionResult Create(OrderCommonViewModel Orders)
{
if (ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
return(View(Orders.Order));
}
// GET: Orders/Create
public ActionResult Create()
{
List <OrderCommonViewModel> OrderItemlist = new List <OrderCommonViewModel>();
var customerlist = (from fooditem in db.FoodItems
join fct in db.FoodCategories on fooditem.FoodCategoryID equals fct.FoodCategoryID
join ftp in db.FoodTypes on fooditem.FoodTypeID equals ftp.FoodTypeID
orderby fct.FoodCategoryName
select new { fct.FoodCategoryName, ftp.FoodTypeName, fooditem.FoodItemName, fooditem.Price }).ToList();
foreach (var item in customerlist)
{
OrderCommonViewModel ocvm = new OrderCommonViewModel(); // ViewModel
ocvm.FoodCategoryName = item.FoodCategoryName;
ocvm.FoodTypeName = item.FoodTypeName;
ocvm.FoodItemName = item.FoodItemName;
ocvm.Price = item.Price;
ocvm.Quantity = 1;
OrderItemlist.Add(ocvm);
}
return(View(OrderItemlist));
}
public ActionResult GetBill(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <OrderCommonViewModel> OrderItemlist = new List <OrderCommonViewModel>();
var orderlist = (from ord in db.OrderDetails
join fooditem in db.FoodItems on ord.FoodItemID equals fooditem.FoodItemID
join fct in db.FoodCategories on fooditem.FoodCategoryID equals fct.FoodCategoryID
join ftp in db.FoodTypes on fooditem.FoodTypeID equals ftp.FoodTypeID
where ord.OrderID == id
orderby fct.FoodCategoryName
select new { ord.OrderID, ord.OrderDetailsID, fct.FoodCategoryName, ftp.FoodTypeName, fooditem.FoodItemName, fooditem.Price, ord.Quantity }).ToList();
foreach (var item in orderlist)
{
OrderCommonViewModel ocvm = new OrderCommonViewModel(); // ViewModel
ocvm.FoodCategoryName = item.FoodCategoryName;
ocvm.FoodTypeName = item.FoodTypeName;
ocvm.FoodItemName = item.FoodItemName;
ocvm.Price = item.Price;
ocvm.Quantity = item.Quantity;
ocvm.OrderDetailsID = item.OrderDetailsID;
OrderItemlist.Add(ocvm);
}
if (OrderItemlist == null)
{
return(HttpNotFound());
}
ViewBag.OrderID = id;
return(View(OrderItemlist.ToList()));
}
// GET: OrderDetails/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
List <OrderCommonViewModel> OrderItemlist = new List <OrderCommonViewModel>();
var orderlist = (from ord in db.OrderDetails
join fooditem in db.FoodItems on ord.FoodItemID equals fooditem.FoodItemID
join fct in db.FoodCategories on fooditem.FoodCategoryID equals fct.FoodCategoryID
join ftp in db.FoodTypes on fooditem.FoodTypeID equals ftp.FoodTypeID
where ord.OrderID == id
orderby fct.FoodCategoryName
select new { ord.OrderID, ord.OrderDetailsID, ord.ChefID, ord.statuscode, fct.FoodCategoryName, ftp.FoodTypeName, fooditem.FoodItemName, fooditem.Price, ord.Quantity }).ToList();
var orderpreparedcnt = 0;
var Assignedcnt = 0;
foreach (var item in orderlist)
{
OrderCommonViewModel ocvm = new OrderCommonViewModel(); // ViewModel
ocvm.FoodCategoryName = item.FoodCategoryName;
ocvm.FoodTypeName = item.FoodTypeName;
ocvm.FoodItemName = item.FoodItemName;
ocvm.Price = item.Price;
ocvm.Quantity = item.Quantity;
ocvm.OrderDetailsID = item.OrderDetailsID;
ocvm.ChefID = item.ChefID;
ocvm.StatusCode = item.statuscode;
if (item.statuscode == 4)
{
Assignedcnt++;
}
else if (item.statuscode == 6)
{
Assignedcnt++;
orderpreparedcnt++;
}
else
{
}
if (orderlist.Count() == Assignedcnt)
{
ViewBag.Assigned = true;
}
else
{
ViewBag.Assigned = false;
}
if (orderlist.Count() == orderpreparedcnt)
{
ViewBag.OrderPrepared = true;
}
else
{
ViewBag.OrderPrepared = false;
}
OrderItemlist.Add(ocvm);
}
if (OrderItemlist == null)
{
return(HttpNotFound());
}
ViewBag.Chefs = db.Chefs.ToList();
var setStaus = new List <int>()
{
4, 5, 6
};
ViewBag.StatusMaster = db.StatusMasters.Where(x => setStaus.Contains(x.statuscode)).ToList();
ViewBag.OrderID = id;
return(View(OrderItemlist.ToList()));
}
