public static DataTable GetEmployeesByOption(string option)
    {
        DAEmployee objDA = new DAEmployee();
        DataTable  Dtab  = objDA.GetEmployeeDetails(option);

        return(Dtab);
    }
    public static DataTable SelectEmployeeDetails(string code)
    {
        DAEmployee objDA = new DAEmployee();
        DataTable  Dtab  = objDA.GetEmployeeDetails(code);

        return(Dtab);
    }
Exemple #3
0
        public void AddEmployee([FromBody] Employee objemployee)
        {
            int        Result        = 0;
            DAEmployee objDAEmployee = new DAEmployee();

            Result = objDAEmployee.AddEmployee(objemployee);
        }
        public RowSet DisplayEmpTable()
        {
            DAEmployee dae  = new DAEmployee();
            RowSet     data = dae.DisplayEmpTable();

            return(data);
        }
Exemple #5
0
        public void UpdateEmployee(Employee objemployee)
        {
            int        Result        = 0;
            DAEmployee objDAEmployee = new DAEmployee();

            Result = objDAEmployee.UpdateEmployee(objemployee);
        }
    public static DataTable GetAllEmployees()
    {
        DAEmployee objDA = new DAEmployee();
        DataTable  Dtab  = objDA.GetAllEmployees();

        return(Dtab);
    }
Exemple #7
0
        public void AddSingleEmp()
        {
            // arrange
            int    id        = 1;
            string firstName = "Sumet";
            string lastName  = "Funan";
            int    age       = 25;

            Employee employee = new Employee()
            {
                Id        = id,
                FirstName = firstName,
                LastName  = lastName,
                Age       = age
            };

            // act
            DAEmployee daEmployee = new DAEmployee();

            daEmployee.Add(employee);

            // assert
            var result = daEmployee.GetAll().ToList()[0];

            Assert.AreEqual(1, result.Id);
            Assert.AreEqual("Sumet", result.FirstName);
            Assert.AreEqual("Funan", result.LastName);
            Assert.AreEqual(25, result.Age);
        }
Exemple #8
0
        public List <Employee> GetEmployees()
        {
            DAEmployee      objDAEmployee = new DAEmployee();
            List <Employee> lstemployees  = new List <Employee>();

            lstemployees = objDAEmployee.GetAllEmployees();
            return(lstemployees);
        }
Exemple #9
0
        public void DeleteEmployee(int ID)
        {
            int        Result        = 0;
            DAEmployee objDAEmployee = new DAEmployee();
            Employee   objEmployee   = new Employee();

            objEmployee.EmployeeID = ID;
            Result = objDAEmployee.DeleteEmployee(objEmployee);
        }
    public static EmployeeList GetEmployeeAsaList()
    {
        EmployeeList objList = new EmployeeList();

        DAEmployee objDA = new DAEmployee();
        DataTable  table = objDA.GetAllEmployeeList();

        foreach (DataRow dr in table.Rows)
        {
            BOEmployee objBO = new BOEmployee();
            objBO.Code  = dr["code"].ToString();
            objBO.Pin   = dr["pin_number"].ToString();
            objBO.Name  = dr["name"].ToString();
            objBO.Email = dr["email"].ToString();
            //  objBO.Password = dr["password"].ToString();
            objList.AddToList(objBO);
        }
        return(objList);
    }
Exemple #11
0
        public void AddTwoEmp()
        {
            // arrange
            Employee employee1 = SetEmployee(1, "Sumet", "Funan", 25);
            Employee employee2 = SetEmployee(2, "Hello", "World", 28);

            // act
            DAEmployee daEmployee = new DAEmployee();

            daEmployee.Add(employee1);
            daEmployee.Add(employee2);

            // assert
            var result = daEmployee.GetAll().ToList();

            Assert.AreEqual(2, result.Count);

            AssertEmployee(1, "Sumet", "Funan", 25, result[0]);
            AssertEmployee(2, "Hello", "World", 28, result[1]);
        }
        public void ContractualEmployeeSalary()
        {
            IDAEmployee DaEmployee     = new DAEmployee();
            double      expectedSalary = 5250;
            double?     workingDays    = 10.5;
            Employee    employee       = new Employee
            {
                Id           = 2,
                Name         = "Test2",
                EmployeeType = Constants.EmployeeTypes.Contractual,
                DateOfBirth  = new DateTime(2000, 2, 1),
                TIN          = 123456
            };

            DaEmployee.Create(employee);
            EmployeeFactory factory     = new Factory();
            IEmployee       employeeObj = factory.GetEmployee(employee.EmployeeType, null, workingDays);
            double          salary      = employeeObj.GetSalary();

            Assert.Equal(expectedSalary, salary);
        }
        public void RegularEmployeeSalary()
        {
            IDAEmployee DaEmployee     = new DAEmployee();
            double      expectedSalary = 16236.36;
            double?     absentDays     = 1.5;
            Employee    employee       = new Employee
            {
                Id           = 1,
                Name         = "Test1",
                EmployeeType = Constants.EmployeeTypes.Regular,
                DateOfBirth  = new DateTime(2000, 1, 1),
                TIN          = 12345
            };

            DaEmployee.Create(employee);
            EmployeeFactory factory     = new Factory();
            IEmployee       employeeObj = factory.GetEmployee(employee.EmployeeType, absentDays, null);
            double          salary      = employeeObj.GetSalary();

            Assert.Equal(expectedSalary, salary);
        }
        public void UpdateEmpTable()
        {
            DAEmployee dae = new DAEmployee();

            dae.UpdateEmpTable();
        }
        public void InsertEmpTable()
        {
            DAEmployee dae = new DAEmployee();

            dae.InsertEmpTable();
        }
        public void DeleteEmpTable()
        {
            DAEmployee dae = new DAEmployee();

            dae.DeleteEmpTable();
        }
        public void CreateEmpTable()
        {
            DAEmployee dae = new DAEmployee();

            dae.CreateEmpTable();
        }
Exemple #18
0
 public EmployeeLogic()
 {
     _daEmployee = new DAEmployee();
 }
    public static long ChangePassword(BOEmployee objBO)
    {
        DAEmployee objDA = new DAEmployee();

        return(Convert.ToInt64(objDA.ChangePassword(objBO)));
    }
    public static long InsertEmployeeDetails(BOEmployee objBO)
    {
        DAEmployee objDA = new DAEmployee();

        return(Convert.ToInt64(objDA.InsertEmployeeDetails(objBO)));
    }