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