public IActionResult addCustomer()
{
customerTypeModel ct = new customerTypeModel();
ViewData["cus_type"] = ct.drop_cus_type_code();
prefixModel px = new prefixModel();
ViewData["prefix"] = px.drop_prefix("");
provinceModel pv = new provinceModel();
ampuresModel am = new ampuresModel();
districts dt = new districts();
ViewData["province"] = pv.drop_province("");
ViewData["amphur"] = am.dorp_amphur("");
ViewData["district"] = dt.drop_district("");
conditionPayModel cd = new conditionPayModel();
ViewData["condition"] = cd.drop_con_pay("");
lineModel ln = new lineModel();
ViewData["line"] = ln.drop_line("");
line_saleModel ls = new line_saleModel();
ViewData["line_sale"] = ls.drop_line_sale("");
return(View());
}
// GET: /<controller>/
public IActionResult Index()
{
CompanyModel cp = new CompanyModel();
ampuresModel ap = new ampuresModel();
districts dt = new districts();
provinceModel pv = new provinceModel();
cp.select_comp();
ViewData["comp_address"] = cp.comp_address;
ViewData["comp_amphur"] = ap.dorp_amphur(cp.comp_amphur);
ViewData["comp_create_admin_id"] = cp.comp_create_admin_id;
ViewData["comp_create_date"] = cp.comp_create_date;
ViewData["comp_district"] = dt.drop_district(cp.comp_district);
ViewData["comp_edit_date"] = cp.comp_edit_date;
ViewData["comp_email"] = cp.comp_email;
ViewData["comp_fax"] = cp.comp_fax;
ViewData["comp_name"] = cp.comp_name;
ViewData["comp_name_en"] = cp.comp_name_en;
ViewData["comp_postcode"] = cp.comp_postcode;
ViewData["comp_province"] = pv.drop_province(cp.comp_province);
ViewData["comp_road"] = cp.comp_road;
ViewData["comp_tax"] = cp.comp_tax;
ViewData["comp_tel"] = cp.comp_tel;
ViewData["comp_trade"] = cp.comp_trade;
ViewData["comp_web"] = cp.comp_web;
ViewData["comp_edit_admin_id"] = cp.comp_edit_admin_id;
return(View());
}
public IActionResult province()
{
provinceModel pv = new provinceModel();
ViewData["province"] = pv.list_province();
return(View());
}
public void selectFamily(string person)
{
personal_familyModel fm = new personal_familyModel();
districtModel dis = new districtModel();
amphurModel amp = new amphurModel();
provinceModel prov = new provinceModel();
fm.selectFamilyPerson(person);
ViewData["d_name"] = fm.fam_name_dad;
ViewData["d_last"] = fm.fam_lastname_dad;
ViewData["d_age"] = fm.fam_age_dad;
ViewData["d_num"] = fm.fam_num_dad;
ViewData["d_moo"] = fm.fam_moo_dad;
ViewData["d_province"] = prov.selectProvince_forEdit(fm.fam_province_dad);
ViewData["d_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_dad);
ViewData["d_district"] = dis.select_district_forEdit(fm.fam_district_dad);
ViewData["d_postcode"] = fm.fam_postcode_dad;
ViewData["d_tel"] = fm.fam_tel_dad;
ViewData["d_mobile"] = fm.fam_mobile_dad;
ViewData["d_province_name"] = fm.province_name_dad;
ViewData["d_amphur_name"] = fm.amphur_name_dad;
ViewData["d_district_name"] = fm.district_name_dad;
ViewData["m_name"] = fm.fam_name_mom;
ViewData["m_last"] = fm.fam_lastname_mom;
ViewData["m_age"] = fm.fam_age_mom;
ViewData["m_num"] = fm.fam_num_mom;
ViewData["m_moo"] = fm.fam_moo_mom;
ViewData["m_province"] = prov.selectProvince_forEdit(fm.fam_province_mom);
ViewData["m_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_mom);
ViewData["m_district"] = dis.select_district_forEdit(fm.fam_district_mom);
ViewData["m_postcode"] = fm.fam_postcode_mom;
ViewData["m_tel"] = fm.fam_tel_mom;
ViewData["m_mobile"] = fm.fam_mobile_mom;
ViewData["m_province_name"] = fm.province_name_mom;
ViewData["m_amphur_name"] = fm.amphur_name_mom;
ViewData["m_district_name"] = fm.district_name_mom;
ViewData["h_name"] = fm.fam_name_marry;
ViewData["h_last"] = fm.fam_lastname_marry;
ViewData["h_age"] = fm.fam_age_marry;
ViewData["h_num"] = fm.fam_num_marry;
ViewData["h_moo"] = fm.fam_moo_marry;
ViewData["h_province"] = prov.selectProvince_forEdit(fm.fam_province_marry);
ViewData["h_amphur"] = amp.select_amphur_forEdit(fm.fam_amphur_marry);
ViewData["h_district"] = dis.select_district_forEdit(fm.fam_district_marry);
ViewData["h_postcode"] = fm.fam_postcode_marry;
ViewData["h_tel"] = fm.fam_tel_marry;
ViewData["h_mobile"] = fm.fam_mobile_marry;
ViewData["h_province_name"] = fm.province_name_marry;
ViewData["h_amphur_name"] = fm.amphur_name_marry;
ViewData["h_district_name"] = fm.district_name_marry;
}
public IActionResult editAgent(string id)
{
SuplierModel sp = new SuplierModel();
sp.select_suplier("sup_id = '" + id + "'");
ViewData["sup_id"] = id;
ViewData["sup_code"] = sp.sup_code;
ViewData["sup_name"] = sp.sup_name;
ViewData["sup_name_contact"] = sp.sup_name_contact;
ViewData["sup_tel"] = sp.sup_tel;
ViewData["sup_fax"] = sp.sup_fax;
ViewData["sup_email"] = sp.sup_email;
ViewData["sup_web"] = sp.sup_web;
ViewData["sup_trade"] = sp.sup_trade;
ViewData["sup_tax"] = sp.sup_tax;
ViewData["sup_num"] = sp.sup_num;
ViewData["sup_road"] = sp.sup_road;
ViewData["sup_postcode"] = sp.sup_postcode;
ViewData["sup_credit_money"] = sp.sup_credit_money;
ViewData["sup_credit"] = sp.credit_name;
ViewData["sup_distict"] = sp.district_name;
ViewData["sup_amphur"] = sp.amphur_name;
ViewData["sup_province"] = sp.province_name;
ViewData["sup_prefix"] = sp.prefix_name;
ViewData["sup_prefix_end"] = sp.prefix_end;
conditionPayModel cd = new conditionPayModel();
ViewData["credit"] = cd.drop_con_pay(sp.sup_credit_id);
prefixModel px = new prefixModel();
ViewData["prefix"] = px.drop_prefix(sp.sup_prefix_id);
districts dt = new districts();
ViewData["distict"] = dt.drop_district(sp.sup_district);
ampuresModel am = new ampuresModel();
ViewData["amphur"] = am.dorp_amphur(sp.sup_amphur);
provinceModel pv = new provinceModel();
ViewData["province"] = pv.drop_province(sp.sup_province);
return(View());
}
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());
}
public IActionResult addPersonal()
{
info_prefixModels prefix = new info_prefixModels();
ViewData["prefix_th"] = prefix.select_prefixTH();
ViewData["prefix_en"] = prefix.select_prefixEN();
provinceModel province = new provinceModel();
ViewData["province"] = province.selectProvince();
amphurModel amphur = new amphurModel();
ViewData["amphur"] = amphur.select_amphur();
districtModel district = new districtModel();
ViewData["district"] = district.select_district();
return(View());
}
public void selectAddressPerson(string person)
{
AddressModel add = new AddressModel();
districtModel dis = new districtModel();
amphurModel amp = new amphurModel();
provinceModel prov = new provinceModel();
add.selectAddressPerson(person);
ViewData["add_num"] = add.address_num;
ViewData["add_moo"] = add.address_moo;
ViewData["add_type"] = add.address_type;
ViewData["add_type_name"] = add.address_type_name;
ViewData["add_name"] = add.address_name;
ViewData["add_alley"] = add.address_alley;
ViewData["add_road"] = add.address_road;
ViewData["add_district"] = dis.select_district_forEdit(add.address_district_id);
ViewData["add_district_name"] = add.address_district_name;
ViewData["add_amphur"] = amp.select_amphur_forEdit(add.address_amphur_id);
ViewData["add_amphur_name"] = add.address_amphur_name;
ViewData["add_province"] = prov.selectProvince_forEdit(add.address_province_id);
ViewData["add_province_name"] = add.address_province_name;
ViewData["add_postcode"] = add.address_postcode;
ViewData["call_num"] = add.address_num_call;
ViewData["call_moo"] = add.address_moo_call;
ViewData["call_type"] = add.address_type_call;
ViewData["call_type_name"] = add.address_type_name_call;
ViewData["call_name"] = add.address_name_call;
ViewData["call_alley"] = add.address_alley_call;
ViewData["call_road"] = add.address_road_call;
ViewData["call_district"] = dis.select_district_forEdit(add.address_district_id_call);
ViewData["call_district_name"] = add.address_district_name_call;
ViewData["call_amphur"] = amp.select_amphur_forEdit(add.address_amphur_id_call);
ViewData["call_amphur_name"] = add.address_amphur_name_call;
ViewData["call_province"] = prov.selectProvince_forEdit(add.address_province_id_call);
ViewData["call_province_name"] = add.address_province_name_call;
ViewData["call_postcode"] = add.address_postcode_call;
}
public IActionResult addAgent()
{
conditionPayModel cd = new conditionPayModel();
ViewData["credit"] = cd.drop_con_pay("");
prefixModel px = new prefixModel();
ViewData["prefix"] = px.drop_prefix("");
districts dt = new districts();
ViewData["distict"] = dt.drop_district("");
ampuresModel am = new ampuresModel();
ViewData["amphur"] = am.dorp_amphur("");
provinceModel pv = new provinceModel();
ViewData["province"] = pv.drop_province("");
return(View());
}
public void province()
{
provinceModel province = new provinceModel();
ViewData["province"] = province.selectProvince();
}
public IActionResult emp(string code, string txt)
{
code_test = code;
personalModel ps = new personalModel();
ViewData["person_edit"] = ps.personal_for_edit();
info_positionModel posi = new info_positionModel();
companyModel comp = new companyModel();
sectionModel sect = new sectionModel();
departmentModel dep = new departmentModel();
emp_typeModel type = new emp_typeModel();
ViewData["position_dropdown"] = posi.dropDownPosition();
ViewData["company"] = comp.drop_company();
ViewData["section"] = sect.drop_section();
ViewData["department"] = dep.drop_dep();
ViewData["type"] = type.dropdown_type();
info_prefixModels prefix = new info_prefixModels();
info_statusModel status = new info_statusModel();
personal_studyModel study = new personal_studyModel();
ViewData["prefix_th"] = prefix.select_prefixTH();
ViewData["prefix_en"] = prefix.select_prefixEN();
ViewData["type_emp"] = type.dropdown_type();
ViewData["status"] = status.dropdown_status();
//view employee//
view_employeeModel emp = new view_employeeModel();
emp.selectData(code);
ViewData["emp_id"] = code;
ViewData["emp_code"] = emp.ep_code;
ViewData["emp_name_th"] = emp.prefix_name_en + " " + emp.ps_name_th + " " + emp.ps_lastname_th;
ViewData["emp_name_en"] = emp.prefix_name_en + " " + emp.ps_name_en + " " + emp.ps_lastname_en;
ViewData["emp_type"] = emp.type_name;
ViewData["emp_status"] = emp.ep_status;
ViewData["emp_start_date"] = emp.ep_start;
ViewData["emp_end_date"] = emp.ep_end;
ViewData["emp_email"] = emp.contact_email;
ViewData["emp_table"] = emp.contact_table;
ViewData["emp_phone"] = emp.contact_phone;
ViewData["emp_mobile1"] = emp.contact_mobile1;
ViewData["emp_mobile2"] = emp.contact_mobile2;
ViewData["position_name"] = emp.post_name;
ViewData["position_type"] = emp.type_name;
ViewData["position_dept"] = emp.dept_name;
ViewData["position_sect"] = emp.Section_name;
ViewData["position_comp"] = emp.T_Company;
ViewData["gender"] = emp.ps_gender;
ViewData["age"] = Convert.ToInt32((DateTime.Now.Year)) - Convert.ToInt32((Convert.ToDateTime(emp.ps_birthday).Year));
ViewData["nationality"] = emp.ps_nationality;
ViewData["race"] = emp.ps_race;
ViewData["religion"] = emp.ps_religion;
ViewData["blood"] = emp.ps_blood;
ViewData["birthday"] = Convert.ToDateTime(emp.ps_birthday).ToString("dd MMMM yyyy");
ViewData["birthday_format"] = Convert.ToDateTime(emp.ps_birthday).ToString("dd/MM/yyyy");
ViewData["identification"] = emp.ps_national_id;
ViewData["date_issue"] = emp.ps_national_date_start;
ViewData["expired_date"] = emp.ps_national_date_end;
ViewData["marital"] = emp.ps_status_marital;
ViewData["emp_person_id"] = emp.ep_ref_personal_id;
ViewData["type_"] = type.dropdown_type_id(emp.ep_ref_type_id);
emp_positionModel posit = new emp_positionModel();
ViewData["position"] = posit.emp_position_list(code);
//
/// address
dataAddress(code);
///
// study
ViewData["data_study"] = study.tb_study(code);
//
// work
personal_workModel work = new personal_workModel();
ViewData["data_work"] = work.tb_work(code);
//
// train
personal_trainModel train = new personal_trainModel();
ViewData["data_train"] = train.tb_train(code);
//
// family
personal_familyModel fam = new personal_familyModel();
fam.get_family(code);
ViewData["dad_name"] = fam.fam_name_dad + " " + fam.fam_lastname_dad;
ViewData["dad_age"] = fam.fam_age_dad;
ViewData["dad_tel"] = fam.fam_tel_dad;
ViewData["dad_mobile"] = fam.fam_mobile_dad;
ViewData["dad_address"] = fam.fam_num_dad + " หมู่ " + fam.fam_moo_dad + " " + fam.fam_district_dad + ", " + fam.fam_amphur_dad + ", " + fam.fam_province_dad + " " + fam.fam_postcode_dad;
ViewData["mom_name"] = fam.fam_name_mom + " " + fam.fam_lastname_mom;
ViewData["mom_age"] = fam.fam_age_mom;
ViewData["mom_tel"] = fam.fam_tel_mom;
ViewData["mom_mobile"] = fam.fam_mobile_mom;
ViewData["mom_address"] = fam.fam_num_mom + " หมู่ " + fam.fam_moo_mom + " " + fam.fam_district_mom + ", " + fam.fam_amphur_mom + ", " + fam.fam_province_mom + " " + fam.fam_postcode_mom;
ViewData["marry_name"] = fam.fam_name_marry + " " + fam.fam_lastname_marry;
ViewData["marry_age"] = fam.fam_age_marry;
ViewData["marry_tel"] = fam.fam_tel_marry;
ViewData["marry_mobile"] = fam.fam_mobile_marry;
ViewData["marry_address"] = fam.fam_num_marry + " หมู่ " + fam.fam_moo_marry + " " + fam.fam_district_marry + ", " + fam.fam_amphur_marry + ", " + fam.fam_province_marry + " " + fam.fam_postcode_marry;
//
// child
personal_kidModel child = new personal_kidModel();
ViewData["data_child"] = child.tb_kid(code);
//
/// income
checkPay(code);
select_income();
///
/// minus
minus();
minusSalary(code);
///
/// fund
fund(code);
empFundResign fn = new empFundResign();
empFundChange fc = new empFundChange();
ViewData["fundResign"] = fn.list_fundResignEmp(code);
ViewData["fundChange"] = fc.list_fundChange_emp(code);
///
/// commend
commend(code);
///
/// admonish
admonish(code);
///
////
provinceModel province = new provinceModel();
ViewData["province"] = province.selectProvince();
amphurModel amphur = new amphurModel();
ViewData["amphur"] = amphur.select_amphur();
districtModel district = new districtModel();
ViewData["district"] = district.select_district();
//profile img
empModel em = new empModel();
em.check_img(code);
if (string.IsNullOrEmpty(em.img_name) == true)
{
ViewData["profile_img"] = "../../profile/face-2.jpg";
}
else
{
ViewData["profile_img"] = "../../profile/" + em.img_name;
}
empPositionChangeModel pc = new empPositionChangeModel();
pc.pc_emp_id = code;
ViewData["data_change_position"] = pc.list_posiotnChane_emp_id();
EmpPositionResignModel rs = new EmpPositionResignModel();
ViewData["data_resign_position"] = rs.list_position_resign_emp(code);
return(View());
}
public IActionResult editcustomer(string cus)
{
ViewData["cus_id"] = cus;
CustomerModel ctm = new CustomerModel();
ctm.select_customer(" cus_id = '" + cus + "'");
ViewData["cus_code"] = ctm.cus_code;
ViewData["cus_name"] = ctm.cus_name;
ViewData["cus_name_contact"] = ctm.cus_name_contact;
ViewData["cus_trade"] = ctm.cus_trade;
ViewData["cus_tax"] = ctm.cus_tax;
customerTypeModel ct = new customerTypeModel();
ViewData["cus_type"] = ct.drop_cus_type_code(ctm.cus_ref_type_id);
prefixModel px = new prefixModel();
ViewData["prefix"] = px.drop_prefix(ctm.cus_ref_prefix_id);
px.select_prefix("prefix_id = '" + ctm.cus_ref_prefix_id + "'");
ViewData["last_name"] = px.prefix_ending;
CustomerAddressModel ca = new CustomerAddressModel();
ca.select_address("add_ref_cus_id = '" + cus + "'");
ViewData["add_num"] = ca.add_num;
ViewData["add_alley"] = ca.add_alley;
ViewData["add_road"] = ca.add_road;
ViewData["add_postcode"] = ca.add_poscode;
ViewData["add_status"] = ca.add_type_status;
ViewData["add_branch"] = ca.add_branch;
ViewData["add_id"] = ca.add_id;
provinceModel pv = new provinceModel();
ampuresModel am = new ampuresModel();
districts dt = new districts();
ViewData["province"] = pv.drop_province(ca.add_province);
ViewData["amphur"] = am.dorp_amphur(ca.add_amphur);
ViewData["district"] = dt.drop_district(ca.add_district);
CustomerContactModel c_t = new CustomerContactModel();
c_t.select_contact("ct_ref_cus_id = '" + cus + "'");
ViewData["ct_tel"] = c_t.ct_tel;
ViewData["ct_fax"] = c_t.ct_fax;
ViewData["ct_email"] = c_t.ct_email;
ViewData["ct_web"] = c_t.ct_web;
ViewData["ct_id"] = c_t.ct_id;
CustomerCreditModel crd = new CustomerCreditModel();
crd.select_credit("credit_ref_cus_id = '" + cus + "'");
ViewData["credit_money"] = crd.credit_money;
ViewData["credit_id"] = crd.credit_id;
conditionPayModel cd = new conditionPayModel();
ViewData["condition"] = cd.drop_con_pay(crd.credit_ref_condition);
CustomerLineSaleModel cl = new CustomerLineSaleModel();
cl.select_cus_line("cs_ref_cus_id = '" + cus + "'");
ViewData["sale_name"] = cl.cs_sale_name;
ViewData["sale_id"] = cl.cs_id;
lineModel ln = new lineModel();
ViewData["line"] = ln.drop_line(cl.cs_ref_line_id);
line_saleModel ls = new line_saleModel();
ViewData["line_sale"] = ls.drop_line_sale("");
CustomerTransportModel ts = new CustomerTransportModel();
ts.select_cus_tran("at_ref_cus_id = '" + cus + "'");
ViewData["name_ts"] = ts.at_customer_name;
ViewData["num_ts"] = ts.at_num;
ViewData["alley_ts"] = ts.at_alley;
ViewData["road_ts"] = ts.at_road;
ViewData["postcode_ts"] = ts.at_postcode;
ViewData["province_ts"] = pv.drop_province(ts.at_province);
ViewData["amphur_ts"] = am.dorp_amphur(ts.at_amphur);
ViewData["district_ts"] = dt.drop_district(ts.at_district);
ViewData["ts_id"] = ts.at_id;
return(View());
}
