private void BuyCoursePage_Loaded(object sender, RoutedEventArgs e) { DanhGiaPage.khoahocdangxem = khoahocduocmua; fr_binhluan.Navigate(typeof(DanhGiaPage)); txtblock_tengiaovien.Text = "Giảng viên: " + khoahocduocmua.tenGiaoVien; txtblock_soNguoiDaMua.Text = "Số người đã mua: " + Convert.ToString(khoahocduocmua.soNguoiDaMua) + " Lượt mua"; Txtblockbuycourse_Username.Text = "Xin chào, " + UserSession.userlogined.username; hocphi.Text = khoahocduocmua.giaKhoaHocHienThi; danhgia.Text = "Đánh giá trung bình: " + Convert.ToString(khoahocduocmua.danhGia) + " / 5"; txtbox_thongTinKhoaHoc.Text = khoahocduocmua.thongTinKhoaHoc; BitmapImage bitmapImage = new BitmapImage(); Uri uri = new Uri("ms-appx:///" + khoahocduocmua.imagelink); bitmapImage.UriSource = uri; courseimage_buycoursepage.Source = bitmapImage; ws = new kidmathwebserviceSoapClient(); List <khoaHoc> dskhoahoc = new List <khoaHoc>(); dskhoahoc = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>(); dskhoahoc = dskhoahoc.FindAll(khoahoc => khoahoc.maKhoaHoc != "" && khoahoc.maKhoaHoc != khoahocduocmua.maKhoaHoc); dscackhoahoclienquan.ItemsSource = dskhoahoc; }
private void MainPage_AffterLogin_Loaded(object sender, RoutedEventArgs e) { ws = new kidmathwebserviceSoapClient(); List <khoaHoc> dskhoahoc = new List <khoaHoc>(); dskhoahoc = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>(); dskhoahoc = dskhoahoc.FindAll(kh => kh.maKhoaHoc != ""); flipview_dskhoahoc.ItemsSource = dskhoahoc; }
private void Admin_CourseInfomationLoaded(object sender, RoutedEventArgs e) { ws = new kidmathwebserviceSoapClient(); List <khoaHoc> dskhoahoc = new List <khoaHoc>(); dskhoahoc = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>(); dskhoahoc = dskhoahoc.FindAll(khoahoc => khoahoc.maKhoaHoc != ""); gvdsachKhoaHoc.ItemsSource = dskhoahoc; soluongkh.Text = Convert.ToString(dskhoahoc.Count); }
private void Admin_StatisticalPage_Loaded(object sender, RoutedEventArgs e) { ws = new kidmathwebserviceSoapClient(); List <khoaHoc> dskhoahoc = new List <khoaHoc>(); dskhoahoc = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>(); dskhoahoc = dskhoahoc.FindAll(kh => kh.maKhoaHoc != ""); adpage_statistical_dskhoahoc.ItemsSource = dskhoahoc; ws = new kidmathwebserviceSoapClient(); soLuongNguoiDung.Text = ws.checkExistsAsync("select * from nguoiDung").Result.Body.checkExistsResult.ToString(); ws = new kidmathwebserviceSoapClient(); soLuongKhoaHocDaBan.Text = ws.checkExistsAsync("select * from muaKhoaHoc").Result.Body.checkExistsResult.ToString(); ws = new kidmathwebserviceSoapClient(); tongSoTienNguoiDungNap.Text = ws.doanhthu_functAsync().Result.ToString(); ws = new kidmathwebserviceSoapClient(); tongSoTienNguoiDungSuDung.Text = (Convert.ToInt32(tongSoTienNguoiDungNap.Text) - ws.nguoidungchi_functAsync().Result).ToString(); }
private void checkbuy(string tenkhoahoc) { ws = new kidmathwebserviceSoapClient(); khoaHoc temp = new khoaHoc(); temp = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>().Find(kh => kh.tenKhoaHoc == tenkhoahoc); string sql = "SELECT * FROM muaKhoaHoc WHERE muaKhoaHoc.username = '******' AND muaKhoaHoc.tenKhoaHoc ='" + tenkhoahoc + "';"; ws = new kidmathwebserviceSoapClient(); if (ws.checkExistsAsync(sql).Result.Body.checkExistsResult != 0) { ViewCoursePage_AfterBuy.khoahocduocmua = temp; this.Frame.Navigate(typeof(ViewCoursePage_AfterBuy)); } else { BuyCoursePage.khoahocduocmua = temp; this.Frame.Navigate(typeof(BuyCoursePage)); } }
private void tap_khoahoc(object sender, TappedRoutedEventArgs e) { ws = new kidmathwebserviceSoapClient(); StackPanel khoahocduocchon = sender as StackPanel; khoaHoc temp = khoahocduocchon.DataContext as khoaHoc; Chinhsuakhoahoc.khoahoccanchinhsua = temp; temp = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>().Find(kh => kh.maKhoaHoc == temp.maKhoaHoc); string sql = "SELECT * FROM muaKhoaHoc WHERE muaKhoaHoc.username = '******' AND muaKhoaHoc.maKhoaHoc ='" + temp.maKhoaHoc + "';"; ws = new kidmathwebserviceSoapClient(); if (ws.checkExistsAsync(sql).Result.Body.checkExistsResult != 0) { ViewCoursePage_AfterBuy.khoahocduocmua = temp; this.Frame.Navigate(typeof(ViewCoursePage_AfterBuy)); } else { BuyCoursePage.khoahocduocmua = temp; this.Frame.Navigate(typeof(BuyCoursePage)); } }
private async void pheduyet(object sender, RoutedEventArgs e) { Button userstatus = sender as Button; danhGia temp = userstatus.DataContext as danhGia; khoaHoc khoahocdangsua = new khoaHoc(); if (temp.tinhTrang == "Phê duyệt") { var msg = new MessageDialog("Phê duyệt bài viết này?"); msg.Commands.Add(new UICommand() { Id = 0, Label = "Xác nhận" }); msg.Commands.Add(new UICommand() { Id = 1, Label = "Hủy" }); var rs = await msg.ShowAsync(); if ((int)rs.Id == 0) { string sql_duyetbai = "UPDATE [appToanTieuHocDB].[dbo].danhGia SET danhGia.tinhTrang = 'd' WHERE danhGia.ngayDuyet = '" + temp.ngayDuyet + "';"; ws = new kidmathwebserviceSoapClient(); int kqpheduyet = ws.ThucHienLenhAsync(sql_duyetbai).Result.Body.ThucHienLenhResult; if (kqpheduyet != 0) { string sql_updatedanhgia = "UPDATE [appToanTieuHocDB].[dbo].khoaHoc SET khoaHoc.soLuongDanhGia = khoaHoc.soLuongDanhGia + 1 WHERE khoaHoc.maKhoaHoc = '" + temp.maKhoaHoc + "' ;"; ws = new kidmathwebserviceSoapClient(); int kqupdate = ws.ThucHienLenhAsync(sql_updatedanhgia).Result.Body.ThucHienLenhResult; if (kqupdate != 0) { ws = new kidmathwebserviceSoapClient(); khoahocdangsua = (ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>()).Find(kh => kh.maKhoaHoc == temp.maKhoaHoc); double diemdanhgiamoi = 5; diemdanhgiamoi = (Convert.ToInt32(khoahocdangsua.danhGia) * Convert.ToInt32(khoahocdangsua.soLuongDanhGia) + Convert.ToInt32(temp.rate)) / (Convert.ToInt32(khoahocdangsua.soLuongDanhGia) + 1); int diemdanhgia = Convert.ToInt32(diemdanhgiamoi); string sql_updatedanhgia2 = "UPDATE [appToanTieuHocDB].[dbo].[khoaHoc] SET khoaHoc.danhGia = '" + diemdanhgia + "' WHERE khoaHoc.maKhoaHoc = '" + temp.maKhoaHoc + "';"; ws = new kidmathwebserviceSoapClient(); int kqupdate2 = ws.ThucHienLenhAsync(sql_updatedanhgia2).Result.Body.ThucHienLenhResult; if (kqupdate2 != 0) { temp.tinhTrang = "Đã duyệt"; var msg_ = new MessageDialog("Đã hoàn tất quá trình duyệt bài viết").ShowAsync(); } else { var msg_ = new MessageDialog("Lỗi khi cập nhật điểm đánh giá").ShowAsync(); } } else { var msg_ = new MessageDialog("Lỗi khi cập nhật số lượng đánh giá").ShowAsync(); } } else { var msg_ = new MessageDialog("Lỗi khi cập nhật trạng thái của đánh giá").ShowAsync(); } } } }
private void Page_UserInfo_Loaded(object sender, RoutedEventArgs e) { ws = new kidmathwebserviceSoapClient(); List <khoaHoc> dskhoahoc = new List <khoaHoc>(); dskhoahoc = ws.getDataKhoaHocAsync().Result.Body.getDataKhoaHocResult.ToList <khoaHoc>(); flipview_dskhoahoc.ItemsSource = dskhoahoc; txtblock_userloginedname.Text = UserSession.userlogined.tenNguoiDung; txtblock_email.Text = UserSession.userlogined.email; txtblock_soDienThoai.Text = UserSession.userlogined.soDienThoai; txtblock_tenNguoiDung.Text = UserSession.userlogined.tenNguoiDung; txtblock_username.Text = UserSession.userlogined.username; txtblock_soTienDaNap.Text = Convert.ToString(UserSession.userlogined.soTienDaNap) + " ( VNĐ)"; txtblock_soTienHienCo.Text = UserSession.userlogined.soTienHienCo + " ( VNĐ)"; ws = new kidmathwebserviceSoapClient(); List <muaKhoaHoc> dslichsumua = new List <muaKhoaHoc>(); dslichsumua = ws.getDatMuaKhoaHocAsync().Result.Body.getDatMuaKhoaHocResult.ToList <muaKhoaHoc>(); dslichsumua = dslichsumua.FindAll(hoadon => hoadon.username == UserSession.userlogined.username); foreach (var oder in dslichsumua) { oder.giaKhoaHoc = -oder.giaKhoaHoc; if (oder.maKhoaHoc == "l1cb") { oder.maKhoaHoc = "Mua khóa lớp 1"; } else if (oder.maKhoaHoc == "l2cb") { oder.maKhoaHoc = "Mua khóa lớp 2"; } else if (oder.maKhoaHoc == "l3cb") { oder.maKhoaHoc = "Mua khóa lớp 3"; } else if (oder.maKhoaHoc == "l4cb") { oder.maKhoaHoc = "Mua khóa lớp 4"; } else if (oder.maKhoaHoc == "l5cb") { oder.maKhoaHoc = "Mua khóa lớp 5"; } else if (oder.maKhoaHoc == "ontapcb") { oder.maKhoaHoc = "Mua khóa ôn tập"; } else { oder.maKhoaHoc = "Không xác định"; } } gvlichsumua.ItemsSource = dslichsumua; ws = new kidmathwebserviceSoapClient(); List <lichSuNapTien> dslichsunap = new List <lichSuNapTien>(); dslichsunap = ws.getDataLichSuNapTienAsync().Result.Body.getDataLichSuNapTienResult.ToList <lichSuNapTien>(); dslichsunap = dslichsunap.FindAll(hoadon => hoadon.username == UserSession.userlogined.username); gvlichsunap.ItemsSource = dslichsunap; }