private void UserControl_Loaded(object sender, RoutedEventArgs e)
{
ThanhVienDAOlmpl tv = new ThanhVienDAOlmpl();
foreach (CHUYENDI_THANHVIEN mt in tripDetailVM.tvThamGiaList)
{
ThanhVien tmp = tv.GetMemberById(mt.MaThanhVien);
PieSeries ps = new PieSeries()
{
Title = tmp.TenThanhVien, Values = new ChartValues <int> {
mt.TienThu
}, DataLabels = true
};
myChart2.Series.Add(ps);
}
myChart2.FontSize = 12;
myChart2.Foreground = new SolidColorBrush(Colors.DimGray);
}
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);
}
}
}
}
}
