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); }