//Lay du lieu tu bang QLHoaDon
public System.Data.Linq.Table <QLHoaDon> LayHD()
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
return(qlNX.QLHoaDons);
}
//Lay du lieu tu bang QLNhanVien
public System.Data.Linq.Table <QLNhanVien> LayNV()
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
return(qlNX.QLNhanViens);
}
//Cap nhat du lieu hoa don tu bang du lieu QLHoaDon
public bool CapNhatHD(string MaKH, string TenKhachHang, string DiaChi, string DienThoai, string BienSo, string LoaiXe, string NgayGui, string HinhThucGui, string ThanhTien, ref string err)
{
try
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var hdQuery = (from hd in qlNX.QLHoaDons
where hd.BienSo == BienSo
select hd).SingleOrDefault();
if (hdQuery != null)
{
hdQuery.MaKH = MaKH;
hdQuery.TenKhachHang = TenKhachHang;
hdQuery.DiaChi = DiaChi;
hdQuery.DienThoai = DienThoai;
hdQuery.BienSo = BienSo;
hdQuery.LoaiXe = LoaiXe;
hdQuery.NgayGui = NgayGui;
hdQuery.HinhThucGui = HinhThucGui;
hdQuery.ThanhTien = ThanhTien;
}
return(true);
}
catch (ExecutionEngineException e)
{
MessageBox.Show("e");
return(false);
}
}
//Cap nhat du lieu xe tu bang du lieu QLXe
public bool CapNhatXe(string Bienso, string LoaiXe, string NgayGui, string HinhThucGui, string MaKH, ref string err)
{
try
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var xeQuery = (from xe in qlNX.QLXes
where xe.Bienso == Bienso
select xe).SingleOrDefault();
if (xeQuery != null)
{
xeQuery.Bienso = Bienso;
xeQuery.LoaiXe = LoaiXe;
xeQuery.NgayGui = NgayGui;
xeQuery.HinhThucGui = HinhThucGui;
xeQuery.NgayGui = NgayGui;
xeQuery.MaKH = MaKH;
}
return(true);
}
catch (ExecutionEngineException e)
{
MessageBox.Show("e");
return(false);
}
}
//Lay du lieu tu bang QLXe
public System.Data.Linq.Table <QLXe> LayXe()
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
return(qlNX.QLXes);
}
//Lay du lieu tu bang QLKhachHang
public System.Data.Linq.Table <QLKhachHang> LayKH()
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
return(qlNX.QLKhachHangs);
}
//Tim du lieu hoa don
public void TimHD(string MaKH, DataGridView dgv)
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var hdQuery = (from hd in qlNX.QLHoaDons
where hd.MaKH == MaKH
select hd).ToList();
dgv.DataSource = hdQuery;
}
//Tim du lieu khach hang
public void TimKH(string MaKH, DataGridView dgv)
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var khQuery = (from kh in qlNX.QLKhachHangs
where kh.MaKH == MaKH
select kh).ToList();
dgv.DataSource = khQuery;
}
//Tim du lieu nhan vien
public void TimNV(string MaNV, DataGridView dgv)
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var nvQuery = (from nv in qlNX.QLNhanViens
where nv.MaNV == MaNV
select nv).ToList();
dgv.DataSource = nvQuery;
}
//Tim du lieu nhan vien
public void TimXe(string BienSo, DataGridView dgv)
{
DataSet ds = new DataSet();
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var xeQuery = (from xe in qlNX.QLXes
where xe.Bienso == BienSo
select xe).ToList();
dgv.DataSource = xeQuery;
}
//Xoa du lieu khach hang tu bang du lieu QLKhachHang
public bool XoaKH(ref string err, string MaKH)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var khQuery = from kh in qlNX.QLKhachHangs
where kh.MaKH == MaKH
select kh;
qlNX.QLKhachHangs.DeleteAllOnSubmit(khQuery);
qlNX.SubmitChanges();
return(true);
}
//Xoa du lieu hoa don tu bang du lieu QLHoaDon
public bool XoaHD(ref string err, string BienSo)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var hdQuery = from hd in qlNX.QLHoaDons
where hd.BienSo == BienSo
select hd;
qlNX.QLHoaDons.DeleteAllOnSubmit(hdQuery);
qlNX.SubmitChanges();
return(true);
}
//Xoa du lieu nhan vien tu bang du lieu QLNhanVien
public bool XoaNhanVien(ref string err, string MaNV)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var nvQuery = from nv in qlNX.QLNhanViens
where nv.MaNV == MaNV
select nv;
qlNX.QLNhanViens.DeleteAllOnSubmit(nvQuery);
qlNX.SubmitChanges();
return(true);
}
//Xoa du lieu xe tu bang du lieu QLXe
public bool XoaXe(ref string err, string BienSo)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var xeQuery = from xe in qlNX.QLXes
where xe.Bienso == BienSo
select xe;
qlNX.QLXes.DeleteAllOnSubmit(xeQuery);
qlNX.SubmitChanges();
return(true);
}
//Them du lieu khach hang tu bang du lieu QLKhachHang
public bool ThemKH(string MaKH, string TenKhachHang, string DiaChi, string DienThoai, ref string err)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
QLKhachHang kh = new QLKhachHang();
kh.MaKH = MaKH;
kh.HoTen = TenKhachHang;
kh.DiaChi = DiaChi;
kh.SoDienThoai = DienThoai;
qlNX.QLKhachHangs.InsertOnSubmit(kh);
qlNX.QLKhachHangs.Context.SubmitChanges();
return(true);
}
//Them du lieu xe tu bang du lieu QLXe
public bool ThemXe(string Bienso, string LoaiXe, string NgayGui, string HinhThucGui, string MaKH, ref string err)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
QLXe xe = new QLXe();
xe.Bienso = Bienso;
xe.LoaiXe = LoaiXe;
xe.NgayGui = NgayGui;
xe.HinhThucGui = HinhThucGui;
xe.MaKH = MaKH;
qlNX.QLXes.InsertOnSubmit(xe);
qlNX.QLXes.Context.SubmitChanges();
return(true);
}
//Them du lieu nhan vien tu bang du lieu QLNhanVien
public bool ThemNV(string MaNV, string HoTen, string NgaySinh, string GioiTinh, string DiaChi, ref string err)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
QLNhanVien nv = new QLNhanVien();
nv.MaNV = MaNV;
nv.HoTen = HoTen;
nv.NgaySinh = NgaySinh;
nv.GioiTinh = GioiTinh;
nv.DiaChi = DiaChi;
qlNX.QLNhanViens.InsertOnSubmit(nv);
qlNX.QLNhanViens.Context.SubmitChanges();
return(true);
}
//Them du lieu hoa don tu bang du lieu QLHoaDon
public bool ThemHD(string MaKH, string TenKhachHang, string DiaChi, string DienThoai, string BienSo, string LoaiXe, string NgayGui, string HinhThucGui, string ThanhTien, ref string err)
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
QLHoaDon hd = new QLHoaDon();
hd.MaKH = MaKH;
hd.TenKhachHang = TenKhachHang;
hd.DiaChi = DiaChi;
hd.DienThoai = DienThoai;
hd.BienSo = BienSo;
hd.LoaiXe = LoaiXe;
hd.NgayGui = NgayGui;
hd.HinhThucGui = HinhThucGui;
hd.NgayGui = NgayGui;
hd.ThanhTien = ThanhTien;
qlNX.QLHoaDons.InsertOnSubmit(hd);
qlNX.QLHoaDons.Context.SubmitChanges();
return(true);
}
//Cap nhat du lieu khach hang tu bang du lieu QLKhachHang
public bool CapNhatKH(string MaKH, string TenKhachHang, string DiaChi, string DienThoai, ref string err)
{
try
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var khQuery = (from kh in qlNX.QLKhachHangs
where kh.MaKH == MaKH
select kh).SingleOrDefault();
if (khQuery != null)
{
khQuery.MaKH = MaKH;
khQuery.HoTen = TenKhachHang;
khQuery.DiaChi = DiaChi;
khQuery.SoDienThoai = DienThoai;
}
return(true);
}
catch (ExecutionEngineException e)
{
MessageBox.Show("e");
return(false);
}
}
//Cap Nhat du lieu nhan vien tu bang du lieu QLNhanVien
public bool CapNhatNhanVien(string MaNV, string HoTen, string NgaySinh, string GioiTinh, string DiaChi, ref string err)
{
try
{
QLNhaXeDataContext qlNX = new QLNhaXeDataContext();
var nvQuery = (from nv in qlNX.QLNhanViens
where nv.MaNV == nv.MaNV
select nv).SingleOrDefault();
if (nvQuery != null)
{
nvQuery.MaNV = MaNV;
nvQuery.HoTen = HoTen;
nvQuery.NgaySinh = NgaySinh;
nvQuery.GioiTinh = GioiTinh;
nvQuery.DiaChi = DiaChi;
}
return(true);
}
catch (ExecutionEngineException e)
{
MessageBox.Show("e");
return(false);
}
}
