public ActionResult DeleteConfirmed(int id)
 {
     ComplainRegistrationModel complainRegistrationModel = db.Complains.Find(id);
     db.Complains.Remove(complainRegistrationModel);
     db.SaveChanges();
     return RedirectToAction("Index");
 }
        // GET: Complains/Assign/5
        public ActionResult Assign(int?id)
        {
            ViewBag.ComplainRegistratationID = id;
            ComplainRegistrationModel c = new ComplainRegistrationModel();

            c = db.Complains.Find(id);
            ViewBag.Complaintext = c.Problem;
            ViewBag.DepartmentID = new SelectList(db.Departments, "ID", "Name", c.DepartmentID);
            ViewBag.OfficerID    = new SelectList(db.Officers, "ID", "Name");

            return(View());
        }
 public ActionResult Edit([Bind(Include = "ID,UserName,MobileNO,Address,Aadhar,Problem,DepartmentID,Status")] ComplainRegistrationModel complainRegistrationModel)
 {
     if (ModelState.IsValid)
     {
         db.Entry(complainRegistrationModel).State = EntityState.Modified;
         db.SaveChanges();
        return RedirectToAction("Index");
         
     }
     ViewBag.DepartmentID = new SelectList(db.Departments, "ID", "Name", complainRegistrationModel.DepartmentID);
     return View(complainRegistrationModel);
 }
 // GET: ComplainRegistrationModels/Details/5
 public ActionResult Details(int? id)
 {
     if (id == null)
     {
         return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
     }
     ComplainRegistrationModel complainRegistrationModel = db.Complains.Find(id);
     if (complainRegistrationModel == null)
     {
         return HttpNotFound();
     }
     return View(complainRegistrationModel);
 }
 public ActionResult TicketView(int t_id)
 {
     TicketViewModel tvm = new TicketViewModel();
     tvm.Ticket_No = t_id;
     ComplainRegistrationModel complainRegistrationModel=db.Complains.Find(t_id);
     tvm.UserName = complainRegistrationModel.UserName;
     DepartmentModel dpt = db.Departments.Find(complainRegistrationModel.DepartmentID);
     tvm.DepartmentName = dpt.Name;
     tvm.Location = dpt.Location;
     tvm.HODName = dpt.HeadOfDepartment;
     tvm.Contact_NO = dpt.ContactNo;
     return View(tvm);
 }
 // GET: ComplainRegistrationModels/Edit/5
 public ActionResult Edit(int? id)
 {
     if (id == null)
     {
         return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
     }
     ComplainRegistrationModel complainRegistrationModel = db.Complains.Find(id);
     if (complainRegistrationModel == null)
     {
         return HttpNotFound();
     }
     ViewBag.DepartmentID = new SelectList(db.Departments, "ID", "Name", complainRegistrationModel.DepartmentID);
     return View(complainRegistrationModel);
 }
        public ActionResult Solve(Complain complain)
        {
            ComplainRegistrationModel cm = new ComplainRegistrationModel();
            Complain temp = new Complain();

            temp = db.ComplainDetails.Find(complain.ID);


            cm                 = db.Complains.Find(temp.ComplainRegistratationID);
            cm.Status          = "Solved";
            db.Entry(cm).State = EntityState.Modified;
            db.SaveChanges();

            return(RedirectToAction("Index", "ComplainRegistrationModels"));
        }
        public ActionResult Create([Bind(Include = "ID,UserName,MobileNO,Address,Aadhar,Problem,DepartmentID")] ComplainRegistrationModel complainRegistrationModel)
        {
            if (ModelState.IsValid)
            {
                complainRegistrationModel.Status = "Panding";
                complainRegistrationModel.Date = DateTime.Now.Date;
              //  ticket_ID = complainRegistrationModel.ID;
                db.Complains.Add(complainRegistrationModel);
                db.SaveChanges();
             //   complainRegistrationModel = db.Complains.LastOrDefault();
                ticket_ID = complainRegistrationModel.ID;
                return RedirectToAction("TicketView",new { t_id = ticket_ID});
               // return RedirectToAction("Index");
            }

            ViewBag.DepartmentID = new SelectList(db.Departments, "ID", "Name", complainRegistrationModel.DepartmentID);
            return View(complainRegistrationModel);
        }
        public ActionResult Create([Bind(Include = "ID,Complaintext,ComplainRegistratationID,DepartmentID,OfficerID,Date")] Complain complain)
        {
            if (ModelState.IsValid)
            {
                complain.Date = DateTime.Now.Date;
                db.ComplainDetails.Add(complain);
                ComplainRegistrationModel c = new ComplainRegistrationModel();
                c                 = db.Complains.Find(complain.ComplainRegistratationID);
                c.Status          = "Assigned";
                db.Entry(c).State = EntityState.Modified;
                db.SaveChanges();


                return(RedirectToAction("Index"));
            }

            ViewBag.ComplainRegistratationID = complain.ComplainRegistratationID;
            ViewBag.DepartmentID             = new SelectList(db.Departments, "ID", "Name", complain.DepartmentID);
            ViewBag.OfficerID = new SelectList(db.Officers, "ID", "Name", complain.OfficerID);
            return(View(complain));
        }