public ActionResult BookingIndex()
        {
            ArchiveNewBooking Archive = new ArchiveNewBooking();

            foreach (var item in db.NewBookings.ToList())
            {
                if (item.pickupdate <= DateTime.Now)
                {
                    Archive.Booked       = item.Booked;
                    Archive.BookingIds   = item.BookingIds;
                    Archive.cellnum      = item.cellnum;
                    Archive.clientname   = item.clientname;
                    Archive.Collection   = item.Collection;
                    Archive.ConNum       = item.ConNum;
                    Archive.ConType      = item.ConType;
                    Archive.Distance     = item.Distance;
                    Archive.Dropoff      = item.Dropoff;
                    Archive.email        = item.email;
                    Archive.est          = item.est;
                    Archive.estTime      = item.estTime;
                    Archive.final        = item.final;
                    Archive.news         = item.news;
                    Archive.newss        = item.newss;
                    Archive.pickupdate   = item.pickupdate;
                    Archive.Size         = item.Size;
                    Archive.priorty      = "";
                    Archive.specInstruct = item.specInstruct;
                    Archive.testtext     = item.testtext;
                    Archive.two          = item.two;
                    Archive.vat          = item.vat;
                }
            }
            return(PartialView("_Bookings", db.NewBookings.ToList()));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            ArchiveNewBooking archiveNewBooking = db.ArchiveNewBookings.Find(id);

            db.ArchiveNewBookings.Remove(archiveNewBooking);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "BookingIds,pickupdate,clientname,cellnum,email,ConNum,ConType,Size,specInstruct,testtext,two,Distance,final,Collection,Dropoff,priorty,est,estTime,news,newss,Booked,vat")] ArchiveNewBooking archiveNewBooking)
 {
     if (ModelState.IsValid)
     {
         db.Entry(archiveNewBooking).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(archiveNewBooking));
 }
        // GET: ArchiveNewBookings/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ArchiveNewBooking archiveNewBooking = db.ArchiveNewBookings.Find(id);

            if (archiveNewBooking == null)
            {
                return(HttpNotFound());
            }
            return(View(archiveNewBooking));
        }