public ActionResult GetResultData(string search, string airline, string nomorPenerbangan, string kotaAsal, string kotaTujuan, string waktuBerangkat, string penumpangSakit) { var dc = new PinereDataContext(PinereConstant.PinereConnectionString); List <SearchResult> ResultList = new List <SearchResult>(); try { if (search == "True") { var Result = (from a in dc.GetDataAirlineList() select a); if (!airline.IsNullOrEmpty()) { Result = Result.Where(o => o.Nama_Airline.Value.ToString() == airline); } if (!nomorPenerbangan.IsNullOrEmpty()) { Result = Result.Where(o => o.Nomor_Penerbangan.Contains(nomorPenerbangan)); } if (!kotaAsal.IsNullOrEmpty()) { Result = Result.Where(o => o.Kota_Asal == kotaAsal); } if (!kotaTujuan.IsNullOrEmpty()) { Result = Result.Where(o => o.Kota_Tujuan == kotaTujuan); } if (!waktuBerangkat.IsNullOrEmpty()) { Result = Result.Where(o => DataRepository.GetDateStringFromDate(o.Waktu_Berangkat) == waktuBerangkat); } if (!penumpangSakit.IsNullOrEmpty()) { Result = Result.Where(o => o.Penumpang_Sakit.Value.ToString() == penumpangSakit); } Result = Result.OrderByDescending(o => o.CreatedDate); ResultList = (from a in Result select new SearchResult { NamaAirline = a.Nama_Airline_Dis, NomorPenerbangan = a.Nomor_Penerbangan, WaktuBerangkat = DataRepository.GetDateStringFromDate(a.Waktu_Berangkat), KotaAsal = a.Kota_Asal_Dis, KotaTujuan = a.Kota_Tujuan_Dis, PenumpangSakit = a.Penumpang_Sakit_Dis, ActionEdit = Url.Action("Edit", new { @DataAirlineId = a.ID }) }).ToList(); } } catch (Exception e) { throw new Exception(e.Message); } return(Json(new { iTotalRecords = ResultList.Count(), iTotalDisplayRecords = ResultList.Count(), aaData = ResultList }, JsonRequestBehavior.AllowGet)); }