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;
}
