public ActionResult Index(int?id) { var empHistory = from hk in db.hist_karyawan join k in db.karyawan on hk.karyawan_id equals k.karyawan_id join d in db.ref_divisi on hk.divisi_id equals d.divisi_id into divisiGroup from dg in divisiGroup.DefaultIfEmpty() join c in db.ref_cctr on hk.cctr_id equals c.cctr_id into cctrGroup from cg in cctrGroup.DefaultIfEmpty() join j in db.ref_gol_jabatan on hk.gol_jabatan_id equals j.gol_jabatan_id into jabatanGroup from jg in jabatanGroup.DefaultIfEmpty() join lj in db.ref_lvl_jabatan on hk.lvl_jabatan_id equals lj.lvl_jabatan_id into lvlJabatanGroup from ljg in lvlJabatanGroup.DefaultIfEmpty() join sj in db.ref_sub_lvl_jabatan on hk.sub_lvl_jabatan_id equals sj.sub_lvl_jabatan_id into sublvlJabatanGroup from sjg in sublvlJabatanGroup.DefaultIfEmpty() join sk in db.ref_status_karyawan on hk.status_karyawan_id equals sk.status_karyawan_id into statusGroup from skg in statusGroup.DefaultIfEmpty() join lk in db.ref_lokasi_kerja on hk.lokasi_kerja_id equals lk.lokasi_kerja_id into lokasiGroup from lg in lokasiGroup.DefaultIfEmpty() where k.karyawan_id == 16 select new EmployeeHistoryViewModel { hist_karyawan_id = hk.hist_karyawan_id, divisi = (divisiGroup.Select(s => s.nama_divisi).FirstOrDefault() == null ? string.Empty : divisiGroup.Select(s => s.nama_divisi).FirstOrDefault()), cctr = (cctrGroup.Select(s => s.cctr).FirstOrDefault() == null ? string.Empty : cctrGroup.Select(s => s.cctr).FirstOrDefault()), jabatan = (jabatanGroup.Select(s => s.nama_jabatan).FirstOrDefault() == null ? string.Empty : jabatanGroup.Select(s => s.nama_jabatan).FirstOrDefault()), lvl_jabatan = (lvlJabatanGroup.Select(s => s.lvl_jabatan).FirstOrDefault() == null ? string.Empty : lvlJabatanGroup.Select(s => s.lvl_jabatan).FirstOrDefault()), sub_lvl_jabatan = (sublvlJabatanGroup.Select(s => s.sub_lvl_jabatan).FirstOrDefault() == null ? "\0" : sublvlJabatanGroup.Select(s => s.sub_lvl_jabatan).FirstOrDefault()), status_karyawan = (statusGroup.Select(s => s.status_karyawan).FirstOrDefault() == null ? string.Empty : statusGroup.Select(s => s.status_karyawan).FirstOrDefault()), lokasi_kerja = (lokasiGroup.Select(s => s.nama_lokasi).FirstOrDefault() == null ? string.Empty : lokasiGroup.Select(s => s.nama_lokasi).FirstOrDefault()), tgl_mulai = hk.tgl_mulai, tgl_selesai = hk.tgl_selesai, keterangan = hk.keterangan }; ViewBag.CCTR = helper.GetDropDownList("cctr"); ViewBag.Divisi = helper.GetDropDownList("divisi"); ViewBag.Jabatan = helper.GetDropDownList("jabatan"); ViewBag.LvlJabatan = helper.GetDropDownList("lvljabatan"); ViewBag.Lokasi = helper.GetDropDownList("lokasi"); ViewBag.Status = helper.GetDropDownList("status"); ViewBag.SubLvlJabatan = helper.GetDropDownList("sublvljabatan"); return(View(empHistory.ToList())); }
public ActionResult Create() { ViewBag.CCTR = helper.GetDropDownList("cctr"); ViewBag.Divisi = helper.GetDropDownList("divisi"); ViewBag.Jabatan = helper.GetDropDownList("jabatan"); ViewBag.LvlJabatan = helper.GetDropDownList("lvljabatan"); ViewBag.Lokasi = helper.GetDropDownList("lokasi"); ViewBag.Status = helper.GetDropDownList("status"); ViewBag.SubLvlJabatan = helper.GetDropDownList("sublvljabatan"); return(View()); }