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