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