// GET: CheckOutSupplies/Create public ActionResult Create() { // Defining Values to pass into ViewBag below selectListStudents and Supplies var students = db.Students.Where(s => s.StudentsID == s.StudentsID).ToList(); IEnumerable <SelectListItem> selectListStudents = from s in students select new SelectListItem { Value = s.StudentsID.ToString(), Text = s.StudentName + ", UVUID: " + s.UVUID + " " }; var supplies = db.Supplies.Where(s => s.SuppliesID == s.SuppliesID).ToList(); IEnumerable <SelectListItem> selectListSupplies = from s in supplies select new SelectListItem { Value = s.SuppliesID.ToString(), Text = s.Name + ", Value: " + s.Value + ", Number: " + s.Number + ", Class Room: " + s.ClassRoom + " " }; ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepName"); ViewBag.StudentsID = new SelectList(selectListStudents, "Value", "Text"); ViewBag.SuppliesID = new SelectList(selectListSupplies, "Value", "Text"); CheckOutSupplies model = new CheckOutSupplies(); model.CheckedOutDate = DateTime.Now; model.DueDate = DateTime.Now.AddDays(7); return(View(model)); }
public ActionResult DeleteConfirmed(int id) { CheckOutSupplies checkOutSupplies = db.CheckOutSupplies.Find(id); db.CheckOutSupplies.Remove(checkOutSupplies); db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: CheckOutSupplies/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CheckOutSupplies checkOutSupplies = db.CheckOutSupplies.Find(id); if (checkOutSupplies == null) { return(HttpNotFound()); } return(View(checkOutSupplies)); }
public ActionResult Edit([Bind(Include = "CheckOutSuppliesID,StudentsID,SuppliesID,DepartmentID,DueDate,ReturnedSupply,ReturnedDate,CheckedOutDate")] CheckOutSupplies checkOutSupplies) { if (checkOutSupplies.ReturnedSupply) { DateTime CurrentDate = DateTime.Now; checkOutSupplies.ReturnedDate = CurrentDate; db.Entry(checkOutSupplies).State = EntityState.Modified; } if (ModelState.IsValid) { db.Entry(checkOutSupplies).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepName", checkOutSupplies.DepartmentID); ViewBag.StudentsID = new SelectList(db.Students, "StudentsID", "StudentName", checkOutSupplies.StudentsID); ViewBag.SuppliesID = new SelectList(db.Supplies, "SuppliesID", "Name", checkOutSupplies.SuppliesID); return(View(checkOutSupplies)); }
public ActionResult Create([Bind(Include = "CheckOutSuppliesID,StudentsID,SuppliesID,DepartmentID,DueDate,ReturnedSupply,ReturnedDate,CheckedOutDate")] CheckOutSupplies checkOutSupplies) { if (ModelState.IsValid) { try { db.CheckOutSupplies.Add(checkOutSupplies); db.SaveChanges(); return(RedirectToAction("Index")); } catch { return(Content("check out request was invalid go back and try again")); } } ViewBag.SuppliesID = new SelectList(db.Supplies, "SuppliesID", "Name", checkOutSupplies.SuppliesID); ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepName", checkOutSupplies.DepartmentID); ViewBag.StudentsID = new SelectList(db.Students, "StudentsID", "StudentName", checkOutSupplies.StudentsID); return(View(checkOutSupplies)); }
// GET: CheckOutSupplies/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CheckOutSupplies checkOutSupplies = db.CheckOutSupplies.Find(id); if (checkOutSupplies == null) { return(HttpNotFound()); } // Defining Values to pass into ViewBag below selectListStudents and Supplies var students = db.Students.Where(s => s.StudentsID == s.StudentsID).ToList(); IEnumerable <SelectListItem> selectListStudents = from s in students select new SelectListItem { Value = s.StudentsID.ToString(), Text = s.StudentName + ", UVUID: " + s.UVUID + " " }; var supplies = db.Supplies.Where(s => s.SuppliesID == s.SuppliesID).ToList(); IEnumerable <SelectListItem> selectListSupplies = from s in supplies select new SelectListItem { Value = s.SuppliesID.ToString(), Text = s.Name + ", Value: " + s.Value + ", Number: " + s.Number + ", Class Room: " + s.ClassRoom + " " }; ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepName", checkOutSupplies.DepartmentID); ViewBag.StudentsID = new SelectList(selectListStudents, "Value", "Text", checkOutSupplies.StudentsID); ViewBag.SuppliesID = new SelectList(selectListSupplies, "Value", "Text", checkOutSupplies.SuppliesID); return(View(checkOutSupplies)); }