public LoaiXe findByProperties(string nhanhieu, string mauxe, string mau, int namsx)
{
using (var db = new QLHTGTEntities())
{
LoaiXe loaiXe = db.LoaiXes.Where(c => c.NhanHieu == nhanhieu && c.MauXe == mauxe && c.NamSX == namsx && c.Mau == mau).FirstOrDefault();
if (loaiXe != null)
{
return(loaiXe);
}
}
return(null);
}
public List <HinhThucThanhToan> findAll()
{
using (var db = new QLHTGTEntities())
{
List <HinhThucThanhToan> hinhThucThanhToans = db.HinhThucThanhToans.ToList();
if (hinhThucThanhToans != null)
{
return(hinhThucThanhToans);
}
}
return(null);
}
public LoaiXe findById(int id)
{
using (var db = new QLHTGTEntities())
{
LoaiXe loaiXe = db.LoaiXes.Where(b => b.ID == id).FirstOrDefault();
if (loaiXe != null)
{
return(loaiXe);
}
}
return(null);
}
public List <LoaiXe> findAll()
{
using (var db = new QLHTGTEntities())
{
List <LoaiXe> loaiXes = db.LoaiXes.ToList();
if (loaiXes != null)
{
return(loaiXes);
}
}
return(null);
}
public List <LoiViPham> findAll()
{
using (var db = new QLHTGTEntities())
{
List <LoiViPham> loiViPhams = db.LoiViPhams.ToList();
if (loiViPhams != null)
{
return(loiViPhams);
}
}
return(null);
}
public HinhThucThanhToan findById(int id)
{
using (var db = new QLHTGTEntities())
{
HinhThucThanhToan hinhThucThanhToan = db.HinhThucThanhToans.Where(b => b.ID == id).FirstOrDefault();
if (hinhThucThanhToan != null)
{
return(hinhThucThanhToan);
}
}
return(null);
}
public YeuCauDangKyXe findById(int id)
{
using (var db = new QLHTGTEntities())
{
YeuCauDangKyXe yeuCauDangKyXe = db.YeuCauDangKyXes.Where(b => b.ID == id).FirstOrDefault();
if (yeuCauDangKyXe != null)
{
return(yeuCauDangKyXe);
}
}
return(null);
}
public List <HoaDon> findAll()
{
using (var db = new QLHTGTEntities())
{
List <HoaDon> hoaDons = db.HoaDons.ToList();
if (hoaDons != null)
{
return(hoaDons);
}
}
return(null);
}
public BangLai findById(int id)
{
using (var db = new QLHTGTEntities())
{
BangLai bangLai = db.BangLais.Where(b => b.ID == id).FirstOrDefault();
if (bangLai != null)
{
return(bangLai);
}
}
return(null);
}
public List <BangLai> findAll()
{
using (var db = new QLHTGTEntities())
{
List <BangLai> bangLais = db.BangLais.Include("NguoiDung").ToList();
if (bangLais != null)
{
return(bangLais);
}
}
return(null);
}
internal MucPhiTruocBa findByProperties(bool loaixe, int khuvuc)
{
using (var db = new QLHTGTEntities())
{
MucPhiTruocBa mucPhiTruocBa = db.MucPhiTruocBas.Where(b => b.LoaiXe == loaixe && b.KhuVuc == khuvuc).FirstOrDefault();
if (mucPhiTruocBa != null)
{
return(mucPhiTruocBa);
}
}
return(null);
}
public BangLai findBySoBangLai(string SoBangLai)
{
using (var db = new QLHTGTEntities())
{
BangLai bangLai = db.BangLais.Where(b => b.SoBangLai == SoBangLai).FirstOrDefault();
if (bangLai != null)
{
return(bangLai);
}
}
return(null);
}
public MucPhiTruocBa findById(int id)
{
using (var db = new QLHTGTEntities())
{
MucPhiTruocBa mucPhiTruocBa = db.MucPhiTruocBas.Where(b => b.ID == id).FirstOrDefault();
if (mucPhiTruocBa != null)
{
return(mucPhiTruocBa);
}
}
return(null);
}
public HoaDon findById(int id)
{
using (var db = new QLHTGTEntities())
{
HoaDon hoaDon = db.HoaDons.Where(b => b.ID == id).FirstOrDefault();
if (hoaDon != null)
{
return(hoaDon);
}
}
return(null);
}
public List <MucPhiTruocBa> findAll()
{
using (var db = new QLHTGTEntities())
{
List <MucPhiTruocBa> mucPhiTruocBas = db.MucPhiTruocBas.ToList();
if (mucPhiTruocBas != null)
{
return(mucPhiTruocBas);
}
}
return(null);
}
public Xe findById(int id)
{
using (var db = new QLHTGTEntities())
{
Xe xe = db.Xes.Include("NguoiDung").Include("LoaiXe").Where(b => b.ID == id).FirstOrDefault();
if (xe != null)
{
return(xe);
}
}
return(null);
}
public List <YeuCauDangKyXe> findAll()
{
using (var db = new QLHTGTEntities())
{
List <YeuCauDangKyXe> yeuCauDangKyXes = db.YeuCauDangKyXes.ToList();
if (yeuCauDangKyXes != null)
{
return(yeuCauDangKyXes);
}
}
return(null);
}
public List <Xe> findByUserId(int UserId)
{
using (var db = new QLHTGTEntities())
{
List <Xe> xes = db.Xes.Include("NguoiDung").Include("LoaiXe").Where(b => b.NguoiDung_id == UserId).ToList();
if (xes != null)
{
return(xes);
}
}
return(null);
}
public Xe findByBienSo(string BienSo)
{
using (var db = new QLHTGTEntities())
{
Xe xe = db.Xes.Include("NguoiDung").Include("LoaiXe").Where(b => b.BienSo == BienSo).FirstOrDefault();
if (xe != null)
{
return(xe);
}
}
return(null);
}
public List <Xe> findAll()
{
using (var db = new QLHTGTEntities())
{
List <Xe> xes = db.Xes.Include("NguoiDung").Include("LoaiXe").ToList();
if (xes != null)
{
return(xes);
}
}
return(null);
}
public BienBanViPham findById(int id)
{
using (var db = new QLHTGTEntities())
{
BienBanViPham bienBanViPham = db.BienBanViPhams.Include("HoaDon").Include("LoiViPhams").Where(b => b.ID == id).FirstOrDefault();
if (bienBanViPham != null)
{
return(bienBanViPham);
}
}
return(null);
}
public MucPhiCapBien findByProperties(bool loaixe, decimal giatien, int khuvuc)
{
using (var db = new QLHTGTEntities())
{
MucPhiCapBien mucPhiCapBien = db.MucPhiCapBiens.Where(b => b.LoaiXe == loaixe && b.KhuVuc == khuvuc &&
b.GiaToiDa >= giatien && b.GiaToiThieu < giatien).FirstOrDefault();
if (mucPhiCapBien != null)
{
return(mucPhiCapBien);
}
}
return(null);
}
public List <BienBanViPham> findByBangLai(string soBangLai)
{
using (var db = new QLHTGTEntities())
{
BangLai bangLai = db.BangLais.Where(b => b.SoBangLai == soBangLai).FirstOrDefault();
List <BienBanViPham> bienBanViPhams = db.BienBanViPhams.Include("LoiViPhams").Where(b => b.BangLai_id == bangLai.ID).ToList();
if (bienBanViPhams != null)
{
return(bienBanViPhams);
}
}
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 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);
}
}
}
