public static List <DiemThi> getAll()
{
string query = "select * from DiemThi";
list = new List <DiemThi>();
DataTable db = DataProvider.LoadData(query);
for (int i = 0; i < db.Rows.Count; i++)
{
DiemThi dt = new DiemThi();
dt.Hocky = int.Parse(db.Rows[i]["HocKy"].ToString());
dt.NamHoc = int.Parse(db.Rows[i]["NamHoc"].ToString());
dt.DiemTB10 = db.Rows[i]["DiemTB10"].ToString();
dt.DiemTB4 = db.Rows[i]["DiemTB4"].ToString();
dt.DiemTBTL10 = db.Rows[i]["DiemTBTL10"].ToString();
dt.DiemTBTL4 = db.Rows[i]["DiemTBTL4"].ToString();
dt.SoTCDat = db.Rows[i]["SoTCDat"].ToString();
dt.SoTCTL = db.Rows[i]["SoTCTL"].ToString();
dt.DiemRL = db.Rows[i]["DiemRL"].ToString();
dt.LoaiRL = db.Rows[i]["LoaiRL"].ToString();
list.Add(dt);
}
foreach (DiemThi dt in list)
{
dt.DiemMons = getDiemMon(dt.NamHoc, dt.Hocky);
}
return(list);
}
public static List<DiemThi> getAll()
{
string query = "select * from DiemThi";
list = new List<DiemThi>();
DataTable db = DataProvider.LoadData(query);
for (int i = 0; i < db.Rows.Count; i++)
{
DiemThi dt = new DiemThi();
dt.Hocky=int.Parse(db.Rows[i]["HocKy"].ToString());
dt.NamHoc = int.Parse(db.Rows[i]["NamHoc"].ToString());
dt.DiemTB10 =db.Rows[i]["DiemTB10"].ToString();
dt.DiemTB4 = db.Rows[i]["DiemTB4"].ToString();
dt.DiemTBTL10 = db.Rows[i]["DiemTBTL10"].ToString();
dt.DiemTBTL4 = db.Rows[i]["DiemTBTL4"].ToString();
dt.SoTCDat = db.Rows[i]["SoTCDat"].ToString();
dt.SoTCTL = db.Rows[i]["SoTCTL"].ToString();
dt.DiemRL =db.Rows[i]["DiemRL"].ToString();
dt.LoaiRL = db.Rows[i]["LoaiRL"].ToString();
list.Add(dt);
}
foreach (DiemThi dt in list)
{
dt.DiemMons = getDiemMon(dt.NamHoc, dt.Hocky);
}
return list;
}
public static void AddDiemThi(DiemThi dt)
{
string query = string.Format("select * from DiemThi where NamHoc={0} and HocKy={1}",dt.NamHoc,dt.Hocky);
if (DataProvider.LoadData(query).Rows.Count==0)
{
string sql = string.Format("Insert into DiemThi values({0},{1},'{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", dt.Hocky, dt.NamHoc,dt.DiemTB10,dt.DiemTB4,dt.DiemTBTL10,dt.DiemTBTL4,dt.SoTCDat,dt.SoTCTL,dt.DiemRL,dt.LoaiRL);
DataProvider.Insert(sql);
}
}
public static void AddDiemThi(DiemThi dt)
{
string query = string.Format("select * from DiemThi where NamHoc={0} and HocKy={1}", dt.NamHoc, dt.Hocky);
if (DataProvider.LoadData(query).Rows.Count == 0)
{
string sql = string.Format("Insert into DiemThi values({0},{1},'{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", dt.Hocky, dt.NamHoc, dt.DiemTB10, dt.DiemTB4, dt.DiemTBTL10, dt.DiemTBTL4, dt.SoTCDat, dt.SoTCTL, dt.DiemRL, dt.LoaiRL);
DataProvider.Insert(sql);
}
}
public ChiTIetForm(Object t)
{
InitializeComponent();
// LichHoc lh = (LichHoc)t;
//dataGridView1.DataSource = lh.Chitiet;
DiemThi dt = (DiemThi)t;
dataGridView1.DataSource = dt.DiemMons;
}
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;
}
