// GET: citations/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            citation citation = db.citations.Find(id);

            if (User.IsInRole("Admin"))
            {
                if (citation == null)
                {
                    return(HttpNotFound());
                }
                ViewBag.orderID = new SelectList(db.orders, "ID", "orderno", citation.orderID);
                return(View(citation));
            }
            else
            {
                if (User.Identity.Name == citation.order.user.email)
                {
                    if (citation == null)
                    {
                        return(HttpNotFound());
                    }
                    ViewBag.orderID = new SelectList(db.orders, "ID", "orderno", citation.orderID);
                    return(View(citation));
                }
                else
                {
                    return(RedirectToAction("AccessDenied", "Authentication"));
                    //return new HttpStatusCodeResult(HttpStatusCode.Forbidden);
                }
            }
        }
        public ActionResult DeleteConfirmed(int id)
        {
            citation citation = db.citations.Find(id);

            db.citations.Remove(citation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult AddCitation(citation cit)
 {
     if (!Check_Session())
     {
         return(RedirectToAction("SignIn", "user"));
     }
     cit.DATE_TIME = DateTime.Now;
     db.citations.Add(cit);
     db.SaveChanges();
     return(RedirectToAction("Index"));
 }
        public ActionResult DeleteConfirmed(int id)
        {
            if (!Check_Session())
            {
                return(RedirectToAction("SignIn", "user"));
            }
            citation citation = db.citations.Find(id);

            db.citations.Remove(citation);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult Edit([Bind(Include = "ID,plan,country,businessname,websiteurl,businessdescription,keywords,founder,address,phone,email,cloudurl,orderID")] citation citation)
        {
            int orderid = citation.orderID;

            if (ModelState.IsValid)
            {
                db.Entry(citation).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Details", "orders", new { @id = orderid }));
            }
            ViewBag.orderID = new SelectList(db.orders, "ID", "orderno", citation.orderID);
            return(View(citation));
        }
        // GET: citations/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            citation citation = db.citations.Find(id);

            if (citation == null)
            {
                return(HttpNotFound());
            }
            return(View(citation));
        }
        //
        // GET: /Citation/Details/5

        public ActionResult Details(int id = 0)
        {
            if (!Check_Session())
            {
                return(RedirectToAction("SignIn", "user"));
            }
            citation citation = db.citations.Find(id);

            if (citation == null)
            {
                return(HttpNotFound());
            }
            return(View(citation));
        }
        //
        // GET: /Citation/Edit/5

        public ActionResult Edit(int id = 0)
        {
            if (!Check_Session())
            {
                return(RedirectToAction("SignIn", "user"));
            }
            citation citation = db.citations.Find(id);

            if (citation == null)
            {
                return(HttpNotFound());
            }
            genericsController gn = new genericsController();

            ViewBag.crime_list = new SelectList(gn.Get_Crime_List(), "Text", "Value");
            return(View(citation));
        }
        public ActionResult Edit(citation citation)
        {
            if (!Check_Session())
            {
                return(RedirectToAction("SignIn", "user"));
            }

            if (ModelState.IsValid)
            {
                db.Entry(citation).State = EntityState.Modified;
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }
            genericsController gn = new genericsController();

            ViewBag.crime_list = new SelectList(gn.Get_Crime_List(), "Text", "Value");
            return(View(citation));
        }