public static DataAirline GetDataAirline(int Id)
{
DataAirline DataAirline = new DataAirline();
try
{
using (var dc = new PinereDataContext(PinereConstant.PinereConnectionString))
{
DataAirline = (from a in dc.GetDataAirline(Id)
select new DataAirline
{
Id = a.ID,
NamaAirline = a.Nama_Airline.Value.ToString(),
NamaAirlineDis = a.Nama_Airline_Dis,
NomorPenerbangan = a.Nomor_Penerbangan,
WaktuBerangkat = GetDateStringFromDate(a.Waktu_Berangkat),
KotaAsal = a.Kota_Asal,
KotaAsalDis = a.Kota_Asal_Dis,
KotaTujuan = a.Kota_Tujuan,
KotaTujuanDis = a.Kota_Tujuan_Dis,
JumlahPenumpang = a.Jumlah_Penumpang.Value.ToString(),
PenumpangSakit = a.Penumpang_Sakit.Value.ToString(),
PenumpangSakitDis = a.Penumpang_Sakit_Dis,
FormGendec = a.Form_Gendec,
CreatedBy = a.CreatedBy,
CreatedDate = GetDateStringFromDate(a.CreatedDate),
UpdatedBy = a.UpdatedBy,
UpdatedDate = GetDateStringFromDate(a.UpdatedDate),
NamaPetugas = a.Nama_Petugas,
NomorPetugas = a.Nomor_Petugas,
JumlahSakit = a.Jumlah_Sakit.Value.ToString()
}).SingleOrDefault();
if (DataAirline == null)
{
DataAirline = new DataAirline();
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(DataAirline);
}