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