public ActionResult XoaCongTyVanTai(string idCongTy) { try { int cCongTy = Convert.ToInt32(idCongTy); var context = new QLVanTai_2017(); var CongTyVT = context.QLVT_CongTyVanTai.FirstOrDefault(c => c.CT_IdCongTyVT == cCongTy); if (CongTyVT.SoLuongXe != 0) { } else { var dsCapTuyenChoDn = context.QLVT_DanhSachCapTuyenChoDN .Where(c => c.CT_IdCongTyVT == CongTyVT.CT_IdCongTyVT).ToList(); context.QLVT_DanhSachCapTuyenChoDN.RemoveRange(dsCapTuyenChoDn); context.QLVT_CongTyVanTai.Remove(CongTyVT); } context.SaveChanges(); return(Json(new { status = true, message = "Xóa thành công." }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { status = false, message = "Xóa thất bại." }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ThemTTBenXe(string TenBenXe, string MaBen, string TS_IdTinh_So, string DiaChi, string SDT, string CoQuanQuanLy, string TongDienTich, string DienTich_XeKhach, string DienTich_PhuongTienKhac, string DienTich_NhaCho, string LoaiBenXe, string SoTuyenQuyHoach, string SoLuotXuatBenQuyHoach, string TS_TT_IdTrangThai, string GhiChu) { try { var context = new QLVanTai_2017(); int intMaBen = Convert.ToInt32(MaBen); var checkBenXe = context.QLVT_ThongTinBenXe .FirstOrDefault(u => (u.TenBenXe.CompareTo(TenBenXe) == 0)); if (checkBenXe != null) { //if (Convert.ToInt32(MaBen) == checkBenXe.MaBen) //{ // return Json(new { status = false, error = "Trùng mã bến xe" }, JsonRequestBehavior.AllowGet); //} if (String.Compare(TenBenXe, checkBenXe.TenBenXe, StringComparison.Ordinal) == 0) { return(Json(new { status = false, error = "Trùng tên bến xe" }, JsonRequestBehavior.AllowGet)); } } else { var benxe = new QLVT_ThongTinBenXe() { TenBenXe = TenBenXe, MaBen = Convert.ToInt32(MaBen), TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So), DiaChi = DiaChi, SDT = SDT, CoQuanQuanLy = CoQuanQuanLy, TongDienTich = (float)Convert.ToDouble(TongDienTich), DienTich_XeKhach = (float)Convert.ToDouble(DienTich_XeKhach), DienTich_PhuongTienKhac = (float)Convert.ToDouble(DienTich_PhuongTienKhac), DienTich_NhaCho = (float)Convert.ToDouble(DienTich_NhaCho), LoaiBenXe = Convert.ToInt32(LoaiBenXe), SoTuyenQuyHoach = Convert.ToInt32(SoTuyenQuyHoach), SoLuotXuatBenQuyHoach = Convert.ToInt32(SoLuotXuatBenQuyHoach), GhiChu = GhiChu, TS_TT_IdTrangThai = Convert.ToInt32(TS_TT_IdTrangThai) }; context.QLVT_ThongTinBenXe.Add(benxe); context.SaveChanges(); return(Json(new { status = true, message = "Thêm thành công" }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Thêm thất bại" }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult SuaTTBenXe(string BX_IdBenXe, string TenBenXe, string MaBen, string TS_IdTinh_So, string DiaChi, string SDT, string CoQuanQuanLy, string TongDienTich, string DienTich_XeKhach, string DienTich_PhuongTienKhac, string DienTich_NhaCho, string LoaiBenXe, string SoTuyenQuyHoach, string SoLuotXuatBenQuyHoach, string GhiChu, string TS_TT_IdTrangThai) { try { var context = new QLVanTai_2017(); int intMaBen = Convert.ToInt32(MaBen); var checkBenXe = context.QLVT_ThongTinBenXe .FirstOrDefault(u => (String.Compare(u.TenBenXe, TenBenXe, StringComparison.Ordinal) == 0)); if (checkBenXe != null && Convert.ToInt32(BX_IdBenXe) != checkBenXe.BX_IdBenXe) { //if (Convert.ToInt32(MaBen) == checkBenXe.MaBen) //{ // return Json(new { status = false, error = "Trùng mã bến xe" }, JsonRequestBehavior.AllowGet); //} if (String.Compare(TenBenXe, checkBenXe.TenBenXe, StringComparison.Ordinal) == 0) { return(Json(new { status = false, error = "Trùng tên bến xe" }, JsonRequestBehavior.AllowGet)); } } else { int idBenXe = Convert.ToInt32(BX_IdBenXe); var benXe = context.QLVT_ThongTinBenXe.FirstOrDefault(u => u.BX_IdBenXe == idBenXe); benXe.TenBenXe = TenBenXe; benXe.MaBen = Convert.ToInt32(MaBen); benXe.TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So); benXe.DiaChi = DiaChi; benXe.SDT = SDT; benXe.CoQuanQuanLy = CoQuanQuanLy; benXe.TongDienTich = Convert.ToDouble(TongDienTich); benXe.DienTich_XeKhach = Convert.ToDouble(DienTich_XeKhach); benXe.DienTich_PhuongTienKhac = Convert.ToDouble(DienTich_PhuongTienKhac); benXe.DienTich_NhaCho = Convert.ToDouble(DienTich_NhaCho); benXe.LoaiBenXe = Convert.ToInt32(LoaiBenXe); benXe.SoTuyenQuyHoach = Convert.ToInt32(SoTuyenQuyHoach); benXe.SoLuotXuatBenQuyHoach = Convert.ToInt32(SoLuotXuatBenQuyHoach); benXe.GhiChu = GhiChu; benXe.TS_TT_IdTrangThai = Convert.ToInt32(TS_TT_IdTrangThai); context.SaveChanges(); return(Json(new { status = true, message = "Sửa thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Sửa thất bại." }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult XoaTinhSo(string idTinhSo) { try { int cTinhSo = Convert.ToInt32(idTinhSo); var context = new QLVanTai_2017(); var TinhSo = context.QLVT_ThongTinTinh_SoGiaoThong.FirstOrDefault(c => c.TS_IdTinh_So == cTinhSo); context.QLVT_ThongTinTinh_SoGiaoThong.Remove(TinhSo); context.SaveChanges(); return(Json(new { status = true, message = "Xóa thành công." }, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(Json(new { status = false, message = "Xóa thất bại." }, JsonRequestBehavior.AllowGet)); } }
public ActionResult SuaTTTinhSo(string idTinhSo, string maTinh, string tenTinh, string trangThai, string giamDoc , string sdt, string email) { //Chua check pass try { var context = new QLVanTai_2017(); int intMaTinh = Convert.ToInt32(maTinh); var checkTinhSo = context.QLVT_ThongTinTinh_SoGiaoThong .FirstOrDefault(u => u.TS_IdMaTinh == intMaTinh || u.TS_TenTinh == tenTinh); if (checkTinhSo != null && checkTinhSo.TS_IdTinh_So != Convert.ToInt32(idTinhSo)) { if (Convert.ToInt32(maTinh) == checkTinhSo.TS_IdMaTinh) { return(Json(new { status = false, error = "Trùng mã tỉnh" }, JsonRequestBehavior.AllowGet)); } if (String.Compare(tenTinh, checkTinhSo.TS_TenTinh, StringComparison.Ordinal) == 0) { return(Json(new { status = false, error = "Trùng tên tỉnh" }, JsonRequestBehavior.AllowGet)); } } else { int intIdTinhSo = Convert.ToInt32(idTinhSo); var tinhSo = context.QLVT_ThongTinTinh_SoGiaoThong.FirstOrDefault(u => u.TS_IdTinh_So == intIdTinhSo); tinhSo.TS_IdMaTinh = Convert.ToInt32(maTinh); tinhSo.TS_TenTinh = tenTinh; tinhSo.TS_TT_IdTrangThai = Convert.ToInt32(trangThai); tinhSo.GiamDocSo = giamDoc; tinhSo.SoDienThoai = sdt; tinhSo.Email = email; context.SaveChanges(); return(Json(new { status = true, message = "Sửa thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Sửa thất bại." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult ThemTTTinhSo(string maTinh, string tenTinh, string trangThai, string giamDoc , string sdt, string email) { try { var context = new QLVanTai_2017(); int intMaTinh = Convert.ToInt32(maTinh); var checkTinhSo = context.QLVT_ThongTinTinh_SoGiaoThong .FirstOrDefault(u => (u.TS_IdMaTinh == intMaTinh) || (u.TS_TenTinh == tenTinh)); if (checkTinhSo != null) { if (Convert.ToInt32(maTinh) == checkTinhSo.TS_IdMaTinh) { return(Json(new { status = false, error = "Trùng mã tỉnh" }, JsonRequestBehavior.AllowGet)); } if (String.Compare(tenTinh, checkTinhSo.TS_TenTinh, StringComparison.Ordinal) == 0) { return(Json(new { status = false, error = "Trùng tên tỉnh" }, JsonRequestBehavior.AllowGet)); } } else { var tinhSo = new QLVT_ThongTinTinh_SoGiaoThong { TS_IdMaTinh = Convert.ToInt32(maTinh), TS_TenTinh = tenTinh, TS_TT_IdTrangThai = Convert.ToInt32(trangThai), GiamDocSo = giamDoc, SoDienThoai = sdt, Email = email }; context.QLVT_ThongTinTinh_SoGiaoThong.Add(tinhSo); context.SaveChanges(); return(Json(new { status = true, message = "Thêm thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Thêm thất bại." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult xoaThongTinXe(string idXe) { try { var context = new QLVanTai_2017(); int iIdXe = Convert.ToInt32(idXe); var Xe = context.QLVT_ThongTinXe.FirstOrDefault(c => c.TX_IdXe == iIdXe); var Xe_beta = context.QLVT_ThongTinXe_beta.FirstOrDefault(c => c.TX_IdXe == Xe.TX_IdXe); context.QLVT_ThongTinXe_beta.Remove(Xe_beta); context.QLVT_ThongTinXe.Remove(Xe); context.SaveChanges(); return(Json(new { status = true, error = "Xóa thành công." }, JsonRequestBehavior.AllowGet)); } catch (Exception) { return(Json(new { status = false, error = "Xóa thất bại." }, JsonRequestBehavior.AllowGet)); } }
public ActionResult ThemTTCongTyVanTai(string TenCongTy, string MaCongTy, string DiaChi, string TS_IdTinh_So) { try { var context = new QLVanTai_2017(); int intCongTyVanTai = Convert.ToInt32(MaCongTy); int iIdTinhSo = Convert.ToInt32(TS_IdTinh_So); var checkCongTyVanTai = context.QLVT_CongTyVanTai .FirstOrDefault(u => (u.MaCongTy == intCongTyVanTai) || (u.TenCongTy.CompareTo(TenCongTy) == 0)); if (checkCongTyVanTai != null && checkCongTyVanTai.TS_IdTinh_So == Convert.ToInt32(TS_IdTinh_So)) { if (Convert.ToInt32(intCongTyVanTai) == checkCongTyVanTai.MaCongTy && checkCongTyVanTai.TS_IdTinh_So != iIdTinhSo) { return(Json(new { status = false, message = "Trùng mã bến xe" }, JsonRequestBehavior.AllowGet)); } if (String.Compare(TenCongTy, checkCongTyVanTai.TenCongTy, StringComparison.Ordinal) == 0) { return(Json(new { status = false, message = "Trùng tên bến xe" }, JsonRequestBehavior.AllowGet)); } } else { var CongTyVanTai = new QLVT_CongTyVanTai() { TenCongTy = TenCongTy, MaCongTy = Convert.ToInt32(MaCongTy), SoLuongXe = 0, DiaChi = DiaChi, TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So), }; context.QLVT_CongTyVanTai.Add(CongTyVanTai); context.SaveChanges(); return(Json(new { status = true, message = "Thêm thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, message = "Thêm thất bại." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult SuaTTCongTyVanTai(string CT_IdCongTyVT, string TenCongTy, string MaCongTy, string DiaChi, string TS_IdTinh_So) { try { var context = new QLVanTai_2017(); int MaCongTyVanTai = Convert.ToInt32(MaCongTy); var checkCongTyVanTai = context.QLVT_CongTyVanTai .FirstOrDefault(u => (u.MaCongTy == MaCongTyVanTai) || (u.TenCongTy.CompareTo(TenCongTy) == 0)); if (checkCongTyVanTai != null && checkCongTyVanTai.CT_IdCongTyVT != Convert.ToInt32(CT_IdCongTyVT) && checkCongTyVanTai.TS_IdTinh_So == Convert.ToInt32(TS_IdTinh_So)) { if (Convert.ToInt32(MaCongTyVanTai) == checkCongTyVanTai.MaCongTy) { return(Json(new { status = false, message = "Trùng mã bến xe" }, JsonRequestBehavior.AllowGet)); } if (String.Compare(TenCongTy, checkCongTyVanTai.TenCongTy, StringComparison.Ordinal) == 0) { return(Json(new { status = false, message = "Trùng tên bến xe" }, JsonRequestBehavior.AllowGet)); } } else { int idCongTyVanTai = Convert.ToInt32(CT_IdCongTyVT); var CongTyVanTai = context.QLVT_CongTyVanTai.FirstOrDefault(u => u.CT_IdCongTyVT == idCongTyVanTai); CongTyVanTai.MaCongTy = Convert.ToInt32(MaCongTy); CongTyVanTai.TenCongTy = TenCongTy; CongTyVanTai.DiaChi = DiaChi; CongTyVanTai.TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So); context.SaveChanges(); return(Json(new { status = true, message = "Sửa thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, message = "Sửa thất bại." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult ThemThongTinXe(string TX_MaSoXe, string TX_BienSoXe , string CT_IdCongTyVT, string soGhe, string soGiuong, string gioXuatBen , string tongLuotVanChuyen, string TX_TT_IdTrangThaiXe, string LT_IdLuongTuyen) { try { var context = new QLVanTai_2017(); int maSoXe = Convert.ToInt32(TX_MaSoXe); var checkThongTinXe = context.QLVT_ThongTinXe .FirstOrDefault(u => u.TX_MaSoXe == maSoXe || u.TX_BienSoXe.CompareTo(TX_BienSoXe) == 0); if (checkThongTinXe != null) { if (checkThongTinXe.TX_MaSoXe == maSoXe) { return(Json(new { status = false, error = "Mã số xe đã tồn tại" }, JsonRequestBehavior.AllowGet)); } if (checkThongTinXe.TX_BienSoXe.CompareTo(TX_BienSoXe) == 0) { return(Json(new { status = false, error = "Biển số xe đã tồn tại" }, JsonRequestBehavior.AllowGet)); } } else { var ThongTinXe = new QLVT_ThongTinXe() { TX_MaSoXe = Convert.ToInt32(TX_MaSoXe), TX_BienSoXe = TX_BienSoXe, //TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So), CT_IdCongTyVT = Convert.ToInt32(CT_IdCongTyVT), TX_TT_IdTrangThaiXe = Convert.ToInt32(TX_TT_IdTrangThaiXe), LT_IdLuongTuyen = Convert.ToInt64(LT_IdLuongTuyen), }; context.QLVT_ThongTinXe.Add(ThongTinXe); context.SaveChanges(); var ThongTinXeBeta = new QLVT_ThongTinXe_beta() { TX_IdXe = ThongTinXe.TX_IdXe, TX_BX_TongLuotVanChuyen = Convert.ToInt32(tongLuotVanChuyen), TX_GioXuatBen = gioXuatBen, TX_BX_SoGhe = Convert.ToInt32(soGhe) != 0 ? Convert.ToInt32(soGhe) : 0, TX_BX_SoGiuong = Convert.ToInt32(soGiuong) != 0 ? Convert.ToInt32(soGiuong) : 0 }; context.QLVT_ThongTinXe_beta.Add(ThongTinXeBeta); context.SaveChanges(); int IdCongTyVanTai = Convert.ToInt32(CT_IdCongTyVT); var CongTyVanTai = context.QLVT_CongTyVanTai.FirstOrDefault(u => u.CT_IdCongTyVT == IdCongTyVanTai); CongTyVanTai.SoLuongXe++; context.SaveChanges(); //Cấp tuyến cho DN long idLuongTuyen = Convert.ToInt64(LT_IdLuongTuyen); var checkCapTuyen = context.QLVT_DanhSachCapTuyenChoDN.FirstOrDefault(c => c.LT_IdLuongTuyen == idLuongTuyen && c.CT_IdCongTyVT == IdCongTyVanTai); if (checkCapTuyen == null) { var CapTuyen = new QLVT_DanhSachCapTuyenChoDN { CT_IdCongTyVT = IdCongTyVanTai, LT_IdLuongTuyen = idLuongTuyen }; context.QLVT_DanhSachCapTuyenChoDN.Add(CapTuyen); context.SaveChanges(); } return(Json(new { status = true, message = "Thêm thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Thêm không thành công." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult SuaThongTinXe(string idXe, string TX_MaSoXe, string TX_BienSoXe , string CT_IdCongTyVT, string soGhe, string soGiuong, string gioXuatBen , string tongLuotVanChuyen, string TX_TT_IdTrangThaiXe, string LT_IdLuongTuyen) { try { var context = new QLVanTai_2017(); int intIdXe = Convert.ToInt32(idXe); int maSoXe = Convert.ToInt32(TX_MaSoXe); var checkThongTinXe = context.QLVT_ThongTinXe .FirstOrDefault(u => (u.TX_MaSoXe == maSoXe || u.TX_BienSoXe.CompareTo(TX_BienSoXe) == 0) && u.TX_IdXe != intIdXe); if (checkThongTinXe != null) { if (checkThongTinXe.TX_MaSoXe == maSoXe) { return(Json(new { status = false, error = "Mã số xe đã tồn tại" }, JsonRequestBehavior.AllowGet)); } if (checkThongTinXe.TX_BienSoXe.CompareTo(TX_BienSoXe) == 0) { return(Json(new { status = false, error = "Biển số xe đã tồn tại" }, JsonRequestBehavior.AllowGet)); } } else { var ThongTinXe = context.QLVT_ThongTinXe.FirstOrDefault(c => c.TX_IdXe == intIdXe); int idCongTyVTCu = Convert.ToInt32(ThongTinXe.CT_IdCongTyVT); int idCongTyVTMoi = Convert.ToInt32(CT_IdCongTyVT); //Khi đổi DN if (idCongTyVTMoi != idCongTyVTCu) { var CongTyVanTaiCu = context.QLVT_CongTyVanTai.FirstOrDefault(u => u.CT_IdCongTyVT == ThongTinXe.CT_IdCongTyVT); if (CongTyVanTaiCu != null) { CongTyVanTaiCu.SoLuongXe--; } else { return(Json(new { status = false, error = "Thêm không thành công." }, JsonRequestBehavior.AllowGet)); } var CongTyVanTaiMoi = context.QLVT_CongTyVanTai.FirstOrDefault(u => u.CT_IdCongTyVT == idCongTyVTMoi); if (CongTyVanTaiMoi != null) { CongTyVanTaiMoi.SoLuongXe++; } else { return(Json(new { status = false, error = "Thêm không thành công." }, JsonRequestBehavior.AllowGet)); } //Xóa tuyến cũ nếu trong CTy VT ko còn xe chạy trong tuyến int countXe = CongTyVanTaiCu.QLVT_ThongTinXe.Count(c => c.LT_IdLuongTuyen == ThongTinXe.LT_IdLuongTuyen); if (countXe <= 1) { var capTuyen = context.QLVT_DanhSachCapTuyenChoDN.FirstOrDefault(c => c.LT_IdLuongTuyen == ThongTinXe.LT_IdLuongTuyen); context.QLVT_DanhSachCapTuyenChoDN.Remove(capTuyen); context.SaveChanges(); } //Cấp tuyến mới khi đổi DN long idLuongTuyen = Convert.ToInt64(LT_IdLuongTuyen); var checkCapTuyen = context.QLVT_DanhSachCapTuyenChoDN.FirstOrDefault(c => c.LT_IdLuongTuyen == idLuongTuyen && c.CT_IdCongTyVT == CongTyVanTaiMoi.CT_IdCongTyVT); if (checkCapTuyen == null) { var CapTuyen = new QLVT_DanhSachCapTuyenChoDN { CT_IdCongTyVT = CongTyVanTaiMoi.CT_IdCongTyVT, LT_IdLuongTuyen = idLuongTuyen }; context.QLVT_DanhSachCapTuyenChoDN.Add(CapTuyen); context.SaveChanges(); } } long idTuyenCu = ThongTinXe.LT_IdLuongTuyen; long idTuyenMoi = Convert.ToInt64(LT_IdLuongTuyen); ThongTinXe.TX_MaSoXe = Convert.ToInt32(TX_MaSoXe); ThongTinXe.TX_BienSoXe = TX_BienSoXe; //TS_IdTinh_So = Convert.ToInt32(TS_IdTinh_So); ThongTinXe.CT_IdCongTyVT = Convert.ToInt32(CT_IdCongTyVT); ThongTinXe.TX_TT_IdTrangThaiXe = Convert.ToInt32(TX_TT_IdTrangThaiXe); ThongTinXe.LT_IdLuongTuyen = idTuyenMoi; var ThongTinXeBeta = context.QLVT_ThongTinXe_beta.FirstOrDefault(c => c.TX_IdXe == intIdXe); ThongTinXeBeta.TX_BX_TongLuotVanChuyen = Convert.ToInt32(tongLuotVanChuyen); ThongTinXeBeta.TX_GioXuatBen = gioXuatBen; ThongTinXeBeta.TX_BX_SoGhe = Convert.ToInt32(soGhe) != 0 ? Convert.ToInt32(soGhe) : 0; ThongTinXeBeta.TX_BX_SoGiuong = Convert.ToInt32(soGiuong) != 0 ? Convert.ToInt32(soGiuong) : 0; context.SaveChanges(); //Update tuyến if (idTuyenCu != idTuyenMoi) { var updateTuyen = context.QLVT_DanhSachCapTuyenChoDN.FirstOrDefault(c => c.CT_IdCongTyVT == ThongTinXe.CT_IdCongTyVT); updateTuyen.LT_IdLuongTuyen = idTuyenMoi; } return(Json(new { status = true, message = "Thêm thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Thêm không thành công." }, JsonRequestBehavior.AllowGet)); } return(null); }
public ActionResult ThemTTLuongTuyen(string benDi, string benDen, string maTuyen, string hanhTrinhChay, string cuLy, string luuLuong, string idTrangThai, string idPhanLoai) { try { var context = new QLVanTai_2017(); var checkLuongTuyen = context.QLVT_LuongTuyen .FirstOrDefault(u => (u.LT_HanhTrinhChay.CompareTo(hanhTrinhChay) == 0) || u.LT_MaTuyen.CompareTo(maTuyen) == 0); if (checkLuongTuyen != null) { if (checkLuongTuyen.LT_HanhTrinhChay.CompareTo(hanhTrinhChay) == 0) { return(Json(new { status = false, error = "Hành trình chạy đã tồn tại" }, JsonRequestBehavior.AllowGet)); } if (checkLuongTuyen.LT_MaTuyen.CompareTo(maTuyen) == 0) { return(Json(new { status = false, error = "Mã tuyến đã tồn tại" }, JsonRequestBehavior.AllowGet)); } } else { int idBenDi = Convert.ToInt32(benDi); int idBenDen = Convert.ToInt32(benDen); var diemDauCuoi = context.QLVT_LuongTuyen_DiemDauCuoi .FirstOrDefault(u => u.LT_DC_IdBen_01 == idBenDi && u.LT_DC_IdBen_02 == idBenDen); if (diemDauCuoi == null) { var objDiemCuoi = new QLVT_LuongTuyen_DiemDauCuoi() { LT_DC_IdBen_01 = idBenDi, LT_DC_IdBen_02 = idBenDen, LT_DC_TenBen_01 = context.QLVT_ThongTinBenXe.FirstOrDefault(u => u.BX_IdBenXe == idBenDi) .TenBenXe, LT_DC_TenBen_02 = context.QLVT_ThongTinBenXe.FirstOrDefault(u => u.BX_IdBenXe == idBenDen) .TenBenXe, LT_DC_TT_IdTrangThai = 1, }; context.QLVT_LuongTuyen_DiemDauCuoi.Add(objDiemCuoi); context.SaveChanges(); diemDauCuoi = context.QLVT_LuongTuyen_DiemDauCuoi .FirstOrDefault(u => u.LT_DC_IdBen_01 == idBenDi && u.LT_DC_IdBen_02 == idBenDen); } var LuongTuyen = new QLVT_LuongTuyen() { LT_MaTuyen = maTuyen, LT_HanhTrinhChay = hanhTrinhChay, LT_CuLy = Convert.ToInt32(cuLy), LT_LuuLuongQuyDinh = Convert.ToInt32(luuLuong), TT_IdTrangThaiTuyen = Convert.ToInt32(idTrangThai), LT_PL_IdLuongTuyen = Convert.ToInt32(idPhanLoai), LT_DC_IdLuongTuyen = diemDauCuoi.LT_DC_IdLuongTuyen }; context.QLVT_LuongTuyen.Add(LuongTuyen); context.SaveChanges(); var TinhSo1 = context.QLVT_ThongTinBenXe .FirstOrDefault(c => c.BX_IdBenXe == LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01) .TS_IdTinh_So; var TinhSo2 = context.QLVT_ThongTinBenXe .FirstOrDefault(c => c.BX_IdBenXe == LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02) .TS_IdTinh_So; var CapTuyen1 = new QLVT_CapTuyenChoTinh_So() { LT_IdLuongTuyen = LuongTuyen.LT_IdLuongTuyen, TS_IdTinh_So = TinhSo1 }; var CapTuyen2 = new QLVT_CapTuyenChoTinh_So() { LT_IdLuongTuyen = LuongTuyen.LT_IdLuongTuyen, TS_IdTinh_So = TinhSo2 }; context.QLVT_CapTuyenChoTinh_So.Add(CapTuyen1); if (CapTuyen1.TS_IdTinh_So != CapTuyen2.TS_IdTinh_So) { context.QLVT_CapTuyenChoTinh_So.Add(CapTuyen2); } context.SaveChanges(); return(Json(new { status = true, message = "Thêm thành công." }, JsonRequestBehavior.AllowGet)); } } catch (Exception e) { return(Json(new { status = false, error = "Thêm không thành công." }, JsonRequestBehavior.AllowGet)); } return(Json(new { status = true }, JsonRequestBehavior.AllowGet)); }
public ActionResult SuaTTLuongTuyen(string idLuongTuyen, string benDi, string benDen, string maTuyen, string hanhTrinhChay, string cuLy, string luuLuong, string idTrangThai, string idPhanLoai) { // return Json(new { status = false, error = "Sửa đang bảo trì." }, JsonRequestBehavior.AllowGet); try { var context = new QLVanTai_2017(); long lIdLuongTuyen = Convert.ToInt64(idLuongTuyen); var checkLuongTuyen = context.QLVT_LuongTuyen .FirstOrDefault(u => (u.LT_HanhTrinhChay.CompareTo(hanhTrinhChay) == 0) || u.LT_MaTuyen.CompareTo(maTuyen) == 0); if (checkLuongTuyen != null && checkLuongTuyen.LT_IdLuongTuyen != lIdLuongTuyen) { if (checkLuongTuyen.LT_HanhTrinhChay.CompareTo(hanhTrinhChay) == 0) { return(Json(new { status = false, error = "Hành trình chạy đã tồn tại" }, JsonRequestBehavior.AllowGet)); } if (checkLuongTuyen.LT_MaTuyen.CompareTo(maTuyen) == 0) { return(Json(new { status = false, error = "Mã tuyến đã tồn tại" }, JsonRequestBehavior.AllowGet)); } } else { int idBenDi = Convert.ToInt32(benDi); int idBenDen = Convert.ToInt32(benDen); var diemDauCuoi = context.QLVT_LuongTuyen_DiemDauCuoi .FirstOrDefault(u => u.LT_DC_IdBen_01 == idBenDi && u.LT_DC_IdBen_02 == idBenDen); if (diemDauCuoi == null) { diemDauCuoi = new QLVT_LuongTuyen_DiemDauCuoi() { LT_DC_IdBen_01 = idBenDi, LT_DC_IdBen_02 = idBenDen, LT_DC_TenBen_01 = context.QLVT_ThongTinBenXe.FirstOrDefault(u => u.BX_IdBenXe == idBenDi) .TenBenXe, LT_DC_TenBen_02 = context.QLVT_ThongTinBenXe.FirstOrDefault(u => u.BX_IdBenXe == idBenDen) .TenBenXe, LT_DC_TT_IdTrangThai = 1, }; context.QLVT_LuongTuyen_DiemDauCuoi.Add(diemDauCuoi); context.SaveChanges(); } var objLuongTuyen = context.QLVT_LuongTuyen.FirstOrDefault(i => i.LT_IdLuongTuyen == lIdLuongTuyen); if (objLuongTuyen != null) { var idDCLuongTuyen = objLuongTuyen.LT_DC_IdLuongTuyen; objLuongTuyen.LT_MaTuyen = maTuyen; objLuongTuyen.LT_HanhTrinhChay = hanhTrinhChay; objLuongTuyen.LT_CuLy = Convert.ToInt32(cuLy); objLuongTuyen.LT_LuuLuongQuyDinh = Convert.ToInt32(luuLuong); objLuongTuyen.TT_IdTrangThaiTuyen = Convert.ToInt32(idTrangThai); objLuongTuyen.LT_PL_IdLuongTuyen = Convert.ToInt32(idPhanLoai); objLuongTuyen.LT_DC_IdLuongTuyen = diemDauCuoi.LT_DC_IdLuongTuyen; if (idDCLuongTuyen != diemDauCuoi.LT_DC_IdLuongTuyen) { /// var TinhSo1 = context.QLVT_ThongTinBenXe .FirstOrDefault(c => c.BX_IdBenXe == objLuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01) .TS_IdTinh_So; var TinhSo2 = context.QLVT_ThongTinBenXe .FirstOrDefault(c => c.BX_IdBenXe == objLuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02) .TS_IdTinh_So; var CapTuyen1 = context.QLVT_CapTuyenChoTinh_So.FirstOrDefault(c => c.QLVT_LuongTuyen.LT_DC_IdLuongTuyen == objLuongTuyen.LT_IdLuongTuyen && c.TS_IdTinh_So == TinhSo1); var CapTuyen2 = context.QLVT_CapTuyenChoTinh_So.FirstOrDefault(c => c.QLVT_LuongTuyen.LT_DC_IdLuongTuyen == objLuongTuyen.LT_IdLuongTuyen && c.TS_IdTinh_So == TinhSo2); if (TinhSo1 == TinhSo2 && CapTuyen1 != CapTuyen2 && CapTuyen2 != null) { context.QLVT_CapTuyenChoTinh_So.Remove(CapTuyen2); CapTuyen1.TS_IdTinh_So = TinhSo1; } if (TinhSo1 != TinhSo2) { if (CapTuyen1 == null) { CapTuyen1 = new QLVT_CapTuyenChoTinh_So { TS_IdTinh_So = TinhSo1, LT_IdLuongTuyen = objLuongTuyen.LT_IdLuongTuyen }; context.QLVT_CapTuyenChoTinh_So.Add(CapTuyen1); } if (CapTuyen2 == null) { CapTuyen2 = new QLVT_CapTuyenChoTinh_So { TS_IdTinh_So = TinhSo2, LT_IdLuongTuyen = objLuongTuyen.LT_IdLuongTuyen }; context.QLVT_CapTuyenChoTinh_So.Add(CapTuyen2); } } } context.SaveChanges(); return(Json(new { status = true, message = "Sửa thành công." }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { status = false, error = "Sửa thất bại." }, JsonRequestBehavior.AllowGet)); } } } catch (Exception e) { return(Json(new { status = false, error = "Sửa thất bại." }, JsonRequestBehavior.AllowGet)); } return(null); }