ASP.NET CORE - CRUD Using Dependency Injection

Create database Web
use Web
Create table Details(  
   Name varchar(50),
   Username varchar(50),
   Password varchar(50) 
); 
Insert into Details values ('divya','[email protected]',1234)
Insert into Details values ('maneesha','[email protected]',5678)
Insert into Details values ('Ishika','[email protected]',8976)
SELECT * FROM Details  

namespace dependency.Model {
    public class Connection {
        public string connectionstring {
            get;
            set;
        }
        public Connection() {
            this.connectionstring = $ "Data Source=.\\SQLEXPRESS;Initial 
            Catalog=WEB;Integrated Security=True";
        }
    }
}

using System.Data.SqlClient;
namespace dependency.Model{
   public class DAL {
        Connection Conn;
        public DAL(Connection _CONN) {
            Conn = _CONN;
        }
        public string GETVALUE(string QUERY){
            SqlConnection sqlConnection = new SqlConnection(Conn.connectionstring);
            Conn.connectionstring = sqlConnection.ConnectionString;
            SqlCommand COMMAND = new SqlCommand();
            COMMAND.Connection = sqlConnection;
            COMMAND.CommandText = QUERY;
            sqlConnection.Open();
            var RES1 = COMMAND.ExecuteScalar();
            sqlConnection.Close();
            return RES1.ToString();
        }
        public string VALUE(string QUERY) {
            SqlConnection sqlConnection = new SqlConnection(Conn.connectionstring);
            Conn.connectionstring = sqlConnection.ConnectionString;
            SqlCommand COMMAND = new SqlCommand();
            COMMAND.Connection = sqlConnection;
            COMMAND.CommandText = QUERY;
            sqlConnection.Open();
            var RES2 = COMMAND.ExecuteNonQuery();
            sqlConnection.Close();
            return RES2.ToString();
        }       
    }
}

using System;
namespace dependency.Model {
    public class Logic {
        DAL DL;
        public Logic(DAL _DL) {
            DL = _DL;
        }
        public bool login(string Username, string Password) {
            string Pass = DL.GETVALUE($ "select Password from Details where Username='{Username}'");
            return Pass == Password;
        }
        public String INSERT(String Name, String Username, String Password) {
            string Pass = DL.VALUE($ "insert into Details (Name,Username,Password)VALUES('{Name}','{Username}','{Password}')");
            return Pass;
        }
        public String UPDATE(String Name, String Username, String Password) {
            string Pass = DL.VALUE($ "UPDATE Details SET Username='{Username}',Password='{Password}' WHERE Name='{Name}'");
            return Pass;
        }
        public String DELETE(String Name, String Username, String Password) {
            string Pass = DL.VALUE($ "DELETE FROM Details WHERE Name='{Name}'");
            return Pass;
        }
    }
}

To Read/Retrieve the data

To read the data from the database, click on the READ.cshtml page and write the given code to create a form.

@page
@model dependency.Pages.READModel
@{
}
<div class="container col-md-4">    
    <form method="POST">
        <label for="Uname" class="col-form-label">USERNAME</label>
        <input type="text" class="form-control" name="Username" placeholder="Username..." />
        <label for="pass" class="col-form-label">PASSWORD</label>
        <input type="text" class="form-control" name="Password" placeholder="Password..." />
        <div class="row">
        <input type="submit" class="btn btn-success" value="SIGN UP" />          
        </div>
    </form>
</div>

Open READ.cshtml.cs page as you can see, the READModel inherits from the PageModel which plays an important role in the Razor Pages. Normally, this page has some methods that start with On+Http Method, such as OnGet, and OnPost. First of all, create a constructor to inject the dependency and write the given code for reading the data from the database.

using System;
using dependency.Model;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
namespace dependency.Pages {
    public class READModel: PageModel {
        public void OnGet() {}
        Logic _logic;
        public READModel(Logic logic1) {
            _logic = logic1;
        }
        public IActionResult OnPost(String Username, String Password) {
            if (_logic.login(Username, Password)) {
                return Redirect("/DEMO");
            } else {
                return Redirect("/Error");
            }
        }
    }
}

Output Screen

To Insert the data

To Insert the data into the database, first of all, create a Razor page named the page INSERT then click on the INSERT.cshtml page and write the given code to create a form.

@page
@model dependency.Pages.INSERTModel
@{
}
<div class="container col-md-4">
    <form method="POST">
        <label for="name" class="col-form-label">NAME</label>
        <input type="text" class="form-control" name="Name" placeholder="NAME..." />
        <label for="Uname" class="col-form-label">USERNAME</label>
        <input type="text" class="form-control" name="Username" placeholder="USERNAME..." />
        <label for="pass" class="col-form-label">PASSWORD</label>
        <input type="text" class="form-control" name="PASSWORD" placeholder="PASSWORD..." />
        <div class="row">
        <input type="submit" class="btn btn-success" value="INSERT" />
        </div>
    </form>
</div>

Open INSERT.cshtml.cs page and create a constructor to inject the dependency and write the given code for inserting the data into the database.

using System;
using dependency.MODEL;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
namespace dependency.Pages {
    public class INSERTModel: PageModel {
        public void OnGet() {}
        Logic LOGICS;
        public INSERTModel(Logic LOGIC1) {
            LOGICS = LOGIC1;
        }
        public IActionResult OnPost(String Name, String Username, String Password) {
            LOGICS.INSERT(NAME, USERNAME, PASSWORD);
            return Redirect("/DEMO");
        }
    }
}

You can observe that here we are using the OnPost request to insert the data using the LOGIC method.

Output Screen

To Edit/Update the data

To update the data from the database, first, create a Razor page and name the page UPDATE then click on the UPDATE.cshtml page and write the given code to create a form.

@page
@model dependency.Pages.UPDATEModel
@{
}
<div class="container col-md-4">
    <form method="POST">
        <label for="fname" class="col-form-label">NAME</label>
        <input type="text" class="form-control" name="NAME" placeholder="NAME..." />
        <label for="fname" class="col-form-label">USERNAME</label>
        <input type="text" class="form-control" name="USERNAME" placeholder="USERNAME..." />
        <label for="lname" class="col-form-label">PASSWORD</label>
        <input type="text" class="form-control" name="PASSWORD" placeholder="PASSWORD..." />
        <div class="row">
        <input type="submit" class="btn btn-success" value="UPDATE" />
        </div>
    </form>
</div>

Open UPDATE.cshtml.cs page and create a constructor to inject the dependency and write the given code for updating the data from the database.

using System;
using dependency.MODEL;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
namespace dependency.Pages {
    public class UPDATEModel: PageModel {
        public void OnGet() {}
        Logic LOGICS;
        public UPDATEModel(Logic _LOGIC) {
            LOGICS = _LOGIC;
        }
        public IActionResult OnPost(String Name, String Username, String Password) {
            LOGICS.UPDATE(Name, Username, Password);
            return Redirect("/DEMO");
        }
    }
}

This Razor page will enable us to edit/update the data of an existing table.

Output Screen

To Delete the data

To delete the data from the database, first, create a Razor page named the page DELETE then click on the DELETE.cshtml page and write the given code to create a form.

@page
@model dependency.Pages.DELETEModel
@{
}
<div class="container col-md-4">
    <form method="POST">
        <label for="name" class="col-form-label">NAME</label>
        <input type="text" class="form-control" name="NAME" placeholder="NAME..." />
        <label for="uname" class="col-form-label">USERNAME</label>
        <input type="text" class="form-control" name="USERNAME" placeholder="USERNAME..." />
        <label for="pass" class="col-form-label">PASSWORD</label>
        <input type="text" class="form-control" name="PASSWORD" placeholder="PASSWORD..." />
        <div class="row">
        <input type="submit" class="btn btn-success" value="DELETE" />
        </div>
    </form>
</div>

Open DELETE.cshtml.cs page and create a constructor to inject the dependency and write the given code for deleting the data from the database.

using System;
using dependency.MODEL;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.RazorPages;
namespace dependency.Pages {
    public class DELETEModel: PageModel {
        public void OnGet() {}
        Logic LOGICS;
        public DELETEModel(Logic _LOGIC) {
            LOGICS = _LOGIC;
        }
        public IActionResult OnPost(String Name, String Username, String Password) {
            LOGICS.DELETE(NAME, USERNAME, PASSWORD);
            return Redirect("/DEMO");
        }
    }
}

Output Screen

Step 9

Open Startup. cs and write the services for dependency injection (here I have written singleton services).

public IConfiguration Configuration {
    get;
}
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services) {
    services.AddRazorPages();
    services.AddSingleton < dependency.MODEL.CONNECTION > ();
    services.AddSingleton < dependency.MODEL.DAL > ();
    services.AddSingleton < dependency.MODEL.LOGIC > ();
}

And that’s it. We have created our ASP.NET Core application using dependency injection.

Conclusion

We have learned how to fetch data using dependency injection in ASP.NET Core. In this article, we have used SQL database for creating data, reading data, editing data, and deleting data from the database.