CodeHub

1. namespace CRUDAPI.Controllers  
2. {  
3.     [RoutePrefix("Api/Employee")]  
4.     public class EmployeeAPIController : ApiController  
5.     {  
6.         WebApiDbEntities objEntity = new WebApiDbEntities();  
7.          
8.         [HttpGet]  
9.         [Route("AllEmployeeDetails")]  
10.         public IQueryable<EmployeeDetail> GetEmaployee()  
11.         {  
12.             try  
13.             {  
14.                 return objEntity.EmployeeDetails;  
15.             }  
16.             catch(Exception)  
17.             {  
18.                 throw;  
19.             }  
20.         }  
21.   
22.         [HttpGet]  
23.         [Route("GetEmployeeDetailsById/{employeeId}")]  
24.         public IHttpActionResult GetEmaployeeById(string employeeId)  
25.         {  
26.             EmployeeDetail objEmp = new EmployeeDetail();  
27.             int ID = Convert.ToInt32(employeeId);  
28.             try  
29.             {  
30.                  objEmp = objEntity.EmployeeDetails.Find(ID);  
31.                 if (objEmp == null)  
32.                 {  
33.                     return NotFound();  
34.                 }  
35.   
36.             }  
37.             catch (Exception)  
38.             {  
39.                 throw;  
40.             }  
41.             
42.             return Ok(objEmp);  
43.         }  
44.   
45.         [HttpPost]  
46.         [Route("InsertEmployeeDetails")]  
47.         public IHttpActionResult PostEmaployee(EmployeeDetail data)  
48.         {  
49.              
50.             if (!ModelState.IsValid)  
51.             {  
52.                 return BadRequest(ModelState);  
53.             }  
54.             try  
55.             {  
56.                 objEntity.EmployeeDetails.Add(data);  
57.                 objEntity.SaveChanges();  
58.             }  
59.             catch(Exception)  
60.             {  
61.                 throw;  
62.             }  
63.   
64.             return Ok(data);  
65.         }  
66.          
67.         [HttpPut]  
68.         [Route("UpdateEmployeeDetails")]  
69.         public IHttpActionResult PutEmaployeeMaster(EmployeeDetail employee)  
70.         {  
71.             if (!ModelState.IsValid)  
72.             {  
73.                 return BadRequest(ModelState);  
74.             }  
75.   
76.             try  
77.             {  
78.                 EmployeeDetail objEmp = new EmployeeDetail();  
79.                 objEmp = objEntity.EmployeeDetails.Find(employee.EmpId);  
80.                 if (objEmp != null)  
81.                 {  
82.                     objEmp.EmpName = employee.EmpName;  
83.                     objEmp.Address = employee.Address;  
84.                     objEmp.EmailId = employee.EmailId;  
85.                     objEmp.DateOfBirth = employee.DateOfBirth;  
86.                     objEmp.Gender = employee.Gender;  
87.                     objEmp.PinCode = employee.PinCode;  
88.   
89.                 }  
90.                 int i = this.objEntity.SaveChanges();  
91.   
92.             }  
93.             catch(Exception)  
94.             {  
95.                 throw;  
96.             }  
97.             return Ok(employee);  
98.         }  
99.         [HttpDelete]  
100.         [Route("DeleteEmployeeDetails")]  
101.         public IHttpActionResult DeleteEmaployeeDelete(int id)  
102.         {  
103.             //int empId = Convert.ToInt32(id);  
104.             EmployeeDetail emaployee = objEntity.EmployeeDetails.Find(id);  
105.             if (emaployee == null)  
106.             {  
107.                 return NotFound();  
108.             }  
109.   
110.             objEntity.EmployeeDetails.Remove(emaployee);  
111.             objEntity.SaveChanges();  
112.   
113.             return Ok(emaployee);  
114.         }  
115.     }  
116. }  

Entity Framework Code First Migrations

• Open Package Manager Console and select the default project as your WebAPI project. Type the command Enable-Migrations and press enter.

• Once the command is executed, it does some changes to our solution. As a part of adding migrations, it creates a Migrations folder and adds a class file named ”Configuration.cs”. This class is derived from DbMigrationsConfiguration class. 

• The context parameter is the instance of our context class that got generated while we were adding a controller. We provided the name as StudentManagementContext. This class derives from DbContext class. This context class takes care of DB schema and the DbSet properties of this class are basically the tables that we’ll have when our database will be created. It added Students as a DbSet property that returns our Student model/entity and would be directly mapped to the table that will be generated in the database.
• The next step is to execute the command named “Add-Migrations”. In the package manager console, execute this command with a parameter of your choice that would be the name of our first migration. I call it ”Initial”. So, the command would be Add-Migrations Initial.

• Again in the package manager console, run the command “Update-Database”.