public ActionResult SaveAdvisory(SA_Advisory UserNews)
        {
            for (int i = 0; i < Request.Files.Count; i++)
            {
                var file = Request.Files[i];

                if (file != null && file.ContentLength > 0)
                {
                    var fileName = Path.GetFileName(file.FileName);

                    var path = Path.Combine(Server.MapPath("~/ProductImages"), fileName);
                    file.SaveAs(path);
                    UserNews.AdvisoryImg = fileName;
                }
            }
            UserNews.CreatedTime = DateTime.Now;
            AdvisoryDataStore Obj = new AdvisoryDataStore();

            if (UserNews.id == 0)
            {
                Obj.AddAdvisory(UserNews);
            }
            else
            {
                Obj.EditAdvisory(UserNews);
            }
            return(RedirectToAction("Advisory"));
        }
        public ActionResult AdvisoryList()
        {
            AdvisoryDataStore  Obj      = new AdvisoryDataStore();
            List <SA_Advisory> NewsList = Obj.GetAdvisoryList().OrderByDescending(w => w.id).Take(6).ToList();

            return(PartialView("~/Views/PartialView/AdvisoryPartialView.cshtml", NewsList));
        }
        // GET: AdvisorySolutions
        public ActionResult Advisory()
        {
            AdvisoryDataStore Obj = new AdvisoryDataStore();

            return(View("Advisory"));
        }