示例#1
0
 public async void DeleteGiaoDichByID(int id)
 {
     var dao = new DAO();
     var doc = await dao.LoadDatabase();
     var node = doc.SelectSingleNode("//GiaoDich[@ID=" + id + "]");
     var element = doc.DocumentElement;
     element.RemoveChild(node);
     dao.SaveDatabase(element.OwnerDocument);
 }
示例#2
0
 public async Task<List<LoaiGD>> LoadLoaiGD()
 {
     var dao = new DAO();
     var nodeList = await dao.GetNodeList("//LoaiGD");
     return nodeList.Select(xmlNode => new LoaiGD
     {
         ID = int.Parse(xmlNode.Attributes.GetNamedItem("ID").NodeValue.ToString()),
         Ten = xmlNode.Attributes.GetNamedItem("Ten").NodeValue.ToString()
     }).ToList();
 }
示例#3
0
 public async Task<List<GiaoDich>> LoadGiaoDichByLoaiGD(int IDLoai)
 {
     var dao = new DAO();
     var nodeList = await dao.GetNodeList("//GiaoDich[@IDLoai=" + IDLoai + "]");
     return nodeList.Select(xmlNode => new GiaoDich
     {
         ID = int.Parse(xmlNode.Attributes.GetNamedItem("ID").NodeValue.ToString()),
         Ten = xmlNode.Attributes.GetNamedItem("Ten").NodeValue.ToString(),
         SoTien = int.Parse(xmlNode.Attributes.GetNamedItem("SoTien").NodeValue.ToString()),
         Ngay = DateTime.Parse(xmlNode.Attributes.GetNamedItem("Ngay").NodeValue.ToString()),
         GhiChu = xmlNode.Attributes.GetNamedItem("GhiChu").NodeValue.ToString(),
         LoaiGD = int.Parse(xmlNode.Attributes.GetNamedItem("IDLoai").NodeValue.ToString())
     }).ToList();
 }
示例#4
0
 public async Task<GiaoDich> LoadGiaoDichById(int id)
 {
     var dao = new DAO();
     var node = await dao.GetSingleNode("GiaoDich[@ID=" + id + "]");
     if (node != null)
     {
         var giaoDich = new GiaoDich()
         {
             ID = int.Parse(node.Attributes.GetNamedItem("ID").NodeValue.ToString()),
             Ten = node.Attributes.GetNamedItem("Ten").NodeValue.ToString(),
             SoTien = int.Parse(node.Attributes.GetNamedItem("SoTien").NodeValue.ToString()),
             Ngay = DateTime.Parse(node.Attributes.GetNamedItem("Ngay").NodeValue.ToString()),
             GhiChu = node.Attributes.GetNamedItem("GhiChu").NodeValue.ToString(),
             LoaiGD = int.Parse(node.Attributes.GetNamedItem("IDLoai").NodeValue.ToString())
         };
         return giaoDich;
     }
     return null;
 }
示例#5
0
 public async Task<int> LoadIDLoaiGD(string name)
 {
     var dao = new DAO();
     var node = await dao.GetSingleNode("//LoaiGD[@Ten='" + name + "']");
     return int.Parse(node?.Attributes.GetNamedItem("ID").NodeValue.ToString());
 }