public bool addCanBo(CanBo canBo)
{
using (var db = new QLHTGTEntities())
{
CanBo cbo = this.findByUsername(canBo.username);
if (cbo != null)
{
return(false);
}
try
{
db.CanBoes.Add(canBo);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public HoaDon addHoaDon(HoaDon hoaDon)
{
using (var db = new QLHTGTEntities())
{
HinhThucThanhToan hinhThucThanhToan = db.HinhThucThanhToans.Where(n => n.ID == hoaDon.HinhThucThanhToan_id).FirstOrDefault();
if (hinhThucThanhToan != null)
{
try
{
hoaDon.HinhThucThanhToan = hinhThucThanhToan;
db.HoaDons.Add(hoaDon);
if (db.SaveChanges() > 0)
{
return(hoaDon);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}
}
return(null);
}
public bool updateXe(Xe xe)
{
using (var db = new QLHTGTEntities())
{
try
{
Xe xeUpdate = db.Xes.Find(xe.ID);
if (xe == null)
{
return(false);
}
xeUpdate.SoKhung = xe.SoKhung;
xeUpdate.SoMay = xe.SoMay;
xeUpdate.NguoiDung_id = xe.NguoiDung_id;
xeUpdate.LoaiXe_id = xe.LoaiXe_id;
xeUpdate.GiaTien = xe.GiaTien;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool doiMatKhau(int id, string matkhau)
{
using (var db = new QLHTGTEntities())
{
try
{
NguoiDung user = db.NguoiDungs.Find(id);
if (user == null)
{
return(false);
}
user.password = matkhau;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateYeuCauDangKyXe(YeuCauDangKyXe yeuCauDangKyXe)
{
using (var db = new QLHTGTEntities())
{
try
{
YeuCauDangKyXe yeuCauDangKyXeUpdate = db.YeuCauDangKyXes.Find(yeuCauDangKyXe.ID);
if (yeuCauDangKyXe == null)
{
return(false);
}
yeuCauDangKyXeUpdate.SoKhung = yeuCauDangKyXe.SoKhung;
yeuCauDangKyXeUpdate.SoMay = yeuCauDangKyXe.SoMay;
yeuCauDangKyXeUpdate.GiaTien = yeuCauDangKyXe.GiaTien;
yeuCauDangKyXeUpdate.NgayHen = yeuCauDangKyXe.NgayHen;
yeuCauDangKyXeUpdate.HDTruocBa = yeuCauDangKyXe.HDTruocBa;
yeuCauDangKyXeUpdate.HDCapBien = yeuCauDangKyXe.HDCapBien;
yeuCauDangKyXeUpdate.NguoiDung_id = yeuCauDangKyXe.NguoiDung_id;
yeuCauDangKyXeUpdate.LoaiXe_id = yeuCauDangKyXe.LoaiXe_id;
yeuCauDangKyXeUpdate.MPTruocBa_id = yeuCauDangKyXe.MPTruocBa_id;
yeuCauDangKyXeUpdate.MPCapBien_id = yeuCauDangKyXe.MPCapBien_id;
yeuCauDangKyXeUpdate.CanBo_id = yeuCauDangKyXe.CanBo_id;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool addXe(Xe xe)
{
using (var db = new QLHTGTEntities())
{
NguoiDung nguoiDung = db.NguoiDungs.Where(n => n.ID == xe.NguoiDung_id).FirstOrDefault();
LoaiXe loaiXe = db.LoaiXes.Where(n => n.ID == xe.LoaiXe_id).FirstOrDefault();
if (nguoiDung != null && loaiXe != null)
{
try
{
xe.NguoiDung = nguoiDung;
db.Xes.Add(xe);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
return(false);
}
public bool addYeuCauDangKyXe(YeuCauDangKyXe yeuCauDangKyXe)
{
using (var db = new QLHTGTEntities())
{
NguoiDung nguoiDung = db.NguoiDungs.Where(n => n.ID == yeuCauDangKyXe.NguoiDung_id).FirstOrDefault();
LoaiXe loaiXe = db.LoaiXes.Where(n => n.ID == yeuCauDangKyXe.LoaiXe_id).FirstOrDefault();
MucPhiTruocBa mucPhiTruocBa = db.MucPhiTruocBas.Where(n => n.ID == yeuCauDangKyXe.MPTruocBa_id).FirstOrDefault();
MucPhiCapBien mucPhiCapBien = db.MucPhiCapBiens.Where(n => n.ID == yeuCauDangKyXe.MPCapBien_id).FirstOrDefault();
CanBo canBo = db.CanBoes.Where(n => n.ID == yeuCauDangKyXe.CanBo_id).FirstOrDefault();
if (nguoiDung != null &&
loaiXe != null &&
mucPhiTruocBa != null &&
mucPhiCapBien != null &&
canBo != null
)
{
try
{
yeuCauDangKyXe.NguoiDung = nguoiDung;
db.YeuCauDangKyXes.Add(yeuCauDangKyXe);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
return(false);
}
public bool updateHoaDon(HoaDon hoaDon)
{
using (var db = new QLHTGTEntities())
{
try
{
HoaDon hoaDonUpdate = db.HoaDons.Find(hoaDon.ID);
if (hoaDon == null)
{
return(false);
}
hoaDonUpdate.ThanhTien = hoaDon.ThanhTien;
hoaDonUpdate.NgayThanhToan = hoaDon.NgayThanhToan;
hoaDonUpdate.HinhThucThanhToan_id = hoaDon.HinhThucThanhToan_id;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateMucPhiCapBien(MucPhiCapBien mucPhiCapBien)
{
using (var db = new QLHTGTEntities())
{
try
{
MucPhiCapBien mucPhiCapBienUpdate = db.MucPhiCapBiens.Find(mucPhiCapBien.ID);
if (mucPhiCapBien == null)
{
return(false);
}
mucPhiCapBienUpdate.LoaiXe = mucPhiCapBien.LoaiXe;
mucPhiCapBienUpdate.KhuVuc = mucPhiCapBien.KhuVuc;
mucPhiCapBienUpdate.MucPhi = mucPhiCapBien.MucPhi;
mucPhiCapBienUpdate.GiaToiThieu = mucPhiCapBien.GiaToiThieu;
mucPhiCapBienUpdate.GiaToiDa = mucPhiCapBien.GiaToiDa;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateCanBo(CanBo canBo)
{
using (var db = new QLHTGTEntities())
{
try
{
CanBo canBoUpdate = db.CanBoes.Where(n => n.username == canBo.username).FirstOrDefault();
if (canBoUpdate == null)
{
return(false);
}
canBoUpdate.Ten = canBo.Ten;
canBoUpdate.Bac = canBo.Bac;
canBoUpdate.username = canBo.username;
canBoUpdate.password = canBo.password;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool doiMatKhau(string username, string oldPassword, string newPassword)
{
using (var db = new QLHTGTEntities())
{
try
{
CanBo canBo = db.CanBoes.Where(n => n.username == username).FirstOrDefault();
if (canBo == null || canBo.password != oldPassword)
{
return(false);
}
canBo.password = newPassword;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool addBangLai(BangLai bangLai)
{
using (var db = new QLHTGTEntities())
{
NguoiDung nguoiDung = db.NguoiDungs.Where(n => n.ID == bangLai.NguoiDung_id).FirstOrDefault();
if (nguoiDung != null)
{
try
{
bangLai.NguoiDung = nguoiDung;
db.BangLais.Add(bangLai);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
return(false);
}
public bool updateBangLai(BangLai bangLai)
{
using (var db = new QLHTGTEntities())
{
try
{
BangLai bangLaiUpdate = db.BangLais.Find(bangLai.ID);
if (bangLai == null)
{
return(false);
}
bangLaiUpdate.Hang = bangLai.Hang;
bangLaiUpdate.NgayCap = bangLai.NgayCap;
bangLaiUpdate.NguoiDung_id = bangLai.NguoiDung_id;
bangLaiUpdate.NoiCap = bangLai.NoiCap;
bangLaiUpdate.SoBangLai = bangLai.SoBangLai;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateMucPhiTruocBa(MucPhiTruocBa mucPhiTruocBa)
{
using (var db = new QLHTGTEntities())
{
try
{
MucPhiTruocBa mucPhiTruocBaUpdate = db.MucPhiTruocBas.Find(mucPhiTruocBa.ID);
if (mucPhiTruocBa == null)
{
return(false);
}
mucPhiTruocBaUpdate.LoaiXe = mucPhiTruocBa.LoaiXe;
mucPhiTruocBaUpdate.KhuVuc = mucPhiTruocBa.KhuVuc;
mucPhiTruocBaUpdate.MucPhi = mucPhiTruocBa.MucPhi;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateHDNopPhat_BienBanViPham(BienBanViPham bienBan)
{
using (var db = new QLHTGTEntities())
{
try
{
BienBanViPham bienBanUpdate = db.BienBanViPhams.Find(bienBan.ID);
if (bienBan == null)
{
return(false);
}
bienBanUpdate.HDNopPhat = bienBan.HDNopPhat;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateLoaiXe(LoaiXe loaiXe)
{
using (var db = new QLHTGTEntities())
{
try
{
LoaiXe loaiXeUpdate = db.LoaiXes.Find(loaiXe.ID);
if (loaiXe == null)
{
return(false);
}
loaiXeUpdate.NhanHieu = loaiXe.NhanHieu;
loaiXeUpdate.MauXe = loaiXe.MauXe;
loaiXeUpdate.NamSX = loaiXe.NamSX;
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public BienBanViPham addBienBanViPham(BienBanViPham bienBanViPham)
{
using (var db = new QLHTGTEntities())
{
db.BienBanViPhams.Add(bienBanViPham);
if (db.SaveChanges() > 0)
{
return(bienBanViPham);
}
}
return(null);
}
public bool addMucPhiTruocBa(MucPhiTruocBa mucPhiTruocBa)
{
using (var db = new QLHTGTEntities())
{
try
{
db.MucPhiTruocBas.Add(mucPhiTruocBa);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool addHinhThucThanhToan(HinhThucThanhToan hinhThucThanhToan)
{
using (var db = new QLHTGTEntities())
{
try
{
db.HinhThucThanhToans.Add(hinhThucThanhToan);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool addLoaiXe(LoaiXe loaiXe)
{
using (var db = new QLHTGTEntities())
{
try
{
db.LoaiXes.Add(loaiXe);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool addMucPhiCapBien(MucPhiCapBien mucPhiCapBien)
{
using (var db = new QLHTGTEntities())
{
try
{
db.MucPhiCapBiens.Add(mucPhiCapBien);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteHinhThucThanhToan(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
HinhThucThanhToan hinhThucThanhToanDel = db.HinhThucThanhToans.Find(id);
db.HinhThucThanhToans.Remove(hinhThucThanhToanDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteLoaiXe(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
LoaiXe loaiXeDel = db.LoaiXes.Find(id);
db.LoaiXes.Remove(loaiXeDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteMucPhiCapBien(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
MucPhiCapBien mucPhiCapBienDel = db.MucPhiCapBiens.Find(id);
db.MucPhiCapBiens.Remove(mucPhiCapBienDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteCanBo(string username)
{
using (var db = new QLHTGTEntities())
{
try
{
CanBo canBoDel = db.CanBoes.Where(n => n.username == username).FirstOrDefault();
db.CanBoes.Remove(canBoDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteBangLai(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
BangLai bangLaiDel = db.BangLais.Find(id);
db.BangLais.Remove(bangLaiDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteYeuCauDangKyXe(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
YeuCauDangKyXe yeuCauDangKyXeDel = db.YeuCauDangKyXes.Find(id);
db.YeuCauDangKyXes.Remove(yeuCauDangKyXeDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool deleteHoaDon(int id)
{
using (var db = new QLHTGTEntities())
{
try
{
HoaDon hoaDonDel = db.HoaDons.Find(id);
db.HoaDons.Remove(hoaDonDel);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool addNguoiDung(NguoiDung nguoiDung)
{
using (var db = new QLHTGTEntities())
{
try
{
db.NguoiDungs.Add(nguoiDung);
if (db.SaveChanges() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch
{
return(false);
}
}
}
public bool updateHinhThucThanhToan(HinhThucThanhToan hinhThucThanhToan)
{
using (var db = new QLHTGTEntities())
{
try
{
HinhThucThanhToan hinhThucThanhToanUpdate = db.HinhThucThanhToans.Find(hinhThucThanhToan.ID);
if (hinhThucThanhToan == null)
{
return(false);
}
hinhThucThanhToanUpdate.HTTT = hinhThucThanhToan.HTTT;
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}