public static void AddLH (LichHoc lt, SQLiteConnection connection)
{
DataProvider dtb = new DataProvider (connection);
if (dtb.GetLH_Ma (lt.MaMH) == null) {
dtb.AddLH (lt);
}
}
public static bool AddLH (LichHoc lh, SQLiteConnection connection)
{
DataProvider dtb = new DataProvider (connection);
if (dtb.GetLH_Ma (lh.MaMH, lh.NamHoc,lh.HocKy) == null) {
dtb.AddLH (lh);
return true;
}
return false;
}
public static async Task<List<LichHoc>> MakeDataFromXml (SQLiteConnection connection)
{
if (BUser.GetMainUser (connection) != null) {
list = new List<LichHoc> ();
var httpClient = new HttpClient ();
httpClient.Timeout = TimeSpan.FromSeconds (20);
Task<string> contentsTask = httpClient.GetStringAsync (UrlHelper.UrlLH(BUser.GetMainUser(connection).Id));
string contents;
try
{
contents = await contentsTask;
}
catch(Exception e) {
return null;
}
XDocument doc = XDocument.Parse (contents);
//get lichthi
IEnumerable<XElement> childList =
from el in doc.Root.Elements ()
select el;
//get attri lichthi
int k = GetId (connection);
DataProvider dtb = new DataProvider (connection);
foreach (XElement node in childList) {
LichHoc lichhoc = new LichHoc ();
lichhoc = dtb.GetLH_Ma (node.Elements ().ElementAt (3).Value.Trim (),node.Elements ().ElementAt (4).Value.Trim (),node.Elements ().ElementAt (1).Value.Trim ());
if (lichhoc != null) {
chiTietLH ct = new chiTietLH ();
ct.Id = lichhoc.Id;
ct.CBGD = node.Elements ().ElementAt (0).Value.Trim ();
ct.Phong = node.Elements ().ElementAt (6).Value.Trim ();
ct.Thu = node.Elements ().ElementAt (11).Value.Trim ();
ct.TietBatDau = node.Elements ().ElementAt (12).Value.Trim ();
ct.SoTiet = node.Elements ().ElementAt (8).Value.Trim ();
ct.ThoigianBD = node.Elements ().ElementAt (10).Value.Trim ().Substring (0, 10);
ct.ThoigianKT = node.Elements ().ElementAt (10).Value.Trim ().Substring (12);
ct.Tuan = convertToDate (setTKB_Tuan (node.Elements ().ElementAt (13).Value.Trim ()),ct.ThoigianBD);
AddCTLH (connection, ct);
} else {
k++;
LichHoc lh = new LichHoc ();
MonHoc mh = new MonHoc ();
lh.Id = k.ToString ();
lh.MaMH = node.Elements ().ElementAt (3).Value.Trim ();
lh.MaLop = node.Elements ().ElementAt (2).Value.Trim ();
lh.NhomMH = node.Elements ().ElementAt (5).Value.Trim ();
lh.HocKy = node.Elements ().ElementAt (1).Value.Trim ();
lh.NamHoc = node.Elements ().ElementAt (4).Value.Trim ();
mh.MaMH = lh.MaMH;
mh.TenMH = node.Elements ().ElementAt (9).Value.Trim ();
mh.SoTC = int.Parse (node.Elements ().ElementAt (7).Value.Trim ());
chiTietLH ct = new chiTietLH ();
ct.Id = k.ToString ();
ct.CBGD = node.Elements ().ElementAt (0).Value.Trim ();
ct.Phong = node.Elements ().ElementAt (6).Value.Trim ();
ct.Thu = node.Elements ().ElementAt (11).Value.Trim ();
ct.TietBatDau = node.Elements ().ElementAt (12).Value.Trim ();
ct.SoTiet = node.Elements ().ElementAt (8).Value.Trim ();
ct.ThoigianBD = node.Elements ().ElementAt (10).Value.Trim ().Substring (0, 10);
ct.ThoigianKT = node.Elements ().ElementAt (10).Value.Trim ().Substring (12);
ct.Tuan = convertToDate (setTKB_Tuan (node.Elements ().ElementAt (13).Value.Trim ()),ct.ThoigianBD);
AddCTLH (connection, ct);
bool done=AddLH (lh, connection);
if (done) {
list.Add (lh);
}
BMonHoc.Add (connection, mh);
}
}
return list;
}
return null;
}
public static LichHoc GetLH (SQLiteConnection connection, string id, string namHoc, string hocKy)
{
DataProvider dtb = new DataProvider (connection);
return dtb.GetLH_Ma (id, namHoc , hocKy);
}
public static async Task<List<LichHoc>> MakeDataFromXml (SQLiteConnection connection)
{
list = new List<LichHoc> ();
var httpClient = new HttpClient ();
Task<string> contentsTask = httpClient.GetStringAsync("http://www.schoolapi.somee.com/api/thoikhoabieu/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
int k = GetId (connection);
DataProvider dtb = new DataProvider (connection);
foreach (XElement node in childList) {
LichHoc lichhoc = new LichHoc ();
lichhoc = dtb.GetLH_Ma (node.Elements ().ElementAt (3).Value.Trim());
if (lichhoc!=null) {
chiTietLH ct = new chiTietLH ();
ct.Id = lichhoc.Id;
ct.CBGD = node.Elements ().ElementAt (0).Value.Trim ();
ct.Phong = node.Elements ().ElementAt (6).Value.Trim ();
ct.Thu = node.Elements ().ElementAt (11).Value.Trim ();
ct.TietBatDau = node.Elements ().ElementAt (12).Value.Trim ();
ct.SoTiet = node.Elements ().ElementAt (8).Value.Trim ();
ct.ThoigianBD = node.Elements ().ElementAt (10).Value.Trim ().Substring (0, 10);
ct.ThoigianKT = node.Elements ().ElementAt (10).Value.Trim ().Substring (12);
ct.Tuan = node.Elements ().ElementAt (13).Value.Trim ();
AddCTLH (connection, ct);
} else {
k++;
LichHoc lh = new LichHoc ();
MonHoc mh = new MonHoc ();
lh.Id = k.ToString ();
lh.MaMH = node.Elements ().ElementAt (3).Value.Trim ();
lh.MaLop = node.Elements ().ElementAt (2).Value.Trim ();
lh.NhomMH = node.Elements ().ElementAt (5).Value.Trim ();
lh.HocKy = node.Elements ().ElementAt (1).Value.Trim ();
lh.NamHoc = node.Elements ().ElementAt (4).Value.Trim ();
mh.MaMH = lh.MaMH;
mh.TenMH = node.Elements ().ElementAt (9).Value.Trim ();
mh.SoTC = int.Parse (node.Elements ().ElementAt (7).Value.Trim ());
chiTietLH ct = new chiTietLH ();
ct.Id = k.ToString ();
ct.CBGD = node.Elements ().ElementAt (0).Value.Trim ();
ct.Phong = node.Elements ().ElementAt (6).Value.Trim ();
ct.Thu = node.Elements ().ElementAt (11).Value.Trim ();
ct.TietBatDau = node.Elements ().ElementAt (12).Value.Trim ();
ct.SoTiet = node.Elements ().ElementAt (8).Value.Trim ();
ct.ThoigianBD = node.Elements ().ElementAt (10).Value.Trim ().Substring (0, 10);
ct.ThoigianKT = node.Elements ().ElementAt (10).Value.Trim ().Substring (12);
ct.Tuan = node.Elements ().ElementAt (13).Value.Trim ();
AddCTLH (connection, ct);
list.Add (lh);
AddLH (lh, connection);
BMonHoc.Add (connection, mh);
}
}
return list;
}
