I would like to describe simple way for uploading Excel file as input in Azure Function (http trigger) and downloading Excel file as result of Azure Function work. The solution uses .NET and DocumentFormat.OpenXml for processing xlsx files. Input I assume that AF header looks like this: So we can read xlsx file as follows:…
The post is a part of “Architecture guidelines” series on my blog: System management. It’s embedded document so you may need to scroll it with a separate bar. Direct link to the document is here.
The post is a part of “Architecture guidelines” series on my blog: Performance and Scalability. It’s embedded document so you may need to scroll it with a separate bar. Direct link to the document is here.
I would like to describe architecture guidelines on my webpage. Technical as well as more general issues will be described. All the topics described here should be taken into consideration by professional Architect or Developer in software development process. There are some groups related to architecture listed below. I will describe every group in a…
Service contracts standardization Services in the same inventory should have standardized contracts in following areas: data representation, descriptions and documentation, naming conventions, common vocabulary and definitions, functional expressions, policies, granularity Goals: interoperability interpretability maintainability Formal process needs to be introduced to ensure the services are designed consistently. Decoupling Services should be loosely coupled – without…
It is difficult to find a complete list of recommendations and guidelines on how to secure the Web application. In this post I will list and briefly describe fundamental issues of Web application security. I will focus the most (but not only) on ASP.NET MVC Web app hosted on Azure App service. Security check list details the…
I will present some Azure deployment scenario automation using Azure services: Azure App Service – Web app and Webjob Azure Storage – Blob, Table and Queue Azure Active Directory Visual Studio Team Services with git repository Application structure in Microsoft Azure looks like this: I will present deployment scripted in practice with minimum theory –…
Post’s goal: abilities presentation of Azure cloud services in context of e-archive application implementation. Post text is based on the assumption that application is of the following architecture: website deployed on Azure App Service authentication and authorisation is based on Azure Active Directory service data storage is based on Azure services: Blob/Table/Queue Storage, DocumentDB or SQL…
The following is a list of the most common business requirements for system supporting the processing of digital documents, I call it “e-archive system”: Diverse form of data The system should handle graphic, doc, pdf, zip, txt, and other formats including not only files resulting from scanning paper documents, but also various types of binary…
Digitization of documents is the process of transforming documents in paper form into digital form. The process of digitization is often a component of a more general archiving process, which includes the following procedures: ordering, security, classifying appropriate collections, storage, destruction. The process of digitization is carried out to achieve the following goals: enable a…
Post Redirect Get (PRG) is a web development design pattern that prevents duplicate form submissions through Refresh button in web browser. When a Web app form is submitted through POST request, application does the job and makes a redirection (usually to the same page in case of invalid inputs). See more information about PRG and…
If you’re implementing a professional Web app, logging is a must-have. You can log in for the following purpose: tracking application usage finding bugs for safety reasons Logging can take place at various levels: application hosting level (web servers, application gateways, firewalls, etc.) application code level (presentation layer, application layer and business rules) infrastructure level…
This post presents concept of queries on objects collections generally with dynamic filter. We will use this Linq extension method: Suppose we want to find X class instances based on filter from external system. Assume that we have following classes as filter definition: Next we define class for dynamic Linq query together with other query staff…
PedoStat application allows you to record and analyze exercises in terms of: number of steps, calories burned, distance and other. Select route from the list and start exercise. You can name the routes depending on your needs, for example SHO (as route to shop) or JOB (as route to work), etc. Key feature of PedoStat…
Expenses is a simple but very functional application – to record and manage your expenses. – register expenses in very simple and intuitive way – search and view expenses by selected criteria – make reports of expenses by selected criteria (various summary options) – in html format – export expenses to text file – as…
Konrad Misniakiewicz 