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));
}
