//update status of competition
        private void UpdateStatus()
        {
            var competitionList = _context.Competition.ToList();

            for (int i = 0; i < competitionList.Count; i++)
            {
                if (competitionList[i].StartDate <= DateTime.Now.Date && DateTime.Now.Date <= competitionList[i].EndDate)
                {
                    competitionList[i].Status = CompetitonStatus.Ongoing;
                }
                else
                {
                    if (DateTime.Now.Date < competitionList[i].StartDate && DateTime.Now.Date < competitionList[i].EndDate)
                    {
                        competitionList[i].Status = CompetitonStatus.ComingUp;
                    }
                    else
                    {
                        if (competitionList[i].StartDate.Date < DateTime.Now.Date && competitionList[i].EndDate.Date < DateTime.Now.Date)
                        {
                            competitionList[i].Status = CompetitonStatus.Ended;
                        }
                        if (competitionList[i].EndDate.Date < DateTime.Now.Date && DateTime.Now.Date <= competitionList[i].AwardDate.Date)
                        {
                            competitionList[i].Status = CompetitonStatus.Examining;
                        }
                    }
                }
                _context.Update(competitionList[i]);
                _context.SaveChanges();
            }
        }
        public IActionResult EditPost(Post post, IFormFile Image)
        {
            //update post
            var editPost = _context.Post.Find(post.ID);

            if (editPost == null)
            {
                return(NotFound());
            }
            editPost.PostName   = post.PostName;
            editPost.Decription = post.Decription;
            using (var ms = new MemoryStream())
            {
                Image.CopyTo(ms);
                editPost.Image = ms.ToArray();
            }
            editPost.UpdatedAt = DateTime.Now;
            _context.Post.Update(editPost);
            _context.SaveChanges();

            TempData["Success"] = "Post updated!";
            return(RedirectToAction(nameof(MyAccount)));
        }