public ViewResult Index() { msgListViewModel = new MsgListViewModel(); msgListViewModel.Users = _userRepository.AllUsers; msgListViewModel.Comments = _commentsRepository.AllComments; return(View(msgListViewModel)); }
public ActionResult Index(string name, string message) { int likes = 0; cnn.Open(); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); String sql = "insert into [Users] values ('" + name + "', '" + likes + "', '" + message + "')"; command = new SqlCommand(sql, cnn); adapter.InsertCommand = new SqlCommand(sql, cnn); adapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); cnn.Close(); msgListViewModel = new MsgListViewModel(); msgListViewModel.Users = _userRepository.AllUsers; msgListViewModel.Comments = _commentsRepository.AllComments; return(View(msgListViewModel)); }
public ActionResult Comment(string cmtname, string comment, string extra) { int m_id = int.Parse(extra); int likes = 0; cnn.Open(); SqlCommand command; SqlDataAdapter adapter = new SqlDataAdapter(); String sql = "insert into [Comments] values ('" + comment + "', '" + likes + "', '" + m_id + "', '" + cmtname + "')"; command = new SqlCommand(sql, cnn); adapter.InsertCommand = new SqlCommand(sql, cnn); adapter.InsertCommand.ExecuteNonQuery(); command.Dispose(); cnn.Close(); msgListViewModel = new MsgListViewModel(); msgListViewModel.Users = _userRepository.AllUsers; msgListViewModel.Comments = _commentsRepository.AllComments; return(View("Index", msgListViewModel)); }