public TripDetailVM(string maChuyenDi) { ChuyenDiDAOImpl cdDao = new ChuyenDiDAOImpl(); chuyenDi = cdDao.getChuyenDiById(maChuyenDi); MucChiDAOlmpl mcDao = new MucChiDAOlmpl(); mucChiList = mcDao.GetMucChiByTripId(maChuyenDi); hinhAnhList = new ObservableCollection <HinhAnhChuyenDi>(); hinhAnhList.Add(new HinhAnhChuyenDi() { HinhAnh = chuyenDi.AnhBia }); HinhAnhChuyenDiDAOlmpl haDao = new HinhAnhChuyenDiDAOlmpl(); List <HinhAnhChuyenDi> haList = haDao.GetAllHinhAnhChuyenDi(); tongKet = new TongKet(); int sum = 0; foreach (var mc in mucChiList) { sum += mc.SoTien; } tongKet.Tong = sum; foreach (var ha in haList) { if (ha.MaChuyenDi == maChuyenDi) { hinhAnhList.Add(ha); } } thanhVienList = new ObservableCollection <ThanhVien>(); ChuyenDiThanhVienDAOImpl tvDao = new ChuyenDiThanhVienDAOImpl(); List <CHUYENDI_THANHVIEN> cdtvList = tvDao.GetCHUYENDI_THANHVIENList(); tvThamGiaList = new List <CHUYENDI_THANHVIEN>(); ThanhVienDAOlmpl memDao = new ThanhVienDAOlmpl(); foreach (var tv in cdtvList) { if (tv.MaChuyenDi == maChuyenDi) { tvThamGiaList.Add(tv); ThanhVien tmp = memDao.GetMemberById(tv.MaThanhVien); thanhVienList.Add(tmp); } } int count = 0; foreach (var tv in thanhVienList) { count++; } tongKet.TrungBinh = tongKet.Tong / count; //Tien tra lai cua cac thanh vien ThanhVienDAOlmpl thanhVienDao = new ThanhVienDAOlmpl(); foreach (var tvtg in tvThamGiaList) { ThanhVien tmp = thanhVienDao.GetMemberById(tvtg.MaThanhVien); ThanhVien_TraLai tvtl = new ThanhVien_TraLai(); tvtl.TenThanhVien = tmp.TenThanhVien; tvtl.SoTien = tvtg.TienThu - tongKet.TrungBinh; tongKet.ThanhVienTraLai.Add(tvtl); } loTrinhList = new ObservableCollection <CacMocLoTrinh>(); CacMocLoTrinhDAOlmpl ltDao = new CacMocLoTrinhDAOlmpl(); List <CacMocLoTrinh> ltList = ltDao.GetAllCacMocLoTrinh(); foreach (var lt in ltList) { if (lt.MaChuyenDi == maChuyenDi) { loTrinhList.Add(lt); } } }
private void filterByMember() { cdList.Clear(); foreach (var trip in cdDao.GetAllChuyenDi()) { cdList.Add(trip); } String filterQuery = keywordTextBox.Text; if (!filterQuery.Equals("")) { String unSignLowerMemberName = ConvertToUnSign(filterQuery.ToLower()); ChuyenDiThanhVienDAOImpl tripMemberDAO = new ChuyenDiThanhVienDAOImpl(); List <CHUYENDI_THANHVIEN> trip_members = tripMemberDAO.GetCHUYENDI_THANHVIENList(); ThanhVienDAOlmpl memberDAO = new ThanhVienDAOlmpl(); List <ThanhVien> members = memberDAO.GetAllThanhVien(); for (int i = 0; i < members.Count(); i++) { ThanhVien member = members[i]; String unSignLowerMemberNameItem = ConvertToUnSign(member.TenThanhVien.ToLower()); if (!unSignLowerMemberNameItem.Contains(unSignLowerMemberName)) { members.Remove(member); i--; } } for (int i = 0; i < trip_members.Count(); i++) { CHUYENDI_THANHVIEN trip_member = trip_members[i]; for (int j = 0; j < members.Count(); j++) { if (trip_member.MaThanhVien.Equals(members[j].MaThanhVien)) { break; } if (j == members.Count() - 1) { trip_members.Remove(trip_member); i--; } } } for (int i = 0; i < cdList.Count(); i++) { ChuyenDi trip = cdList[i]; for (int j = 0; j < trip_members.Count(); j++) { if (trip.MaChuyenDi.Equals(trip_members[j].MaChuyenDi)) { break; } if (j == trip_members.Count() - 1) { i--; tripVM.TripList.Remove(trip); } } } } }