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 <LichThi> LoadDataFromSV(string id) { list = new List <LichThi>(); XmlDocument doc = new XmlDocument(); doc.Load("http://localhost:56715/api/lichthi/" + id); XmlElement root = doc.DocumentElement; foreach (XmlNode node in root.ChildNodes) { LichThi lt = new LichThi(); lt.GhepThi = node.ChildNodes[0].InnerText.Trim(); lt.GioBD = node.ChildNodes[1].InnerText.Trim(); lt.MonHoc = new MonHoc(); lt.MonHoc.MaMH = node.ChildNodes[3].InnerText.Trim(); lt.MonHoc.TenMH = node.ChildNodes[8].InnerText.Trim(); lt.NgayThi = node.ChildNodes[4].InnerText.Trim(); lt.PhongThi = node.ChildNodes[5].InnerText.Trim(); lt.SoLuong = int.Parse(node.ChildNodes[6].InnerText.Trim()); lt.SoPhut = int.Parse(node.ChildNodes[7].InnerText.Trim()); lt.ToThi = node.ChildNodes[9].InnerText.Trim(); list.Add(lt); BMonHoc.AddMon(lt.MonHoc); AddLT(lt); } return(list); }
public static List <LichThi> getAll() { list = new List <LichThi>(); string query = "select * from LichThi"; DataTable db = DataProvider.LoadData(query); for (int i = 0; i < db.Rows.Count; i++) { LichThi lt = new LichThi(); lt.MonHoc = new MonHoc(); lt.MonHoc.MaMH = db.Rows[i]["MaMH"].ToString(); lt.GhepThi = db.Rows[i]["GhepThi"].ToString(); lt.ToThi = db.Rows[i]["ToThi"].ToString(); lt.SoLuong = int.Parse(db.Rows[i]["SoLuong"].ToString()); lt.NgayThi = db.Rows[i]["NgayThi"].ToString(); lt.GioBD = db.Rows[i]["GioBD"].ToString(); lt.SoPhut = int.Parse(db.Rows[i]["SoPhut"].ToString()); lt.PhongThi = db.Rows[i]["PhongThi"].ToString(); list.Add(lt); } foreach (LichThi lt in list) { lt.MonHoc = BMonHoc.getByMaMH(lt.MonHoc.MaMH); } return(list); }
public static List <LichHoc> getAll() { string query = "select * from LichHoc"; list = new List <LichHoc>(); DataTable db = DataProvider.LoadData(query); for (int i = 0; i < db.Rows.Count; i++) { LichHoc mh = new LichHoc(); mh.Id = db.Rows[i]["Id"].ToString(); mh.MaLop = db.Rows[i]["MaLop"].ToString(); mh.ThoigianBD = db.Rows[i]["ThoigianBD"].ToString(); mh.ThoigianKT = db.Rows[i]["ThoigianKT"].ToString(); mh.NhomMH = db.Rows[i]["NhomMH"].ToString(); mh.MonHoc = new MonHoc(); mh.MonHoc.MaMH = db.Rows[i]["MaMH"].ToString(); list.Add(mh); } foreach (LichHoc lh in list) { lh.Chitiet = getChiTiets(lh.Id); lh.MonHoc = BMonHoc.getByMaMH(lh.MonHoc.MaMH); } return(list); }
public static List <LichHoc> LoadDataFromSV(string id) { list = new List <LichHoc>(); XmlDocument doc = new XmlDocument(); doc.Load("http://localhost:56715/api/thoikhoabieu/" + id); XmlElement root = doc.DocumentElement; int k = getID(); foreach (XmlNode node in root.ChildNodes) { LichHoc lh = new LichHoc(); MonHoc mh = new MonHoc(); lh.Id = k.ToString(); lh.MonHoc = new MonHoc(); lh.MonHoc.MaMH = node.ChildNodes[2].InnerText.Trim(); lh.MaLop = node.ChildNodes[1].InnerText.Trim(); lh.NhomMH = node.ChildNodes[3].InnerText.Trim(); mh.MaMH = lh.MonHoc.MaMH; mh.TenMH = node.ChildNodes[7].InnerText.Trim(); mh.SoTC = int.Parse(node.ChildNodes[5].InnerText.Trim()); mh.TileThi = 0; lh.ThoigianBD = node.ChildNodes[10].InnerText.Trim().Substring(0, 10); lh.ThoigianKT = node.ChildNodes[10].InnerText.Trim().Substring(12); List <chiTietLH> listct = new List <chiTietLH>(); // constant int one = 1; int five = 5; for (int i = 0; i < node.ChildNodes[8].InnerText.Trim().Length; i++) { chiTietLH ct = new chiTietLH(); ct.Id = k.ToString(); string magv = node.ChildNodes[0].InnerText.Trim().Substring(i * five, five); ct.CBGD = BUser.getUser(magv).Hoten; ct.Phong = node.ChildNodes[4].InnerText.Trim().Substring(i * 6, 6); ct.Thu = node.ChildNodes[8].InnerText.Trim().Substring(i * one, one); ct.TietBatDau = node.ChildNodes[9].InnerText.Trim().Substring(i * one, one);//tiet bat dau = 10 ct.SoTiet = node.ChildNodes[6].InnerText.Trim()[i].ToString(); listct.Add(ct); } lh.Chitiet = listct; list.Add(lh); AddLH(lh); BMonHoc.AddMon(mh); k++; } 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); }
public static List <CTHocPhi> getCTHP(int NamHoc, int HocKy) { string query = string.Format("select * from CTHocPhi where NamHoc={0} and HocKy={1}", NamHoc, HocKy); List <CTHocPhi> listct = new List <CTHocPhi>(); DataTable db = DataProvider.LoadData(query); for (int i = 0; i < db.Rows.Count; i++) { CTHocPhi ct = new CTHocPhi(); ct.monHoc = BMonHoc.getByMaMH(db.Rows[i]["MaMH"].ToString()); ct.HocPhi = db.Rows[i]["HocPhi"].ToString(); ct.MienGiam = db.Rows[i]["MienGiam"].ToString(); ct.MaNhom = db.Rows[i]["MaNhom"].ToString(); ct.PhaiDong = db.Rows[i]["PhaiDong"].ToString(); ct.NamHoc = int.Parse(db.Rows[i]["NamHoc"].ToString()); ct.HocKy = int.Parse(db.Rows[i]["HocKy"].ToString()); listct.Add(ct); } return(listct); }