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