public bool UpdateXe(Xe tx)
{
string query = string.Format("UPDATE Xe SET TenXe = '{0}', So_dang_ky = '{1}', LoaiXe_ID_LoaiXe= {2} WHERE XeID = {3}", tx.TenXe, tx.SoDangKi, tx.MaLoaiXe, tx.ID);
int result = DataProvider.ExecuteNonQuery(query);
return(result > 0);
}
public bool InsertXe(Xe tx)
{
string query = string.Format("EXEC sp_Xe @ten , @sodk , @Xe");
int result = DataProvider.ExecuteNonQuery(query, new object[] { tx.TenXe, tx.SoDangKi, tx.MaLoaiXe });
return(result > 0);
}
public void DeleteXe(int id)
{
Xe xeTemp = new Xe();
xeTemp = db.Xes.Single(c => c.MaXe == id);
db.Xes.Remove(xeTemp);
db.SaveChanges();
}
public static List <Xe> LoadXe()
{
QLCHXeEntity db = new QLCHXeEntity();
var result = (
from c in db.Xes
join hx in db.HangXes on c.MaHangXe equals hx.MaHangXe
join lx in db.LoaiXes on c.MaLoaiXe equals lx.MaLoaiXe
join ncc in db.NhaCungCaps on c.MaNhaCungCap equals ncc.MaNhaCungCap
select new
{
MaXe = c.MaXe,
MaHangXe = c.MaHangXe,
MaLoaiXe = c.MaLoaiXe,
MaNhaCungCap = c.MaNhaCungCap,
TenXe = c.TenXe,
SoLuong = c.SoLuong,
BaoHanh = c.ThongTinBaoHanh,
DonGia = c.DonGia,
GhiChu = c.GhiChu,
HangXe = hx.TenHangXe,
LoaiXe = lx.TenLoaiXe,
NhaCungCap = ncc.TenNhaCungCap,
HinhAnh = c.HinhAnh
}).ToList();
List <Xe> listReturn = new List <Xe>();
foreach (var item in result)
{
Xe xe_list = new Xe();
HangXe hx = new HangXe();
hx.TenHangXe = item.HangXe;
xe_list.HangXe = hx;
LoaiXe lx = new LoaiXe();
lx.TenLoaiXe = item.LoaiXe;
xe_list.LoaiXe = lx;
NhaCungCap ncc = new NhaCungCap();
ncc.TenNhaCungCap = item.NhaCungCap;
xe_list.NhaCungCap = ncc;
xe_list.MaXe = item.MaXe;
xe_list.MaHangXe = item.MaHangXe;
xe_list.MaLoaiXe = item.MaLoaiXe;
xe_list.MaNhaCungCap = item.MaNhaCungCap;
xe_list.TenXe = item.TenXe;
xe_list.SoLuong = item.SoLuong;
xe_list.ThongTinBaoHanh = item.BaoHanh;
xe_list.DonGia = item.DonGia;
xe_list.GhiChu = item.GhiChu;
xe_list.HinhAnh = item.HinhAnh;
listReturn.Add(xe_list);
}
return(listReturn);
}
public List <Xe> loadxe()
{
List <Xe> xelist = new List <Xe>();
DataTable data = DataProvider.Instance.ExcuteQuery("dbo.USP_DSXe");
//DataTable data = DataProvider.Instance.ExcuteQuery("select So_Xe,TenTuyen as 'Tuyến Xe',COUNT(BanVe.IdChuyen) as N'Số vé đã đặt' from BanVe,TuyenXe,ChuyenXe where TuyenXe.IdTuyen=ChuyenXe.IdTuyen and BanVe.IdChuyen=ChuyenXe.IdChuyen group by TenTuyen,NgayDi,Gio,So_Xe");
foreach (DataRow item in data.Rows)
{
Xe xe = new Xe(item);
xelist.Add(xe);
}
return(xelist);
}
public Xe GetXeByID(int id)
{
Xe Xe = null;
string query = "select * from Xe where XeID = " + id;
DataProvider provider = new DataProvider();
DataTable data = provider.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Xe = new Xe(item);
return(Xe);
}
return(Xe);
}
public List <Xe> GetXeToCbb()
{
List <Xe> list = new List <Xe>();
string query = "SELECT * FROM Xe";
DataProvider provider = new DataProvider();
DataTable data = provider.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
Xe Xe = new Xe(item);
list.Add(Xe);
}
return(list);
}
public void EditXe(Xe xe)
{
this.xe = (from c in db.Xes
where c.MaXe == xe.MaXe
select c).Single();
this.xe.MaHangXe = xe.MaHangXe;
this.xe.MaLoaiXe = xe.MaLoaiXe;
this.xe.MaNhaCungCap = xe.MaNhaCungCap;
this.xe.TenXe = xe.TenXe;
this.xe.DonGia = xe.DonGia;
/* this.xe.SoLuong = xe.SoLuong; */
this.xe.ThongTinBaoHanh = xe.ThongTinBaoHanh;
this.xe.GhiChu = xe.GhiChu;
this.xe.HinhAnh = xe.HinhAnh;
db.SaveChanges();
}
public IEnumerable <Xe> TimKiem(string search)
{
List <Xe> Details = new List <Xe>();
var result = db.Search_Xe(search).ToList();
for (int j = 0; j < result.Count; j++)
{
Xe xe = new Xe();
xe.maxe = Convert.ToString(result[j].maxe);
xe.bienkiemsoat = Convert.ToString(result[j].bienkiemsoat);
xe.hangsanxuat = Convert.ToString(result[j].hangsanxuat);
xe.namsanxuat = Convert.ToInt32(result[j].namsanxuat);
xe.soghe = Convert.ToInt32(result[j].soghe);
Details.Add(xe);
}
return(Details);
}
public static List <ChiTietPhieuNhap> LoadCTKho(int id)
{
QLCHXeEntity db = new QLCHXeEntity();
var result = (
from c in db.ChiTietPhieuNhaps
join x in db.Xes on c.MaSanPham equals x.MaXe
where c.MaPhieuNhap == id
select new
{
ID = c.ID,
MaPhieuNhap = c.MaPhieuNhap,
MaSanPham = c.MaSanPham,
DonGiaNhap = c.DonGiaNhap,
SoLuongNhap = c.SoLuongNhap,
Thue = c.Thue,
ThanhTien = c.ThanhTien,
TenXe = x.TenXe
}
).ToList();
List <ChiTietPhieuNhap> listReturn = new List <ChiTietPhieuNhap>();
foreach (var item in result)
{
ChiTietPhieuNhap ctphieunhap_list = new ChiTietPhieuNhap();
Xe x = new Xe();
x.TenXe = item.TenXe;
ctphieunhap_list.Xe = x;
ctphieunhap_list.ID = item.ID;
ctphieunhap_list.MaPhieuNhap = item.MaPhieuNhap;
ctphieunhap_list.MaSanPham = item.MaSanPham;
ctphieunhap_list.DonGiaNhap = item.DonGiaNhap;
ctphieunhap_list.SoLuongNhap = item.SoLuongNhap;
ctphieunhap_list.Thue = item.Thue;
ctphieunhap_list.ThanhTien = item.ThanhTien;
listReturn.Add(ctphieunhap_list);
}
return(listReturn);
}
public void AddXe(Xe xe)
{
db.Xes.Add(xe);
db.SaveChanges();
}
public void Xoa(Xe xe)
{
var result = db.Delete_Xe(xe.maxe);
}
public void CapNhat(Xe xe, string maXE)
{
var result = db.Update_Xe(maXE, xe.bienkiemsoat, xe.hangsanxuat, xe.namsanxuat, xe.soghe);
}
public void Them(Xe xe)
{
var result = db.Insert_Xe(xe.bienkiemsoat, xe.hangsanxuat, xe.namsanxuat, xe.soghe);
}
