August 2019 – Useful code

Month: August 2019

C# – Using Migrations – ASP.NET MVC with EF Core – Video

Posted on August 28, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks, EntityFramework

Migrations in C# are quite well facilitated by the EntityFramework. In general, when an application with databse is created, initially the database model is taken from the model classes. When these models classes change, then they get out of sync…

Tagged with: ASP.NET, core, EF, EntityFramework, Migrations, MVC

C# – Add sorting, filtering, and paging – ASP.NET MVC – Video

Posted on August 27, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks, EntityFramework

Sorting, filtering, paging and summary of an app are quite important features. In this video, which is a continuation of the Microsoft tutorial, I present step-by-step how to do each one of these. It is quite a large video, but…

Tagged with: ASP.NET, filtering, MVC, paging, sorting

C# – Implement CRUD Functionality – ASP.NET MVC with EF Core – Video

Posted on August 26, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks, EntityFramework

This is the second video of the Microsoft tutorials, for ASP.NET MVC with Entity Framework Core: Continuing the previous video, in this one the following tasks are carried out: Customize the Details page Update the Create page Update the Edit…

Tagged with: ASP.NET, CRUD Functionality, EF Core, MVC

C# – Get started with EF Core in an ASP.NET MVC Web App – Video

Posted on August 25, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks, EntityFramework

Lately, I have started with creating video tutorials for ASP.NET. Thus, today it is time to deep dive in the ASP.NET once again, following the Microsoft tutorial for ASP.NET MVC Web App from here. In the video below, the following…

Tagged with: App, ASP.NET, EF Core, Get started, microsoft, MVC Web, tutorial

C# – Create a web app with ASP.NET Core MVC – Video

Posted on August 20, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks

Creating a web application with ASP.NET could look as a hard task. Still, with the pre-built MVC models from Visual Studio, the task is a bit easier. This is how the application looks like, with 2 search buttons and fully…

Tagged with: ASP.NET, ASP.NET Core, data validation, LiveCoding, MVC, Step-by-step, Web App

C# – Create a web API with ASP.NET Core – Video

Posted on August 16, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks

Web API with Visual Studio 2019 is quite a bolierplate task – it is doable in less than 45 minutes, following the Microsoft.com tutorial: The video tutorial is here: The TodoController , implementing the CRUD actions looks like this:

using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.EntityFrameworkCore;
using TodoApi.Models;

namespace TodoApi.Controllers
{
    [ApiController]
    [Route("api/[controller]")]
    public class TodoController : Controller
    {
        private readonly TodoContext _context;

        public TodoController(TodoContext context)
        {
            _context = context;

            if (_context.TodoItems.Count() == 0)
            {
                _context.TodoItems.Add(new TodoItem { Name = "Learn VBA" });
                _context.SaveChanges();
            }
        }

        //GET: api/Todo
        [HttpGet]
        public async Task<ActionResult<IEnumerable<TodoItem>>> GetTodoItems()
        {
            return await _context.TodoItems.ToListAsync();
        }

        //GET: api/Todo/3
        [HttpGet("{id}")]
        public async Task<ActionResult<TodoItem>> GetTodoItem(long id)
        {
            var todoItem = await _context.TodoItems.FindAsync(id);
            if (todoItem== null)
            {
                return NotFound();
            }

            return todoItem;
        }

        //POST: api/Todo
        [HttpPost]
        public async Task<ActionResult<TodoItem>> PostTodoItem(TodoItem item)
        {
            _context.TodoItems.Add(item);
            await _context.SaveChangesAsync();

            return CreatedAtAction(nameof(GetTodoItem), new { id = item.Id }, item);
        }

        //PUT: api/Todo/3
        [HttpPut("{id}")]
        public async Task<IActionResult> PutTodoItem(long id, TodoItem item)
        {
            if (id!=item.Id)
            {
                return BadRequest();
            }
            _context.Entry(item).State = EntityState.Modified;
            await _context.SaveChangesAsync();

            return NoContent();
        }

        //DELETE: api/Todo/3
        [HttpDelete("{id}")]
        public async Task<IActionResult> DeleteTodoItem(long id)
        {
            var todoItem = await _context.TodoItems.FindAsync(id);
            if (todoItem == null)
            {
                return NotFound();
            }

            _context.TodoItems.Remove(todoItem);
            await _context.SaveChangesAsync();

            return NoContent();

        }
    }
}

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using Microsoft.AspNetCore.Mvc;

using Microsoft.EntityFrameworkCore;

using TodoApi.Models;

namespace TodoApi.Controllers

{

[ApiController]

[Route("api/[controller]")]

public class TodoController : Controller

{

private readonly TodoContext _context;

public TodoController(TodoContext context)

{

_context = context;

if (_context.TodoItems.Count() == 0)

{

_context.TodoItems.Add(new TodoItem { Name = "Learn VBA" });

_context.SaveChanges();

}

//GET: api/Todo

[HttpGet]

public async Task<ActionResult<IEnumerable<TodoItem>>> GetTodoItems()

{

return await _context.TodoItems.ToListAsync();

}

//GET: api/Todo/3

[HttpGet("{id}")]

public async Task<ActionResult<TodoItem>> GetTodoItem(long id)

{

var todoItem = await _context.TodoItems.FindAsync(id);

if (todoItem== null)

{

return NotFound();

}

return todoItem;

}

//POST: api/Todo

[HttpPost]

public async Task<ActionResult<TodoItem>> PostTodoItem(TodoItem item)

{

_context.TodoItems.Add(item);

await _context.SaveChangesAsync();

return CreatedAtAction(nameof(GetTodoItem), new { id = item.Id }, item);

}

//PUT: api/Todo/3

[HttpPut("{id}")]

public async Task<IActionResult> PutTodoItem(long id, TodoItem item)

{

if (id!=item.Id)

{

return BadRequest();

}

_context.Entry(item).State = EntityState.Modified;

await _context.SaveChangesAsync();

return NoContent();

}

//DELETE: api/Todo/3

[HttpDelete("{id}")]

public async Task<IActionResult> DeleteTodoItem(long id)

{

var todoItem = await _context.TodoItems.FindAsync(id);

if (todoItem == null)

{

return NotFound();

}

_context.TodoItems.Remove(todoItem);

await _context.SaveChangesAsync();

return NoContent();

}

The…

Tagged with: asp, ASP.NET, C#, core, web api

C# – ASP.NET Core MVC Application with Basic Database Access using Entity Framework – Video

Posted on August 13, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks, EntityFramework

The title somehow looks like random words, picked from a hat at one of those college games we are not supposed to talk about. Anyway, at the second reading it hopefully becomes a bit clearer. And it is simply the…

Tagged with: ASP.NET, Core MVC Application, Entity Framework, Model First, simple

VBA – Longest Palindromic Subsequence Algorithm with Excel – GIF

Posted on August 7, 2019 by

Vitosh Posted in VBA \ Excel

After writing about the longest palindromic substring, now it is time to see the longest palindromic subsequence. What is the difference? Pretty much, if we take the word abracadabra: the longest substring is ada in abracadabra the longest subsequence is…

Tagged with: algorithm, Excel, Longest, Palindromic, subsequence, VBA

ASP – Data Entry MVC Application with Database – Video

Posted on August 6, 2019 by

Vitosh Posted in ASP.Net, C Sharp Tricks

After the first video for MVC here, I have decided to make a next part, in which I save the entries to a database and display them: Sounds like a tiny update. However, it…

Tagged with: .net, asp, C#, data entry, database, MVC

VBA – Longest Palindromic Substring Algorithm with Excel – GIF

Posted on August 4, 2019 by

Vitosh Posted in VBA \ Excel

The longest palindromic substring algorithm exists since 1975. It is different (and easier) than the longest palindromic subsequence. The idea of the substring is to return “anana”, if “bananazorro” is given. This is achieved with a 2 dimensional boolean array matrix and…

C# – xUnit Test Implementation in Fibonacci Calculation – Video

Posted on August 1, 2019 by

Vitosh Posted in C Sharp Tricks

Good software comes with tests. Fortunately, Visual Studio 2019 provides quite nice ways to test the software you are creating. One of these is xUnit – xunit.net. Thus, I have decided to make a video, showing how to implement xUnit…

Tagged with: C#, fibonacci, TDD, Tests, xUnit