コード例 #1
0
        //
        // GET: /PrimaryGuardianBorrows/Create
        public ActionResult Create()
        {
            OFRPDMSContext context = new OFRPDMSContext();
            int centerid = account.GetCurrentUserCenterId();
            ViewBag.PossiblePrimaryGuardians = context.PrimaryGuardians;
            ViewBag.PossibleLibraryResources = context.LibraryResources.Where(lr => lr.CheckedOut == false && lr.CenterId == centerid);

            return View();
        }
コード例 #2
0
        public ActionResult Create(PrimaryGuardianBorrow primaryguardianborrow)
        {
            OFRPDMSContext context = new OFRPDMSContext();
            if (ModelState.IsValid)
            {
                primaryguardianborrow.BorrowDate = System.DateTime.Now;
                context.LibraryResources.Find(primaryguardianborrow.LibraryResourceId).CheckedOut = true;
                primaryguardianborrow.DueDate = primaryguardianborrow.DueDate.AddHours(23);
                primaryguardianborrow.DueDate = primaryguardianborrow.DueDate.AddMinutes(59);
                repoService.primaryGuardianBorrowsRepo.Insert(primaryguardianborrow);
                context.SaveChanges();
                return RedirectToAction("Index");
            }

            ViewBag.PossiblePrimaryGuardians = context.PrimaryGuardians;
            ViewBag.PossibleLibraryResources = context.LibraryResources.Where(lr => lr.CheckedOut == false);
            return View(primaryguardianborrow);
        }
コード例 #3
0
 public ActionResult Edit(PrimaryGuardianBorrow primaryguardianborrow)
 {
     OFRPDMSContext context = new OFRPDMSContext();
     if (ModelState.IsValid)
     {
         if (primaryguardianborrow.Returned)
         {
             context.LibraryResources.Find(primaryguardianborrow.LibraryResourceId).CheckedOut = false;
         }
         else
         {
             return View(primaryguardianborrow);
         }
         primaryguardianborrow.ReturnDate = System.DateTime.Now;
         repoService.primaryGuardianBorrowsRepo.Update(primaryguardianborrow);
         context.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.PossiblePrimaryGuardians = context.PrimaryGuardians;
     ViewBag.PossibleLibraryResources = context.LibraryResources;
     return View(primaryguardianborrow);
 }
コード例 #4
0
        //
        // GET: /PrimaryGuardianBorrows/
        public ViewResult Index(string sortOrder, string currentFilter, string searchString, int? page )
        {
            int centerid = account.GetCurrentUserCenterId();

            ViewBag.CurrentSort = sortOrder;
            ViewBag.PrimaryNameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc" : "";
            ViewBag.ResourceNameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc1" : "";
            ViewBag.ReturnNameSortParm = String.IsNullOrEmpty(sortOrder) ? "Name desc2" : "";

            ViewBag.BorrowDateSortParm = sortOrder == "Date" ? "Date desc" : "Date";
            ViewBag.DueDateSortParm = sortOrder == "Date1" ? "Date desc1" : "Date";
            ViewBag.ReturnDateSortParm = sortOrder == "Date2" ? "Date desc2" : "Date";

            if (Request.HttpMethod == "GET")
            {
                searchString = currentFilter;
            }
            else
            {
                page = 1;
            }
            ViewBag.CurrentFilter = searchString;
             OFRPDMSContext context = new OFRPDMSContext();
            var pgbs = from p in context.PrimaryGuardianBorrows.Where(pgb => pgb.LibraryResource.CenterId == centerid).Include(primaryguardianborrow => primaryguardianborrow.PrimaryGuardian).Include(primaryguardianborrow => primaryguardianborrow.LibraryResource)
                               select p;

            if (!String.IsNullOrEmpty(searchString))
            {
                pgbs = pgbs.Where(p => p.PrimaryGuardian.FirstName.ToUpper().Contains(searchString.ToUpper()) || p.LibraryResource.Name.ToUpper().Contains(searchString.ToUpper()));

            }
            switch (sortOrder)
            {
                case "Name desc":
                    pgbs = pgbs.OrderBy(p => p.PrimaryGuardian.FirstName);

                    break;
                case "Name desc1":

                    pgbs = pgbs.OrderBy(p => p.LibraryResource.Name);

                    break;
                case "Name desc2":

                    pgbs = pgbs.OrderBy(p => p.Returned);

                    break;

                case "Date":
                    pgbs = pgbs.OrderBy(s => s.BorrowDate);
                    break;
                case "Date desc":
                    pgbs = pgbs.OrderByDescending(s => s.BorrowDate);
                    break;
                case "Date1":
                    pgbs = pgbs.OrderBy(s => s.DueDate);
                    break;
                case "Date desc1":
                    pgbs = pgbs.OrderByDescending(s => s.DueDate);
                    break;
                case "Date2":
                    pgbs = pgbs.OrderBy(s => s.ReturnDate);
                    break;
                case "Date desc2":
                    pgbs = pgbs.OrderByDescending(s => s.DueDate);
                    break;

                default:
                    pgbs = pgbs.OrderBy(s => s.BorrowDate);
                    break;
            }

            int pageSize = 10;
            int pageNumber = (page ?? 1);

            return View(pgbs.ToPagedList(pageNumber, pageSize));
        }
コード例 #5
0
 //
 // We took out the edit function and turned it into check in function. The edit view is no longer in use
 public ActionResult Edit(int id)
 {
     OFRPDMSContext context = new OFRPDMSContext();
     PrimaryGuardianBorrow primaryguardianborrow = repoService.primaryGuardianBorrowsRepo.FindById(id);
     ViewBag.PossiblePrimaryGuardians = context.PrimaryGuardians;
     ViewBag.PossibleLibraryResources = context.LibraryResources;
     if (primaryguardianborrow.Returned != true)
     {
         primaryguardianborrow.Returned = true;
         primaryguardianborrow.ReturnDate = System.DateTime.Now;
         LibraryResource res = context.LibraryResources.Find(primaryguardianborrow.LibraryResourceId);
         res.CheckedOut = false;
         context.Entry(res).State = EntityState.Modified;
         repoService.primaryGuardianBorrowsRepo.Update(primaryguardianborrow);
         context.SaveChanges();
     }
     return RedirectToAction("Index");
 }