public static Boolean CapNhatLaiQuyen(String MaQuyen, String strMaAction) { var entity = new QuanLyThueXeEntities(); try { var lstQuyen = entity.PhanQuyens.Where(n => n.MaQuyen == MaQuyen); foreach (var q in lstQuyen) { entity.PhanQuyens.Remove(q); } entity.SaveChanges(); if (!string.IsNullOrEmpty(strMaAction)) { var arrMaAction = strMaAction.Split('#'); foreach (var action in arrMaAction) { var phanQuyen = new PhanQuyen(); phanQuyen.MaQuyen = MaQuyen; phanQuyen.MaAction = int.Parse(action); entity.PhanQuyens.Add(phanQuyen); } entity.SaveChanges(); } return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean TaoTaiKhoan(TaiKhoanViewModel taiKhoan) { var entity = new QuanLyThueXeEntities(); try { var check = entity.TaiKhoans.SingleOrDefault(n => n.TaiKhoanNV == taiKhoan.TaiKhoanNV); if (check != null) { return(false); } TaiKhoan tk = new TaiKhoan(); tk.MaNV = taiKhoan.MaNV; tk.MaQuyen = taiKhoan.MaQuyen; tk.TaiKhoanNV = taiKhoan.TaiKhoanNV; tk.MatKhau = taiKhoan.MatKhau; tk.Online = false; entity.TaiKhoans.Add(tk); entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatTrangThaiXeDangChay() { var entity = new QuanLyThueXeEntities(); try { var hd = entity.HopDongs.Where(n => n.MaTrangThai == "1"); foreach (var item in hd) { var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong); foreach (var c in cthd) { if (c.NgayDi < DateTime.Now) { Xe result = entity.Xes.SingleOrDefault(n => n.MaXe == c.MaXe); result.Status = "2"; } } } entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatThongTinKhachHang(KhachHangViewModel khachHang) { var entity = new QuanLyThueXeEntities(); try { var kh = entity.KhachHangs.SingleOrDefault(n => n.MaKH == khachHang.MaKH); kh.TenKH = khachHang.TenKH; 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); } }
/// <summary> /// Thêm bảng giá /// </summary> /// <param BangGiaViewModel="MaBangGia"></param> /// <returns>Boolean</returns> public static Boolean ThemBangGia(BangGiaViewModel BG) { var entity = new QuanLyThueXeEntities(); try { var bg = new BangGia(); bg.MaBangGia = TuTangMaBG(); bg.MaLoaiXe = BG.MaLoaiXe; bg.MaKH = BG.MaKH; bg.MaLoTrinh = BG.MaLoTrinh; bg.ThoiGian = BG.ThoiGian; bg.SoKM = BG.SoKM; bg.Gia = BG.Gia; bg.Dang = true; entity.BangGias.Add(bg); entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatTrangThaiXeRanh(String SoHopDong) { var entity = new QuanLyThueXeEntities(); try { var hd = entity.HopDongs.Where(n => n.SoHopDong == SoHopDong); foreach (var item in hd) { var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong); foreach (var c in cthd) { Xe result = entity.Xes.SingleOrDefault(n => n.MaXe == c.MaXe); result.Status = "0"; } } entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
//thêm công ty public static Boolean ThemCongTy(CongTiesViewModel CT) { var entity = new QuanLyThueXeEntities(); try { var Ct = new CongTy(); Ct.MaCongTy = TuTangMaCT(); Ct.TenCongTy = CT.TenCongTy; Ct.Email = CT.Email; Ct.DiaChi = CT.DiaChi; Ct.SDT = CT.SDT; Ct.Fax = CT.Fax; Ct.NguoiLienHe = CT.NguoiLienHe; Ct.GhiChu = CT.GhiChu; Ct.Dang = true; entity.CongTies.Add(Ct); entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
///End #endregion #region Chỉnh sửa xe /// <summary> /// Chỉnh sửa xe /// </summary> /// <param name="MaXe"></param> /// <returns>single</returns> // Begin public static Boolean ChinhSuaXe(XeViewModel xe) { var entity = new QuanLyThueXeEntities(); try { var result = entity.Xes.SingleOrDefault(n => n.MaXe == xe.MaXe); result.BienSo = xe.BienSo; result.Mota = xe.MoTa; result.MaLoaiXe = xe.MaLoaiXe; result.HinhAnh = xe.HinhAnh; result.MaCongTy = xe.MaCongTy; result.MaThuongHieu = xe.MaThuongHieu; result.NgayDangKiem = xe.NgayDangKiem; result.GhiChu = xe.GhiChu; result.NgayBaoTriXe = xe.NgayBaoTriXe; result.SoKm = xe.SoKm; result.SoLan = xe.SoLan; result.MaNV = xe.MaNV; result.BaoHiemTuNguyen = xe.BaoHiemTuNguyen; result.BaoHiemBatBuoc = xe.BaoHiemBatBuoc; result.NgayDangKi = xe.DangKi; result.DangKiem = xe.DangKiem; result.HopDong = xe.HopDong; result.ChuXe = xe.ChuXe; result.DiaChi = xe.DiaChi; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatPhuXeBiTrung(String PhuXe, CT_HopDongViewModel CTHDMoi) { var entity = new QuanLyThueXeEntities(); try { var result = entity.CT_HopDongs.Where(n => n.PhuXe == PhuXe); foreach (var CTHDCu in result) { var kq = entity.HopDongs.SingleOrDefault(n => n.SoHopDong == CTHDCu.SoHopDong && n.MaTrangThai == "0"); if (kq != null) { if ( (CTHDMoi.NgayDi > CTHDCu.NgayDi && CTHDMoi.NgayDi < CTHDCu.NgayVe) || (CTHDMoi.NgayVe > CTHDCu.NgayDi && CTHDMoi.NgayVe < CTHDCu.NgayVe) || (CTHDCu.NgayDi > CTHDMoi.NgayDi && CTHDCu.NgayDi < CTHDMoi.NgayVe) || (CTHDCu.NgayVe > CTHDMoi.NgayDi && CTHDCu.NgayVe < CTHDMoi.NgayVe) ) { CTHDCu.PhuXe = null; break; } } } entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatTrangThaiChoThanhToan() { var entity = new QuanLyThueXeEntities(); try { var hd = entity.HopDongs.Where(n => n.MaTrangThai == "1"); foreach (var item in hd) { var cthd = entity.CT_HopDongs.Where(n => n.SoHopDong == item.SoHopDong); foreach (var c in cthd) { if (c.NgayVe < DateTime.Now) { HopDong result = entity.HopDongs.SingleOrDefault(n => n.SoHopDong == c.SoHopDong); result.MaTrangThai = "3"; TrangThaiQueries.CapNhatTrangThaiPhuXeRanh(c.SoHopDong); TrangThaiQueries.CapNhatTrangThaiTaiXeRanh(c.SoHopDong); TrangThaiQueries.CapNhatTrangThaiXeRanh(c.SoHopDong); } } } 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 ThemKhachHang(KhachHangViewModel KH) { var entity = new QuanLyThueXeEntities(); try { var KhHang = new KhachHang(); KhHang.MaKH = TuTangMaKH(); KhHang.TenKH = KH.TenKH; KhHang.GioiTinh = KH.GioiTinh; KhHang.Email = KH.Email; KhHang.CMND = KH.CMND; KhHang.DiaChiKH = KH.DiaChiKH; KhHang.SDT = KH.SDT; KhHang.MaLoaiKH = "LKH1"; 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); } }
// chỉnh sửa thương hiệu xe public static Boolean ChinhSuaTH(ThuongHieuViewModel th) { var entity = new QuanLyThueXeEntities(); try { var Th = entity.ThuongHieuXes.SingleOrDefault(n => n.MaThuongHieu == th.MaThuongHieu); Th.TenThuongHieu = th.TenThuongHieu; entity.SaveChanges(); return true; } catch (Exception ex) { entity.Dispose(); return false; } }
//cap nhat chinh sua 1 action public static Boolean ChinhSuaTinhNang(LoaiActionViewModel action) { var entity = new QuanLyThueXeEntities(); try { var result = entity.LoaiActions.SingleOrDefault(n => n.MaAction == action.MaAction); result.Mota = action.MoTa; entity.SaveChanges(); return true; } catch (Exception ex) { entity.Dispose(); return false; } }
public static Boolean ResetPass(String taiKhoan) { var entity = new QuanLyThueXeEntities(); try { TaiKhoan tk = entity.TaiKhoans.SingleOrDefault(n => n.TaiKhoanNV == taiKhoan); tk.MatKhau = "123456"; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
//cập nhật loại khách hàng public static Boolean ChinhSuaLoaiKH(LoaiKhachHangViewModel loaikh) { var entity = new QuanLyThueXeEntities(); try { var loaiKH = entity.LoaiKhachHangs.SingleOrDefault(n => n.MaLoaiKH == loaikh.MaLoaiKH); loaiKH.TenLoaiKH = loaikh.TenLoaiKH; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// Xóa lộ trình /// </summary> /// <param name="MaLoTrinh"></param> /// <returns></returns> public static Boolean XoaLT(String MaLT) { var entity = new QuanLyThueXeEntities(); try { var LT = entity.LoTrinhs.SingleOrDefault(n => n.MaLoTrinh == MaLT); LT.Dang = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// cập nhật lộ trình /// </summary> /// <param name="lt"></param> /// <returns></returns> public static Boolean ChinhSua_LT(LoTrinhViewModel lt) { var entity = new QuanLyThueXeEntities(); try { var LT = entity.LoTrinhs.SingleOrDefault(n => n.MaLoTrinh == lt.MaLoTrinh); LT.TenLoTrinh = lt.TenLoTrinh; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean ChinhSuaQuyen(QuyenViewModel quyen) { var entity = new QuanLyThueXeEntities(); try { var result = entity.Quyens.SingleOrDefault(n => n.MaQuyen == quyen.MaQuyen); result.TenQuyen = quyen.TenQuyen; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatMaCTy(int SoCTHopDong) { var entity = new QuanLyThueXeEntities(); try { CT_HopDong result = entity.CT_HopDongs.SingleOrDefault(n => n.SoCTHopDong == SoCTHopDong); result.MaCongTy = null; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean DoiMatKhau(TaiKhoanViewModel taiKhoan) { var entity = new QuanLyThueXeEntities(); try { var result = entity.TaiKhoans.SingleOrDefault(n => n.TaiKhoanNV == taiKhoan.TaiKhoanNV); result.MatKhau = taiKhoan.MatKhau; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// Xóa công ty /// </summary> /// <param name="MaCongTy"></param> /// <returns></returns> public static Boolean XoaCty(String MaCongTy) { var entity = new QuanLyThueXeEntities(); try { var CT = entity.CongTies.SingleOrDefault(n => n.MaCongTy == MaCongTy); CT.Dang = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// Xóa xe /// </summary> /// <param name="MaXe"></param> /// <returns></returns> public static Boolean XoaXe(String MaXe) { var entity = new QuanLyThueXeEntities(); try { var Xe = entity.Xes.SingleOrDefault(n => n.MaXe == MaXe); Xe.Dang = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatTrangThaiXeDangCho(String MaXe) { var entity = new QuanLyThueXeEntities(); try { var result = entity.Xes.SingleOrDefault(n => n.MaXe == MaXe); result.Status = "1"; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// Cap Nhat trang thai hoành thành của hợp đồng /// </summary> /// <param name="SoHopDong"></param> /// <returns></returns> public static Boolean CapNhatTrangThaiHoanThanh(String SoHopDong) { var entity = new QuanLyThueXeEntities(); try { var result = entity.HopDongs.SingleOrDefault(n => n.SoHopDong == SoHopDong); result.MaTrangThai = "2"; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// Xóa khách hàng /// </summary> /// <param name="MaKH"></param> /// <returns></returns> #region xóa khách hàng public static Boolean XoaKH(String MaKH) { var entity = new QuanLyThueXeEntities(); try { var KH = entity.KhachHangs.SingleOrDefault(n => n.MaKH == MaKH); KH.Dang = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
/// <summary> /// Xóa nhân viên /// </summary> /// <param name="MaNV"></param> /// <returns></returns> public static Boolean XoaNV(String MaNV) { var entity = new QuanLyThueXeEntities(); try { var NV = entity.NhanViens.SingleOrDefault(n => n.MaNV == MaNV); NV.Dang = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatOffline(String TaiKhoanNV) { var entity = new QuanLyThueXeEntities(); try { TaiKhoan tk = entity.TaiKhoans.SingleOrDefault(n => n.TaiKhoanNV == TaiKhoanNV); tk.Online = false; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
public static Boolean CapNhatNhanVienBoChon(String MaNV) { var entity = new QuanLyThueXeEntities(); try { var result = entity.NhanViens.SingleOrDefault(n => n.MaNV == MaNV); result.Status = "0"; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
//cap nhat controller public static Boolean ChinhSuaNghiepVu(LoaiControllerViewModel controller) { var entity = new QuanLyThueXeEntities(); try { var loaiController = entity.LoaiControllers.SingleOrDefault(n => n.MaController == controller.MaController); loaiController.TenController = controller.TenController; loaiController.Icon = controller.Icon; entity.SaveChanges(); return(true); } catch (Exception ex) { entity.Dispose(); return(false); } }
//thêm mới thương hiệu public static Boolean ThemTH(ThuongHieuViewModel th) { var entity = new QuanLyThueXeEntities(); try { var TH = new ThuongHieuXe(); TH.MaThuongHieu = TuTangMaTHX(); TH.TenThuongHieu = th.TenThuongHieu; entity.ThuongHieuXes.Add(TH); entity.SaveChanges(); return true; } catch (Exception ex) { entity.Dispose(); return false; } }