private ActionResult BaoCaoDoanhNghiepDefault()
{
QLVanTai_2017 dbc = new QLVanTai_2017();
Dictionary <string, dynamic> DataDefault = new Dictionary <string, dynamic>();
DataDefault["So"] = 55;
DataDefault["TuNgay"] = "01/" + DateTime.Now.ToString("MM/yyyy");
DataDefault["DenNgay"] = DateTime.Now.ToString("dd/MM/yyyy");
ViewBag.LstSo = Get_List_So();
ViewBag.LstBen = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = ViewBag.LstBen[0].BX_IdBenXe;
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = ViewBag.LstTuyen[0].LT_IdLuongTuyen;
ViewBag.LstDonVi = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
DataDefault["DonVi"] = ViewBag.LstDonVi[0].CT_IdCongTyVT;
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(DataDefault["TuNgay"], DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], DataDefault["DonVi"]);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
ViewBag.ThongTinBenXe = ThongTinBenXe(DataDefault["Ben"]);
return(View());
}
public ActionResult GetLstBenXe(string TS_IdTinh_So)
{
try
{
var context = new QLVanTai_2017();
int idTinhSo = Convert.ToInt32(TS_IdTinh_So);
var lstBenXe = context.QLVT_ThongTinBenXe
.Where(c => c.TS_IdTinh_So == idTinhSo)
.Select(u => new
{
u.BX_IdBenXe,
u.TenBenXe
}).ToArray();
if (lstBenXe.Length == 0)
{
var notFound = new List <dynamic>();
notFound.Add(new { BX_IdBenXe = -1, TenBenXe = "Không có" });
return(Json(new { status = true, data = notFound }, JsonRequestBehavior.AllowGet));
}
return(Json(new { status = true, data = lstBenXe }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = true, error = "Lấy danh sách bến thất bại" }, JsonRequestBehavior.AllowGet));
}
return(null);
}
// GET: BaoCaoHoatDongNhoHon70
public ActionResult BaoCaoToanQuoc()
{
QLVanTai_2017 en = new QLVanTai_2017();
int Id_So = 55; // mặc định
// lấy danh sách sở
List <QLVT_ThongTinTinh_SoGiaoThong> lstSo = en.QLVT_ThongTinTinh_SoGiaoThong.ToList();
ViewBag.lstSo = lstSo;
// lấy danh sách tuyến
var lstTuyen = en.GetThongTinTuyen_IdSo(Id_So).ToList();
ViewBag.lstTuyen = lstTuyen;
// lấy báo cáo
int thang = DateTime.Now.Month;
int nam = DateTime.Now.Year;
var lstBCSoDuoi70 = en.sp_HD_BaoCaoXeChayNhoHon70_SoGiaoThong(thang, nam, Id_So);
ViewBag.dataGrid = lstBCSoDuoi70;
// khởi tạo mặc định
dynamic dataDefault = new
{
Id_So,
thang,
nam,
};
ViewBag.dataDefault = dataDefault;
return(View());
}
public JsonResult GetBaoCaoSo(int?So, string LstBen, string TuNgay, string DenNgay)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
LstBen = "," + LstBen + ",";
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_SoGiaoThong(TuNgay, DenNgay, So, LstBen).ToList();
var DataDefault = new
{
TuNgay,
DenNgay,
So
};
return(Json(new
{
status = true,
message = "Lấy dữ liệu thành công",
data = new { DataGrid, DataDefault }
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = false, message = "Lấy dữ liệu thất bại", data = "" }, JsonRequestBehavior.AllowGet));
}
}
private ActionResult BaoCaoTuyenDefault()
{
//default
QLVanTai_2017 dbc = new QLVanTai_2017();
Dictionary <string, dynamic> DataDefault = new Dictionary <string, dynamic>();
DataDefault["So"] = 55;
DataDefault["TuNgay"] = "01/" + DateTime.Now.ToString("MM/yyyy");
DataDefault["DenNgay"] = DateTime.Now.ToString("dd/MM/yyyy");
ViewBag.LstSo = Get_List_So();
ViewBag.LstBenXe = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = ViewBag.LstBenXe[0].BX_IdBenXe;
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = ViewBag.LstTuyen[0].LT_IdLuongTuyen;
ViewBag.LstDVTT = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
string lstCongTy = "";
foreach (var v in ViewBag.LstDVTT)
{
lstCongTy += v.CT_IdCongTyVT;
}
ViewBag.LstDVTT.Insert(0, new { CT_IdCongTyVT = -1, TenCongTy = "Tất cả" });
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_Tuyen(DataDefault["TuNgay"],
DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], lstCongTy);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
return(View());
}
private ActionResult BaoCaoSoDefault()
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
//DataDefault
var DataDefault = new
{
So = 55,
TuNgay = "01/" + DateTime.Now.ToString("MM/yyyy"),
DenNgay = DateTime.Now.ToString("dd/MM/yyyy")
};
ViewBag.DataDefault = DataDefault;
ViewBag.LstSo = Get_List_So();
ViewBag.List_Ben = Get_List_Ben_TheoIDSo(DataDefault.So);
ViewBag.List_Ben.Insert(0, new { BX_IdBenXe = -1, TenBenXe = "Tất cả" });
string lstBen = ",";
foreach (var v in ViewBag.List_Ben)
{
lstBen += v.BX_IdBenXe + ",";
}
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_SoGiaoThong(DataDefault.TuNgay, DataDefault.DenNgay, DataDefault.So, lstBen).ToList();
ViewBag.DataGrid = DataGrid;
return(View());
}
catch (Exception e)
{
return(View());
}
}
public ActionResult BaoCaoSo(int?So, string TuNgay, string DenNgay)
{
if (string.IsNullOrEmpty(DenNgay))
{
return(BaoCaoSoDefault());
}
else
{
QLVanTai_2017 dbc = new QLVanTai_2017();
//DataDefault
var DataDefault = new
{
So = Convert.ToInt32(So),
TuNgay,
DenNgay
};
ViewBag.DataDefault = DataDefault;
ViewBag.LstSo = Get_List_So();
ViewBag.List_Ben = Get_List_Ben_TheoIDSo(DataDefault.So);
ViewBag.List_Ben.Insert(0, new { BX_IdBenXe = -1, TenBenXe = "Tất cả" });
string lstBen = ",";
foreach (var v in ViewBag.List_Ben)
{
lstBen += v.BX_IdBenXe + ",";
}
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_SoGiaoThong(DataDefault.TuNgay, DataDefault.DenNgay, DataDefault.So, lstBen).ToList();
ViewBag.DataGrid = DataGrid;
return(View());
}
}
// GET: BaoCaoKhongHoatDong
#region [Báo cáo toàn quốc]
private ActionResult BaoCaoToanQuocDefault()
{
try
{
//Default value
int So = 55;
string TuNgay = "01/" + DateTime.Now.ToString("MM/yyyy");
string DenNgay = DateTime.Now.ToString("dd/MM/yyyy");
//////
var dbc = new QLVanTai_2017();
ViewBag.LstSo = Get_List_So();
var DataDefault = new
{
So,
TuNgay,
DenNgay
};
ViewBag.DataDefault = DataDefault;
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_ToanQuoc(TuNgay, DenNgay, "-1").ToList();
ViewBag.DataGrid = DataGrid;
}
catch (Exception e)
{
return(View());
}
return(View());
}
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 GetDSThongTinXe()
{
try
{
var context = new QLVanTai_2017();
var lstThongTinXe = context.QLVT_ThongTinXe_beta.Select(u => new
{
u.TX_IdXe,
u.QLVT_ThongTinXe.TX_BienSoXe,
u.QLVT_ThongTinXe.TX_MaSoXe,
u.QLVT_ThongTinXe.TS_IdTinh_So,
//context.QLVT_ThongTinTinh_SoGiaoThong.FirstOrDefault(c => c.TS_IdTinh_So == u.QLVT_ThongTinXe.TS_IdTinh_So),//u.QLVT_CongTyVanTai.QLVT_ThongTinTinh_SoGiaoThong.TS_TenTinh,
u.QLVT_ThongTinXe.CT_IdCongTyVT,
u.QLVT_ThongTinXe.QLVT_CongTyVanTai.TenCongTy,
u.QLVT_ThongTinXe.TX_TT_IdTrangThaiXe,
u.QLVT_ThongTinXe.QLVT_ThongTinXe_TrangThaiXe.TX_TT_IdTenTrangThai,
u.TX_BX_SoGiuong,
u.TX_BX_SoGhe,
u.TX_BX_TongLuotVanChuyen,
TX_GioXuatBen = u.TX_GioXuatBen,
u.QLVT_ThongTinXe.LT_IdLuongTuyen,
TenTuyen = context.QLVT_LuongTuyen_DiemDauCuoi.FirstOrDefault(c => c.LT_DC_IdLuongTuyen == u.QLVT_ThongTinXe.LT_IdLuongTuyen).LT_DC_TenBen_01
+ " - " + context.QLVT_LuongTuyen_DiemDauCuoi.FirstOrDefault(c => c.LT_DC_IdLuongTuyen == u.QLVT_ThongTinXe.LT_IdLuongTuyen).LT_DC_TenBen_02,
}).ToList();
return(Json(new { status = true, data = lstThongTinXe }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = false, error = "Lấy dữ liệu không thành công." }, JsonRequestBehavior.AllowGet));
}
return(null);
}
// GET: QuanLyCongTyVanTai
public ActionResult Index()
{
try
{
QLVanTai_2017 context = new QLVanTai_2017();
var lstCongTyVanTai = context.QLVT_CongTyVanTai.Select(u => new
{
u.CT_IdCongTyVT,
u.TenCongTy,
u.MaCongTy,
u.SoLuongXe,
u.DiaChi,
u.TS_IdTinh_So,
TenTinhSo = u.QLVT_ThongTinTinh_SoGiaoThong.TS_TenTinh
}).ToList();
ViewBag.dataGridCongTyVanTai = JsonConvert.SerializeObject(lstCongTyVanTai);
var lstTinhSo = context.QLVT_ThongTinTinh_SoGiaoThong.Where(u => u.TS_TT_IdTrangThai == 1)
.Select(u => new
{
u.TS_IdTinh_So,
u.TS_IdMaTinh,
u.TS_TenTinh
}).ToList();
ViewBag.lstTinhSo = JsonConvert.SerializeObject(lstTinhSo);
}
catch (Exception e)
{
//ViewBag.dataGridCongTyVanTai = Json(new { status = false, message = "Lấy dữ liệu thất bại." }, JsonRequestBehavior.AllowGet).ToString();
}
return(View());
}
public ActionResult GetDSBenXe()
{
try
{
QLVanTai_2017 context = new QLVanTai_2017();
var lstBenXe = context.QLVT_ThongTinBenXe.Select(u => new
{
BX_IdBenXe = u.BX_IdBenXe,
TenBenXe = u.TenBenXe,
MaBen = u.MaBen,
TS_IdTinh_So = u.TS_IdTinh_So,
TenTinhSo = u.QLVT_ThongTinTinh_SoGiaoThong.TS_TenTinh,
DiaChi = u.DiaChi,
SDT = u.SDT,
CoQuanQuanLy = u.CoQuanQuanLy,
TongDienTich = u.TongDienTich,
DienTich_XeKhach = u.DienTich_XeKhach,
DienTich_PhuongTienKhac = u.DienTich_PhuongTienKhac,
DienTich_NhaCho = u.DienTich_NhaCho,
LoaiBenXe = u.LoaiBenXe,
SoTuyenQuyHoach = u.SoTuyenQuyHoach,
SoLuotXuatBenQuyHoach = u.SoLuotXuatBenQuyHoach,
GhiChu = u.GhiChu,
TS_TT_IdTrangThai = u.TS_TT_IdTrangThai,
TrangThai = u.QLVT_ThongTinTinh_So_Ben_TrangThai.TS_TT_TenTrangThai
}).ToList();
return(Json(new { status = true, data = lstBenXe }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = false, error = "Lấy dữ liệu thất bại." }, JsonRequestBehavior.AllowGet));
}
return(null);
}
public JsonResult GetBaoCaoDoanhNghiep(string TuNgay, string DenNgay, int?Ben, long?Tuyen, int?DonVi)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
var DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(TuNgay, DenNgay, Ben,
Tuyen, DonVi);
var ThongTinBen = ThongTinBenXe(Convert.ToInt32(Ben));
var ThongTinDonVi = ThongTinDVVT(Convert.ToInt32(DonVi));
var DataDefault = new
{
TuNgay,
DenNgay,
Ben = Convert.ToInt32(Ben),
Tuyen = Convert.ToInt64(Tuyen),
DonVi = Convert.ToInt32(DonVi)
};
var data = new
{
DataGrid,
ThongTinBen,
ThongTinDonVi,
DataDefault
};
return(Json(new { status = true, message = "Lấy dữ liệu thành công", data }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json(new { status = false, message = "Lấy dữ liệu thất bại", data = "" }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult BaoCaoDoanhNghiep(int?So, int?Ben, int?DonVi, long?Tuyen, string TuNgay, string DenNgay)
{
if (string.IsNullOrEmpty(DenNgay))
{
return(BaoCaoDoanhNghiepDefault());
}
else
{
QLVanTai_2017 dbc = new QLVanTai_2017();
Dictionary <string, dynamic> DataDefault = new Dictionary <string, dynamic>();
DataDefault["So"] = Convert.ToInt32(So);
DataDefault["TuNgay"] = TuNgay;
DataDefault["DenNgay"] = DenNgay;
ViewBag.LstSo = Get_List_So();
ViewBag.LstBen = Get_List_Ben_TheoIDSo(DataDefault["So"]);
DataDefault["Ben"] = Convert.ToInt32(Ben);
ViewBag.LstTuyen = Get_List_Tuyen_TheoBen(DataDefault["Ben"]);
DataDefault["Tuyen"] = Convert.ToInt64(Tuyen);
ViewBag.LstDonVi = Get_List_DVVT_TheoIDTuyen(DataDefault["Tuyen"]);;
DataDefault["DonVi"] = Convert.ToInt32(DonVi);
ViewBag.DataGrid = dbc.sp_HD_BaoCaoXeKhongHoatDong_DonViVanTai(DataDefault["TuNgay"], DataDefault["DenNgay"], DataDefault["Ben"], DataDefault["Tuyen"], DataDefault["DonVi"]);
ViewBag.DataDefault = DataDefault;
ViewBag.ThongTinTuyen = GetThongTinTuyen_TheoID(DataDefault["Tuyen"]);
ViewBag.ThongTinBenXe = ThongTinBenXe(DataDefault["Ben"]);
return(View());
}
}
// GET: QuanLyThongTin
public ActionResult Index()
{
try
{
var context = new QLVanTai_2017();
var lstThongTinXe = context.QLVT_ThongTinXe_beta.Select(u => new
{
u.TX_IdXe,
u.QLVT_ThongTinXe.TX_BienSoXe,
u.QLVT_ThongTinXe.TX_MaSoXe,
u.QLVT_ThongTinXe.TS_IdTinh_So,
//context.QLVT_ThongTinTinh_SoGiaoThong.FirstOrDefault(c => c.TS_IdTinh_So == u.QLVT_ThongTinXe.TS_IdTinh_So),//u.QLVT_CongTyVanTai.QLVT_ThongTinTinh_SoGiaoThong.TS_TenTinh,
u.QLVT_ThongTinXe.CT_IdCongTyVT,
u.QLVT_ThongTinXe.QLVT_CongTyVanTai.TenCongTy,
u.QLVT_ThongTinXe.TX_TT_IdTrangThaiXe,
u.QLVT_ThongTinXe.QLVT_ThongTinXe_TrangThaiXe.TX_TT_IdTenTrangThai,
u.TX_BX_SoGiuong,
u.TX_BX_SoGhe,
u.TX_BX_TongLuotVanChuyen,
TX_GioXuatBen = u.TX_GioXuatBen,
u.QLVT_ThongTinXe.LT_IdLuongTuyen,
TenTuyen = context.QLVT_LuongTuyen.FirstOrDefault(c => c.LT_IdLuongTuyen == u.QLVT_ThongTinXe.LT_IdLuongTuyen).QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01
+ " - " + context.QLVT_LuongTuyen.FirstOrDefault(c => c.LT_IdLuongTuyen == u.QLVT_ThongTinXe.LT_IdLuongTuyen).QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02,
}).ToList();
ViewBag.lstThongTinXe = JsonConvert.SerializeObject(lstThongTinXe);
var lstTrangThaiThongTinXe = context.QLVT_ThongTinXe_TrangThaiXe
.Select(c => new
{
c.TX_TT_IdTrangThaiXe,
c.TX_TT_IdTenTrangThai
}).ToList();
ViewBag.lstTrangThaiThongTinXe = JsonConvert.SerializeObject(lstTrangThaiThongTinXe);
var lstLuongTuyenThongTinXe = context.QLVT_LuongTuyen
.Select(c => new
{
c.LT_IdLuongTuyen,
TenTuyen = c.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01 + " - " +
c.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02
}).ToList();
ViewBag.lstLuongTuyenThongTinXe = JsonConvert.SerializeObject(lstLuongTuyenThongTinXe);
var lstCongTyVanTaiThongTinXe = context.QLVT_CongTyVanTai
.Select(c => new
{
c.CT_IdCongTyVT,
c.TenCongTy
}).ToList();
ViewBag.lstCongTyVanTaiThongTinXe = JsonConvert.SerializeObject(lstCongTyVanTaiThongTinXe);
}
catch (Exception e)
{
//ViewBag.dataGridLuongTuyen = Json(new { status = false, error = "Lấy dữ liệu không thành công." }, JsonRequestBehavior.AllowGet).ToString();
}
return(View());
}
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 List <int> TanXuatXuatBen()
{
List <int> lis = new List <int>();
QLVanTai_2017 dbc = new QLVanTai_2017();
for (int i = 0; i < 24; i++)
{
var tem = dbc.NhatTrinhXes.Where(ptr => ptr.GioCapXuatBen.Value.Hour == i && ptr.GioCapXuatBen.Value.Day == DateTime.Now.Day && ptr.GioCapXuatBen.Value.Month == DateTime.Now.Month && ptr.GioCapXuatBen.Value.Year == DateTime.Now.Year).ToList();
lis.Add(tem.Count);
}
return(lis);
}
public JsonResult GetThongTinDonVi(int?DonVi)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
return(Json(new { status = true, messeage = "Lấy dữ liệu thành công", data = ThongTinBenXe(Convert.ToInt32(DonVi)) }));
}
catch (Exception e)
{
return(Json(new { status = false, messeage = "Lấy dữ liệu thất bại", data = "" }));
}
}
public ActionResult GetDSLuongTuyen(string idTinhSo)
{
int iIdTinhSoDi = Convert.ToInt32(idTinhSo);
try
{
QLVanTai_2017 context = new QLVanTai_2017();
var lstLuongTuyen = context.QLVT_CapTuyenChoTinh_So.Where(u => u.TS_IdTinh_So == iIdTinhSoDi).Select(c =>
new {
c.QLVT_LuongTuyen.LT_IdLuongTuyen,
c.QLVT_LuongTuyen.LT_MaTuyen,
c.QLVT_LuongTuyen.LT_HanhTrinhChay,
c.QLVT_LuongTuyen.LT_CuLy,
c.QLVT_LuongTuyen.LT_LuuLuongQuyDinh,
c.QLVT_LuongTuyen.TT_IdTrangThaiTuyen,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_TrangThai.TT_TenTrangThai,
c.QLVT_LuongTuyen.LT_PL_IdLuongTuyen,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_PhanLoai.LT_PL_TenLoai,
c.QLVT_LuongTuyen.LT_DC_IdLuongTuyen,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01,
c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02,
IdTinhSoDi = context.QLVT_ThongTinBenXe.FirstOrDefault(d => d.BX_IdBenXe == c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01).TS_IdTinh_So,
IdTinhSoDen = context.QLVT_ThongTinBenXe.FirstOrDefault(d => d.BX_IdBenXe == c.QLVT_LuongTuyen.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02).TS_IdTinh_So,
}).ToList();
//var lstLuongTuyen = context.QLVT_LuongTuyen.Select(u => new
//{
// LT_IdLuongTuyen = u.LT_IdLuongTuyen,
// LT_MaTuyen = u.LT_MaTuyen,
// LT_HanhTrinhChay = u.LT_HanhTrinhChay,
// LT_CuLy = u.LT_CuLy,
// LT_LuuLuongQuyDinh = u.LT_LuuLuongQuyDinh,
// TT_IdTrangThaiTuyen = u.TT_IdTrangThaiTuyen,
// TrangThaiTuyen = u.QLVT_LuongTuyen_TrangThai.TT_TenTrangThai,
// LT_PL_IdLuongTuyen = u.LT_PL_IdLuongTuyen,
// PhanLoaiLuongTuyen = u.QLVT_LuongTuyen_PhanLoai.LT_PL_TenLoai,
// LT_DC_IdLuongTuyen = u.LT_DC_IdLuongTuyen,
// LT_DC_IdBen_01 = u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01,
// LT_DC_IdBen_02 = u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02,
// LT_DC_TenBen_01 = u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_01,
// LT_DC_TenBen_02 = u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_TenBen_02,
// IdTinhSoDi = context.QLVT_ThongTinBenXe.FirstOrDefault(c => c.BX_IdBenXe == u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_01).TS_IdTinh_So,
// IdTinhSoDen = context.QLVT_ThongTinBenXe.FirstOrDefault(c => c.BX_IdBenXe == u.QLVT_LuongTuyen_DiemDauCuoi.LT_DC_IdBen_02).TS_IdTinh_So,
//}).ToList();
return(Json(new { status = true, data = lstLuongTuyen }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = false, error = "Lấy dữ liệu thất bại" }, JsonRequestBehavior.AllowGet));
}
return(null);
}
// GET: QuanLyBenXe
public ActionResult Index()
{
try
{
QLVanTai_2017 context = new QLVanTai_2017();
var lstBenXe = context.QLVT_ThongTinBenXe.Select(u => new
{
BX_IdBenXe = u.BX_IdBenXe,
TenBenXe = u.TenBenXe,
MaBen = u.MaBen,
TS_IdTinh_So = u.TS_IdTinh_So,
TenTinhSo = u.QLVT_ThongTinTinh_SoGiaoThong.TS_TenTinh,
DiaChi = u.DiaChi,
SDT = u.SDT,
CoQuanQuanLy = u.CoQuanQuanLy,
TongDienTich = u.TongDienTich,
DienTich_XeKhach = u.DienTich_XeKhach,
DienTich_PhuongTienKhac = u.DienTich_PhuongTienKhac,
DienTich_NhaCho = u.DienTich_NhaCho,
LoaiBenXe = u.LoaiBenXe,
SoTuyenQuyHoach = u.SoTuyenQuyHoach,
SoLuotXuatBenQuyHoach = u.SoLuotXuatBenQuyHoach,
GhiChu = u.GhiChu,
TS_TT_IdTrangThai = u.TS_TT_IdTrangThai,
TrangThai = u.QLVT_ThongTinTinh_So_Ben_TrangThai.TS_TT_TenTrangThai
}).ToList();
ViewBag.dataGridBenXe = JsonConvert.SerializeObject(lstBenXe);
var lstTinhSo = context.QLVT_ThongTinTinh_SoGiaoThong.Where(u => u.TS_TT_IdTrangThai == 1)
.Select(u => new
{
u.TS_IdTinh_So,
u.TS_IdMaTinh,
u.TS_TenTinh
}).ToList();
ViewBag.lstTinhSo = JsonConvert.SerializeObject(lstTinhSo);
var lstTrangThaiBenXe = context.QLVT_ThongTinTinh_So_Ben_TrangThai
.Select(u => new
{
u.TS_TT_IdTrangThai,
u.TS_TT_TenTrangThai
}).ToList();
ViewBag.lstTrangThaiBenXe = JsonConvert.SerializeObject(lstTrangThaiBenXe);
}
catch (Exception e)
{
//ViewBag.dataGridBenXe = Json(new { status = false, error = "Lấy dữ liệu thất bại." }, JsonRequestBehavior.AllowGet).ToString();
}
return(View());
}
public List <int> TocDoTangTruongTheoNam()
{
List <int> lis = new List <int>();
QLVanTai_2017 dbc = new QLVanTai_2017();
for (int i = DateTime.Now.Year; i >= 2005; i--)
{
var SoLuong = dbc.QLVT_ThongTinXe.Where(ptr =>
(ptr.TX_NgayThemMoi.Value.Year <= i) && (ptr.TX_NgayNgungHoatDong.Value.Year >= i)).ToList();
lis.Add(SoLuong.Count);
}
return(lis);
}
public List <int> TocDoTangTruongTheoThang()
{
List <int> lis = new List <int>();
QLVanTai_2017 dbc = new QLVanTai_2017();
for (int i = 1; i <= DateTime.Now.Month; i++)
{
var SoLuong = dbc.QLVT_ThongTinXe.Where(ptr =>
(ptr.TX_NgayThemMoi.Value.Month <= i || ptr.TX_NgayThemMoi.Value.Year <= DateTime.Now.Year) && (ptr.TX_NgayNgungHoatDong.Value.Month >= i || ptr.TX_NgayNgungHoatDong.Value.Year >= DateTime.Now.Year)).ToList();
lis.Add(SoLuong.Count);
}
return(lis);
}
public List <int> TongLuotVanChuyenThucTe()
{
QLVanTai_2017 dbc = new QLVanTai_2017();
List <int> lis = new List <int>();
for (int item = 1; item <= DateTime.Now.Day; item++)
{
DateTime a = new DateTime(DateTime.Now.Year, DateTime.Now.Month, item);
var temp = dbc.NhatTrinhXes.Where(ptr => EntityFunctions.TruncateTime(ptr.GioCapXuatBen) == a.Date && ptr.XeXepKhach.Value == true).ToList();
lis.Add(temp.Count);
}
return(lis);
}
public JsonResult GetBCKhongThucHienTQ(string LstSo, string TuNgay, string DenNgay)
{
try
{
QLVanTai_2017 dbc = new QLVanTai_2017();
LstSo = "," + LstSo;
var BC = dbc.sp_HD_BaoCaoXeKhongHoatDong_ToanQuoc(TuNgay, DenNgay, LstSo).ToList();
return(Json(new { status = true, messeage = "Lấy dữ liệu thành công", data = BC }));
}
catch (Exception e)
{
return(Json(new { status = false, messeage = "Lấy dữ liệu thất bại", data = "" }));
}
}
/// <summary>
/// Báo cáo mặc định
/// </summary>
/// <returns></returns>
public ActionResult BaoCaoTaiSo()
{
QLVanTai_2017 en = new QLVanTai_2017();
int Id_So = 55; // mặc định
// lấy danh sách sở
var lstSo = en.QLVT_ThongTinTinh_SoGiaoThong
.Select(s => new
{
s.TS_IdTinh_So,
s.TS_TenTinh
}).ToList();
ViewBag.lstSo = lstSo;
// lấy danh sách tuyến
var lstTuyen = en.GetThongTinTuyen_IdSo(Id_So).ToList();
lstTuyen.Insert(0, new GetThongTinTuyen_IdSo_Result {
LT_IdLuongTuyen = -1, TenTuyenn = "Tất cả"
});
ViewBag.lstTuyen = lstTuyen;
// lấy báo cáo
int thang = DateTime.Now.Month;
int nam = DateTime.Now.Year;
try
{
var lstBCSoDuoi70 = en.sp_HD_BaoCaoXeChayNhoHon70_SoGiaoThong(thang, nam, Id_So).ToList();
ViewBag.dataGrid = lstBCSoDuoi70;
}
catch (Exception ex)
{
string ss = ex.ToString();
}
// khởi tạo mặc định
dynamic dataDefault = new
{
Id_So,
thang,
nam,
};
ViewBag.dataDefault = dataDefault;
return(View());
}
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));
}
}
