public ActionResult SubmitArticle(tbl_Article a)
        {
            a.User_Id = db.tbl_Users.SingleOrDefault(x => x.Username == HttpContext.User.Identity.Name).User_Id;

            MyService.ServiceController myServiceController = new MyService.ServiceController();
            myServiceController.SubmitNewArticle(a.Article_Name, a.Article_Description, a.Article_PublishDate, a.User_Id,
                a.MedaManager_Id, a.ArticleStatus_Id, a.Article_State_Id, Convert.ToInt32(a.ArticleComment_Id), "TextArticle");

            ViewBag.MediaManager_ID =
                    new SelectList(
                        db.tbl_Users.Where(
                            x => x.Role_Id == 2),
                        "User_Id", "Username");
            return View();
        }
        public ActionResult UpdateArticle(tbl_Article a)
        {
            a.User_Id = db.tbl_Users.SingleOrDefault(x => x.Username == HttpContext.User.Identity.Name).User_Id;

            tbl_Comments com = new tbl_Comments();
            com = db.tbl_Comments.SingleOrDefault(x => x.Article_Id == a.Article_Id);
            if (com == null)
            {
                com = new tbl_Comments();
            }

            string commentContent = "";

            if (com.ArticleComment_Id != 0)
            {
                a.ArticleComment_Id = com.ArticleComment_Id;
                commentContent = com.ArticleComment_Content;
            }
            else
            {
                a.ArticleComment_Id = null;
                commentContent = "";
            }

            MyService.ServiceController myServiceController = new MyService.ServiceController();
            myServiceController.SubmitUpdatedArticle(a.Article_Id, a.Article_Name, a.Article_Description,
                a.Article_PublishDate, a.User_Id, a.MedaManager_Id, a.ArticleStatus_Id, a.Article_State_Id,
                commentContent, Convert.ToInt32(a.ArticleComment_Id), "TextArticle");
            return View();
        }
        public ActionResult Edit(tbl_Article a)
        {
            //if (ModelState.IsValid)
            //{
            //    db.Entry(tbl_Article).State = EntityState.Modified;
            //    db.SaveChanges();
            //    return RedirectToAction("Index");
            //}
            //ViewBag.ArticleStatus_Id = new SelectList(db.tbl_ArticleStatus, "ArticleStatus_Id", "ArticleStatus_Type", tbl_Article.ArticleStatus_Id);
            //ViewBag.User_Id = new SelectList(db.tbl_Users, "User_Id", "First_Name", tbl_Article.User_Id);
            //return View(tbl_Article);

            tbl_Users curretUser = db.tbl_Users.SingleOrDefault(x => x.Username == HttpContext.User.Identity.Name);

            //tbl_Article currArt = db.tbl_Article.SingleOrDefault(x => x.Article_Id == a.Article_Id);
            //a.Article_State_Id = currArt.Article_State_Id;

            if (curretUser.Role_Id == 1) //Reviewer
            {
                MyService.ServiceController myServiceController = new MyService.ServiceController();
                myServiceController.AcceptOrRejectArticleByReviewer(a.Article_Id, a.Article_Name, a.Article_Description,
                    a.Article_PublishDate, a.User_Id, a.MedaManager_Id, a.ArticleStatus_Id, a.Article_State_Id,
                    a.tbl_Comments.ArticleComment_Content, Convert.ToInt32(a.ArticleComment_Id), "TextArticle");

                ViewBag.ArticleStatus_Id = new SelectList(db.tbl_ArticleStatus, "ArticleStatus_Id", "ArticleStatus_Type");
                ViewBag.User_Id = new SelectList(db.tbl_Users, "User_Id", "First_Name");
                return View();
            }

            else if (curretUser.Role_Id == 2) //Media Manager
            {
                MyService.ServiceController myServiceController = new MyService.ServiceController();
                myServiceController.AcceptOrRejectArticleByMediaManager(a.Article_Id, a.Article_Name, a.Article_Description,
                    a.Article_PublishDate, a.User_Id, a.MedaManager_Id, a.ArticleStatus_Id, a.Article_State_Id,
                    a.tbl_Comments.ArticleComment_Content, Convert.ToInt32(a.ArticleComment_Id), "TextArticle");

                ViewBag.ArticleStatus_Id = new SelectList(db.tbl_ArticleStatus, "ArticleStatus_Id", "ArticleStatus_Type");
                ViewBag.User_Id = new SelectList(db.tbl_Users, "User_Id", "First_Name");
                return View();
            }

            return View();
        }