Workshop: From databases to Web + Desktop + Mobile applications one day

Workshop: From databases to Web + Desktop + Mobile applications one day

Description:
We will start from a database with two tables: Department and Employees. A Department may have more Employees, an Employee is part of a Department.
The applications we will be doing (Web, Desktop, Android) will contain editing and viewing of Employees and Departments.

What will be the outcome:
1. Web / Android / Windows applications themselves.
2. A way to develop applications for any platform (Internet / Desktop / Mobile)
3. A list of links by which you can learn programming on the Web / Desktop / Mobile.
4. After the workshop: An hour of free consulting about building an application.


What you need

1. Preinstalled Windows Laptop (we will send you the list of software you need to install)
2. One-day of work


Workshop content

1. 8:30 am: The arrival of the participants. Solve possible installation problems.
2. Time 9: .NET Core Console Applications for Department Editing. Classes, Sql.
3. Time 10: .NET Core REST Web API Applications for Editing Department
4. 11:15: Basic Angular Tutorial
5. Time 15: Angular Tutorial to access the REST Web API
6. Time 13: Lunch break
7. Time 14:30: Editing the Angular Department
8. Time 16: Editing the Angular Employee
9. Time 17: Generate Mobile, Web, Desktop, and Deployment
10. Time 18: Questions
Date: June 30, 2018, 9: 00-19: 00

.

Modern Web Applications .NET Core with Angular class

Who is addressed to

This tutorial is aimed to C# programmers with at least 6 months experience. Also , they should  have at least 6 months experience with HTML / CSS / Javascript . This will help them how to build applications with the .NET Core framework and a front end framework ( Angular)

The class will be taken by Andrei Ignat, former C# MVP for 6 years, https://forums.asp.net moderator and OpenSource contributor( you can find his AspNetCoreImageTagHelper mentioned on https://github.com/aspnet/Mvc ). More details at his blog at http://msprogrammer.serviciipeweb.ro .

What it contains

Day 1: Angular 5 introduction

1. What you need

2. Angular component

3. TypeScript basics

4. Observables

5. HTTP

6. Routing

Day 2: .NET Core WebAPI introduction

1. What you need

2. WebAPI basics

3. Documentation ( swagger / open API )

4. SignalR with Observables

5. Generating from Database

6. Testing

Day 3 : Creating Web / Desktop / Mobile Application

1. What you need

2. Gluing Day 2 and Day 3

3. Web Application with .NET Core and Angular

4. Desktop Application with .NET Core and Electron

5. Mobile Application with PhoneGag

What to expect

After completing this course, you will be able to create Web/Desktop/Mobile application by applying the structure described above

ASP.NET Core class

Who is addressed to

This tutorial is aimed to C# programmers with at least 6 months experience. Also , they should  have at least 6 months experience with HTML / CSS / Javascript .. This will help them to understand ASP.NET Core foundations and how to build applications with the .NET Core framework

The class will be taken by Andrei Ignat, former C# MVP for 6 years, https://forums.asp.net moderator and OpenSource contributor( you can find his AspNetCoreImageTagHelper mentioned on https://github.com/aspnet/Mvc ). More details at his blog at http://msprogrammer.serviciipeweb.ro .

What it contains

Day 1. ASP.NET Core Basics

MVC – model , view , controller.

  • Views, Areas, Layout.
  • ViewBag, Controller, Action
  • Model
  • Model binding
  • generate from database ( EF)

Transmitting data from

  • action to action
  • view to action
  • action to view
  • view to view


Day 2. Intermediate WebAPI

WebApi

  • Creation,
  • Formatters ( XML, Json, others)
  • Filters ( logging time, validation)
  • Caching

Practical WebAPI

  • Ajax with WebAPI
  • Knockout with WebAPi


Day 3 Advanced .NET Core

Dependency injection

  • logging
  • action

Middleware – slug routing

Angular with .NET Core

Testing

What to expect

After completing this course, you will be able to:

a.  Understand how to create a new application with ASP.NET Core

b. Know how to use the intermediat features of ASP.NET Core

c. Understand how to make an modern application with Angular on frontend and .NET Core on backend

Putting data into existing PDF

I have had to introduce data for NGO into an existing PDF. Why PDF ? Because yes, it is easy to print. but from a templating point of view it is a nightmare.  by templating I understand putting data at specific places , like

First Name :

Last Name :

And filling in the blanks.

The solution: complicated.  The  pdf can have Form fields to be filled . I discovered

 https://www.pdfescape.com/windows/

that can be used to put form fields into existing documents and save the pdf.

And I figured that this is all. Nope. Look here

109 0 obj
<</Subtype/Widget/Rect[119.52 347.25 565.92 358.77]/AP<</N 110 0 R>>/DA(/Helv 8.64 Tf 0 g)/F 4/FT/Tx/P 1 0 R/T(untitled22)/Q 0/V(*NumeONG*)>>

endobj


110 0 obj

<</Type/XObject/Subtype/Form/BBox[0 0 446.39999 11.51999]/Resources<</Font<</Helv 77 0 R>>>>/Filter/FlateDecode/Length 90>>stream
xœÓ©Ppòuær
á2PIå\†@ª
ÈNñ‹¸ô=RsÊ,ôÌLBÒ¸€ÐPÁHÁHÏÌL!$—+ZC˯47ÕßÏ]K36Ä‹Ë5„Ëh&endstream

endobj

The PDF format is a primitve form of XML. The 109 0 obj  finishes with  endobj . I figured that I will replace
*NumeONG*

with the name and all will be ok. Nope . The critical point is the stream at the next obj

110 0 obj
<</Type/XObject/Subtype/Form/BBox[0 0 446.39999 11.51999]/Resources<</Font<</Helv 77 0 R>>>>/Filter/FlateDecode/Length 90>>stream
xœÓ©Ppòuær
á2PIå\†@ª
ÈNñ‹¸ô=RsÊ,ôÌLBÒ¸€ÐPÁHÁHÏÌL!$—+ZC˯47ÕßÏ]K36Ä‹Ë5„Ëh&endstream
endobj

Not only is is encoded

Filter/FlateDecode

but also it says the length of the stream,

Filter/FlateDecode/Length 90

That is a problem, because the replacement for the name will be dynamic.

Solution?

The qpdf solftware http://qpdf.sourceforge.net that allows to transform those streams into something readable

qpdf –qdf  –object-streams=disable   m.pdf a.pdf

GitHub as a central Hub

I do not know how, but GitHub is now a hub for all things.

I , personnally, used GitHub as a

– source control ( see https://github.com/ignatandrei/Exporter )

– documentation ( see https://github.com/ignatandrei/Exporter/wiki )

– Angular application deployment (https://ignatandrei.github.io/Decl230   – done with  gh-pages –  see build.bat from https://github.com/ignatandrei/Decl230 )

– read-only database ( Sqlite download from github in the project  https://github.com/ignatandrei/IsThisTaxiLegal )

I have seen many other uses

–  like Docker files generator ( for example, for docker phone gap  see https://github.com/webratio/docker )

– blog

and may others ( https://readwrite.com/2013/11/08/seven-ways-to-use-github-that-arent-coding/)

I need just a server hosting service affordable….