public static List <DiemMon> getDiemMon(int namhoc, int hocky)
{
List <DiemMon> listct = new List <DiemMon>();
string query = "select * from DiemMon where NamHoc=" + namhoc + " and HocKy=" + hocky;
DataTable db = DataProvider.LoadData(query);
for (int i = 0; i < db.Rows.Count; i++)
{
DiemMon dm = new DiemMon();
dm.Hocky = hocky;
dm.NamHoc = namhoc;
dm.DiemKT = db.Rows[i]["DiemKT"].ToString();
dm.DiemThi = db.Rows[i]["DiemThi"].ToString();
dm.DiemTK10 = db.Rows[i]["DiemTK10"].ToString();
dm.DiemChu = db.Rows[i]["DiemChu"].ToString();
dm.MonHoc.MaMH = db.Rows[i]["MaMH"].ToString();
listct.Add(dm);
}
foreach (DiemMon dm in listct)
{
dm.MonHoc = BMonHoc.getByMaMH(dm.MonHoc.MaMH);
}
return(listct);
}
public static List<DiemMon> getDiemMon(int namhoc, int hocky)
{
List<DiemMon> listct = new List<DiemMon>();
string query = "select * from DiemMon where NamHoc=" + namhoc + " and HocKy=" + hocky;
DataTable db = DataProvider.LoadData(query);
for (int i = 0; i < db.Rows.Count; i++)
{
DiemMon dm = new DiemMon();
dm.Hocky = hocky;
dm.NamHoc = namhoc;
dm.DiemKT=db.Rows[i]["DiemKT"].ToString();
dm.DiemThi = db.Rows[i]["DiemThi"].ToString();
dm.DiemTK10 = db.Rows[i]["DiemTK10"].ToString();
dm.DiemChu = db.Rows[i]["DiemChu"].ToString();
dm.MonHoc.MaMH = db.Rows[i]["MaMH"].ToString();
listct.Add(dm);
}
foreach (DiemMon dm in listct)
{
dm.MonHoc = BMonHoc.getByMaMH(dm.MonHoc.MaMH);
}
return listct;
}
static void AddDiemMon(DiemMon dm)
{
string query = string.Format("select * from DiemMon where MaMH='{0}' and NamHoc={1} and HocKy={2}", dm.MonHoc.MaMH, dm.NamHoc, dm.Hocky);
if (DataProvider.LoadData(query).Rows.Count == 0)
{
string sql = string.Format("Insert into DiemMon values('{0}','{1}','{2}','{3}','{4}',{5},{6})", dm.MonHoc.MaMH, dm.DiemKT, dm.DiemThi, dm.DiemTK10, dm.DiemChu, dm.Hocky, dm.NamHoc);
DataProvider.Insert(sql);
}
}
public static List <DiemThi> LoadDataFromSV(string id)
{
list = new List <DiemThi>();
XmlDocument doc = new XmlDocument();
doc.Load("http://localhost:56715/api/diemthi/" + id);
XmlElement root = doc.DocumentElement;
foreach (XmlNode node in root.ChildNodes)
{
DiemThi lt = new DiemThi();
lt.DiemRL = node.ChildNodes[0].InnerText.Trim();
lt.DiemMons = new List <DiemMon>();
foreach (XmlNode nod in node.ChildNodes[5].ChildNodes)
{
DiemMon dm = new DiemMon();
MonHoc mh = new MonHoc();
dm.Hocky = int.Parse(node.ChildNodes[9].InnerText.Trim()[7].ToString());
dm.NamHoc = int.Parse(node.ChildNodes[9].InnerText.Trim().Substring(17));
dm.DiemKT = nod.ChildNodes[0].InnerText;
dm.MonHoc = new MonHoc();
dm.MonHoc.MaMH = nod.ChildNodes[1].InnerText;
mh.MaMH = dm.MonHoc.MaMH;
mh.TenMH = nod.ChildNodes[5].InnerText;
mh.SoTC = int.Parse(nod.ChildNodes[4].InnerText);
mh.TileThi = int.Parse(nod.ChildNodes[3].InnerText.ToString());
dm.DiemThi = nod.ChildNodes[6].InnerText;
dm.DiemTK10 = nod.ChildNodes[7].InnerText;
dm.DiemChu = nod.ChildNodes[8].InnerText;
lt.DiemMons.Add(dm);
AddDiemMon(dm);
BMonHoc.AddMon(mh);
BMonHoc.UpdateMH(mh);
}
lt.DiemTB4 = node.ChildNodes[1].InnerText.Trim();
lt.DiemTB10 = node.ChildNodes[2].InnerText.Trim();
lt.DiemTBTL4 = node.ChildNodes[3].InnerText.Trim();
lt.DiemTBTL10 = node.ChildNodes[4].InnerText.Trim();
lt.LoaiRL = node.ChildNodes[6].InnerText.Trim();
lt.SoTCDat = node.ChildNodes[7].InnerText.Trim();
lt.SoTCTL = node.ChildNodes[8].InnerText.Trim();
lt.NamHoc = int.Parse(node.ChildNodes[9].InnerText.Trim().Substring(17));
lt.Hocky = int.Parse(node.ChildNodes[9].InnerText.Trim()[7].ToString());
AddDiemThi(lt);
list.Add(lt);
}
return(list);
}
public static List<DiemThi> LoadDataFromSV(string id)
{
list = new List<DiemThi>();
XmlDocument doc = new XmlDocument();
doc.Load("http://localhost:56715/api/diemthi/"+id);
XmlElement root = doc.DocumentElement;
foreach (XmlNode node in root.ChildNodes)
{
DiemThi lt = new DiemThi();
lt.DiemRL = node.ChildNodes[0].InnerText.Trim();
lt.DiemMons = new List<DiemMon>();
foreach (XmlNode nod in node.ChildNodes[5].ChildNodes)
{
DiemMon dm = new DiemMon();
MonHoc mh = new MonHoc();
dm.Hocky = int.Parse(node.ChildNodes[9].InnerText.Trim()[7].ToString());
dm.NamHoc = int.Parse(node.ChildNodes[9].InnerText.Trim().Substring(17));
dm.DiemKT = nod.ChildNodes[0].InnerText;
dm.MonHoc = new MonHoc();
dm.MonHoc.MaMH = nod.ChildNodes[1].InnerText;
mh.MaMH = dm.MonHoc.MaMH;
mh.TenMH = nod.ChildNodes[5].InnerText;
mh.SoTC = int.Parse(nod.ChildNodes[4].InnerText);
mh.TileThi = int.Parse( nod.ChildNodes[3].InnerText.ToString());
dm.DiemThi = nod.ChildNodes[6].InnerText;
dm.DiemTK10 = nod.ChildNodes[7].InnerText;
dm.DiemChu = nod.ChildNodes[8].InnerText;
lt.DiemMons.Add(dm);
AddDiemMon(dm);
BMonHoc.AddMon(mh);
BMonHoc.UpdateMH(mh);
}
lt.DiemTB4 = node.ChildNodes[1].InnerText.Trim();
lt.DiemTB10 = node.ChildNodes[2].InnerText.Trim();
lt.DiemTBTL4 = node.ChildNodes[3].InnerText.Trim();
lt.DiemTBTL10 = node.ChildNodes[4].InnerText.Trim();
lt.LoaiRL = node.ChildNodes[6].InnerText.Trim();
lt.SoTCDat = node.ChildNodes[7].InnerText.Trim();
lt.SoTCTL = node.ChildNodes[8].InnerText.Trim();
lt.NamHoc = int.Parse(node.ChildNodes[9].InnerText.Trim().Substring(17));
lt.Hocky = int.Parse(node.ChildNodes[9].InnerText.Trim()[7].ToString());
AddDiemThi(lt);
list.Add(lt);
}
return list;
}
static void AddDiemMon(DiemMon dm)
{
string query = string.Format("select * from DiemMon where MaMH='{0}' and NamHoc={1} and HocKy={2}", dm.MonHoc.MaMH, dm.NamHoc, dm.Hocky);
if (DataProvider.LoadData(query).Rows.Count==0)
{
string sql = string.Format("Insert into DiemMon values('{0}','{1}','{2}','{3}','{4}',{5},{6})", dm.MonHoc.MaMH, dm.DiemKT,dm.DiemThi,dm.DiemTK10,dm.DiemChu, dm.Hocky, dm.NamHoc);
DataProvider.Insert(sql);
}
}