public PartialViewResult ReturnTrip(long tripId)
{
qlChuyenBusiness = Get <QL_DANGKYXE_LAIXEBusiness>();
ChuyenBO trip = qlChuyenBusiness.GetDetail(tripId);
return(PartialView("_ReturnTrip", trip));
}
/// <summary>
/// @author: duynn
/// @description: chi tiết chuyến
/// @since: 28/08/2018
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ChuyenBO GetDetail(long id)
{
ChuyenBO result = (from trip in this.context.QL_DANGKYXE_LAIXE.Where(x => x.ID == id)
join registration in this.context.QL_DANGKY_XE
on trip.QL_DANGKY_XE_ID equals registration.ID
join car in this.context.QL_XE
on trip.XE_ID equals car.ID
join driver in this.context.QL_LAIXE
on trip.LAIXE_ID equals driver.ID
join leader in this.context.DM_NGUOIDUNG
on registration.CANBO_ID equals leader.ID
into groupLeader
from grLeader in groupLeader.DefaultIfEmpty()
join calendar in this.context.LICHCONGTAC
on registration.LICHCONGTAC_ID equals calendar.ID
into groupCalendar
from grCal in groupCalendar.DefaultIfEmpty()
orderby trip.ID descending
select new ChuyenBO
{
ID = trip.ID,
TEN_CHUYEN = trip.TEN_CHUYEN,
MUCDICH = registration.MUCDICH,
NOIDUNG = registration.NOIDUNG,
XE_ID = car.ID,
TENXE = car.TENXE,
LAIXE_ID = driver.ID,
TEN_LAIXE = driver.HOTEN,
DIENTHOAI_LAIXE = driver.SODIENTHOAI,
TRANGTHAI = trip.TRANGTHAI ?? 0,
NGAY_XUATPHAT = registration.NGAY_XUATPHAT,
GIO_XUATPHAT = registration.GIO_XUATPHAT,
PHUT_XUATPHAT = registration.PHUT_XUATPHAT,
DIEM_XUATPHAT = registration.DIEM_XUATPHAT,
NGAYSUA = registration.NGAYSUA,
NGUOITAO = registration.NGUOITAO,
IS_BHYT = trip.IS_BHYT,
LOAICHUYEN_ID = trip.LOAICHUYEN_ID,
IS_TUVONG_TRENDUONG = trip.IS_TUVONG_TRENDUONG,
TEN_CANBO = grLeader.HOTEN,
TEN_BENHNHAN = registration.TEN_BENHNHAN,
LICHCONGTAC_ID = grCal.ID,
TEN_LICHCONGTAC = grCal.TIEUDE
}).FirstOrDefault();
if (result != null)
{
if (result.LOAICHUYEN_ID != null)
{
result.TEN_LOAICHUYEN = (result.LOAICHUYEN_ID == LOAICHUYEN_CONSTANT.CHUYEN_NGANG_TUYEN ?
TENLOAICHUYEN_CONSTANT.CHUYEN_NGANG_TUYEN : TENLOAICHUYEN_CONSTANT.CHUYEN_VE);
}
if (result.NGAY_XUATPHAT != null)
{
result.THOIGIAN_XUATPHAT = string.Format("{0:dd/MM/yyyy}", result.NGAY_XUATPHAT);
if (result.GIO_XUATPHAT != null)
{
result.THOIGIAN_XUATPHAT += " " + result.GIO_XUATPHAT.Value.ToString("D2") + "h";
if (result.PHUT_XUATPHAT != null)
{
result.THOIGIAN_XUATPHAT += result.PHUT_XUATPHAT.Value.ToString("D2");
}
}
}
switch (result.TRANGTHAI.Value)
{
case TRANGTHAI_CHUYEN_CONSTANT.MOITAO_ID:
result.TEN_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.MOITAO_TEXT;
result.MAU_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.MOITAO_COLOR;
break;
case TRANGTHAI_CHUYEN_CONSTANT.DANGCHAY_ID:
result.TEN_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.DANGCHAY_TEXT;
result.MAU_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.DANGCHAY_COLOR;
break;
case TRANGTHAI_CHUYEN_CONSTANT.DA_HOANTHANH_ID:
result.TEN_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.DA_HOANTHANH_TEXT;
result.MAU_TRANGTHAI = TRANGTHAI_CHUYEN_CONSTANT.DA_HOANTHANH_COLOR;
break;
default:
break;
}
}
return(result);
}
