public static int Add(DiemThi lt,SQLiteConnection connection ) { DataProvider dtb = new DataProvider (connection); if (dtb.GetDT (lt.NamHoc,lt.Hocky).Count==0) { return dtb.AddDT (lt); } return 0; }
public static async Task<List<DiemThi>> MakeDataFromXml(SQLiteConnection connection) { list = new List<DiemThi> (); var httpClient = new HttpClient (); Task<string> contentsTask = httpClient.GetStringAsync("http://www.schoolapi.somee.com/api/diemthi/3111410094"); string contents = await contentsTask; XDocument doc = XDocument.Parse (contents); //get lichthi IEnumerable<XElement> childList = from el in doc.Root.Elements () select el; //get attri lichthi foreach (XElement node in childList) { DiemThi lt = new DiemThi(); lt.DiemRL = node.Elements().ElementAt(0).Value.Trim(); foreach (XElement nod in node.Elements().ElementAt(5).Elements()) { DiemMon dm = new DiemMon(); MonHoc mh = new MonHoc(); dm.Hocky = int.Parse(node.Elements().ElementAt(9).Value.Trim()[7].ToString()); dm.NamHoc = int.Parse(node.Elements().ElementAt(9).Value.Trim().Substring(17)); dm.DiemKT = nod.Elements().ElementAt(0).Value.Trim(); // change TIle & also happened in BlichHOc dm.MaMH = nod.Elements().ElementAt(1).Value.Trim(); mh.MaMH = dm.MaMH; mh.TenMH = nod.Elements().ElementAt(5).Value.Trim(); mh.SoTC = int.Parse(nod.Elements().ElementAt(4).Value.Trim()); mh.TiLeThi = int.Parse(nod.Elements().ElementAt(3).Value.Trim()); dm.DiemThi = nod.Elements().ElementAt(6).Value.Trim(); dm.DiemTK10 = nod.Elements ().ElementAt (7).Value.Trim (); dm.DiemChu = nod.Elements ().ElementAt (8).Value.Trim (); AddDM(dm,connection); BMonHoc.Add (connection, mh); BMonHoc.UpdateMH(connection,mh); } lt.DiemTB4 = node.Elements().ElementAt(1).Value.Trim(); lt.DiemTB10 = node.Elements().ElementAt(2).Value.Trim(); lt.DiemTBTL4 = node.Elements().ElementAt(3).Value.Trim(); lt.DiemTBTL10 = node.Elements().ElementAt(4).Value.Trim(); lt.LoaiRL = node.Elements().ElementAt(6).Value.Trim(); lt.SoTCDat = node.Elements().ElementAt(7).Value.Trim(); lt.SoTCTL = node.Elements().ElementAt(8).Value.Trim(); lt.NamHoc = int.Parse(node.Elements().ElementAt(9).Value.Trim().Substring(17)); lt.Hocky = int.Parse(node.Elements().ElementAt(9).Value.Trim()[7].ToString()); Add(lt,connection); list.Add(lt); } return list; }
public void UpdateCell(DiemThi dt) { TB10.Text = "Điểm TB Hệ 10: "+dt.DiemTB10; TB4.Text ="Điểm TB Hệ 4: "+ dt.DiemTB4; TC.Text = "Số TC Đạt: " + dt.SoTCDat; TCTL.Text = "Số TCTL:" + dt.SoTCTL; TBTL10.Text = "Điểm TB TL Hệ 10: " + dt.DiemTBTL10; TBTL4.Text = "Điểm TB TL Hệ 4: " + dt.DiemTBTL4; DRL.Text = "Điểm Rèn Luyện: " + dt.DiemRL; }
public int AddDT (DiemThi T) { int i = _connection.Insert (T); _connection.Commit (); return i; }
public static async Task<List<DiemThi>> MakeDataFromXml (SQLiteConnection connection) { if (BUser.GetMainUser (connection) != null) { list = new List<DiemThi> (); var httpClient = new HttpClient (); httpClient.Timeout = TimeSpan.FromSeconds (30); string contents; Task<string> contentsTask = httpClient.GetStringAsync (UrlHelper.UrlDT(BUser.GetMainUser(connection).Id)); try{ contents = await contentsTask; } catch { return null; } XDocument doc = XDocument.Parse (contents); //get lichthi IEnumerable<XElement> childList = from el in doc.Root.Elements () select el; //get attri lichthi foreach (XElement node in childList) { DiemThi lt = new DiemThi (); lt.DiemRL = node.Elements ().ElementAt (0).Value.Trim (); foreach (XElement nod in node.Elements().ElementAt(5).Elements()) { DiemMon dm = new DiemMon (); MonHoc mh = new MonHoc (); dm.Hocky = node.Elements ().ElementAt (9).Value.Trim () [7].ToString (); dm.NamHoc = node.Elements ().ElementAt (9).Value.Trim ().Substring (17); dm.DiemKT = nod.Elements ().ElementAt (0).Value.Trim (); dm.MaMH = nod.Elements ().ElementAt (1).Value.Trim (); mh.MaMH = dm.MaMH; mh.TenMH = nod.Elements ().ElementAt (5).Value.Trim (); mh.SoTC = int.Parse (nod.Elements ().ElementAt (4).Value.Trim ()); mh.TiLeThi = int.Parse (nod.Elements ().ElementAt (3).Value.Trim ()); dm.DiemThi = nod.Elements ().ElementAt (6).Value.Trim (); dm.DiemTK10 = nod.Elements ().ElementAt (7).Value.Trim (); dm.DiemChu = nod.Elements ().ElementAt (8).Value.Trim (); AddDM (dm, connection); BMonHoc.Add (connection, mh); BMonHoc.UpdateMH (connection, mh); } lt.DiemTB4 = node.Elements ().ElementAt (1).Value.Trim (); lt.DiemTB10 = node.Elements ().ElementAt (2).Value.Trim (); lt.DiemTBTL4 = node.Elements ().ElementAt (3).Value.Trim (); lt.DiemTBTL10 = node.Elements ().ElementAt (4).Value.Trim (); lt.LoaiRL = node.Elements ().ElementAt (6).Value.Trim (); lt.SoTCDat = node.Elements ().ElementAt (7).Value.Trim (); lt.SoTCTL = node.Elements ().ElementAt (8).Value.Trim (); lt.NamHoc = node.Elements ().ElementAt (9).Value.Trim ().Substring (17); lt.Hocky = node.Elements ().ElementAt (9).Value.Trim () [7].ToString (); Add (lt, connection); list.Add (lt); } return list; } return null; }
async void LoadData (string hocKy, string namHoc) { listViewDT.Visibility = ViewStates.Invisible; progress.Visibility = ViewStates.Visible; progress.Indeterminate = true; btnHKKe.Enabled = false; btnHKTruoc.Enabled = false; btnHKTruoc.SetBackgroundResource(Android.Resource.Color.DarkerGray); btnHKKe.SetBackgroundResource (Android.Resource.Color.DarkerGray); DiemThi diemThi = new DiemThi (); if (Common.checkNWConnection (Activity) == true && autoupdate == true&&isfirst) { var rs= await BDiemThi.MakeDataFromXml (SQLite_Android.GetConnection ()); if (rs==null) { Toast.MakeText (Activity, "Xảy ra lỗi trong quá trình cập nhật dữ liệu từ server", ToastLength.Long).Show(); } } if (hocKy == "0") { diemThi = BDiemThi.GetNewestDT (SQLite_Android.GetConnection ()); if (diemThi != null) { lastnh = diemThi.NamHoc; lasthk = diemThi.Hocky; btnHKTruoc.Enabled = true; btnHKTruoc.SetBackgroundResource(Android.Resource.Color.HoloBlueDark); } } else { diemThi = BDiemThi.GetDT (SQLite_Android.GetConnection (), hocKy, namHoc); btnHKKe.Enabled = true; btnHKTruoc.Enabled = true; btnHKTruoc.SetBackgroundResource(Android.Resource.Color.HoloBlueDark); btnHKKe.SetBackgroundResource (Android.Resource.Color.HoloBlueDark); int t=0; while (diemThi == null&&t<3) { string hK; string nH; Common.calSemester (hocKy, namHoc, btn_value, out hK, out nH); diemThi = BDiemThi.GetDT (SQLite_Android.GetConnection (), hK, nH); t++; } if (t == 3 && diemThi == null) { btnHKTruoc.Enabled = false; btnHKTruoc.SetBackgroundResource(Android.Resource.Color.DarkerGray); } } lbl_HK.Text = hocKy; lbl_NH.Text = namHoc; if (diemThi != null) { if (lastnh.Equals (diemThi.NamHoc) && lasthk.Equals (diemThi.Hocky)) { btnHKKe.Enabled = false; btnHKKe.SetBackgroundResource(Android.Resource.Color.DarkerGray); } listViewDT.Visibility=ViewStates.Visible; List<DiemMon> listDM = BDiemThi.GetDiemMons (SQLite_Android.GetConnection (), diemThi.Hocky, diemThi.NamHoc); lbl_HK.Text = diemThi.Hocky; lbl_NH.Text = diemThi.NamHoc; DiemThiHKAdapter adapter = new DiemThiHKAdapter (Activity, listDM); listViewDT.Adapter = adapter; txtNotify.Visibility = ViewStates.Gone; // radioGroup.Visibility = ViewStates.Visible; linear.Visibility = ViewStates.Visible; linearDT.Visibility = ViewStates.Visible; isfirst=false; } else { linear.Visibility = ViewStates.Invisible; linearDT.Visibility = ViewStates.Invisible; listViewDT.Visibility=ViewStates.Invisible; txtNotify.Visibility = ViewStates.Visible; txtNotify.Text = "Hiện tại điểm thi chưa có dữ liệu. Xin vui lòng thử lại sau!!!"; } progress.Indeterminate = false; progress.Visibility = ViewStates.Gone; }