예제 #1
0
        // GET: api/Boards
        public List <Board> Get()
        {
            List <Board> list = new List <Board>();

            using (var db = new BoardSystemContext())
            {
                try
                {
                    list = getList(0);
                }
                catch
                {
                }
            }
            return(list);
        }
예제 #2
0
 // DELETE: api/Boards/5
 public void Delete(int boardNum)
 {
     using (var db = new BoardSystemContext())
     {
         Board board;
         try
         {
             board = db.Boards.Find(boardNum);
             db.Boards.Remove(board);
             db.SaveChanges();
         }
         catch
         {
         }
     }
 }
예제 #3
0
        private List <Board> getList(int page)
        {
            using (var db = new BoardSystemContext())
            {
                List <Board> list;
                if (page == 0)
                {
                    list = db.Boards.OrderByDescending(s => s.BoardNum).Take(20).ToList();
                }
                else
                {
                    list = db.Boards.OrderByDescending(s => s.BoardNum).Skip(20 + (page - 1) * 10).Take(10).ToList();
                }

                return(list);
            }
        }
 public IActionResult Register(User model)
 {
     if (ModelState.IsValid)
     {
         using (var db = new BoardSystemContext())
         {
             db.Users.Add(model);
             try
             {
                 db.SaveChanges();
             } catch (Exception ex)
             {
                 Console.WriteLine(ex);
                 return(RedirectToAction("Error", "Home"));
             }
         }
         return(RedirectToAction("Index", "Home"));
     }
     return(View(model));
 }
예제 #5
0
        // GET: /<controller>/
        public IActionResult Index()
        {
            if (HttpContext.Session.GetString("USER_LOGIN_KEY") == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            using (var db = new BoardSystemContext())
            {
                List <Board> list;
                try
                {
                    list = getList(0);
                }
                catch
                {
                    return(RedirectToAction("Error", "Home"));
                }

                return(View(list));
            }
        }
예제 #6
0
 public IActionResult DeleteComment(int boardNum, int commentNum)
 {
     if (HttpContext.Session.GetString("USER_LOGIN_KEY") == null)
     {
         return(RedirectToAction("Login", "Account"));
     }
     using (var db = new BoardSystemContext())
     {
         Comment comment;
         try
         {
             comment = db.Comments.Find(commentNum);
             db.Comments.Remove(comment);
             db.SaveChanges();
         }
         catch
         {
             return(RedirectToAction("Error", "Home"));
         }
         return(Redirect("Detail?boardNum=" + boardNum));
     }
 }
예제 #7
0
        // POST: api/Boards
        public void Post([System.Web.Http.FromBody] Board board)
        {
            if (ModelState.IsValid)
            {
                using (var db = new BoardSystemContext())
                {
                    try
                    {
                        db.Boards.Add(board);

                        if (db.SaveChanges() > 0)
                        {
                            //  return Redirect("Index");
                        }
                    }
                    catch
                    {
                        // return RedirectToAction("Error", "Home");
                    }
                }
                ModelState.AddModelError(string.Empty, "投稿できません。");
            }
        }
예제 #8
0
        public IActionResult Delete(int boardNum)
        {
            if (HttpContext.Session.GetString("USER_LOGIN_KEY") == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            using (var db = new BoardSystemContext())
            {
                Board board;
                try
                {
                    board = db.Boards.Find(boardNum);
                    db.Boards.Remove(board);
                    db.SaveChanges();
                }
                catch
                {
                    return(RedirectToAction("Error", "Home"));
                }

                return(Redirect("Index"));
            }
        }
예제 #9
0
        public string Post([FromBody] User user, int id)
        {
            User   loginUser = null;
            string login     = "******";

            using (var db = new BoardSystemContext())
            {
                try
                {
                    loginUser = db.Users.FirstOrDefault(u => u.UserId.Equals(user.UserId) && u.UserPassword.Equals(user.UserPassword));
                    if (loginUser != null)
                    {
                        login = "******";
                    }
                }
                catch
                {
                    //return RedirectToAction("Error", "Home");
                }
            }

            Console.Write(user);
            return(login);
        }
예제 #10
0
        public IActionResult Detail(int boardNum)
        {
            if (HttpContext.Session.GetString("USER_LOGIN_KEY") == null)
            {
                return(RedirectToAction("Login", "Account"));
            }
            using (var db = new BoardSystemContext())
            {
                Board board;
                IEnumerable <Comment> commentList;
                try
                {
                    board = db.Boards.FirstOrDefault(n => n.BoardNum.Equals(boardNum));
                    db.Entry(board).Entity.BoardViews = board.BoardViews + 1;
                    db.SaveChanges();
                    commentList         = db.Comments.ToList().Where(d => d.BoardNum.Equals(boardNum));
                    ViewBag.commentList = commentList;
                } catch {
                    return(RedirectToAction("Error", "Home"));
                }

                return(View(board));
            }
        }