public List <FullEmployee> GetAllFullEmployee() { var Db = new ApricotContext(); List <FullEmployee> myfullemployees = new List <FullEmployee>(0); EmployeeRepository employeeRepo = new EmployeeRepository(Db); EmployeeDetailRepository employeeDetailRepo = new EmployeeDetailRepository(Db); List <Employee> employees = employeeRepo.GetAll().ToList(); foreach (var employee in employees) { Employee_Detail employeeDetail = employeeDetailRepo.GetByEmpID(employee.Emp_ID); FullEmployee fullemp = new FullEmployee(); if (employeeDetail != null) { fullemp.Emp_ID = employee.Emp_ID; fullemp.Emp_Name = employee.Emp_Name; fullemp.Emp_No = employee.Emp_No; fullemp.Department = _context.Departments.Find(employee.Dept_ID); fullemp.Is_Active = employee.Is_Active; fullemp.Emp_Address = employeeDetail.Emp_Address; fullemp.Emp_Contact_No = employeeDetail.Emp_Contact_No; fullemp.Emp_Gender = employeeDetail.Emp_Gender; } myfullemployees.Add(fullemp); } return(myfullemployees); }
public void EditFullEmployee(FullEmployee model) { EmployeeRepository employeeRepo = new EmployeeRepository(_context); Employee employee = employeeRepo.GetByEmpID(model.Emp_ID); if (employee != null) { employee.Emp_ID = model.Emp_ID; employee.Emp_Name = model.Emp_Name; employee.Emp_No = model.Emp_No; employee.Dept_ID = Convert.ToInt64(model.Department.Dept_Name.Split('-')[0]); employee.Is_Active = model.Is_Active; employeeRepo.UpdateEmployee(employee); EmployeeDetailRepository employeeDetailRepo = new EmployeeDetailRepository(_context); Employee_Detail employeeDetail = employeeDetailRepo.GetByEmpID(employee.Emp_ID); employeeDetail.Emp_Address = model.Emp_Address; employeeDetail.Emp_Contact_No = model.Emp_Contact_No; employeeDetail.Emp_Gender = model.Emp_Gender; employeeDetailRepo.UpdateEmployeeDetail(employeeDetail); } }
public FullEmployee GetFullEmployeeByEmpNumber(Int64 id) { var Db = new ApricotContext(); FullEmployee fullEmployee = new FullEmployee(); EmployeeRepository employeeRepo = new EmployeeRepository(Db); EmployeeDetailRepository employeeDetailRepo = new EmployeeDetailRepository(Db); DepartmentRepository departmentRepo = new DepartmentRepository(Db); Employee employee = employeeRepo.GetByEmpID(id); Employee_Detail employeeDetail = employeeDetailRepo.GetByEmpID(id); Department department = departmentRepo.GetByDepartmentID(employee.Dept_ID); if (employee != null && employeeDetail != null) { fullEmployee.Emp_ID = employee.Emp_ID; fullEmployee.Emp_No = employee.Emp_No; fullEmployee.Emp_Name = employee.Emp_Name; fullEmployee.Is_Active = employee.Is_Active; fullEmployee.Department = _context.Departments.Find(employee.Dept_ID); fullEmployee.Emp_Address = employeeDetail.Emp_Address; fullEmployee.Emp_Contact_No = employeeDetail.Emp_Contact_No; fullEmployee.Emp_Gender = employeeDetail.Emp_Gender; } return(fullEmployee); }
/// <summary> /// Получает весь список сотрудников в сокращенном виде /// </summary> /// <returns></returns> public List <FullEmployee> GetAllFullEmployees() { using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.ConnectionString(connectionStringName))) { List <FullEmployee> listOfModels = new List <FullEmployee>(); SqlCommand cmd = new SqlCommand("SELECT * FROM FullEmployee", connection as SqlConnection); cmd.CommandType = CommandType.Text; connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var t = reader["DateOfBirth"].ToString(); DateTime.Parse(reader["DateOfBirth"].ToString()); var e = new FullEmployee( (int)reader["EmployeeId"], reader["FirstName"].ToString(), reader["MiddleName"].ToString(), reader["LastName"].ToString(), (DateTime)reader["DateOfBirth"], reader["FullAddress"].ToString(), reader["Department"].ToString(), reader["About"].ToString()); listOfModels.Add(e); } } return(listOfModels); } }
public ActionResult Create(FullEmployee model) { if (ModelState.IsValid) { var Db = new ApricotContext(); FillFullEmployee Fillfemp = new FillFullEmployee(Db); Fillfemp.CreateFullEmployee(model); return(RedirectToAction("index")); } return(View(model)); }
public ActionResult Edit(FullEmployee model) { if (ModelState.IsValid) { var Db = new ApricotContext(); FillFullEmployee Fillfemp = new FillFullEmployee(Db); Fillfemp.EditFullEmployee(model); return(RedirectToAction("Index", "ManageEmployee")); } return(View(model)); }
public ActionResult Create() { var Db = new ApricotContext(); FullEmployee femp = new FullEmployee(); List <Department> departments = new List <Department>(); //Get All Departments DepartmentRepository departmentRepo = new DepartmentRepository(Db); departments = departmentRepo.GetAll().ToList(); var departmentList = new List <String>(0); foreach (var department in departments) { departmentList.Add(department.Dept_ID.ToString() + " - " + department.Dept_Name); } ViewBag.DepartmentList = departmentList; return(View(femp)); }
public void CreateFullEmployee(FullEmployee model) { Employee employee = new Employee(); EmployeeRepository employeeRepo = new EmployeeRepository(_context); employee.Emp_ID = model.Emp_ID; employee.Emp_Name = model.Emp_Name; employee.Emp_No = model.Emp_No; employee.Dept_ID = Convert.ToInt64(model.Department.Dept_Name.Split('-')[0]); employee.Is_Active = model.Is_Active; employeeRepo.AddEmployee(employee); EmployeeDetailRepository employeeDetailRepo = new EmployeeDetailRepository(_context); Employee_Detail employeeDetail = new Employee_Detail() { Emp_ID = employee.Emp_ID, Emp_Address = model.Emp_Address, Emp_Contact_No = model.Emp_Contact_No, Emp_Gender = model.Emp_Gender }; employeeDetailRepo.AddEmployeeDetail(employeeDetail); }
public ActionResult Edit(Int64 id) { var Db = new ApricotContext(); FillFullEmployee fillFullEmployee = new FillFullEmployee(Db); FullEmployee fullEmployee = new FullEmployee(); fullEmployee = fillFullEmployee.GetFullEmployeeByEmpNumber(id); List <Department> departments = new List <Department>(); //Get All Departments DepartmentRepository departmentRepo = new DepartmentRepository(Db); departments = departmentRepo.GetAll().ToList(); var departmentList = new List <String>(0); foreach (var department in departments) { departmentList.Add(department.Dept_ID.ToString() + " - " + department.Dept_Name); } ViewBag.DepartmentList = departmentList; return(View(fullEmployee)); }