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