public ActionResult Edit(CollectionModels collection, int?page)
        {
            var oldCollection = db.CollectionModel.Where(m => m.Id == collection.Id).FirstOrDefault();

            db.CollectionModel.Remove(oldCollection);
            db.SaveChanges();

            var newCollection = new CollectionModels();

            newCollection.Collection_Id = collection.Collection_Id;
            newCollection.Disease_Term  = collection.Disease_Term;
            newCollection.Title         = collection.Title;

            db.CollectionModel.Add(newCollection);
            db.SaveChanges();

            var collectionList = db.CollectionModel.OrderBy(m => m.Id).ToList();

            var count = 1;

            foreach (var item in collectionList)
            {
                item.Collection_Id = count;
                db.SaveChanges();
                count++;
            }
            var orderedList = db.CollectionModel.OrderBy(m => m.Id).ToList().ToPagedList(page ?? 1, 6);

            return(View("Index", orderedList));
        }
        // GET: Collections/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            try
            {
                Collection       collection = _collectionManager.RetreiveCollectionByID(id);
                CollectionModels model      = new CollectionModels
                {
                    Name         = collection.Name,
                    CollectionID = collection.CollectionID,
                    UserID       = collection.UserID,
                    Active       = collection.Active
                };
                System.Web.HttpContext.Current.Session["editCollection"] = collection;


                return(View(model));
            }
            catch (Exception ex)
            {
                return(RedirectToAction("Index", "Error", new { message = ex.Message, stackTrace = ex.StackTrace }));
            }
        }
        // GET: Create
        public ActionResult Create()
        {
            var collectionId = db.CollectionModel.Max(m => m.Collection_Id);
            var model        = new CollectionModels();

            model.Collection_Id = collectionId + 1;

            return(View(model));
        }
        // GET: Delete
        public ActionResult Delete(int id)
        {
            var collection = db.CollectionModel.Where(m => m.Id == id).FirstOrDefault();
            var model      = new CollectionModels();

            model.Collection_Id = collection.Collection_Id;
            model.Disease_Term  = collection.Disease_Term;
            model.Title         = collection.Title;

            return(View(model));
        }
        public ActionResult Create(CollectionModels collection, int?page)
        {
            if (!ModelState.IsValid)
            {
                return(View());
            }
            db.CollectionModel.Add(collection);
            db.SaveChanges();
            var collectList = db.CollectionModel.OrderBy(m => m.Id).ToList().ToPagedList(page ?? 1, 6);

            return(View("Index", collectList));
        }
 public ActionResult Create(CollectionModels collection)
 {
     if (ModelState.IsValid)
     {
         try
         {
             collection.UserID = (int)(System.Web.HttpContext.Current.Session["userID"]);
             _collectionManager.AddCollection(collection);
             return(RedirectToAction("Index", "Profile"));
         }
         catch (Exception ex)
         {
             return(RedirectToAction("Index", "Error", new { message = ex.Message, stackTrace = ex.StackTrace }));
         }
     }
     return(View(collection));
 }
        public ActionResult Edit(CollectionModels collection)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    var oldCollection = (Collection)(System.Web.HttpContext.Current.Session["editCollection"]);
                    _collectionManager.EditCollection(oldCollection, collection);
                    System.Web.HttpContext.Current.Session.Remove("editCollection");
                }
                catch (Exception ex)
                {
                    return(RedirectToAction("Index", "Error", new { message = ex.Message, stackTrace = ex.StackTrace }));
                }

                return(RedirectToAction("Index", "Profile"));
            }
            return(View(collection));
        }