Sales Order Web Application

This is a Asp.Net Web App that features Order function.

Functions

• Select
• Update
• Delete
• Create

So this is a web application developed using Asp.Net, Dapper. Using Dapper we managed to communicate with Sql Server and execute sql commands. While we used Model-View-Controller way to develop a web application, where each controller do a different action, like insert controller contains action method that help us insert data from web app to sql.

These are some features we incorporated in this application

Features

• Login and logout: CookieAuthentication
• Cache: OutputCache and ResponseCache
• View Validation Attributes like: Required, string length, range()
• Route Attribute
• Bootstrap for CSS
• Mobile Responsive
• Logging: Using Serilog

Working

Login Page

---

Index Page

This page shows all the items present in Orders Table

---

Update Page

---

Delete Page

---

Insert Page

---

Attribute Validation

All the fields are validated, no empty value can be passed in any of the input field. Minimum and maximum length are set in product id field, in orderid value greater than 100 is invalid. Password is set to be 8 alphanumeric long and many more validation are done. Error messages will be displayed below the input field if any condition is violated. If a value is not present in Sql database then "No Record Found" is shown.

---

Log

Using Serilog, every Event, Error and Exception is recorded in console and saved in log file.

Working Process

We use Asp.Net MVC Web App to develop this application, here controller contains action methods which is called when client(web browser) sends a request to server, in response the server will send the contents, this content are mainly webpages which is present in Views and process the logic in the action method.

©️ SalesOrder 2024