Power BI Report Server: Key Features and Elements
Every CTO knows the struggle of managing complex reports. The inefficiency of scattered data, the constant juggling between reporting tools, the challenge of ensuring accurate KPIs...
Kapil Panchal - October 27, 2020
Listening is fun too.
Straighten your back and cherish with coffee - PLAY !
The Repository pattern is the most popular pattern for creating an enterprise level application. The repository is used to create an abstraction layer between the data access layer and the business logic layer of an application.Implementation of repository patterns can help to abstract your application from changes in the data store and can facilitate automated unit testing.
Repository directly communicates with Database (Data Access Layer (DAL)) andfetch the data and provide it to the logical layer (Business logic layer (BAL)). The purpose of the Repository is to isolate the data access layer (DAL) and the Business Logic Layer (BAL). Instead of writing entire data access logic in a controller write this logic in a different class known as a repository. This will make your code maintainable and understandable.
If an application doesn't follow the repository pattern then an application has the following problems:
Ā
Using the Repository pattern has the following advantages:
Ā
The main purpose of the repository pattern is to isolate the data access layer and business logic.In Asp.Net MVC model is used to interact with the Data Access layer and Controller for performing Data access operation. The controller is responsible for passing data to the view. If the controller has tightly coupled to mode then any model changes directly impact on the controller and also on View.
The following diagram gives an overview of the repository pattern:
Ā
1.1-Process Flow DiagramĀ
Ā
Step 1: Create web application
Open Visual Studio
Create new project
ĀProvide name and Location and Click on next.
Select the Basic template (MVC) and Click on ok.
Step 2: Create a table
Open Microsoft SQL server management studio.
Select the Database and Create a table.
Ā
1.2 student tableĀ
Step 3: Connect with the database with (Db First Approach).
Open solution explorer and Add new Data Model.
Connect with the database and add a table.
Ā
1.3 Establish Connection for SQL server.Ā
Step 4: Create a Repository for Employee
Create Repository folder inside the project
ĀIStudentRepository.cs
ĀusingSystem.Collections.Generic; namespaceRepository.Models { publicinterfaceIStudentRepository { IEnumerableGetStudents(); student GetStudentById(ints_id); voidInsertStudent(student s); voidUpdateStudent(student s); voidDeleteStudent(ints_id); voidsave(); } }
StudentRepository.cs
StudentRepositoryimplementsIStudentRepository
using System; usingSystem.Collections.Generic; usingSystem.Linq; namespaceRepository.Models { publicclassStudentRepository :IStudentRepository { private demoEntities2 _context; publicStudentRepository(demoEntities2 context) { this._context = context; } publicIEnumerableGetStudents() { return _context.students.ToList(); } public student GetStudentById(ints_id) { return _context.students.Find(s_id); } publicvoidInsertStudent(student s) { _context.students.Add(s); } publicvoidUpdateStudent(student s) { _context.Entry(s).State = System.Data.Entity.EntityState.Modified; } publicvoidDeleteStudent(ints_id) { student s = _context.students.Find(s_id); _context.students.Remove(s); } publicvoidsave() { _context.SaveChanges(); } publicvoidDispose() { thrownewNotImplementedException() } } }
Step 5: Call Repository from Controller.
Add new controller
Controller Interact with StudentRepository by creating Reference of IStudentRepository
StudentController.cs
ĀusingDemo.Models; usingSystem.Linq; usingSystem.Web.Mvc; namespaceDemo.Controllers { publicclassStudentController : Controller { // GET: Student privateIStudentRepositoryinterfaceobj; publicStudentController() { this.interfaceobj = newStudentRepository(new demoEntities2()); } // GET: Student publicActionResultIndex() { var data = from m ininterfaceobj.GetStudents() select m; return View(data); } publicActionResultDetailStudent(int id) { student s = interfaceobj.GetStudentById(id); return View(s); } publicActionResultCreateStudent() { returnView(); } [HttpPost] publicActionResultCreateStudent(student s) { interfaceobj.InsertStudent(s); interfaceobj.save(); returnRedirectToAction("Index"); } publicActionResultUpdateStudent(int id) { student s = interfaceobj.GetStudentById(id); return View(s); } [HttpPost] publicActionResultUpdateStudent(int id, student s) { interfaceobj.UpdateStudent(s); interfaceobj.save(); returnRedirectToAction("Index"); } publicActionResultDeleteStudent(int id) { student s = interfaceobj.GetStudentById(id); return View(s); } [HttpPost] publicActionResultDeleteStudent(int id, student s) { interfaceobj.DeleteStudent(id); interfaceobj.save(); returnRedirectToAction("Index"); } } }
Step 5: Add View.
ĀAdd View for Index, CreateStudent, DetailStudent, DeleteStudent
ĀIndex.cs
@model IEnumerable@{ ViewBag.Title = "Index"; } Index
@Html.ActionLink("Create New", "CreateStudent")
@foreach (var item in Model) { }
Ā Ā @Html.DisplayNameFor(model => model.s_id) Ā @Html.DisplayNameFor(model => model.s_name) Ā @Html.DisplayNameFor(model => model.s_lastname) Ā @Html.DisplayNameFor(model => model.s_bday) Ā Ā Ā Ā @Html.DisplayFor(modelItem => item.s_id) Ā @Html.DisplayFor(modelItem => item.s_name) Ā @Html.DisplayFor(modelItem => item.s_lastname) Ā @Html.DisplayFor(modelItem => item.s_bday) Ā @Html.ActionLink("Edit", "UpdateStudent", new { id=item.s_id }) | @Html.ActionLink("Details", "DetailStudent", new { id=item.s_id }) | @Html.ActionLink("Delete", "DeleteStudent", new { id=item.s_id }) Ā
Ā
@model Demo.Models.student @{ ViewBag.Title = "CreateStudent"; }ĀCreateStudent
@using (Html.BeginForm()) { @Html.AntiForgeryToken()student
@Html.LabelFor(model =>model.s_name, htmlAttributes: new { @class = "control-label col-md-2" }) @Html.EditorFor(model =>model.s_name, new { htmlAttributes = new { @class = "form-control" } }) @Html.LabelFor(model =>model.s_lastname, htmlAttributes: new { @class = "control-label col-md-2" }) @Html.EditorFor(model =>model.s_lastname, new { htmlAttributes = new { @class = "form-control" } }) @Html.LabelFor(model =>model.s_bday, htmlAttributes: new { @class = "control-label col-md-2" }) @Html.EditorFor(model =>model.s_bday, new { htmlAttributes = new { @class = "form-control" } }) }@Html.ActionLink("Back to List", "Index")@section Scripts { @Scripts.Render("~/bundles/jqueryval") }
note:
Asp.net MVC provide Template [List, add, edit, delete] for View. For adding View Right Click on the method and Add View. Select Template and add Model class.
In RouteConfig.cs file change the name of controller [Home->Student]
Step 7: Build and Run Project
Build and Run the application.
Build Your Agile Team
Every CTO knows the struggle of managing complex reports. The inefficiency of scattered data, the constant juggling between reporting tools, the challenge of ensuring accurate KPIs...
The very first reason why you should implement Row Level Security is to foster trust, a crucial element for any business's success. Next, it reduces data clutter and helps you load...
The performance of Power BI is significantly influenced by two essential factors: design consistency and the rapid loading of BI elements. This holds true whether you choose Tableau...