public static void AddCTHP(CTHocPhi ct) { string query = string.Format("select * from CTHocPhi where MaMH='{0}' and NamHoc={1} and HocKy={2}", ct.monHoc.MaMH, ct.NamHoc, ct.HocKy); if (DataProvider.LoadData(query).Rows.Count == 0) { try { string sql = string.Format("Insert into CTHocPhi values('{0}','{1}','{2}','{3}','{4}',{5},{6})", ct.monHoc.MaMH,ct.MaNhom, ct.HocPhi, ct.MienGiam,ct.PhaiDong, ct.NamHoc, ct.HocKy); DataProvider.Insert(sql); } catch { } } }
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); }
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; }
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; }