public IActionResult getListTerminalAvailable(ParamTerminal data) { MonTerminalAvailableDL dal = new MonTerminalAvailableDL(); MonTerminalAvailableModel hasil = new MonTerminalAvailableModel(); /** * This params is for pagination function */ if (!string.IsNullOrEmpty(data.limit) && data.limit != "string" && !string.IsNullOrEmpty(data.page) && data.page != "string") { data.page = data.page; data.limit = data.limit; } else if (!string.IsNullOrEmpty(data.page) && data.page != "string" && string.IsNullOrEmpty(data.limit) && data.limit != "string") { data.page = data.page; data.limit = "10"; } else if (!string.IsNullOrEmpty(data.limit) && data.limit != "string" && string.IsNullOrEmpty(data.page) && data.page != "string") { data.page = "1"; data.limit = data.limit; } else { data.page = "1"; data.limit = "10"; } IEnumerable <TerminalAvailable> result = dal.getDataTerminalAvailabe(data); hasil.message = "Success"; hasil.status = "S"; hasil.count = result.Cast <Object>().Count(); hasil.data = new PagedList <TerminalAvailable>(result.ToList(), Convert.ToInt32(data.page), Convert.ToInt32(data.limit)); return(Ok(hasil)); }
public IEnumerable <TerminalAvailable> getDataTerminalAvailabe(ParamTerminal paramTerminal) { IEnumerable <TerminalAvailable> result = null; using (IDbConnection connection = Extension.GetConnection(1)) { try { /* string fnoPermohonan = ""; * if (!string.IsNullOrEmpty(NoPermohonan) && NoPermohonan != "7") * { * fnoPermohonan = " AND A.NO_PERMOHONAN='" + NoPermohonan + "' "; * } * * * */ string paramKodeRegional = ""; if (!string.IsNullOrEmpty(paramTerminal.kd_regional) && paramTerminal.kd_regional != "string") { paramKodeRegional = " WHERE KD_REGIONAL ='" + paramTerminal.kd_regional + "'"; } string paramKdCabangInduk = ""; if (!string.IsNullOrEmpty(paramTerminal.kd_cabang_induk) && paramTerminal.kd_cabang_induk != "string") { paramKdCabangInduk = " AND KD_CABANG_INDUK='" + paramTerminal.kd_cabang_induk + "'"; } string paramKdCabang = ""; if (!string.IsNullOrEmpty(paramTerminal.kd_cabang) && paramTerminal.kd_cabang != "string") { paramKdCabang = " AND KD_CABANG='" + paramTerminal.kd_cabang + "'"; } string paramKdTerminal = ""; if (!string.IsNullOrEmpty(paramTerminal.kd_terminal) && paramTerminal.kd_terminal != "string") { paramKdTerminal = " AND KD_TERMINAL='" + paramTerminal.kd_terminal + "'"; } string paramStatus = ""; if (!string.IsNullOrEmpty(paramTerminal.status) && paramTerminal.status != "string") { if (!string.IsNullOrEmpty(paramTerminal.kd_regional) && paramTerminal.kd_regional != "string") { paramStatus = " AND STATUS='" + paramTerminal.status + "'"; } else { paramStatus = " WHERE STATUS='" + paramTerminal.status + "'"; } } string paramType = ""; if (!string.IsNullOrEmpty(paramTerminal.type_terminal) && paramTerminal.type_terminal != "string") { if (paramTerminal.type_terminal == "PENUMPANG") { if (!string.IsNullOrEmpty(paramTerminal.kd_regional) && paramTerminal.kd_regional != "string") { paramType = " AND JENIS_KAPAL IN ('KPLPNMPANG', 'KPLRORO', 'KPLCRUISE')"; } else { if (!string.IsNullOrEmpty(paramTerminal.status) && paramTerminal.status != "string") { paramType = " AND JENIS_KAPAL IN ('KPLPNMPANG', 'KPLRORO', 'KPLCRUISE')"; } else { paramType = " WHERE JENIS_KAPAL IN ('KPLPNMPANG', 'KPLRORO', 'KPLCRUISE')"; } } } } string paramJenisKapal = ""; if (!string.IsNullOrEmpty(paramTerminal.jenis_kapal) && paramTerminal.jenis_kapal != "string") { paramJenisKapal = " AND JENIS_KAPAL='" + paramTerminal.jenis_kapal + "'"; } string paramLokasi = ""; if (!string.IsNullOrEmpty(paramTerminal.lokasi) && paramTerminal.lokasi != "string") { paramLokasi = " AND NAMA_LOKASI='" + paramTerminal.lokasi + "'"; } string paramKegiatan = ""; if (!string.IsNullOrEmpty(paramTerminal.kegiatan) && paramTerminal.kegiatan != "string") { paramKegiatan = " AND KEGIATAN='" + paramTerminal.kegiatan + "'"; } string paramOrderby = ""; if (!string.IsNullOrEmpty(paramTerminal.order_by_column) && paramTerminal.order_by_column != "string" && !string.IsNullOrEmpty(paramTerminal.order_by_sort) && paramTerminal.order_by_sort != "string") { paramOrderby = " ORDER BY " + paramTerminal.order_by_column + " " + paramTerminal.order_by_sort; } string paramSearch = ""; if (paramTerminal.is_searching == true && !string.IsNullOrEmpty(paramTerminal.search_key) && paramTerminal.search_key != "string") { paramSearch = " WHERE NAMA_KAPAL LIKE '%" + paramTerminal.search_key + "%'"; } string paramNoPPKJasa = ""; if (!string.IsNullOrEmpty(paramTerminal.no_ppk_jasa) && paramTerminal.no_ppk_jasa != "string") { paramNoPPKJasa = " AND NO_PPK_JASA = '" + paramTerminal.no_ppk_jasa + "'"; } string sql = "SELECT * FROM(" + "SELECT * FROM (SELECT A.*, B.REGIONAL_NAMA NAMA_REGIONAL, " + "(CASE WHEN A.TGL_MULAI IS NULL AND A.TGL_SELESAI IS NULL AND A.STATUS_NOTA=0 THEN 'RENCANA' " + "WHEN A.TGL_MULAI IS NOT NULL AND A.TGL_SELESAI IS NULL AND A.STATUS_NOTA=0 THEN 'SANDAR' " + "WHEN A.TGL_MULAI IS NOT NULL AND A.TGL_SELESAI IS NOT NULL THEN 'HISTORY' END" + ") STATUS " + "FROM VW_MAGIC_TERMINAL_INFO_HOME A, APP_REGIONAL B WHERE A.KD_REGIONAL=B.ID AND B.PARENT_ID IS NULL AND B.ID NOT IN (12300000,20300001) ) " + paramKodeRegional + paramKdCabangInduk + paramKdCabang + paramKdTerminal + paramStatus + paramType + paramJenisKapal + paramLokasi + paramKegiatan + paramNoPPKJasa + paramOrderby + ") " + paramSearch; result = connection.Query <TerminalAvailable>(sql, new { KD_REGIONAL = paramTerminal.kd_regional }); } catch (Exception) { result = null; } } return(result); }