public MainPage()
{
this.InitializeComponent();
var ws = new kidmathwebserviceSoapClient();
Loaded += MainPage_Loaded;
}
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 LopvaChuongPage_AfterLogin_Loaded(object sender, RoutedEventArgs e)
{
txtblock_tenKhoaHoc.Text = "Bạn đang xem khóa học: " + khoahocdangxem.tenKhoaHoc;
User_btn.Content = "Xin chào, " + UserSession.userlogined.tenNguoiDung;
ws = new kidmathwebserviceSoapClient();
dschuong = ws.getDataChuongAsync().Result.Body.getDataChuongResult.ToList <chuong>();
dschuong = dschuong.FindAll(chuong => chuong.maKhoaHoc == khoahocdangxem.maKhoaHoc);
dstenchuong.ItemsSource = dschuong;
chuongduocchon = dschuong[0];
ws = new kidmathwebserviceSoapClient();
dsbai = ws.getDataBaiAsync().Result.Body.getDataBaiResult.ToList <bai>();
dsbai = dsbai.FindAll(bai => bai.maChuong == chuongduocchon.maChuong);
listbox_dsbaihoctrong1chuong.ItemsSource = dsbai;
baiduocchon = dsbai[0];
tenbaihienthi.Text = baiduocchon.tenBai;
ws = new kidmathwebserviceSoapClient();
videoduocchon = (ws.getDatavideoAsync().Result.Body.getDatavideoResult.ToList <video>()).Find(video => video.maBai == baiduocchon.maBai);
VideoPage.videoduocchon = videoduocchon;
Active_frame.Navigate((typeof(VideoPage)));
ws = new kidmathwebserviceSoapClient();
dsbaithi = ws.getDataDanhSachCauHoiAsync().Result.Body.getDataDanhSachCauHoiResult.ToList <danhSachCauHoi>();
dsbaithi = dsbaithi.FindAll(baithi => baithi.maBai == baiduocchon.maBai);
}
private void Admin_MailboxPage_Loaded(object sender, RoutedEventArgs e)
{
ws = new kidmathwebserviceSoapClient();
dsthongbao = ws.getDatathongBaoAsync().Result.Body.getDatathongBaoResult.ToList <thongBao>();
dsthongbao = dsthongbao.FindAll(thongbao => thongbao.username != "");
foreach (var thongbao in dsthongbao)
{
if (thongbao.tinhTrang == 'd')
{
thongbao.loaiThongBao = "Đã duyệt";
}
else if (thongbao.tieuDe == "Yêu cầu nạp tiền" && thongbao.tinhTrang == 'c')
{
thongbao.loaiThongBao = "Nạp tiền";
}
else if (thongbao.tieuDe != "Yêu cầu nạp tiền" && thongbao.tinhTrang == 'c')
{
thongbao.loaiThongBao = "Phản hồi";
}
}
foreach (var thongbao in dsthongbao)
{
//c : chưa duyệt ; d: đã duyệt
if (thongbao.tinhTrang == 'd')
{
thongbao.loaiThongBao = "Đã duyệt";
}
}
gvdsachthongbao.ItemsSource = dsthongbao;
}
private int checkusername(string username)
{
string sql = "SELECT * from nguoiDung WHERE username = '******';";
ws = new kidmathwebserviceSoapClient();
int check = ws.checkExistsAsync(sql).Result.Body.checkExistsResult;
return(check);
}
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 navigateto_baiviet(object sender, TappedRoutedEventArgs e)
{
ws = new kidmathwebserviceSoapClient();
StackPanel baivietduocchon = sender as StackPanel;
mainForum temp = baivietduocchon.DataContext as mainForum;
binhLuan_Forum.baivietduocchon = temp;
Forum_Baiviet.baivietdangxem = temp;
this.Frame.Navigate(typeof(Forum_Baiviet));
}
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 timkhoacungtag(object sender, RoutedEventArgs e)
{
Button btntag = sender as Button;
mainForum temp = btntag.DataContext as mainForum;
ws = new kidmathwebserviceSoapClient();
List <mainForum> dsbaiviet2 = new List <mainForum>();
dsbaiviet2 = ws.getDatamainForumAsync().Result.Body.getDatamainForumResult.ToList <mainForum>();
dsbaiviet2 = dsbaiviet2.FindAll(baiviet => baiviet.tinhTrang != "pheduyet" && baiviet.tag == temp.tag);
grview_dsbinhluan.ItemsSource = dsbaiviet2;
}
private void MainForum_Loaded(object sender, RoutedEventArgs e)
{
DateTime now = DateTime.Now;
ws = new kidmathwebserviceSoapClient();
List <mainForum> dsbaiviet = new List <mainForum>();
dsbaiviet = ws.getDatamainForumAsync().Result.Body.getDatamainForumResult.ToList <mainForum>();
dsbaiviet = dsbaiviet.FindAll(baiviet => baiviet.tinhTrang != "pheduyet");
grview_dsbinhluan.ItemsSource = dsbaiviet;
grview_dsbinhluanmoinhat.ItemsSource = dsbaiviet.FindAll(baiviet => baiviet.luotxem > 30);
}
private async void btnclick_guinhanxet(object sender, RoutedEventArgs e)
{
DateTime now = DateTime.Now;
int diemdanhgia;
if (Convert.ToInt32(diemDanhGia.Text) != 1 && Convert.ToInt32(diemDanhGia.Text) != 2 &&
Convert.ToInt32(diemDanhGia.Text) != 3 && Convert.ToInt32(diemDanhGia.Text) != 4 &&
Convert.ToInt32(diemDanhGia.Text) != 5)
{
var msg = new MessageDialog("Vui lòng nhập đánh giá từ 1 tới 5", "Error").ShowAsync();
}
else if (tieuDe.Text == "" || tieuDe.Text.Length > 100)
{
var msg = new MessageDialog("Tiêu đề không phù hợp", "Error").ShowAsync();
}
else if (noiDung.Text == "")
{
var msg = new MessageDialog("Phần nội dung không dược để trống", "Error").ShowAsync();
}
else
{
diemdanhgia = Convert.ToInt32(diemDanhGia.Text);
ws = new kidmathwebserviceSoapClient();
string idbaiviet = UserSession.userlogined.username + DateTime.Now;
string sql = "INSERT into danhGia values('" + UserSession.userlogined.username + "','" + diemdanhgia + "','" + khoahocdangxem.maKhoaHoc + "',N'" + tieuDe.Text + "',N'" + noiDung.Text + "','" + DateTime.Now + "','c');";
if (ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult != 0)
{
var msg = new MessageDialog("Bài đánh giá của bạn đang chờ phê duyệt");
msg.Commands.Add(new UICommand()
{
Id = 0, Label = "Gửi bài mới"
});
msg.Commands.Add(new UICommand()
{
Id = 1, Label = "OK"
});
var rs = await msg.ShowAsync();
if ((int)rs.Id == 0)
{
this.Frame.Navigate(typeof(DanhGiaPage));
}
}
else
{
var msg = new MessageDialog("Xảy ra lỗi khi gửi đánh giá, vui lòng thử lại sau", "Error").ShowAsync();
}
}
}
private void Chinhsuanoidungkhoahoc_Loaded(object sender, RoutedEventArgs e)
{
ws = new kidmathwebserviceSoapClient();
dschuong = ws.getDataChuongAsync().Result.Body.getDataChuongResult.ToList <chuong>();
dschuong = dschuong.FindAll(chuong => chuong.maKhoaHoc == khoahocdangxem.maKhoaHoc);
ListView_dschuong.ItemsSource = dschuong;
chuongduocchon = dschuong[0];
ws = new kidmathwebserviceSoapClient();
dsbai = ws.getDataBaiAsync().Result.Body.getDataBaiResult.ToList <bai>();
dsbai = dsbai.FindAll(bai => bai.maChuong == chuongduocchon.maChuong);
ListView_dsbai.ItemsSource = dsbai;
baiduocchon = dsbai[0];
}
private void selectionchange_dschuong(object sender, SelectionChangedEventArgs e)
{
chuong selectedchuong = ListView_dschuong.SelectedItem as chuong;
if (selectedchuong != null)
{
dsbai = dsbai.FindAll(bai => bai.maChuong == selectedchuong.maChuong);
chuongduocchon = selectedchuong;
ws = new kidmathwebserviceSoapClient();
dsbai = ws.getDataBaiAsync().Result.Body.getDataBaiResult.ToList <bai>();
dsbai = dsbai.FindAll(bai => bai.maChuong == chuongduocchon.maChuong);
ListView_dsbai.ItemsSource = dsbai;
}
}
private async void Muakhoahoc()
{
ws = new kidmathwebserviceSoapClient();
decimal sodu = UserSession.userlogined.soTienHienCo;
decimal giakhoahoc = Convert.ToDecimal(khoahocduocmua.giaKhuyenMai);
DateTime now = DateTime.Now;
string orderid = Convert.ToString(now);
string sql_muakhoahoc = "INSERT into muaKhoaHoc values('" + orderid + "' ,'" + khoahocduocmua.maKhoaHoc + "','" + UserSession.userlogined.username + "','" + now + "','" + khoahocduocmua.giaKhuyenMai + "');";
if (giakhoahoc <= sodu)
{
sodu = sodu - giakhoahoc;
string sql_trutien = "UPDATE nguoiDung SET nguoiDung.soTienHienCo = '" + sodu + "' WHERE nguoiDung.username = '******';";
string sql_songuoidamua = "UPDATE khoaHoc SET khoaHoc.soNguoiDaMua = khoaHoc.soNguoiDaMua + 1 WHERE khoaHoc.maKhoaHoc ='" + khoahocduocmua.maKhoaHoc + "';";
if (ws.ThucHienLenhAsync(sql_trutien).Result.Body.ThucHienLenhResult != 0 && ws.ThucHienLenhAsync(sql_songuoidamua).Result.Body.ThucHienLenhResult != 0 && ws.ThucHienLenhAsync(sql_muakhoahoc).Result.Body.ThucHienLenhResult != 0)
{
var msg = new MessageDialog("Mua khóa học thành công").ShowAsync();
this.Frame.Navigate(typeof(ViewCoursePage_AfterBuy));
}
}
else
{
var msg = new MessageDialog("Bạn không đủ tiền để mua khóa học này");
msg.Commands.Add(new UICommand()
{
Id = 0, Label = "Nạp tiền vào tài khoản"
});
msg.Commands.Add(new UICommand()
{
Id = 1, Label = "Học thử"
});
msg.Commands.Add(new UICommand()
{
Id = 2, Label = "Hủy"
});
var rs = await msg.ShowAsync();
if ((int)rs.Id == 0)
{
this.Frame.Navigate(typeof(NaptienPage));
}
else if ((int)rs.Id == 1)
{
LopvaChuongPage_AfterLogin.checkbuy = "notbuy";
this.Frame.Navigate(typeof(LopvaChuongPage_AfterLogin));
}
}
}
private void BinhLuan_Forum_Loaded(object sender, RoutedEventArgs e)
{
txtbox_noidung.Text = "";
ws = new kidmathwebserviceSoapClient();
dsbinhluan = ws.GetDatatraLoiForumAsync().Result.Body.GetDatatraLoiForumResult.ToList <traloiForum>();
dsbinhluan = dsbinhluan.FindAll(binhluan => binhluan.idbaiviet == baivietduocchon.idbaiviet);
foreach (var binhluan in dsbinhluan)
{
binhluan.username = '******' + binhluan.username;
}
grview_dsbinhluan.ItemsSource = dsbinhluan;
ws = new kidmathwebserviceSoapClient();
string sql_congluotview = "UPDATE mainForum SET mainForum.luotxem = mainForum.luotxem + 1 WHERE mainForum.idbaiviet = '" + baivietduocchon.idbaiviet + "';";
ws.ThucHienLenhAsync(sql_congluotview);
}
private void btnclick_cauhoi(string buttonnumber)
{
if (btn_batdauthi.IsEnabled == false)
{
caudangchon = int.Parse(buttonnumber) - 1;
namedapanA.Visibility = Visibility.Visible;
namedapanB.Visibility = Visibility.Visible;
namedapanC.Visibility = Visibility.Visible;
namedapanD.Visibility = Visibility.Visible;
daa.Visibility = Visibility.Visible;
dab.Visibility = Visibility.Visible;
dac.Visibility = Visibility.Visible;
dad.Visibility = Visibility.Visible;
ws = new kidmathwebserviceSoapClient();
List <danhSachCauHoi> dscauhoi = new List <danhSachCauHoi>();
dscauhoi = ws.getDataDanhSachCauHoiAsync().Result.Body.getDataDanhSachCauHoiResult.ToList <danhSachCauHoi>();
danhSachCauHoi cauhoi = new danhSachCauHoi();
cauhoi = dscauhoi.Find(quest => quest.maCauHoi == buttonnumber && quest.maBai == mabaihocdangthi);
txtblock_Cauhoi.Text = cauhoi.tenCauHoi;
txtblock_A.Text = cauhoi.A;
txtblock_B.Text = cauhoi.B;
txtblock_C.Text = cauhoi.C;
txtblock_D.Text = cauhoi.D;
if (ketquabaithi[caudangchon] == 'A')
{
namedapanA.IsChecked = true;
}
else if (ketquabaithi[caudangchon] == 'B')
{
namedapanB.IsChecked = true;
}
else if (ketquabaithi[caudangchon] == 'C')
{
namedapanC.IsChecked = true;
}
else if (ketquabaithi[caudangchon] == 'D')
{
namedapanD.IsChecked = true;
}
dapandung[caudangchon] = cauhoi.dapAnDung;
}
else
{
var msgerr = new MessageDialog("Lỗi xảy ra khi chọn câu hỏi. Hãy chắc chắn rằng bạn đã chọn bài và ấn vào nút Bắt đầu thi").ShowAsync();
};
}
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 Userinfomation_Load(object sender, RoutedEventArgs e)
{
ws = new kidmathwebserviceSoapClient();
listuser = ws.getDataNguoiDungAsync().Result.Body.getDataNguoiDungResult.ToList <nguoiDung>();
listuser = listuser.FindAll(user => user.username != "admin" && user.username != "");
foreach (var user in listuser)
{
if (user.kieuThanhVien == "U")
{
user.kieuThanhVien = "Bình thường";
}
else if (user.kieuThanhVien == "B")
{
user.kieuThanhVien = "Bị khóa";
}
}
gvsachnguoidung.ItemsSource = listuser;
}
private async void insertUser()
{
ws = new kidmathwebserviceSoapClient();
string sql = "INSERT into nguoiDung values('" + txtbox_username.Text + "','" + passwdbox_xacnhanmatkhau.Password.ToString() + "'" +
",'" + txtbox_hovaten.Text + "','" + txtbox_sdt.Text + "','" + txtbox_email.Text + "',0,0,'U');";
int ketqua = ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult;
if (ketqua != 0)
{
await dangkythanhcongAsync();
}
else if (passwdbox_matkhau.Password.ToString() != passwdbox_xacnhanmatkhau.Password.ToString())
{
await baoloidangky_password();
}
else
{
await baoloidangky_null();
}
}
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));
}
}
async private void Btn_Dangnhap_Click(object sender, RoutedEventArgs e)
{
username = Txtbox_Username.Text.ToString();
password = Passwdbox_Password.Password.ToString();
if (username == "")
{
await(new MessageDialog("Vui lòng nhập tên người dùng", "Thông báo").ShowAsync());
return;
}
if (password == "")
{
await(new MessageDialog("Vui lòng nhập mật khẩu", "Thông báo").ShowAsync());
return;
}
ws = new kidmathwebserviceSoapClient();
List <nguoiDung> listnguoidung = new List <nguoiDung>();
listnguoidung = ws.getDataNguoiDungAsync().Result.Body.getDataNguoiDungResult.ToList <nguoiDung>();
nguoiDung sessionuser = listnguoidung.Find(user => user.username == username && user.password == password);
if (sessionuser == null)
{
await(new MessageDialog("Tên tài khoản hoặc mật khẩu không chính xác", "Error").ShowAsync());
}
else
{
UserSession.userlogined = sessionuser;
if (sessionuser.kieuThanhVien == "B")
{
var msg = new MessageDialog("Tài khoản của bạn đã bị khóa, liên hệ [email protected] để được hỗ trợ", "Error").ShowAsync();
}
if (sessionuser.kieuThanhVien == "A")
{
this.Frame.Navigate(typeof(AdminMainPage));
}
if (sessionuser.kieuThanhVien == "U")
{
this.Frame.Navigate(typeof(MainPage_AffterLogin));
}
}
}
private void selectionchange_dsbaitrong1chuong(object sender, SelectionChangedEventArgs e)
{
bai selectedbai = ListView_dsbai.SelectedItem as bai;
baiduocchon = selectedbai;
if (selectedbai != null || videoduocchon != null)
{
ws = new kidmathwebserviceSoapClient();
videoduocchon = (ws.getDatavideoAsync().Result.Body.getDatavideoResult.ToList <video>()).Find(video => video.maBai == baiduocchon.maBai);
txtblock_linkVideo.Text = videoduocchon.linkvideo;
txtblock_tenVideo.Text = videoduocchon.tenBai;
txtblock_maVideo.Text = videoduocchon.maBai;
}
else
{
txtblock_linkVideo.Text = " Trống !";
txtblock_tenVideo.Text = " Trống !";
txtblock_maVideo.Text = " Trống !";
}
}
private async void updateUser()
{
txtblock_password.IsEnabled = true;
txtblock_tenNguoiDung.IsEnabled = true;
txtblock_email.IsEnabled = true;
txtblock_soDienThoai.IsEnabled = true;
ws = new kidmathwebserviceSoapClient();
string sql = " UPDATE nguoiDung SET nguoiDung.passwd = '" + txtblock_password.Text +
"', nguoiDung.tenNguoiDung = N'" + txtblock_tenNguoiDung.Text + "',nguoiDung.email = '" +
txtblock_email.Text + "',nguoiDung.soDienThoai= '" + txtblock_soDienThoai.Text +
"' WHERE nguoiDung.username = '******'; ";
int ketqua = ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult;
if (ketqua != 0)
{
await dangkythanhcongAsync();
txtblock_password.IsEnabled = false;
passwdbox_xacnhanmatkhau.IsEnabled = false;
txtblock_tenNguoiDung.IsEnabled = false;
txtblock_email.IsEnabled = false;
txtblock_soDienThoai.IsEnabled = false;
suathongtin.IsEnabled = true;
huysuathongtin.Visibility = Visibility.Collapsed;
luuthongtin.Visibility = Visibility.Collapsed;
suathongtin.Opacity = 1;
stpn1.Opacity = 1;
stpn2.Opacity = 1;
txtblock_password.PlaceholderText = "******";
passwdbox_xacnhanmatkhau.Visibility = Visibility.Collapsed;
}
else if (txtblock_password.Text != passwdbox_xacnhanmatkhau.Text)
{
await baoloidangky_password();
}
else
{
await baoloidangky_null();
}
}
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 btnclick_luuchinhsuakhoahoc(object sender, RoutedEventArgs e)
{
khoahocsauchinhsua.tenKhoaHoc = txtblock_adpage_tenkhoahoc.Text;
khoahocsauchinhsua.tenGiaoVien = txtblock_tenGiaoVien.Text;
khoahocsauchinhsua.imagelink = txtblock_ImageLink.Text;
khoahocsauchinhsua.giaKhoaHoc = txtblock_giaKhoaHoc.Text;
khoahocsauchinhsua.giaKhuyenMai = txtblock_giaKhuyenMai.Text;
khoahocsauchinhsua.thoiGianKhuyenMai = txtblock_thoiGianKhuyenMai.Text;
khoahocsauchinhsua.maKhoaHoc = txtblock_maKhoaHoc.Text;
khoahocsauchinhsua.maLop = txtblock_maLop.Text;
khoahocsauchinhsua.soNguoiDaMua = Convert.ToInt32(txtblock_soNguoiDaMua.Text);
khoahocsauchinhsua.thongTinKhoaHoc = txtbox_thongTinKhoaHoc.Text;
string sql = "UPDATE khoaHoc SET maKhoaHoc ='" + khoahocsauchinhsua.maKhoaHoc + "',tenKHoaHoc =N'" + khoahocsauchinhsua.tenKhoaHoc + "',tenGiaoVien=N'" + khoahocsauchinhsua.tenGiaoVien + "',thongTinKhoaHoc =N'" + khoahocsauchinhsua.thongTinKhoaHoc + "',soNguoiDaMua=" + khoahocsauchinhsua.soNguoiDaMua + ",giaKHoaHoc =" + Convert.ToInt32(khoahocsauchinhsua.giaKhoaHoc) + ",giaKhuyenMai =" + Convert.ToInt32(khoahocsauchinhsua.giaKhuyenMai) + ",thoiGianKhuyenMai =N'" + khoahocsauchinhsua.giaKhuyenMai + "',maLop =N'" + khoahocsauchinhsua.maLop + "'," +
"imagelink =N'" + khoahocsauchinhsua.imagelink + "' WHERE maKhoaHoc ='" + khoahoccanchinhsua.maKhoaHoc + "';";
ws = new kidmathwebserviceSoapClient();
if (ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult != 0)
{
var msg = new MessageDialog("Cập nhật dữ liệu thành công");
msg.Commands.Add(new UICommand()
{
Id = 0, Label = "Tải lại trang"
});
msg.Commands.Add(new UICommand()
{
Id = 1, Label = "Tiếp tục"
});
var rs = await msg.ShowAsync();
if ((int)rs.Id == 0)
{
this.Frame.Navigate(typeof(Chinhsuakhoahoc));
}
}
else
{
var msg = new MessageDialog("Cập nhật dữ liệu lỗi").ShowAsync();
}
}
private void PageDanhGia_Loaded(object sender, RoutedEventArgs e)
{
ws = new kidmathwebserviceSoapClient();
dsdanhGia = ws.getDataDanhGiaAsync().Result.Body.getDataDanhGiaResult.ToList <danhGia>();
dsdanhGia = dsdanhGia.FindAll(danhGia => danhGia.username != "");
foreach (var danhGia in dsdanhGia)
{
//c : chưa duyệt ; d: đã duyệt
if (danhGia.tinhTrang == "d")
{
danhGia.tinhTrang = "Đã duyệt";
}
else if (danhGia.tinhTrang == "c")
{
danhGia.tinhTrang = "Phê duyệt";
}
// danhGia.maKhoaHoc = "Mã khóa học: " + danhGia.maKhoaHoc + " Điểm đánh giá: ";
}
gvdsachdanhgia.ItemsSource = dsdanhGia;
}
private async System.Threading.Tasks.Task naptienAsync()
{
string capcha = txtbox_capcha.Text;
DateTime now = DateTime.Now;
if (txtbox_nhaplaicapcha.Text != capcha)
{
var msg = new MessageDialog("Nhập sai mã", "Error").ShowAsync();
txtbox_capcha.Text = RandomString(6);
}
else
{
ws = new kidmathwebserviceSoapClient();
string sql = "INSERT into thongBao values('naptien','c','" + UserSession.userlogined.username + "',N'Yêu cầu nạp tiền',N'Số tiền: " + txtbox_sotien.Text + " User: "******"" +
" Mã giao dịch: " + txtbox_magiaodich.Text + " Số tài khoản: " + txtbox_sotaikhoan.Text + "','" + now + "'," + txtbox_sotien.Text + ");";
if (ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult != 0)
{
var msg = new MessageDialog("Đã gửi yêu cầu nạp tới Admin");
msg.Commands.Add(new UICommand()
{
Id = 0, Label = "Tiếp tục"
});
msg.Commands.Add(new UICommand()
{
Id = 1, Label = "Quay về trang chủ"
});
var rs = await msg.ShowAsync();
if ((int)rs.Id == 0)
{
this.Frame.Navigate(typeof(NaptienPage));
}
else if ((int)rs.Id == 1)
{
this.Frame.Navigate(typeof(MainPage_AffterLogin));
}
}
}
}
private void guibinhluan(object sender, RoutedEventArgs e)
{
if (txtbox_noidung.Text == "")
{
var msgerr = new MessageDialog("Vui lòng nhập nội dung bình luận", "Error").ShowAsync();
}
else
{
DateTime now = DateTime.Now;
traloiForum binhluancuaban = new traloiForum();
binhluancuaban.idbaiviet = baivietduocchon.idbaiviet;
binhluancuaban.binhLuan = txtbox_noidung.Text;
binhluancuaban.tenNguoiDung = "Đặng Rất Giàu"; //UserSession.userlogined.tenNguoiDung;
binhluancuaban.username = "******"; //UserSession.userlogined.username;
binhluancuaban.ngayBinhLuan = now;
ws = new kidmathwebserviceSoapClient();
string sql = "INSERT into traloiForum values('" + binhluancuaban.idbaiviet + "','" + binhluancuaban.username + "',N'" + binhluancuaban.tenNguoiDung + "',N'" + binhluancuaban.binhLuan + "','" + binhluancuaban.ngayBinhLuan + "');";
if (ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult != 0)
{
ws = new kidmathwebserviceSoapClient();
string sql_congluotxem = "UPDATE mainForum SET mainForum.luotbinhluan = mainForum.luotbinhluan + 1 WHERE mainForum.idbaiviet = '" + baivietduocchon.idbaiviet + "';";
if (ws.ThucHienLenhAsync(sql_congluotxem).Result.Body.ThucHienLenhResult != 0)
{
this.Frame.Navigate(typeof(binhLuan_Forum));
}
else
{
var msg = new MessageDialog("Cộng lượt bình luận xảy ra lỗi", "Error").ShowAsync();
}
}
else
{
var msg2 = new MessageDialog("Thêm câu trả lời lỗi", "Error").ShowAsync();
}
}
}
private async void Xoabaidanhgia(object sender, RoutedEventArgs e)
{
Button userstatus = sender as Button;
danhGia temp = userstatus.DataContext as danhGia;
if (temp.tinhTrang == "Đã duyệt")
{
var msg_ = new MessageDialog("Không thể xóa đánh giá đã phê duyệt").ShowAsync();
}
else if (temp.tinhTrang == "Phê duyệt")
{
var msg_2 = new MessageDialog("Đánh giá chưa được duyệt ! Bạn muốn xóa");
msg_2.Commands.Add(new UICommand()
{
Id = 0, Label = "Xác nhận"
});
msg_2.Commands.Add(new UICommand()
{
Id = 1, Label = "Hủy"
});
var rs = await msg_2.ShowAsync();
if ((int)rs.Id == 0)
{
string sql_xoathongbao = "DELETE FROM danhGia WHERE danhGia.ngayDuyet = '" + temp.ngayDuyet + "';";
ws = new kidmathwebserviceSoapClient();
if (ws.ThucHienLenhAsync(sql_xoathongbao).Result.Body.ThucHienLenhResult != 0)
{
var msg_ = new MessageDialog("Đã xóa").ShowAsync();
this.Frame.Navigate(typeof(PageDanhGia));
}
else
{
var msg_1 = new MessageDialog("Xảy ra lỗi").ShowAsync();
}
}
}
}
private async System.Threading.Tasks.Task thongbaoAsync()
{
string capcha = txtbox_capcha.Text;
DateTime now = DateTime.Now;
if (txtbox_nhaplaicapcha.Text != capcha)
{
var msg = new MessageDialog("Nhập sai mã", "Error").ShowAsync();
txtbox_capcha.Text = RandomString(6);
}
else
{
ws = new kidmathwebserviceSoapClient();
string sql = "INSERT into thongBao values('phanhoi','c','" + UserSession.userlogined.username + "',N'" + txtbox_tieude.Text + "',N'" + txtbox_noidung + "','" + now + "',0);";
if (ws.ThucHienLenhAsync(sql).Result.Body.ThucHienLenhResult != 0)
{
var msg = new MessageDialog("Đã gửi câu hỏi đến bộ phận tư vấn");
msg.Commands.Add(new UICommand()
{
Id = 0, Label = "Tiếp tục"
});
msg.Commands.Add(new UICommand()
{
Id = 1, Label = "Quay về trang chủ"
});
var rs = await msg.ShowAsync();
if ((int)rs.Id == 0)
{
this.Frame.Navigate(typeof(NaptienPage));
}
else if ((int)rs.Id == 1)
{
this.Frame.Navigate(typeof(MainPage_AffterLogin));
}
}
}
}
