示例#1
0
        // GET: BookTables/Loan/5
        public ActionResult Loan(int?id, string Name)
        {
            //get member's names for drop down list
            var MemberList  = new List <string>();
            var MemberQuery = from item in db.MemberTable
                              select item;

            //populate view model to allow data from different tables to be used in same view
            var model = new MemberBookVM
            {
                MemberTable = MemberQuery.Select(a => new SelectListItem
                {
                    Text  = a.Name,
                    Value = a.Name
                })
            };



            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            BookTable bookTable = db.BookTable.Find(id);

            if (bookTable == null)
            {
                return(HttpNotFound());
            }
            return(View(model));
        }
示例#2
0
        public ActionResult Loan(int id, MemberBookVM model)
        {
            //get member's names for drop down list
            var MemberList  = new List <string>();
            var MemberQuery = from item in db.MemberTable
                              select item;

            //populate view model
            var model1 = new MemberBookVM
            {
                MemberTable = MemberQuery.Select(a => new SelectListItem
                {
                    Text  = a.Name,
                    Value = a.MemberID.ToString()
                })
            };


            if (ModelState.IsValid)
            {
                //used to get the instance of the member where the name is the same as the one saved to the vm
                var result = db.MemberTable.FirstOrDefault(s => s.Name == model.memberName);

                //grabs the book from the database that is currently being looked at
                var book = db.BookTable.FirstOrDefault(s => s.BookID == id);

                if (book != null)
                {   //changes the onloan status to 1 which makes it 'on loan'
                    book.OnLoan = 1;
                    //puts the member id of the selected member into the memberid section in the book table
                    book.MemberID        = result.MemberID;
                    db.Entry(book).State = EntityState.Modified;
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
            }

            //ViewBag.MemberID = new SelectList(db.MemberTable, "MemberID", "Name", bookTable.MemberID);
            return(View("Index"));
        }