public DataTable GetEmployees(string employee_id)
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.GetEmployees(employee_id));
}
}
public EmployeeVO GetLoginEmployee(string employee_id, string employee_pwd)
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.GetLoginEmployee(employee_id, employee_pwd));
}
}
public DataTable GetAllEmployees()
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.GetAllEmployees());
}
}
public EmployeeVO GetEmployee(string employee_id)
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.GetEmployee(employee_id));
}
}
public Employee GetEmployeeById(int id)
{
var repo = new EmployeeDAC();
var emp = repo.GetById(id);
return(emp);
}
public bool DeleteEmployee(string employee_id)
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.DeleteEmployee(employee_id));
}
}
public bool SaveEmployee(EmployeeVO employeeVO)
{
using (EmployeeDAC employeeDAC = new EmployeeDAC())
{
return(employeeDAC.SaveEmployee(employeeVO));
}
}
public bool Insert(EmployeeBE emp)
{
Mapper.Initialize(cf => cf.CreateMap <EmployeeBE, Employee>());
EmployeeDAC dac = new EmployeeDAC();
dac.Insert(Mapper.Map <EmployeeBE, Employee>(emp));
return(true);
}
public ActionResult Index(EmployeeVO employeeVO)
{
EmployeeVO login = new EmployeeDAC().GetLoginEmployee(employeeVO.Employee_id, GetSHA256(employeeVO.Employee_pwd));
if (login == null)
{
ViewBag.Msg = "로그인에 실패하였습니다. ID나 비밀번호를 확인해주시길 바랍니다.";
return(View());
}
else
{
Session["login"] = login;
return(Redirect("/"));
}
}
///<summary>
///Action method which
///insert the data into database by capturing
///Model values which comes from user as input
///</summary>
public ActionResult AddNewEmployee(EmpModel Emp)
{
//To Prevent firing validation error on first page Load
if (ModelState.IsValid)
{
string constr = ConfigurationManager.ConnectionStrings["getconn"].ToString();
EmployeeDAC employeeDAC = new EmployeeDAC(constr);
int i = employeeDAC.AddNewRecord(Emp);
if (i >= 1)
{
ViewBag.Message = "New Employee Added Successfully";
}
}
ModelState.Clear();
return(View());
}
public List <EmployeeBE> Get()
{
EmployeeDAC dac = new EmployeeDAC();
//List<EmployeeBE> listbe = new List<EmployeeBE>();
//var config = new MapperConfiguration(cfg =>
//{
// cfg.CreateMap<List<Employee>, List<EmployeeBE>>();
//});
//config.AssertConfigurationIsValid();
//Mapper.Initialize(config);
Mapper.Initialize(cfg => cfg.CreateMap <Employee, EmployeeBE>());
Mapper.Configuration.AssertConfigurationIsValid();
List <EmployeeBE> listbe = Mapper.Map <List <Employee>, List <EmployeeBE> >(dac.Get());
return(listbe);
}
public List <EmployeeVO> GetAllEmployee()
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.GetAllEmployee());
}
public EmployeeVO GetEmployeeInfo(int empID)
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.GetEmployeeInfo(empID));
}
public bool RegisterEmployee(EmployeeVO vo)
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.RegisterEmployee(vo));
}
public bool DeleteEmployee(int code)
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.DeleteEmployee(code));
}
public bool UpdateEmployee(EmployeeVO item)
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.UpdateEmployee(item));
}
public bool InsertEmployee(EmployeeVO item)
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.InsertEmployee(item));
}
public List <ComboItemVO> GetComboEmployee()
{
EmployeeDAC dac = new EmployeeDAC();
return(dac.GetComboEmployee());
}
