public void del_positon(string id)
{
positionModel ps = new positionModel();
ps.ps_id = id;
ps.del_position();
}
public string view_position(string id)
{
positionModel ps = new positionModel();
ps.select_position("ps_id = '" + id + "'");
return(ps.ps_code + "^" + ps.ps_name);
}
public IActionResult position()
{
positionModel ps = new positionModel();
ViewData["position"] = ps.list_position();
return(View());
}
public IActionResult insert_position(string ps_code, string ps_name)
{
positionModel ps = new positionModel();
ps.ps_code = ps_code;
ps.ps_name = ps_name;
ps.insert_position();
return(RedirectToAction("position", "Information"));
}
public IActionResult edit_position(string ps_code_edit, string ps_name_edit, string ps_id)
{
positionModel ps = new positionModel();
ps.ps_code = ps_code_edit;
ps.ps_name = ps_name_edit;
ps.ps_id = ps_id;
ps.update_position();
return(RedirectToAction("position", "Information"));
}
public IActionResult viewEmployee(string id)
{
employeeModel emp = new employeeModel();
prefixModel px = new prefixModel();
provinceModel pv = new provinceModel();
ampuresModel am = new ampuresModel();
districts dt = new districts();
positionModel ps = new positionModel();
emp.select_emp("emp_id = '" + id + "'");
ViewData["emp_code"] = emp.emp_code;
ViewData["emp_prefix"] = px.drop_prefix(emp.emp_prefix);
ViewData["emp_name"] = emp.emp_name;
ViewData["emp_lastname"] = emp.emp_lastname;
ViewData["emp_position"] = ps.drop_position(emp.emp_position);
ViewData["emp_address"] = emp.emp_address;
ViewData["emp_road"] = emp.emp_road;
ViewData["emp_province"] = pv.drop_province(emp.emp_province);
ViewData["emp_amphur"] = am.dorp_amphur(emp.emp_amphur);
ViewData["emp_district"] = dt.drop_district(emp.emp_district);
ViewData["emp_postcode"] = emp.emp_postcode;
ViewData["emp_tel"] = emp.emp_tel;
ViewData["emp_fax"] = emp.emp_fax;
ViewData["emp_email"] = emp.emp_email;
ViewData["emp_national_id"] = emp.emp_national_id;
ViewData["emp_gender"] = emp.emp_gender;
ViewData["emp_tax"] = emp.emp_tax;
ViewData["emp_birth"] = emp.emp_birthday;
ViewData["emp_start"] = emp.emp_start_date;
ViewData["emp_end"] = emp.emp_end_date;
ViewData["emp_id"] = id;
if (string.IsNullOrEmpty(emp.emp_img) == true)
{
ViewData["emp_img"] = "nopicture.jpg";
}
else
{
ViewData["emp_img"] = emp.emp_img;
}
return(View());
}
public IActionResult addEmployee()
{
provinceModel pv = new provinceModel();
ViewData["province"] = pv.drop_province("1");
ampuresModel am = new ampuresModel();
ViewData["amphur"] = am.dorp_amphur("1");
districts dt = new districts();
ViewData["district"] = dt.drop_district("1");
positionModel pt = new positionModel();
ViewData["position_list"] = pt.drop_position();
prefixModel px = new prefixModel();
ViewData["prefix"] = px.drop_prefix("");
return(View());
}
