Example #1
0
        static void Main(string[] args)
        {
            Console.WriteLine("Hello World!");
            //Get data of all employees from database
            EmployeeRepo employeeRepo = new EmployeeRepo();

            //employeeRepo.GetAllEmployee();
            //Adding employee to database
            //EmployeeModel employee = new EmployeeModel();
            //employee.EmployeeName = "Indal";
            //employee.Department = "Tech";
            //employee.PhoneNumber = "6302907918";
            //employee.Address = "02-Khajauli";
            //employee.Gender = 'M';
            //employee.BasicPay = 10000.00M;
            //employee.Deductions = 1500;
            //employee.StartDate = employee.StartDate = Convert.ToDateTime("2020-11-03");

            //if (employeeRepo.AddEmployee(employee))
            //    Console.WriteLine("Records added successfully");
            //if(employeeRepo.UpdateSalary("Bill", 200000))
            //    Console.WriteLine("Salary Updated successfully");
            //employeeRepo.Retrieve_Employee_Within_Specified_Joining_Date(Convert.ToDateTime("03/11/2018"), Convert.ToDateTime("03/11/2019"));
            employeeRepo.SumOfEmployeeSalary();
            employeeRepo.AverageOfEmployeeSalary();
            employeeRepo.MinOfEmployeeSalary();
            employeeRepo.MaxOfEmployeeSalary();
        }