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…
Author: Vitosh
C# – Create a web API with ASP.NET Core – Video
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:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 |
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…
C# – ASP.NET Core MVC Application with Basic Database Access using Entity Framework – Video
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…
VBA – Longest Palindromic Subsequence Algorithm with Excel – GIF
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…
ASP – Data Entry MVC Application with Database – Video
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…
VBA – Longest Palindromic Substring Algorithm with Excel – GIF
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
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…
ASP – Data Entry MVC Application – Video
I have started reading the 2nd edition of the Pro ASP.NET Core MVC book and after reading the first couple of chapters, I have decided to make a video of the application in the second chapter. The code is about…
VBA – Insert an image/picture in Excel and position it correctly
Inserting an image to Excel with VBA is actually one line: ThisWorkbook.Worksheets(1).Pictures.Insert ("C:\Users\myPic.png") The interesting part happens, when it should be correctly positioned. In order to position it the way we want, we need to give 3 parameters – the image…
VBA – Put a Collection inside a Scripting Dicitonary OR Make an Updateable ComboBox
The idea of the article is to make an updateable combobox, which takes all the keys of column A and writes them to the ComboBox. Then, upon selection of the corresponding values in the combobox, it provides the corresponding values…
VBA – ListBox in Excel – Adding, Editing and Removing Data
The idea of the article is to show how to add, edit and remove specific entries of the ListBox in Excel through VBA: ListBox is a control, which is available through Developer>Insert>ActiveX>ListBox in Excel: Once you add it, it has…
VBA – Reverse words in a sentence
Reversing words in a sentence with VBA in Excel is quite easy, using the built-in StrReverse function. StrReverse takes a string and reverses it. Thus, “VitoshAcademy.com” becomes “moc.ymedacAhsotiV”: The idea of reversing the order of the words in a sentence…
VBA – Cells and Ranges in Excel (A bit more than the standard story)
Excel’s ranges and cells are both complicated and very simple. They are simple, because everyone has an idea what is a range and what is a cell, and they are complicated, because these are both: Properties of the worksheet object…
VBA – Benford Analysis (First-Digit Law)
Long time ago, an astronomer called Benford was taking a look at logarithm books, noticing that the earlier pages (starting with 1) are pretty much more worn out than the later ones. He thought about the result, and managed to…
VBA – Dictionary
VBA has a dictionary structure. Dictionary is an object, and it can be referenced either with early binding or with a late binding, referring to Microsoft Scripting Runtime: What is a dictionary? This is the Microsoft definition of the VBA…
Python – Stand Alone Application with GUI
Python has a built-in GUI package, which allows easy building of forms like this: The package used in this example is tkinter. The form above takes the value, entered in the entry field, squares it and displays it back in…
C# – CodeForces – From Hero to Zero
It was some time ago, since I last took a look at programming challange in CodeForces, thus I have decided to take a look again. So, I chose the lowest problem of the second division just to boost up my…
C# – Look at the Variables’ Values, while Debugging in Visual Studio
Debugging is like being the detective in a crime movie where you are also the murderer. In order to debug well, we need to know the value of the current variable. In Visual Studio, this could be acquired through multiple ways.…
Top VBA-Excel errors
Some months ago #VBA was finally considered the most dreaded language in the 2019 StackOverflow survey: One of the reasons for this, is probably that #VBA is quite too easy to enter, thus plenty of non-IT professionals feel fascinated about…
VBA – Abstract classes. Classes, that cannot be instantiated.
There are parts of #VBA, that can scare any VBA developer, who has not bumped into other languages. Although, the “abstract class” term is quite popular in C# and other languages, and is quite easy to be created, in VBA,…
C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async)
Reading from Excel in C# is actally not at tough as many VBA developers would assume. The simple reading is actually quite straightforward – there is only small little trick, requiring the adding of the Microsoft.Office.Interop.Excel reference to the Visual…
C# – How to get the last filled cell of a given row in Excel
Getting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided…
C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it?
Finding the biggest square of specific units in a given matrix of these units is a standard dynamic programming problem. The examples in Google for it are above 18 million, thus I would simply show how it is done with…
C# – Refactoring a Problem
Some days ago I have decided to take a look at one of the homeworks problem of the OOP course at SoftUni. Then, I have decided to solve it with my VBA OOP knowledge, implementing it in C#. Whether VBA…
C# – Quick Reference for Abstract Classes
Abstract Classes in C# are classes, intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class. Reference With other…
Visual Studio – How to create a custom shortcut
If you want to create a custom shortcut to a command in Visual Studio, these are the steps to be taken: Ribbon>Tools>Options Environment>Keyboard Show commands containing (write the command) Press shortcut keys Assign and OK
VBA – How to copy a new object in VBA, without copying its reference
Copying an object in VBA to a new object is somehow tough. If you use Set foo = bar then, both foo and bar would be pointing to the same address in the heap. And if you change the properties of one, you would automatically…
C# – Entity Framework – Using LINQPad for Queries – Just Getting Started
After the previous two articles for C# – Foreign Keys in Entity Framework – Code First – Query with Linq and Entity Framework – Linq vs Extension Methods (Example) it is a good idea to present some actions with LINQPad. LINQPad5 is…
C# – Foreign Keys in Entity Framework – Code First – Query with Linq
In this article, I present an Entity Framework example, building two tables with foreign keys, using code first. The sample I am using is building over the previous article for EF. Pretty much, when you are running your application, if…
Entity Framework – Linq vs Extension Methods (Example)
This article presents a simple example of querying with Linq and Extension Methods in Entity Framework (EF). To set the EF, create a C# Console application. Then add the Package Manager Console from Tools: Then run Install-Package EntityFramework in the Package…
Top