static void Main() { //create object of EmployeesDataAccess class EmployeesDataAccess employeesDataAccess = new EmployeesDataAccess(); //create object of Employee class Employee emp = new Employee(); //Read values from keyboard Console.WriteLine("INSERT EMPLOYEE:::::::::::::::::::::"); Console.Write("\nEmployee ID: "); emp.EmpID = int.Parse(Console.ReadLine()); Console.Write("\nEmployee Name: "); emp.EmpName = Console.ReadLine(); Console.Write("\nSalary: "); emp.Salary = decimal.Parse(Console.ReadLine()); Console.Write("\nDept No: "); emp.DeptNo = int.Parse(Console.ReadLine()); //call the InsertEmployee() method int n = employeesDataAccess.InsertEmployee(emp); Console.WriteLine($"{n} row inserted"); Console.ReadKey(); }
public Employee Post(Employee emp) { EmployeesDataAccess employeesDataAccess = new EmployeesDataAccess(); int n = employeesDataAccess.InsertEmployee(emp); return(emp); }
public IEnumerable <Employee> Get() { EmployeesDataAccess da = new EmployeesDataAccess(); List <Employee> emplist = da.GetAllEmployees(); return(emplist); }
public void Delete(int id) { EmployeesDataAccess da = new EmployeesDataAccess(); da.DeleteEmployee(id); }
public void Put(int id, [FromBody] Employee emp) { EmployeesDataAccess da = new EmployeesDataAccess(); da.UpdateEmployee(id, emp); }
public void Post([FromBody] Employee emp) { EmployeesDataAccess da = new EmployeesDataAccess(); da.SaveEmployee(emp); }
public Employee Get(int id) { EmployeesDataAccess da = new EmployeesDataAccess(); return(da.GetEmployeeById(id)); }