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