Month: December 2017

Reading excel file using C# and ExcelDataReader

I want to introduce you in a library that I usually used to read excel file in C#. It's called ExcelDataReader, it's lightweight library for reading excel files. I will not discuss more about it, you can just to the github repository for the details about it. Create a new Windows Forms Project. Then add … Continue reading Reading excel file using C# and ExcelDataReader

Library Management using ASP.Net MVC (Part 6) Borrowing and returning a book

In this part we will be finishing up the functionality to assign a book to a customer and returning the book. Source Code: https://github.com/alexcalingasan/LibraryManagement Now let's update our View for Create and Edit page of BorrowHistory. Copy and paste this for your BorrowHistory create view. Then change your BorrowHistories Edit view code to this. Then … Continue reading Library Management using ASP.Net MVC (Part 6) Borrowing and returning a book

Library Management using ASP.Net MVC (Part 5) Eager Loading and Projection

In this part you will learn how to get the data from the related entities using eager loading. We will also use projection to get the data that we need for the frontend. In the index page of our books, we want to see the list of books and if they are still available or … Continue reading Library Management using ASP.Net MVC (Part 5) Eager Loading and Projection

Library Management using ASP.Net MVC (Part 4) Entity Framework Relationship and Navigation Properties

In this article, we will start looking at the relationship between the customer and book model and how we can keep track of customer borrowing history. Before we start coding we should determine first the relationship of the customer and the book. Points to consider The customer can borrow multiple books. The book can be … Continue reading Library Management using ASP.Net MVC (Part 4) Entity Framework Relationship and Navigation Properties

Library Management using ASP.Net MVC (Part 3) Adding the Customers

In this article you will learn about Entity Framework code first migration. In the first part we use Entity Framework code first to create the book model. Code first allows us to focus on creating classes for our domain requirements rather than designing a database first then create a classes to match our database. We … Continue reading Library Management using ASP.Net MVC (Part 3) Adding the Customers

Library Management using ASP.Net MVC (Part 2) Request Lifecycle

It is important to understand the request lifecycle in ASP.Net MVC before we proceed with other tutorials. In this article I will briefly discuss to you how the ASP.Net MVC handles the request. When we make http request in our MVC application it will look for the registered routes in URL Routing Module to determine … Continue reading Library Management using ASP.Net MVC (Part 2) Request Lifecycle

Library Management using ASP.Net MVC (Part 1) Books CRUD Function

This tutorial is about creating a library management system using asp.net mvc and in this part you will learn how to create a Model for your data, add the needed data annotation and scaffold a basic crud application for your model. Before we start coding we should identify first the user's problem that we are … Continue reading Library Management using ASP.Net MVC (Part 1) Books CRUD Function

MEAN app with Angular 4 (Part 5) Saving data to MongoDb

In this part we will post a data from angular to node.js and save it to mongoDb. I'm going to use mlab for mongoDb. If you don't have an account yet with mlab, you can register at https://mlab.com/. Login to your mlab account. Then in create new MongoDb. Select the amazon web services as cloud provider … Continue reading MEAN app with Angular 4 (Part 5) Saving data to MongoDb

MEAN app with Angular 4 (Part 4) Angular Form and Routing

This is the continuation of my tutorial of angular 4. In this part you will learn how to bind angular models to input fields and setup angular routing. Angular Form and Data Binding Let's start by creating a form for new event. Open your angular project then add new file called events-register.component.ts inside your app … Continue reading MEAN app with Angular 4 (Part 4) Angular Form and Routing

MEAN app with Angular 4 (Part 3) Displaying the data using Angular Material

In this article we will be using Angular Material to display the data in the front end. In installing angular material it is good to follow the instruction in their website. You can read the instruction in Angular Material getting started page. Setting up Angular Material Open your angular project using your visual studio code editor … Continue reading MEAN app with Angular 4 (Part 3) Displaying the data using Angular Material