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