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));
}