public static List <HocPhi> getAll() { string query = "select * from HocPhi"; list = new List <HocPhi>(); DataTable db = DataProvider.LoadData(query); for (int i = 0; i < db.Rows.Count; i++) { HocPhi hp = new HocPhi(); hp.TongSoTC = db.Rows[i]["TongSoTC"].ToString(); hp.TongSoTien = db.Rows[i]["TongSoTien"].ToString(); hp.TienDongTTLD = db.Rows[i]["TienDongTTLD"].ToString(); hp.TienDaDong = db.Rows[i]["TienDaDong"].ToString(); hp.TienConNo = db.Rows[i]["TienConNo"].ToString(); hp.HocKy = int.Parse(db.Rows[i]["NamHoc"].ToString()); hp.NamHoc = int.Parse(db.Rows[i]["HocKy"].ToString()); list.Add(hp); } foreach (HocPhi hp in list) { hp.ListCTHP = getCTHP(hp.NamHoc, hp.HocKy); } return(list); }
public static HocPhi LoadDataFromSV(string id, string password) { XmlDocument doc = new XmlDocument(); doc.Load("http://localhost:56715/api/hocphi"); XmlElement root = doc.DocumentElement; XmlNode node = root; HocPhi hp = new HocPhi(); hp.HocKy = int.Parse(node.ChildNodes[1].InnerText[7].ToString()); hp.NamHoc = int.Parse(node.ChildNodes[1].InnerText.Substring(19, 4)); hp.TienConNo = node.ChildNodes[2].InnerText; hp.TienDaDong = node.ChildNodes[3].InnerText; hp.TienDongTTLD = node.ChildNodes[4].InnerText; hp.TongSoTC = node.ChildNodes[5].InnerText; hp.TongSoTien = node.ChildNodes[6].InnerText; hp.ListCTHP = new List <CTHocPhi>(); foreach (XmlNode node1 in node.ChildNodes[0].ChildNodes) { CTHocPhi ct = new CTHocPhi(); ct.HocPhi = node1.ChildNodes[0].InnerText; ct.MaNhom = node1.ChildNodes[1].InnerText; ct.MienGiam = node1.ChildNodes[2].InnerText; ct.PhaiDong = node1.ChildNodes[3].InnerText; ct.HocKy = hp.HocKy; ct.NamHoc = hp.NamHoc; ct.monHoc = new MonHoc(); ct.monHoc.MaMH = node1.ChildNodes[4].ChildNodes[1].InnerText; hp.ListCTHP.Add(ct); } AddHP(hp); return(hp); }
public static void AddHP(HocPhi hp) { string query = string.Format("select * from HocPhi where NamHoc={0} and HocKy={1}", hp.NamHoc, hp.HocKy); if (DataProvider.LoadData(query).Rows.Count == 0) { try { string sql = string.Format("insert into HocPhi values('{0}','{1}','{2}','{3}','{4}',{5},{6})",hp.TongSoTC,hp.TongSoTien,hp.TienDongTTLD,hp.TienDaDong,hp.TienConNo,hp.NamHoc,hp.HocKy); DataProvider.Insert(sql); foreach (CTHocPhi ct in hp.ListCTHP) { AddCTHP(ct); } } catch { } } }
public static void AddHP(HocPhi hp) { string query = string.Format("select * from HocPhi where NamHoc={0} and HocKy={1}", hp.NamHoc, hp.HocKy); if (DataProvider.LoadData(query).Rows.Count == 0) { try { string sql = string.Format("insert into HocPhi values('{0}','{1}','{2}','{3}','{4}',{5},{6})", hp.TongSoTC, hp.TongSoTien, hp.TienDongTTLD, hp.TienDaDong, hp.TienConNo, hp.NamHoc, hp.HocKy); DataProvider.Insert(sql); foreach (CTHocPhi ct in hp.ListCTHP) { AddCTHP(ct); } } catch { } } }
public static List<HocPhi> getAll() { string query = "select * from HocPhi"; list = new List<HocPhi>(); DataTable db = DataProvider.LoadData(query); for (int i = 0; i < db.Rows.Count; i++) { HocPhi hp = new HocPhi(); hp.TongSoTC = db.Rows[i]["TongSoTC"].ToString(); hp.TongSoTien = db.Rows[i]["TongSoTien"].ToString(); hp.TienDongTTLD = db.Rows[i]["TienDongTTLD"].ToString(); hp.TienDaDong = db.Rows[i]["TienDaDong"].ToString(); hp.TienConNo = db.Rows[i]["TienConNo"].ToString(); hp.HocKy = int.Parse(db.Rows[i]["NamHoc"].ToString()); hp.NamHoc = int.Parse(db.Rows[i]["HocKy"].ToString()); list.Add(hp); } foreach (HocPhi hp in list) { hp.ListCTHP = getCTHP(hp.NamHoc, hp.HocKy); } return list; }
public static HocPhi LoadDataFromSV(string id, string password) { XmlDocument doc = new XmlDocument(); doc.Load("http://localhost:56715/api/hocphi"); XmlElement root = doc.DocumentElement; XmlNode node = root; HocPhi hp = new HocPhi(); hp.HocKy = int.Parse(node.ChildNodes[1].InnerText[7].ToString()); hp.NamHoc = int.Parse(node.ChildNodes[1].InnerText.Substring(19, 4)); hp.TienConNo = node.ChildNodes[2].InnerText; hp.TienDaDong = node.ChildNodes[3].InnerText; hp.TienDongTTLD = node.ChildNodes[4].InnerText; hp.TongSoTC = node.ChildNodes[5].InnerText; hp.TongSoTien = node.ChildNodes[6].InnerText; hp.ListCTHP = new List<CTHocPhi>(); foreach (XmlNode node1 in node.ChildNodes[0].ChildNodes) { CTHocPhi ct = new CTHocPhi(); ct.HocPhi = node1.ChildNodes[0].InnerText; ct.MaNhom = node1.ChildNodes[1].InnerText; ct.MienGiam = node1.ChildNodes[2].InnerText; ct.PhaiDong = node1.ChildNodes[3].InnerText; ct.HocKy = hp.HocKy; ct.NamHoc = hp.NamHoc; ct.monHoc = new MonHoc(); ct.monHoc.MaMH = node1.ChildNodes[4].ChildNodes[1].InnerText; hp.ListCTHP.Add(ct); } AddHP(hp); return hp; }