Live News Website with AS .NET Core 9 Mvc and SQL

Explore the structure of a news website, focusing on its back end and front end, and learn to download Bootstrap templates and make the site dynamic with ASP.NET Core MVC.

Create your ASP.NET Core MVC project in Visual Studio 2022 using the MVC template, configure the name and target framework, and run with IIS Express to launch a news website.

Discover how layouts define header, footer, and content, how the render body injects the view content, and the five types including a default with sidebars in ASP.NET Core MVC.

Import a bootstrap news template into an ASP.NET Core MVC project, build a shared layout with header and footer, update asset paths, and render the body for pages.

Learn how the Entity Framework simplifies database access in MVC applications, comparing it with ADO.NET and using scaffolding to quickly create data operations without extensive coding.

Explore the structure of the entity framework in the MVC core site, focusing on DbContext, models, and the connector between database, controller, and view.

Explore the database-first approach in entity framework core by creating a sql server database, installing ef and scaffolding tools, then auto generating dbcontext, models, controllers, and views.

Learn to use Entity Framework Core with the database-first method in ASP.NET, creating a SQL Server database and a menu table with id, title, link, parent_id, and priority.

Install essential NuGet packages to integrate your SQL Server database with the ASP.NET Core app, including the MVC code generator, EF Core SQL Server, and design tools, with version guidance.

Generate the DbContext and models automatically through scaffolding in Visual Studio, creating DbSet entries and the menu model for SQL Server.

Organize an ASP.NET Core MVC project using areas to group controllers, views, and models into dedicated folders, then create an admin area and activate it with map controller route.

Scaffold an admin area with a menus controller and views using Entity Framework Core, creating models, a DbContext, and CRUD pages, with layout, routing, and basic admin dashboard setup.

Learn to start using the dedicated chi kai admin template, download the assets, and preview the admin dashboard, then tailor the layout with essential components.

Replace the Cai admin template with KaiAdmin layouts in the admin area, wiring starter templates, layout, and render body to support create, edit, details pages.

Customize the sidebar and admin menus in a .NET Core MVC project by editing the layout, adding the dashboard and menu items, and wiring Font Awesome icons.

Load main menu items by filtering where parent_id is null in the menu index action, using entity framework core and sql in an asp.net core mvc admin area.

Learn to customize the create button in admin menus by editing its text and turning the link into a bootstrap button (btn, btn-outline, primary or success) linking to admin/menus/create.

Learn to customize the admin menu by turning standard buttons into icon buttons, updating edit, details, and delete actions, and wiring submenus with Font Awesome icons and color variations.

Learn to load submenu data by parent id in a live news website built with ASP.NET Core MVC and SQL, wiring a submenu button to fetch and display submenus.

Learn to change the menu title and subtitle in an ASP.NET Core MVC app by loading titles from the parent, updating the index and layout, and verifying in Visual Studio.

Learn to hide the submenu button in a live news website using .NET Core 9 MVC by checking if the parent is null and applying a simple if statement.

Learn to customize the create button for submenus in a .NET Core MVC app by using a hidden parent id, view back passing, and proper create wiring.

Learn to build dynamic main menus by splitting the layout into three view components: footer, navbar, and weather forecasting, using Visual Studio in .NET Core MVC.

Learn to split an ASP.NET Core MVC layout into navbar, footer, and weather forecast using view components and razor views, wiring components in the shared layout.

Add view component classes for the navbar, weather, and footer in the view components folder, adapting controller code to fix errors.

Load menu data for the navbar by querying the menu model with dbcontext, converting to a list async, and returning the results to the navbar view component.

Load the dynamic main menu from the database in an ASP.NET Core MVC app, ordering by priority and rendering parent menus in the navbar via view components.

Learn to implement dynamic sub-menus in a live news site by loading children menus from SQL Server, wiring up links and titles in a .NET Core 9 MVC app.

Create a settings table in SQL and scaffold it into the .NET Core 9 MVC project, defining id, title, address, email, phone, copyright, and social links.

Generate the controller and views for the settings table automatically using the entity framework in a .NET Core MVC project, then integrate and customize the admin area navigation and layout.

Customize the edit view to save changes in the settings table via the settings controller, update the DbContext, and reload the edit view by redirecting back to the edit action.

Learn to load settings data into the footer using a footer view model, fetch the settings via the dbcontext with first or default async, and render in the footer.

Learn to make the footer dynamic by loading settings data into a footer view model, binding title, address, email, phone, and social links like Twitter, Facebook, YouTube, LinkedIn, Instagram.

Implement header settings in the navbar using a view component, loading menu items and a settings record via a tuple, and display social links in the header.

Integrate a free weather forecasting API in a .NET Core MVC app by setting latitude and longitude, choosing forecast days, and loading hourly temperatures into a weather component.

Fetch hourly weather data from the Open Meteor API via HTTP client, parse the JSON, and populate a weather view model to display the current forecast at the top.

Learn to display real-time weather in the header by fetching data from the open API, wiring a weather view model to show temperature, city, and a formatted date.

Create and design the news sql table, save data to the database, and scaffold the DbContext and models with NuGet packages for the project.

Generate a news controller and its create, read, update, and delete views using entity framework, wiring the nodes model and dbcontext, and update nuget packages.

Add a data table to the news index page using data table js, enabling real-time search, sorting, and pagination while loading data via a dedicated action.

Learn to set up and run a data table in a .net core mvc project, including html, scripts, ajax loading, and rendering columns like title, view count, image, and actions.

Diagnose and fix a data table c# code error in a .net core mvc app by debugging a null object reference and resolving a 400 bad request during data loading.

Examine how to navigate the C# data table code, load data and convert it to JSON for the index view via Ajax, including paging, filtering, and sorting.

Scaffold three tables—category, user, and tags—and integrate them into ASP.NET Core MVC project. Scaffold DbContext and models from database, and configure the connection string for controllers and views.

Scaffold an admin category controller and views using Entity Framework, enabling index, create, edit, and delete pages; update the admin layout and navigation, then build and test.

Create and manage tags by generating a tags controller and views in the admin area, linking the Tag model and DbContext, and customizing create, edit, delete, and index pages.

Scaffold an MVC controller with views using Entity Framework Core to manage the user table, creating index, create, edit, and delete pages in the admin area.

Learn how to load category data into the create view by binding categories to a select list, enabling a dynamic category drop-down.

Learn to add a searchable category select using the select2 component in an ASP.NET Core MVC project. Install select2 CSS and JS, bind the category select, and initialize the widget.

Learn to implement a multi-select tags field with select2 in an asp.net core 9 mvc app, storing tag titles as comma-separated values in sql server, and binding to the view.

Learn to make category and tag selects responsive by applying Select2 styles to the container, updating the admin create view in Visual Studio, and verifying results as the page resizes.

Learn to implement a select2 dropdown for user selection in an ASP.NET Core 9 MVC app by loading user IDs and full names from users table into create view.

Learn to add ckeditor, a third-party editor, to the long description in a net core mvc live news site, turning a text area into a wizzywig editor with image uploads.

Explore uploading images into CKEditor by examining the controller's upload method and the server-side saving. See how the editor uses the json response to insert the image URL.

Learn to add a select element for status in the create view to indicate published or unpublished, and configure options and display in the admin interface.

Load and select the main news image with a file input, then encode the form as multipart data when saving the new news item in the admin create view.

Dissect the create action of the news controller, handling image upload with the image helper, saving the image and thumbnail to the server, and updating the database via dbcontext.