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