public static List <LoaiNhanVienViewModel> DanhSachLoaiNhanVien()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from Loainv in entity.LoaiNhanViens
select new LoaiNhanVienViewModel()
{
MaLoaiNV = Loainv.MaLoaiNV,
TenLoaiNV = Loainv.TenLoaiNV,
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Lay Danh sach quyen
/// </summary>
/// <returns></returns>
public static List <QuyenViewModel> LayDanhSachQuyen()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from q in entity.Quyens
select new QuyenViewModel
{
MaQuyen = q.MaQuyen,
TenQuyen = q.TenQuyen
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
public static List <Tinh_TPViewModel> LayDanhSachTinh_TP()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from Tinh in entity.Tinh_TPs
select new Tinh_TPViewModel()
{
MaTinh = Tinh.MaTinh,
TenTinh = Tinh.TenTinh
}).OrderBy(n => n.MaTinh).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Thêm lộ trình
/// </summary>
/// <param name="lotrinh"></param>
/// <returns></returns>
public static Boolean ThemLoTrinh(LoTrinhViewModel lotrinh)
{
var entity = new QuanLyThueXeEntities();
try
{
var lt = new LoTrinh();
lt.MaLoTrinh = TuTangMaLT();
lt.TenLoTrinh = lotrinh.TenLoTrinh;
lt.Dang = true;
lt.MaKH = lotrinh.MaKH;
entity.LoTrinhs.Add(lt);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
// END
#endregion
#region Cập nhật điều phối xe
/// <summary>
/// Cập nhật điều phối xe
/// </summary>
/// <param name="CTHD"></param>
/// <returns></returns>
//Begin
public static Boolean CapNhatDieuPhoiXe(CT_HopDongViewModel CTHD)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = entity.CT_HopDongs.SingleOrDefault(n => n.SoCTHopDong == CTHD.SoCTHopDong);
result.MaLoaiXe = CTHD.MaLoaiXe;
result.MaXe = CTHD.MaXe;
result.BienSoXe = CTHD.BienSoXe;
result.MaCongTy = CTHD.MaCongTy;
result.SoLuongNguoi = CTHD.SoLuongNguoi;
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
//thêm loại nhân viên
public static Boolean ThemLoaiNV(LoaiNhanVienViewModel loainv)
{
var entity = new QuanLyThueXeEntities();
try
{
var lnv = new LoaiNhanVien();
lnv.MaLoaiNV = TuTangMaLNV();
lnv.TenLoaiNV = loainv.TenLoaiNV;
lnv.Dang = true;
lnv.MaLuong = loainv.MaLuong;
entity.LoaiNhanViens.Add(lnv);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
public static List <TaiKhoanViewModel> LayDanhSachTaiKhoan()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from tk in entity.TaiKhoans
where tk.TaiKhoanNV != "admin"
select new TaiKhoanViewModel()
{
MaNV = tk.MaNV,
MaQuyen = tk.MaQuyen,
MatKhau = tk.MatKhau,
STT = tk.STT,
TaiKhoanNV = tk.TaiKhoanNV,
Online = tk.Online,
NhanViens = (
from nv in entity.NhanViens
where nv.MaNV == tk.MaNV
select new NhanVienViewModel()
{
HoTen = nv.HoTen
}).FirstOrDefault(),
Quyens = (
from q in entity.Quyens
where q.MaQuyen == tk.MaQuyen
select new QuyenViewModel()
{
TenQuyen = q.TenQuyen,
}).FirstOrDefault(),
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// End
#endregion
#region Thêm xe
/// <summary>
/// Thêm xe
/// </summary>
/// <param name="xe"></param>
/// <returns>Boolean</returns>
/// Begin
public static Boolean ThemXe(XeViewModel xe)
{
var entity = new QuanLyThueXeEntities();
try
{
var x = new Xe();
x.MaXe = TangMaXe();
x.BienSo = xe.BienSo;
x.Mota = xe.MoTa;
x.MaLoaiXe = xe.MaLoaiXe;
x.HinhAnh = xe.HinhAnh;
x.Dang = true;
x.MaCongTy = xe.MaCongTy;
x.MaThuongHieu = xe.MaThuongHieu;
x.NgayDangKiem = xe.NgayDangKiem;
x.GhiChu = xe.GhiChu;
x.Status = "0";
x.NgayBaoTriXe = xe.NgayBaoTriXe;
x.SoKm = xe.SoKm;
x.SoLan = 0;
x.ThoiGianGanDay = DateTime.Now;
x.MaNV = xe.MaNV;
x.BaoHiemTuNguyen = xe.BaoHiemTuNguyen;
x.BaoHiemBatBuoc = xe.BaoHiemBatBuoc;
x.NgayDangKi = xe.DangKi;
x.DangKiem = xe.DangKiem;
x.HopDong = xe.HopDong;
x.ChuXe = xe.ChuXe;
x.DiaChi = xe.DiaChi;
entity.Xes.Add(x);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
/// <summary>
/// Thêm khach hang
/// </summary>
/// <param KhachHangViewModel="KH"></param>
/// <returns>Boolean</returns>
public static Boolean ThemKhachHangThanThiet(KhachHangViewModel KH)
{
var entity = new QuanLyThueXeEntities();
try
{
var KhHang = new KhachHang();
KhHang.MaKH = TuTangMaKH();
if (String.IsNullOrEmpty(KH.TenCongTy))
{
KhHang.TenKH = KH.NguoiLienHe;
}
else
{
KhHang.TenKH = KH.TenCongTy;
}
KhHang.GioiTinh = KH.GioiTinh;
KhHang.Email = KH.Email;
KhHang.CMND = KH.CMND;
KhHang.DiaChiKH = KH.DiaChiKH;
KhHang.SDT = KH.SDT;
KhHang.MaLoaiKH = "LKH2";
KhHang.TenCongTy = KH.TenCongTy;
KhHang.SDTCongTy = KH.SDTCongTy;
KhHang.GhiChu = KH.GhiChu;
KhHang.DiaChiCongTy = KH.DiaChiCongTy;
KhHang.NguoiLienHe = KH.NguoiLienHe;
KhHang.GiamGia = 0;
KhHang.MaSoThue = KH.MaSoThue;
KhHang.Dang = true;
entity.KhachHangs.Add(KhHang);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
/// <summary>
/// Chi tiet tai khoan
/// </summary>
/// <param name=""></param>
/// <returns>TaiKhoanViewModel</returns>
//chi tiết tài khoản
public static TaiKhoanViewModel LayChiTietTaiKhoan(string Taikhoan)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from tk in entity.TaiKhoans
where tk.TaiKhoanNV == Taikhoan
select new TaiKhoanViewModel()
{
MaNV = tk.MaNV,
MaQuyen = tk.MaQuyen,
MatKhau = tk.MatKhau,
STT = tk.STT,
TaiKhoanNV = tk.TaiKhoanNV,
NhanViens = (
from nv in entity.NhanViens
where nv.MaNV == tk.MaNV
select new NhanVienViewModel()
{
HoTen = nv.HoTen
}).FirstOrDefault(),
Quyens = (
from q in entity.Quyens
where q.MaQuyen == tk.MaQuyen
select new QuyenViewModel()
{
TenQuyen = q.TenQuyen,
}).FirstOrDefault(),
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
public static List <TrangThaiHopDongViewModel> LayDanhSachTrangThai()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from tt in entity.TrangThaiHopDongs
select new TrangThaiHopDongViewModel()
{
MaTrangThai = tt.MaTrangThai,
TenTrangThai = tt.TenTrangThai
}
).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// chỉnh sửa bảng giá
/// </summary>
/// <param name="bg"></param>
/// <returns></returns>
public static Boolean ChinhsuaGia(BangGiaViewModel bg)
{
var entity = new QuanLyThueXeEntities();
try
{
var BG = entity.BangGias.SingleOrDefault(n => n.MaBangGia == bg.MaBangGia);
BG.MaLoaiXe = bg.MaLoaiXe;
BG.MaKH = bg.MaKH;
BG.MaLoTrinh = bg.MaLoTrinh;
BG.Gia = bg.Gia;
BG.ThoiGian = bg.ThoiGian;
BG.SoKM = bg.SoKM;
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
// chỉnh sửa phiếu chi
public static Boolean ChinhSuaPC(PhieuChiViewModel pc)
{
var entity = new QuanLyThueXeEntities();
try
{
var Pc = entity.PhieuChis.SingleOrDefault(n => n.SoPhieuChi == pc.SoPhieuChi);
Pc.MaNV = pc.MaNV;
Pc.LyDo = pc.LyDo;
Pc.NgayChi = pc.NgayChi;
Pc.SoTienChi = pc.SoTienChi;
Pc.NguoiNhan = pc.NguoiNhan;
Pc.DiaChi = pc.DiaChi;
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
public static Boolean ThemCPPS(ChiPhiPhatSinhViewModel CP)
{
var entity = new QuanLyThueXeEntities();
try
{
var cp = new ChiPhiPhatSinh();
cp.MaChiPhi = TuTangMaCPPS();
cp.TenChiPhi = CP.TenChiPhi;
cp.PhiPhatSinh = CP.PhiPhatSinh;
cp.Mota = CP.MoTa;
cp.SoLuong = 1;
entity.ChiPhiPhatSinhs.Add(cp);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
public static List <PhanQuyenViewModel> LayDanhSachPhanQuyen(String MaQuyen)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from pq in entity.PhanQuyens
where pq.MaQuyen == MaQuyen
select new PhanQuyenViewModel()
{
MaQuyen = pq.MaQuyen,
MaAction = pq.MaAction
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
//thông tin chi tiết loại khách hàng
public static LoaiKhachHangViewModel ChiTiet_LoaiKH(String MaLoaiKH)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from loaikh in entity.LoaiKhachHangs
where loaikh.MaLoaiKH == MaLoaiKH
select new LoaiKhachHangViewModel()
{
MaLoaiKH = loaikh.MaLoaiKH,
TenLoaiKH = loaikh.TenLoaiKH,
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
// chỉnh sửa phiếu thu
public static Boolean ChinhSuaPT(PhieuThuViewModel pt)
{
var entity = new QuanLyThueXeEntities();
try
{
var Pt = entity.PhieuThus.SingleOrDefault(n => n.SoPhieuThu == pt.SoPhieuThu);
Pt.MaNV = pt.MaNV;
Pt.LyDo = pt.LyDo;
Pt.NgayThu = pt.NgayThu;
Pt.SoTienThu = pt.SoTienThu;
Pt.DiaChi = pt.DiaChi;
Pt.NguoiNop = pt.NguoiNop;
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
//lấy danh sách bằng
public static List <LoaiBangViewModel> LayDanhSachLoaiBang()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from BL in entity.LoaiBangs
select new LoaiBangViewModel
{
MaBang = BL.MaBang,
TenBang = BL.TenBang,
MoTa = BL.MoTa
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Lay thong tin chi tiet quyen
/// </summary>
/// <param name="MaQuyen"></param>
/// <returns></returns>
public static QuyenViewModel LayThongTinChiTiet(string MaQuyen)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from q in entity.Quyens
where q.MaQuyen == MaQuyen
select new QuyenViewModel()
{
MaQuyen = q.MaQuyen,
TenQuyen = q.TenQuyen
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
public static Boolean ThemNhanVien(NhanVienViewModel NV)
{
var entity = new QuanLyThueXeEntities();
try
{
var nv = new NhanVien();
nv.MaNV = TuTangMaNV();
nv.MaLoaiNV = NV.MaLoaiNV;
nv.HoTen = NV.HoTen;
nv.NgaySinh = NV.NgaySinh;
nv.DiaChi = NV.DiaChi;
nv.CMND = NV.CMND;
nv.HinhAnh = NV.HinhAnh;
nv.Dang = true;
nv.SDT = NV.SDT;
nv.LuongThuong = NV.LuongThuong;
nv.ThongTinKhac = NV.ThongTinKhac;
nv.MaBang = NV.MaBang;
nv.Status = "0";
nv.MaTinh = NV.MaTinh;
nv.NgayNghi = NV.NgayNghi;
nv.SoLan = 0;
nv.ThoiGianGanDay = DateTime.Now;
nv.GioiTinh = NV.GioiTinh;
nv.Email = NV.Email;
nv.NgayHethan = NV.NgayHetHan;
nv.GPLX = NV.GPLX;
entity.NhanViens.Add(nv);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
//Lay danh sach controller
public static List <LoaiControllerViewModel> LayDanhSachNghiepVu()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from t in entity.LoaiControllers
select new LoaiControllerViewModel()
{
MaController = t.MaController,
TenController = t.TenController,
Icon = t.Icon,
STT = t.STT
}).OrderBy(n => n.STT).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Lấy danh sách loại xe
/// </summary>
/// <returns></returns>
public static List <LoaiXeViewModel> LayDanhSachLoaiXe()
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from lx in entity.LoaiXes
select new LoaiXeViewModel()
{
MaLoaiXe = lx.MaLoaiXe,
TenLoaiXe = lx.TenLoaiXe,
Dang = lx.Dang,
STT = lx.STT,
}).OrderBy(n => n.STT).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// thông tin chi tiết 1 loại xe
/// </summary>
/// <param name="MaLoaiXe"></param>
/// <returns></returns>
public static LoaiXeViewModel ChiTiet_LoaiXe(String MaLoaiXe)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from loaixe in entity.LoaiXes
where loaixe.MaLoaiXe == MaLoaiXe
select new LoaiXeViewModel()
{
MaLoaiXe = loaixe.MaLoaiXe,
TenLoaiXe = loaixe.TenLoaiXe,
Dang = loaixe.Dang
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Lấy danh sách lộ trình theo mã khách hàng
/// </summary>
/// <param name="MaKH"></param>
/// <returns></returns>
public static List <LoTrinhViewModel> LayDanhSachLoTrinhTheoMaKH(String MaKH)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from lt in entity.LoTrinhs
where MaKH == lt.MaKH
select new LoTrinhViewModel()
{
MaKH = lt.MaKH,
TenLoTrinh = lt.TenLoTrinh,
MaLoTrinh = lt.MaLoTrinh
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// cap nhat lai trang thai hop dong
/// </summary>
/// <returns>Boolean</returns>
public static Boolean CapNhatTrangThai()
{
var entity = new QuanLyThueXeEntities();
try
{
//Lay danh sach hop dong dang cho
var lstDangCho = entity.HopDongs.Where(n => n.MaTrangThai == "0");
foreach (var dcho in lstDangCho)
{
TrangThaiQueries.CapNhatTrangThaiDangChay(dcho.SoHopDong);
}
TrangThaiQueries.CapNhatTrangThaiPhuXeDangChay();
TrangThaiQueries.CapNhatTrangThaiTaiXeDangChay();
TrangThaiQueries.CapNhatTrangThaiXeDangChay();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
//thông tin chi tiết bằng
public static LoaiBangViewModel ChiTiet_LoaiBang(String MaBang)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from lb in entity.LoaiBangs
where lb.MaBang == MaBang
select new LoaiBangViewModel()
{
MaBang = lb.MaBang,
TenBang = lb.TenBang,
MoTa = lb.MoTa,
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
//END
#endregion
#region Lấy danh sách xe theo loại xe
public static List <XeViewModel> LayDanhSachXeTheoLoaiXe(string MaLoaiXe)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from x in entity.Xes
where (x.MaLoaiXe == MaLoaiXe) && (x.Status == "0" || x.Status == "1") && x.Dang == true
select new XeViewModel()
{
BienSo = x.BienSo,
MaXe = x.MaXe,
Status = x.Status
}).ToList();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
public static Boolean CapNhatThongTinKhachHangThanThiet(KhachHangViewModel khachHang)
{
var entity = new QuanLyThueXeEntities();
try
{
var kh = entity.KhachHangs.SingleOrDefault(n => n.MaKH == khachHang.MaKH);
if (String.IsNullOrEmpty(khachHang.TenCongTy))
{
kh.TenKH = khachHang.NguoiLienHe;
}
else
{
kh.TenKH = khachHang.TenCongTy;
}
kh.GioiTinh = khachHang.GioiTinh;
kh.CMND = khachHang.CMND;
kh.SDT = khachHang.SDT;
kh.Email = khachHang.Email;
kh.DiaChiKH = khachHang.DiaChiKH;
kh.GiamGia = khachHang.GiamGia;
kh.TenCongTy = khachHang.TenCongTy;
kh.NguoiLienHe = khachHang.NguoiLienHe;
kh.SDTCongTy = khachHang.SDTCongTy;
kh.DiaChiCongTy = khachHang.DiaChiCongTy;
kh.MaLoaiKH = khachHang.MaLoaiKH;
kh.GhiChu = khachHang.GhiChu;
kh.MaSoThue = khachHang.MaSoThue;
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
//lay thong tin chi tiet 1 controller
public static LoaiControllerViewModel ThongTinChiTiet(string Macontroller)
{
var entity = new QuanLyThueXeEntities();
try
{
var result = (
from c in entity.LoaiControllers
where c.MaController == Macontroller
select new LoaiControllerViewModel()
{
MaController = c.MaController,
TenController = c.TenController,
Icon = c.Icon,
STT = c.STT
}).SingleOrDefault();
return(result);
}
catch (Exception ex)
{
entity.Dispose();
return(null);
}
}
/// <summary>
/// Thêm phieu thu
/// </summary>
/// <param PhieuThuViewModel="SoPhieuThu"></param>
/// <returns>Boolean</returns>
public static Boolean ThemPhieuThu(PhieuThuViewModel PT)
{
var entity = new QuanLyThueXeEntities();
try
{
var pt = new PhieuThu();
pt.SoPhieuThu = TuTangMaPhieuThu();
pt.LyDo = PT.LyDo;
pt.NgayThu = DateTime.Now;
pt.SoTienThu = PT.SoTienThu;
pt.MaNV = PT.MaNV;
pt.NguoiNop = PT.NguoiNop;
pt.DiaChi = PT.DiaChi;
entity.PhieuThus.Add(pt);
entity.SaveChanges();
return(true);
}
catch (Exception ex)
{
entity.Dispose();
return(false);
}
}
