public JsonResult Add(IEnumerable <TransactionDB> transac)
        {
            bool status = false;
            int  total  = transac.Last().TOTAL;
            int  a      = transacDB.Add(transac, total);

            if (a != 0)
            {
                status = true;
            }
            return(new JsonResult {
                Data = new { status = status }
            });
        }
        public async Task <ActionResult> SubmitBooking(BookingFormModel formModel)
        {
            var lab_id  = int.Parse(TempData["LabID"].ToString());
            var user_id = int.Parse(HttpContext.Request.Cookies["userID"]);

            var time_id = formModel.time_am + formModel.time_pm;

            var items = await ItemDB.GetAvailableItems(formModel.book_date);

            items.RemoveAll(item => item.type != formModel.item_type);

            switch (time_id)
            {
            case 1:
                items.RemoveAll(item => item.time_am == false);
                break;

            case 2:
                items.RemoveAll(item => item.time_pm == false);
                break;

            case 3:
                items.RemoveAll(item => item.time_am == false || item.time_pm == false);
                break;

            default:
                break;
            }

            if (items.Count > 0)
            {
                for (var i = 0; i < formModel.quantity; ++i)
                {
                    var temp = TransactionDB.Add(new Transaction(user_id, items[i].uuid, (int)Transaction_type.borrow, time_id, formModel.book_date)).Result;
                    if (temp == 1)
                    {
                        TempData["BookingSucceed"] = false;
                        return(RedirectToAction("Booking", new { labID = lab_id }));
                    }
                }
            }

            return(RedirectToAction("Index", "User"));
        }