public ActionResult Create([Bind(Include = "acontract,ContractorId,MaintainanceId,Status,Res,Image")] AssignContractor assignContractor)
        {
            if (ModelState.IsValid)
            {
                var booking = db.Maintainances.Where(o => o.MaintainanceId == assignContractor.MaintainanceId).FirstOrDefault();
                assignContractor.Res     = booking.ResName;
                assignContractor.Status  = "Not Available";
                assignContractor.Comment = booking.Comments;
                assignContractor.Image   = booking.Image;

                var mm = db.Contractors.Where(o => o.ContractorId == assignContractor.ContractorId).FirstOrDefault();

                booking.Contractor_EmailAddress = mm.Contractor_EmailAddress;
                booking.Status          = "In Progress";
                booking.Contractor      = mm.ContractorName;
                db.Entry(booking).State = EntityState.Modified;
                db.SaveChanges();

                db.AssignContractors.Add(assignContractor);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.ContractorId   = new SelectList(db.Contractors, "ContractorId", "ContractorName", assignContractor.ContractorId);
            ViewBag.MaintainanceId = new SelectList(db.Maintainances, "MaintainanceId", "StudentNAme", assignContractor.MaintainanceId);
            return(View(assignContractor));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            AssignContractor assignContractor = db.AssignContractors.Find(id);

            db.AssignContractors.Remove(assignContractor);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: AssignContractors/Create
        public ActionResult Create(int id)
        {
            ViewBag.ContractorId   = new SelectList(db.Contractors, "ContractorId", "ContractorName");
            ViewBag.MaintainanceId = new SelectList(db.Maintainances, "MaintainanceId", "StudentNAme");
            AssignContractor c = new AssignContractor();

            c.MaintainanceId = id;
            return(View(c));
        }
 public ActionResult Edit([Bind(Include = "acontract,ContractorId,MaintainanceId,Status")] AssignContractor assignContractor)
 {
     if (ModelState.IsValid)
     {
         db.Entry(assignContractor).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.ContractorId   = new SelectList(db.Contractors, "ContractorId", "ContractorName", assignContractor.ContractorId);
     ViewBag.MaintainanceId = new SelectList(db.Maintainances, "MaintainanceId", "StudentNAme", assignContractor.MaintainanceId);
     return(View(assignContractor));
 }
        // GET: AssignContractors/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AssignContractor assignContractor = db.AssignContractors.Find(id);

            if (assignContractor == null)
            {
                return(HttpNotFound());
            }
            return(View(assignContractor));
        }
        public ActionResult Accept(int?id)
        {
            Contractor bookingRoom = db.Contractors.Where(p => p.ContractorId == id).FirstOrDefault();

            bookingRoom.Contractor_Availability = "Unavailable";

            AssignContractor booking = db.AssignContractors.Where(p => p.Contractor.ContractorName == bookingRoom.ContractorName).FirstOrDefault();

            booking.Status = "Job Accepted";

            db.Entry(booking).State = EntityState.Modified;
            db.SaveChanges();


            return(RedirectToAction("Index"));
        }
        // GET: AssignContractors/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            AssignContractor assignContractor = db.AssignContractors.Find(id);

            if (assignContractor == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ContractorId   = new SelectList(db.Contractors, "ContractorId", "ContractorName", assignContractor.ContractorId);
            ViewBag.MaintainanceId = new SelectList(db.Maintainances, "MaintainanceId", "StudentNAme", assignContractor.MaintainanceId);
            return(View(assignContractor));
        }